SUMMARY

• Around 10 years of IT experience as an Oracle database administrator in Oracle database administration, installation, configuration, migration, sizing and space management, backup and recovery, cloning, upgrades, RAC, standby, replication, patching, performance tuning and troubleshooting, strategic planning, database security, TAR/SR support, Unix shell scripting and documentation, auditing and implementation of technology solutions.
• Involved in different scenarios of OLTP and Dataware housing databases.
• Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Worked in24x7 on - call production database support team and also as a Primary DBA in database engineering team.
• Expertise in installation and configuration of oracle 8i, 9i, 10g,11g, 12c on various platforms like IBM-AIX,SUN SOLARIS, HP-UX, RedHat Linux and Windows.
• Having a sound knowledge of new features of Oracle12c.
• Experience in implementing DR (Disaster Recovery)& High availability solutions using DataGuard(12c/11g/10g), Standby Database (9i) and oracle 9i, 10g,11g,12c RAC.
• Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.
• Experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica PowerCenter/ Datastage.
• Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Datapump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
• Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c/13cOEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sql trace.
• Involved in oracle technical support process through Metalink and other procedures.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in basic and advanced replication using Oracle Streams.
• Worked on implementing Golden Gate replication between different environments.
• Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.
• Experience in configuring and trouble shooting shareplex replication.
• Maintaining Database Security using security compliance auditing, capacity planning.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Good Written and verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10,11, AIX 5.1, 5.2, 5.3, 6.1, 7.1Red Hat Linux RHEL 2.x, 3.x, 4.x, 5.x, 6.x and Windows NT/2000//XP.

RDBMS: Oracle12c/11g/10g/9i

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, C,C++

Tools: TOAD, SQL Tools, FastReader, Informatica PowerCenter, Cognos 8

Oracle Tools: RAC,RMAN, ASM, OEM(11g), CC(12c/13c), SQL*Loader, exp/imp, expdp/impdp, Oracle Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR, ADDM, ASH, SPA, RAT

Database Modeling: Erwin 4.0, Toad Data Modeler.

Other: VERITASNetback up

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Database Administrator

ENVIRONMENT: Oracle 12c/11g,Oracle Golden Gate, SQL, PL/SQL, SQL Developer, TOAD, UNIX shell scripting, Sun Solaris, RHEL, IBM AIX, AutoSys, Netcool, OEM 12c CC, Flyway, Netezza.

RESPONSIBILITIES:

• Worked as database administrator for several applications and provided application related support as required in Data Warehouse Environment.
• Worked on troubleshooting issues related to bugs and database performance issues.
• Performed database upgrades from 11.2.0.4 to 12.1.0.2 in various OS environments i.e., Linux, Solaris, AIX
• Provided database support during various application releases.
• Suggested and implemented best practices for application team regarding database performance.
• Worked extensively on various performance related activities like SQL Tuning Advisor, SQL Plan Management, SQL Tuning Sets, RAT and SPA.
• Worked on fixing various performance issues by analyzing AWR, ASH and ADDM reports.
• Supported various data refresh activities as required by application/Business teams using expdp/impdp and RMAN.
• Automated various database monitoring scripts through AutoSys Scheduling Tool.
• Worked on building and creating schemas as per application needs using Remedy/MyServices and IAG.
• Worked on fixing invalid objects in different database environments by working closely with application team.
• Worked on applying PSU and CPU patches to fix bugs and security updates every quarter.
• Worked on SPA to proactively identify the performance issues related to OS/database upgrades.
• Hands on experience in finding the root cause of the problems that occurred and providing a solution to avoid them in future.
• Worked on implementing Golden Gate replication between different environments.
• Proactively monitored database heath reports that are received in email through Autosys Scheduler, OEM, Netcool and MyServices.
• Having hands on experience on Netezza databases and performed activities like database deployments, session monitoring, database backups and data refresh activities.
• Performed Groom and Generate Statistics operations when required by application team.
• Archived Terabytes of historical data in data warehouse environment to fix performance issues using Exchange Partition for faster archiving.
• Worked on setting up Flyway on various database servers to automate database deployment activities.

Confidential, NC

Sr.Oracle DBA

ENVIRONMENT: Oracle 11g/10g/9i, SQL, PL/SQL, SQL Development, UNIX shell scripting, Sun Solaris, RHEL, IBM AIX.

RESPONSIBILITIES:

• Worked as a primary DBA for several databases and provided application support when and as required.
• Installed and configuredOracle12c,11g, 10g 64 Biton Linux for Production, Development and Testing.
• Installed, configured and tested oracle 10gand 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 10g to 11gand applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Having Experience with Oracle 11g new features including ADR and Database Replay.
• Wrote UNIX Shell Scripts (Korn Shell, C-shell), SQL,PL/SQL, stored procedures, functions and database triggers to automate DBA activities like backupsand performance monitoring.
• Worked with Automatic Storage Management (ASM)Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• High-speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import & Move procedures.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database Objects by fixing row chaining, I/O and CPU bottle necks.
• Monitoring database performance during peak and non-peak loads using OEM Grid Control.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, StatsPack and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.
• Worked on 12c cloud control and resolved the events/incidents as reported.
• Hands on experience in finding the root cause of the problems that occurred and providing a solution to avoid them in future.
• Worked on Compliance reviews and quarterly auditing support.

Confidential, MN

Sr Oracle DBA

ENVIRONMENT: Oracle 11g/10g, SQL, PL/SQL, SQL Development, UNIX shell scripting, Sun Solaris, RHEL.

