PROFESSIONAL SUMMARY:

• 10 years of diversified experience in administration of production databases which includes 11g, 12c (RAC with ASM),Stand - alone database, Replication options known as Data Guard, Golden Gate; In all of these expertise in Installation, configuration, Administration tuning, design, patches, upgrade, migration, capacity planning, OEM Grid Control, Flashback, RMAN backup and recovery, cloning, auditing, troubleshooting and documentation.
• Extensive hands on experience of database performance tuning including RAC and SQL tuning experience with 11g and 12c RAC scalability, HA, robustness and load balancing, RAC performance tuning, instance availability and background processes monitoring, waiting events and log and trace files investigation for troubleshooting.
• Extensive working experience with 11g and 12c RAC database installation, building, configuration and administration, ASM installation, configuration and monitoring and oracle CRS administration.
• Extensive working experience with 10g, 11g and 12c DATAGUARD/active DG to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and trouble shooting.
• Focusing on Exadata Administration. With nodes ranging from 2 to 8 and incorporating data guarded Exadata clusters for maximum availability.
• Experienced on Adding a Node and Deleting Node in 11gR2
• Upgraded RAC Databases from 11.2.0.3 to 11.2.0.4
• Worked On cross platform migrations using GG and Delphix tools.
• Experience in Oracle GoldenGate Installation, configuration, troubleshooting Golden Gate issues
• Perform Query tuning, Instance/Memory tuning by using various performance tools TKProf, Explain Plan, Statspack, ADDM, AWR, etc
• Experienced of managing and administering 24X7 running databases. prepared standard operating procedure(sop) documents for frequently used databases tasks and process
• Good Analytical and Strong interpersonal and excellent communication skills

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 5.x, 6.x, HP-UX 10.x, 11.x,Sun Solaris 9,10,11 AIX 5.1, 5.2

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC), Exadata ASM, MySQL, SQL SERVER 2008/2012, NoSQL, PostgreSQL, Mongo, AWS-RDS,EC2

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools / Utilities: RAC,BladeLogic OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data-Guard, Log-miner, CronTab, ETL

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

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Sr. Oracle DBA & Performance Specialist

Environment: Oracle Exadata Database 12c, 11g, Golden Gate, AIX, Redhat Linux 6/7,OEM, EMC Storage, ETL,Data Warehouse

Responsibilities:

• Architected, Designed, Installed and configured Oracle 11g/12c RAC Database on Solaris, AIX, and Linux platforms
• Administration of Oracle 11g/12c RAC (2 Nodes and 3 Nodes) databases.
• Analyzing AWR, ASH and ADDM reports for resolving DB performance issues.
• Monitoring of databases using OEM 12c Grid Control.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Lead Cross platform Migration of databases using Datapump,GG from Solaris to Linux.
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Review and recommend oracle initialization parameters and new features during OS/Database/Application version upgrades and quarterly releases.
• Lead Root Cause Analysis for critical production performance issue. Identify RCA for production crashes related to bugs and performance issues.
• Support OLTP databases in 24x7 Production environments.
• Capacity Planning of Confidential applications as well as in planning new Confidential architecture implementations
• Weekly interaction with customer explaining the progress on the issues, understanding new concerns and new requirements from Database standpoint.
• Leading new Oracle projects from concept to reality while reducing TCO and maximizing ROI (products, architecture, capacity, performance testing).
• Automation of DBA tasks using shell/Sql/pl-Sql/ scripting.
• Delegation of DBA tasks to offshore and daily handovers to them.

Confidential

Sr. Oracle DBA & Performance Specialist

Environment: Oracle Exadata Database 12c, 11g, Golden Gate, AIX, Linux, Solaris, OEM, EMC Storage,, Data Warehouse

Responsibilities:

• Architected, Designed, Installed and configured Oracle 11g/12c RAC Database on Solaris, AIX, and Linux platforms
• Administration of Oracle 11g/12c RAC (2 Nodes and 3 Nodes) databases.
• Analyzing AWR, ASH, ADDM, Explain Plan, Sql tuning, Sql trace reports for resolving DB performance issues.
• Monitoring of databases using OEM 12c Grid Control.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Review and recommend oracle initialization parameters and new features during OS/Database/Application version upgrades and quarterly releases.
• Lead Root Cause Analysis for critical production performance issue. Identify RCA for production crashes related to bugs and performance issues.
• Support OLTP databases in 24x7 Production environments.
• Cross platform Migration of databases using datapump, GG and Delphix tools from Solaris/AIX to Linux.
• System resources Data collection tool development to support monitoring of 100s of DB servers & app servers.
• Experience in working with Sql Queries and PL/SQL(Stored Procedues, Triggers,Packages/Functions)
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system.
• Cross platform Migration of databases using datapump, GG and Delphix tools from Solaris/AIX to Linux.
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Worked on Active Standby Database and snapshot standby database
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Database refresh, schema refresh, database creation, Implement table partitioning
• Co-ordinate with application team and developers in resolving issues and prepare deployment plans
• Configured and tested backup and recovery using RMAN
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.

Confidential

Sr. Oracle DBA

Environment: Oracle Database 11g, 10g, AIX, Golden Gate, RHEL 6, Hitachi Storage

Responsibilities:

• Supporting customers for resolving their Critical Production Issues.
• Very strong Production Support (24X7) experience
• Installation, configuration, patching and upgrades of Oracle RAC.
• Implementing Change controls in production environment
• Upgrade/Migration of Databases from Oracle 10g to 11g.
• OEM Grid control to monitor all databases.
• Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard
• Worked on Active Standby Database and snapshot standby database
• Experience in oracle GoldenGate installation, configuration, troubleshooting Golden Gate issues
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL
• Database refresh, schema refresh, database creation, Implement table partitioning
• Co-ordinate with application team and developers in resolving issues and prepare deployment plans
• Installed Oracle Apex components
• Configured and tested backup and recovery using RMAN
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Configured and tested backup and recovery using RMAN
• Worked with Oracle Support through TAR to resolve issues
• Building standby database for the replication of the primary database
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Implanted Uni-directional replication using golden gate

Confidential

Performance Consultant

Environment: Oracle 10g, 9i RAC, OEM, RHEL 5, 6, IBM AIX, Hitachi Storage

Responsibilities:

• Installed and configured of Oracle 10g Real Application Clusters on Production database.
• Installed & Configured of Oracle Cluster Software’s (10g) (Placed OCR & Voting disk in Raw ASM file systems).
• Upgraded RAC servers from 9i to 10g
• Installed and configured of OEM(10g grid control)
• Converted single instance database to cluster database.
• Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN
• Managing RAC instances using srvctl.
• Support Production, QA, DEV, UAT databases.
• Cross platform Migration of databases using export/import and Datapump
• Applying rolling patches in RAC environment using Opatch AUTO
• Applying oracle PSU, Memory patches(CPU)
• Converted single instance database to cluster database.
• Worked on Active Standby Database and snapshot standby database
• Capacity Planning, Minimize the database down time.
• Configured and tested backup and recovery using RMAN
• Worked with Oracle Support through TAR to resolve issues
• Building standby database for the replication of the primary database
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.
• Performed Database Reorg for faster Performance.