SUMMARY

• Around 8 years of experience in installation, configuration, administration, migration, tuning, patching & upgrades and troubleshooting of Oracle databases 9i/10g/11g/12c in UNIX and Windows operating systems.
• Implemented Oracle 10g/11g/12c Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), VERITAS Volume Manager Administration, Cluster Interconnects, Load balancing and designing failover systems on UNIX platforms.
• Expertise in installation, configuration and administration of Oracle 9i/10g/11g/12c in very large scale database environment (VLDB) and mission critical OLTP systems.
• Experience with 12c multitenant architecture (container and pluggable databases).
• Installed, configured and maintained databases onExadata X3/X4/X5 hardware.
• Experienced in configuring, maintaining replication using Oracle GoldenGate. Implemented One - way, Bi-directional and Multi-master replication using the classic and integrated processes.
• Involving in maintaining and administering NoSQL databases likeMongoDB.
• Expertise in Configuring & Maintaining Oracle Data Guard for disaster recovery.
• Installed and configured 11gOEM Grid Control & 12c OEM Cloud Control and deployed agents on different targets.
• Expertise in Database upgrading and migration of Oracle server (9i, 10g, 11g and 12c).
• ImplementedOLTP compression, Partitioning, Hybrid Columnar Compression for databases on Exadata, and the basic, low, high compression methodologies.
• Performed TSPITR, duplicating database using RMAN. Involved in Disaster Recovery Planning (DRP).
• Experienced in configuring, maintaining replication using Oracle Streams at table and schema level.
• Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller under UNIX and Windows.
• Data transferring and backup using exports/imports, Data pump and RMAN. Data loading using SQL*Loader.
• Involved in writing stored Procedures, Functions and Triggers to interface application with database system.
• Developed Shell scripts for day-to-day database administration tasks that include various jobs for alert logs and performance, Backups, Restores and Recoverability.
• Tuning oracle databases and tuning applications, with Tuning Tools like OEM, SQL analyzer, Statspack, AWR, ADDM, ASH, RDA,Explain plan, TKPROF, SQL TRACE, SQLT, TRCA, RAT(Real Application Testing) Tool and Oradebug.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Experience in Database Security, Auditing and creating the data model.
• Provided 24 x 7 support and flexible to work beyond regular hours.
• Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.
• Experience in using and maintaining of Materialized Views.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager and Ping Utility.
• Create and maintain databases to Oracle Optimal Flexible Architecture (OFA) standards.
• Experienced with Change management and Help desk ticket management Processes.
• Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.
• Exceptional ability to quickly master new concepts and technologies.
• Capable of working in a Team/independently with ability to lead a DBA team with project management, technical, presentation, communication and time management skills.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c, MongoDB

Operating Systems: Solaris, HP-UX, AIX, Red Hat Linux, Windows NT/2000/2008

Tools: Export/import, Data pump Exp/DPI, RMAN, SQL*Loader, OEM GC, LogMiner, Oracle streams, AWR, ADDM, STATSPACK, TKPROF, SQLT, TRCA, EXPLAIN PLAN, Oracle SQL Developer, SFTP

Other Tools: AUTOSYS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net Worker, HPDP, WinSCP