RESPONSIBILITIES:

• Involved in24x7 on call production support.
• Installed and configuredOracle11g, 10g 64 Biton Linux for Production, Development and Testing.
• Installed, configured and tested oracle 10gand 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 10g to 11gand applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining and row migration.
• Having Experience with Oracle 11g new features including ADR and Database Replay.
• Wrote UNIX Shell Scripts (Korn Shell, C-shell), SQL,PL/SQL, stored procedures, functions and database triggers to automate DBA activities like backups and performance monitoring.
• Worked with Automatic Storage Management (ASM)Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• High-speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/TableRe-organization for faster performance using export/import & Move procedures.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database Objects by fixing row chaining, I/O and CPU bottle necks.
• Monitoring database performance during peak and non-peak loads using OEM Grid Control.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, StatsPack and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

Confidential, IL

Sr Oracle DBA

ENVIRONMENT: Oracle 10g/ 9i, SQL, PL/SQL, SQL Development, UNIX shell scripting, Sun Solaris, Windows NT/2003.

RESPONSIBILITIES:

• Involved in24x7 on call production support.
• Installed and configuredOracle10g 64 Biton Solaris for Production, Development and Testing.
• Installed, configured and tested oracle 10gand 11g RAC environment and trouble shooting.
• Administered Oracle 10g 2 node RAC with ASM using Oracle Cluster Ware, Net Configuration, ASM.
• Expertise in handling various security aspects of the database including VPD (virtual private Database).
• Implemented Migration of Databases from 10g to 11gand applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining and row migration.
• Having Experience with Oracle 11g new features including ADR and Database Replay.
• Wrote UNIX Shell Scripts (Korn Shell, C-shell), SQL,PL/SQL, stored procedures, functions and database triggers to automate DBA activities like backups and performance monitoring.
• Worked withAutomatic Storage Management (ASM)Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Administered Disk’s and Raid’s using VERITAS Volume Manager also created, removed, and resized volumes based on requirement.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• Implemented Oracle Streams which enable the propagation of data, transactions and events in a data stream either within a database, or from one database to another, trouble shooting replication issues.
• High speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/TableRe-organization for faster performance using export/import & Move procedures.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database Objects by fixing row chaining, I/O and CPU bottle necks.
• Monitoring database performance during peak and non-peak loads usingOEM Grid Control.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, StatsPack and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Exporting data to other databases with the help of other third party tools like FastReader.
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Scheduled Jobs through Job Scheduler and performed data modeling using Erwin data modeler.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

Confidential, TX

Sr Oracle DBA

ENVIRONMENT: Oracle Server 10g/9i, SQL, PL/SQL, UNIX Shell Scripting, JAVA,IBM-AIX 5L,Windows 00/03 Server, MS Access.

RESPONSIBILITIES:

• Installation of Oracle10g/9i version on IBM-AIX 5L, Windows2000/2003 Server.
• Installed and createdOracle9i and 10g databases in development, Production and QA environment including configuration, backup & performance tuning.
• Implemented Oracle RAC (Real Application Cluster) with four nodes on a single database for Scalability and high availability.
• Supported Production Database Oracle9i RAC 4 Node with High Level Evaluation, performance tuning, instance recovery, load balance.
• Having experience in OLTP which facilitates and manages transaction oriented applications.
• Parsing data from any format into a normalizedOracledatabase .Coding and preparation of Test plans.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Created and monitored the Standby database Configuration for the Disaster recovery scenarios.
• Worked with Oracle Data Pump(expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Implemented database and Schema Replication using Oracle streams in order to share and propagate data, events, and messages.
• Design and implemented backup strategies, like, incremental, complete and cumulative Backup of the database using Recovery manager (RMAN). Used utilities likeExport/Import and Data Pump.
• Developed customized UNIX shell scripts (Korn Shell, C-Shell),SQL, PL/SQL to automate routine DBA tasks such as backups, Exports/Imports, space usage monitoring, extent growth.
• Design and developed scripts to monitor instance locks, long running queries, free space, extent growth.
• REFRESH/CLONING of Database using RMAN Duplicate for development, testing.
• Analyzing Alert Log and User Trace Files and diagnosing the problem.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Used Automatic Storage Management (ASM) as a vertically integrated file system and volume manager, purpose-built for Oracle database files.
• Optimization and tuning SQL queries and execution plan using TRACEFILE, TKPROF, EXPLAINPLAN.
• Monitoring database performance during peak and non-peak loads using TOAD, OEM, and STATSPACK.
• Daily Health Check Up of the Database using AWR, ADDM.
• Performance tuning which includes creating indexes, analyze tables and optimizer hints.

Confidential

Oracle DBA

ENVIRONMENT: Oracle8i, SQL, PL/SQL, RHEL, Windows 2000 Server.

RESPONSIBILITIES:

• Taking RMAN, Hot Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking permissions as and when required.
• Involved in the Design (Logical & Physical) of Databases.
• Involved in the installation of Oracle8i on Solaris platform.
• Handling day-to-day activities and monitoring performance.
• Creating Databases and database objects, Tablespaces and Rollback Segments.
• Monitoring Tablespaces, Indexes, extents & performance tuning.
• Constantly monitor the Alert log files & Trace files.
• Perform database and SQL tuning using in-house scripts and database tools
• Enrolling the users and creating profiles, and maintaining the system security.
• Ensuring proper Online and Offline backup, Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.