Manager Oracle

Sandeep Thakur

******.*.*******@*****.***

Cell: 201-***-****

PROFESSIONAL SUMMARY:

• Oracle Certified Professional (10g) with over 6+ years of experience on Oracle (9i 10g 11g) Database Administration in

Installing, Administering, Migrating, Upgrading, Tuning, Troubleshooting and Managing over Tera byte of

databases on Linux, Unix, AIX, Solaris and Windows Operating systems

• Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying

various PSU patches using OPatch for 9i 10g 11g

• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw

devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.

• Successfully implemented Adding/Deleting RAC nodes, TAF and Load Balance

• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively

use DATAGUARD BROKER utility.

• Expertise in setting up Data Guard Fail-Over Switch-Over Read-Only scenarios

• Fabricated multiple CLONING databases using traditional method and RMAN utility.

• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for

automating daily administration tasks

• Performed FLASHBACK features to handle efficient database recovery.

• Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery,

Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database

Security.

• Monitor and maintain system security and Auditing.

• Experience in regular Database Administration activities like monitoring database alert logs, manage file system disk

space, resizing table space and de-fragmenting the database as needed, system shut down and restart, unlocking

database table and session locks, as well as monitor and create additional table space and file space as needed.

• Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic shared memory

management (ASMM), ASH and Buffer Cache Advisors.

• Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.

• 10046 trace for sql tuning and to see where the time is being spent

• Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.

• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository

(AWR) and Automatic Database Diagnostics Monitor (ADDM).

• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, Pinning objects.

• Experienced in loading data from flat files using SQL Loader and External Tables.

• Knowledge on Oracle Support processes for technical requests through Meta link.

• Monitoring & Reorganizing Tablespaces/Tables/Indexes.

• Granted Users they Resources by Creating Profiles, Managing Sessions, Privileges and Roles.

• Skilled in using tools such as SQL Developer and TOAD.

• Experienced in converting Business Requirements to Technical Specifications.

• Quick Learner motivated and dedicated to getting the job done in time.

• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with

pager rotation to support during weekends, Holidays and beyond regular hours.

TECHNICAL SKILLS:

Languages C, C++, Java, PL/SQL, SQL,HTML

Database Management: Oracle 11g/10g/9i/8i

Operating Systems HP-UX, UNIX, Red Hat Linux, Solaris, AIX, Windows NT/2000/XP

Oracle Enterprise Manager, TOAD, GRID control, SQL Trace, TKPROF, 10g RAC, Oracle

Utilities & Tools:

Streams, AWR, ADDM, Export &Import, Data pump, Oracle Scheduler, SQL Developer, Putty,

RAID Systems, SQL*Loader, RMAN, SQL*PLUS, isqlplus, Erwin Data Modeler, DBLINK

High Availability. Real Application Clusters (RAC), Oracle Streams, Cloning, Dataguard and Dataguard Broker

CERTIFICATIONS:

• Oracle 10g Database Administration I Certified Associate (OCA 10g)

• Oracle 10g Database Administration II Certified Professional (OCP 10g)

• Oracle 11g Database Administration I Certified Associate (OCA 11g)

Introduction to Oracle 9i SQL

• Oracle Testing ID: OC0857239

EmblemHealth, Melville, NY Nov’09-till date

Role: Oracle DBA

EmblemHealth is committed to providing affordable, quality health coverage in ways that respect and respond to people's

fundamental needs. The goal of the project is to install, configure and administer oracle 10g RAC for few critical databases.

We successfully implemented oracle 10g RAC for High availability.

Responsibilities:

• Involved in implementing and managing Oracle 10g RAC with ASM databases to deliver leading multi-OLTP and

DSS applications, enabled load balancing client-server, server-server as Transparent application failover(TAF).

• Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER (OEM.)

10g grid control.

• Installation and configuration of Oracle Database Software 11g; Creation and configuration of database.

• Upgrading database from Oracle version 10g to 11g.

• Configured Oracle Bi-Directional Streams for a 10g database for High Availability

• Migrated Database from AIX to Linux using RMAN

• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR

support and coordinating the patches and implementing the necessary changes.

• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

• Used Export/Import and Datapump utilities for full/partial backup.

• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.

• Performed logical backup using export/import and data pump (remote export) utilities.

• Database refreshes based on Application requirements.

• Wrote shell script to perform backup and schedule it with crontab.

• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

• Optimize SQL queries for better performance.

• Carried out Optimizing performance and Query tuning using Statspack, Tkprof, and OEM.

• Use Explain Plan for monitoring the query execution.

• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic

Database Diagnostics Monitor (ADDM)..