Languages: C, C++, SQL, PL/SQL,Shell Scripting,PERL scripting

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 and 12c RAC.
• Migrated Oracle databases from Oracle 9i, 10g to Oracle 11gR2/12c.
• Worked closely with Application team to resolve the performance of SQL queries by creating SQL Profiles, SQL Baselines and other.
• Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.
• Experience with 12c multitenant architecture (container and pluggable databases).
• Installed, configured and maintained databases onExadata X3/X4/X5 hardware.
• Worked extensively on Oracle GoldenGate implementing One-way, Bi-directional, Multi-Master replication for HA and migration purposes using the classic and integrated processes.
• One-way GoldenGate replication is extensively used in most of the migrations to reach zero or minimal downtime.
• ImplementedOLTP compression, Partitioning, Hybrid Columnar Compression for databases on Exadata, and the basic, low, high compression methodologies.
• Worked extensively on Very Large Databases (VLDB) ranging from 5 TB to 20 TB.
• Migrated, upgraded Oracle databases from 9i/10g/11gR1 to 11gR2/12c including the cross platform.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Installed, configured and administration of Oracle Dataguard (physical and logical standby databases) for DR and reporting purposes.
• Partitioned tables are implemented on the very large tables to increase the application performance.
• Interacted with Oracle Support regarding multiple service requests to solve performance issues of the Database.
• Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and rewriting the SQL queries to improve the performance.
• Partition table Maintenance by adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old partitions.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Involved in preparing POC on the new database concepts and well documented for future use.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g/12c, Linux, IBM-AIX, Solaris,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor,SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential, Mettawa, IL

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC.
• Migrated of the oracle databases from Oracle 9i, 10g to Oracle 11g.
• Database migration from file system to Oracle 11gR2 ASM.
• Worked closely with Application team to resolve the performance of SQL queries by creating SQL Profiles, SQL Baselines and other.
• Responsible for improvement and maintenance of the databases to include application DDL rollout and upgrades.
• Using GoldenGate One-way and Bi-directional replication are configured as per the application need and widely used in the migrations to achieve minimal downtime.
• Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Maintain Database repositories for PeopleSoft Application includes (GL, AM, ABM and HR) and for reporting tools like Cogonos.
• Partitioned Large tables to execute queries in finite window and fine tune the response time of database.
• Interacted with Oracle Support regarding multiple service requests to solve performance of the Database.
• Involved in Upgrading Oracle 11g OEM GC to 12c OEM Cloud Control.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g, Linux, IBM-AIX, Solaris,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor,SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential, Hoffman Estates, IL

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC.
• Migrated of the oracle databases from Oracle 9i to Oracle 11g.
• Database migration from file system to Oracle 11gR2 ASM.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• Created/Troubleshoot DDL scripts that effect schema structure validating Build Scripts against “standards” and previous environments for consistency creating, updating, scheduled jobs and stored Procedures.
• Assess and recommend alternative processes, procedures and tools to streamline operations and provide a more efficient and cost effective database environment.
• Interacted with Oracle Support regarding multiple service requests to solve performance of the Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g, Linux, HP-UX,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor, Oracle Replication,SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential, Saint Louis, MO

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC.
• Involved in Upgrading of the oracle databases from Oracle 10g to Oracle 11g.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
• Created Materialized Views between databases.
• Worked on GC to solve the issues related to it.
• Database migration from file system to Oracle ASM.
• Conversion of standalone database to 2 node RAC database.
• Build Oracle 11gR2 RAC databases for SAP applications.
• Well versed with Change management and Help desk ticket management Processes.
• Was involved in developing standards for database security, auditing, password management.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances which to be scheduled from networker.
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database. Written Shell Scripts like rotation of Database logs and Archive logs.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health
• Interacted with Oracle Support regarding multiple service requests.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g, Linux, AIX, HP-UX, Solaris, OEM GC, TOAD, RAC, RMAN, Legato Networker, Explain Plan, Data Pump, AWR, ADDM, Oracle Replication,SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Used data guard created, maintained, managed and monitored databases to protect enterprise data from failures, disasters, errors and corruptions.
• Implemented advanced replication and standby databases.
• Maintenance of Oracle 8i.
• Implemented Database upgrading and migration of Oracle server (8i to 9i) and (9i to 10g).
• Responsible for Data load on different databases using SQL*Loader.
• Managed the VERITASNetbackup software for managing the tape device.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Conducted daily routine checks on alert logs and trace files.
• SQL tuning andDatabase performance tuninghas been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Involved in 24x7 production database maintenance and on-call support.
• Experienced in several programming languages including Shell scripting, SQL and PL/SQL in support of DBA activities such as scripting for scheduled jobs, created stored procedures and triggers and integrated front-end web pages with back-end database engines.

Environment: Oracle 8i/9i/10g, Red Hat Linux, Windows, Oracle Advance Replication, TOAD, OEM GC, SQL*Loader, Shell Scripts, PERL Scripts, ERWin, STATSPACK, AWR, ADDM, ASH, SQL TRACE, UTLBSTAT, UTLESTAT