• Installation and configuration of Oracle Client software and Tools.

• Provided Production DBA support, as needed, on a 24/7 basis.

Environment: Oracle 9i, 10g-RAC-ASM R2,11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP-Itanium, HP-

RISC, AIX, DATAGUARD, PL/SQL, TOAD and SQL *Plus

Sprint Nextel Group, Iselin, NJ Dec’08- Oct’09

Role: Database Administrator

Sprint Nextel is widely recognized for developing, engineering and deploying innovative technologies including robust

wireless networks serving more than 53.1 million customers in USA Major part of this project involved configuration and

creating of databases to support market growth and implementation of Physical standby database.

Responsibilities:

• Capacity planning, Install, configure OLTP, Data warehouse (DSS) databases( Oracle 9i & 10GR2) Either in shared

environment/standalone environment as well as on VMware virtual machines.

• Involved in database upgrade from 11.1.0.6 to 11.1.0.7 for DEV and TEST environments.

• Used SRVCTL utility for managing multiple instances and nodes.

• Experience in configuring and maintaining Oracle Replication by using Oracle streams for Data replication from

production system to Data warehouse on RAC Environment.

• Implemented the database with ASM storage, skilled towards database tuning and hands on experience in database

security (auditing), recovery, archival concepts and procedures.

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.

• Upgrade the production and development databases from 9i to 10g

• Created and maintained standby databases using database replication (Data Guard) for high availability.

• Configured databases on Veritas Cluster Server (VCS) and performed cluster failover/failback test.

• Cloned the databases using scripts, cold/Hot backups and Using RMAN.

• Regular monitoring of the databases with Oracle Enterprise Manager, Grid Control for operational databases with high

sensitivity alerts

• Performing SQL*Loader jobs for loading data from text files

• Actively worked on performance tuning of instance (SGA and PGA) and Physical database that included resolving

fragmentation and disk contention. Use Partitioning and indexing feature of Oracle 10g to improve performance.

• Implemented OLAP Data warehouse.

• Disaster recovery planning; implemented database backups and disaster recovery strategies using RMAN and data

pump export, import.

• Troubleshooting and Tuning of production & RAC databases.

• Involved in Logical & Physical Schema Design and data modeling using ERWIN.

• Supported very large database with heavy OLTP and batch activities Writing and testing PL/SQL procedures (stored

procedure, triggers, function, cursors and packages) for maintaining tables, retrieving data from tables and managing

users. Responsibilities included working with developers to tune the PL/SQL, SQL.

• Designed and Implemented database security using Oracle roles and privileges.

• Experienced in optimizing SQL and PL/SQL tuning using CBO, explain plan, TKPROF, Statspack, ADDM, AWR.

• Involved In query optimization and using rule based optimizers and cost based optimizers

• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.

• Work with a geographically dispersed team for round-the-clock monitoring of production systems

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP-UX,ERWIN, PL/SQL,

Informatica, Shareplex,, RAC TOAD, and SQL *Plus.

Drugstore.com, Bellevue, Washington July’07- Nov’08

Role: Oracle DBA

Drugstore.com is an internet retailer in health and beauty care products. Established in 1999, drugstore is one of the

healthcare retailers.

Responsibilities:

• Installation of Oracle Database Software 10g. Created database through DBCA and manually.

• Worked with other DBA’s for Capacity planning of new Databases. Data replication between different Oracle

databases using DBLinks. Setup test environment to simulate the migration process.

• Involved in Installing & Administering Oracle Real Application Cluster (RAC) 10g.

• Convert database from Non RAC database to RAC database using RMAN and ASM.

• Implemented Oracle Uni-Directional Streams for a 10g database.

• Migration of Databases from Solaris to linux.

• Upgraded from 10.2.0.1 to 10.2.0.4 database and installed patches for new Oracle software and doing TAR support.

• Export/Import (Data Pump) of data using batch method. Backup and disaster planning using User Managed/RMAN.

Prepare approach and steps of migration which will be carried for OLTP and DWH databases of production data.

Installed and generated Statspack report on each server for benchmarking the database statistics.

• Enhancement of the existing PL/SQL objects like Procedures, Functions, Packages, views, materialized views.

Tuning & review of some bad performing PL/SQL codes and SQL’s. Assisted in designing both physical and logical

models for new databases.

• Responsible for database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention

and application tuning.

• Created PL/SQL Packages to move / transform data from OLTP to DWH. Gathering statistics of data objects using

Analyze and DBMS_STATS. Developed scripts to monitor the storage usage, object status for daily jobs. Database &

Instance configuration using Grid control, ADDM, ASMM, etc.

• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the

space for normal segments, rollback segments.

• Created database link between two databases to access the table data from one local database to remote database

using distributed database feature. Created snapshots for some most queried tables to get the most refreshed data.

Planned and installed replication of database also.

• Involve in the database community meeting with the client to discuss the methodology and decide the strategy of

migration. Preparation of database migration document. Effort estimation for Data migration for all the databases.

Helped in preparation of Project plan for the Migration.

Environment: Oracle 9i/10g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, TOAD, SQL, PL/SQL, AIX, UNIX, HP-

UX, Solaris, RHELAS4.0

Compass Bank, Concord, CA Aug 06 - June 07

Role: Oracle DBA

BBVA Compass is a leading U.S. banking franchise located in the Sunbelt region. BBVA Compass is the 15th largest U.S.

commercial bank based on deposit market, operating more than 720 branches national wide.

Responsibilities:

• Creation of users, Implemented database auditing, data security.

• Partitioning tables by determining the suitable methodology to improve performance and manageability.

• Generated scripts for daily maintenance activities like analyzing the tables/indexes, growth rate and SGA use.

• Performed Hot, Cold, Table space level backups and Detection of corrupted blocks by using utilities like DBVERIFY

and with RMAN Block corruption.

• Implemented a backup strategy integration with VERITAS Net Backup

• Creation and migration of DB and other related Objects including schema objects

• Created scripts for hot backup and export on a daily basis scheduled with cronjobs.

• Plan for system and monitor capacity usage for new hardware and software requirements

• Automation of Startup Shutdown on all Production and Development Database.

• Interfacing with oracle corporation for technical support(METALINK)

• Modified the listener port number and to archive log mode for one of the existing database

• Clone and refresh environments to create patch test, development and QA environments.

• Conducted multiple test runs to gather timings for production upgrades.

• Implemented Disaster recovery (standby database 9i), documented database and application validation steps.

• Automate monitoring jobs, backups and alerts using UNIX shell scripts.

• Applying Upgrade, CPU Patch and bug fix patch.

• Loading data using SqlLoader.

• De-fragment tables and indexes for improved performance and effective space management.

• On-going SQL tuning using Explain Plan and SQL Trace.

Environment: Oracle 9i, 10g R2, Oracle Enterprise Manager, Oracle Grid control, RHEL, AIX, HP-UX, RMAN, SnapMirror,

DATA PUMP, DATA GUARD, RAC, PL/SQL, TOAD and SQL *Plus.

MIC Technologies, India April 04 – July 06

Role: Database Adminstrator.

MIC Technologies Limited is a global leader in the design, development & manufacturing of high-end Electronic and

Telecommunication equipment and development of Telecom software. With offices around the world it is the largest provider

of integrated business, technology and process solutions on a global delivery platform.

Responsibilities:

• Install / upgrade the Oracle databases and Oracle applications software & patches.

• Involved in Upgrading the database versions from 8i to 9i

• Backup and Recovery (using Cold Backups, hot backup, export/imports)

• VERITAS Net Backup 5.1 Backup & Media Management

• Restoration .Cloning the database and Recovery Drill

• Extensive knowledge of maintaining using Standby databases for high availability

• Managing a database development effort, monitoring multiple databases and tuning, database testing, verification and

validation

• Basic SQL, monitoring system processes, setting up user privileges/passwords and all related activities

• Table spaces and rollback segments maintenance

• Controlling and monitoring user access to the database

• Monitoring and optimizing the performance of the database

• Worked on call for 24x7 production Databases in Data center.

• Maintenance of Oracle Databases on the Production Machines

• Maintaining archived data on tape

• Involved in setting up backups, database reorgs, upgrades and monitoring of databases to identify performance issues.

• Performance monitoring / tuning.

• Tuning and monitoring multiple instances of Oracle on various platforms using Oracle Enterprise Manager.

• Design and Implement Backup & recovery procedures and ensure reliability of Database Backup and Recovery schemes

• Using export and Import utilities to take Logical backups

• Handling complete and incomplete recovery in case of database failure

• Performing database re-organization to get rid of fragmentation and also preventive maintenance

• Monitor database growth and size databases as required

• Monitor disk space usage, balance I/O load.

• Troubleshooting connectivity issues and network problems

• Monitoring alert logs, error trace, free spaces, file systems etc.

• Extensively worked on SQL* Loader to load data from other databases and text files into Oracle Database

• Writing Shell scripts for automating backup and monitoring for the database

Environment: Oracle 8i/9i, Oracle Enterprise Manager, RHEL, PL/SQL, TOAD and SQL *Plus.

Contact this candidate