PROFESSIONAL SUMMARY:

• Over 10 years of experience as an IT professional along with extensive experience as an Oracle DBA in Production, Development and Test environments, transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions.
• Proficient in installation and configuration of Oracle 12C,11g, 10g, 9i, & 8i on SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS, REDHAT-LINUX.
• Configuration and supporting 12C databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
• Implemented Amazon RDS multi-AZ for automatic failover and high availability at the database tier.
• Migration of Oracle 10g and 11g databases from HP-UX to AIX servers using Datapump,RMAN and Golden Gate.
• Expertise in installing, configuring and maintaining Oracle 11g & 10g RAC (Real Applications Clusters) with ASM & OCFS2 file systems on RHEL, AIX, HP-UX.
• Upgraded oracle databases from 9i to 10g and 10g to 11g using both manual method and DBUA.
• Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Experienced in creating multiple VPC’s and public, private subnets as per requirement and distributed them as groups into various availability zones of the AWS VPC.
• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with Veritas NetBackup and Avamar.
• Applied Patch Set Updates to 10g and 11g oracle databases.
• Strong experience in database performance tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables.
• Provided 24x7 on-call production database support with timely resolution of tickets.
• Involved in Logical and physical modeling using Erwin and Data loading using SQL*Loader.
• Performed RAT(Real Application testing) on 10g databases in HP-UX before upgrading and migrating to 11g version in AIX to identify performance issues.
• Good knowledge in implementing Oracle Flashback technology for faster recovery of tables/database.
• Management of Schemas, Objects & Partitioning the tables & indexes
• Expertise in maintaining and reinforcing standards for change management, database security plan and auditing.
• Installed and Configured Oracle GoldenGate for replications and troubleshooting it's issues.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting including using Cronjob for Day-to-Day activities.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views.
• Well experienced in working with various project, application and infrastructure teams, in large enterprise projects.
• Database replication using snapshots, materialized views and advanced Replication methods.
• Versatile team player with excellent analytical, communication and inter personal skill.

TECHNICAL SKILLS:

HP: UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.2,6.1,7.2 Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 98/NT/2000/2003/XP

RDBMS: Oracle 11gR2/R1/10g/9i/8i, Oracle 11gr2,10g (RAC, Data Guard)

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager 12C (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Erwin, TOAD, Data Pump (expdp, impdp), Autosys, Query Analyzer, VERITAS NetBackup, Developer 2000,SQL*Plus,SQL*Loader, Golden Gate,Commvault,Toad,SQL Developer

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Oracle DBA

Environment: AWS,RDS,IBM-AIX 5.1 & 6.1, HP-UX 11.31& 11.23, Oracle 12C,11gR2,10g Oracle RAC (11.2.0.2, 11.2.0.3), Golden Gate,Active DataGuard,Oracle Enterprise Manager 12C (OEM), RMAN, Import/Export, ASM, AWR,TOAD, Unix Scripting, SQL*Plus, PL/SQL

Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g, 11gR2 RAC on IBM-AIX, LINUX, HP-UX.
• Migration of on-premise in 11gR2 to AWS RDS instance 12C.
• Monitoring resources, such as Amazon DB Services, CPU Memory, EBS volumes.
• Configuration and supporting 12C databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
• Creation and Rehydration of EC2 instances .
• Implemented Amazon RDS multi-AZ for automatic failover and high availability at the database tier.
• Proficient in writing Cloud Formation Templates (CFT) in YAML and JSON format to build the AWS services with the paradigm of Infrastructure as a Code.
• Exposed to tools like JIRA as part of the agile work environment.
• Migration of Oracle 10g and 11g databases from HP-UX to AIX servers using Datapump, RMAN and Golden Gate.
• Implemented Oracle 12C, Active Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applying patches, patch sets, critical patch updates and PSUs for multiple databases.
• Configuration,implementation, Support of Bi-directional and Uni-directional replication Golden Gate based replications through GGSCI.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM) 12C.
• 24x7 remote support and on call support for Production databases.
• Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN.
• Experienced with installation of AWS CLI to control various AWS services through SHELL/BASH scripting.
• Experienced in creating multiple VPC’s and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.
• Automating the daily routine activities and Schedule maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs.

Confidential, Collierville, TN

Oracle DBA

Environment: Oracle 12C,11g and 10g,PeopleSoft,RAC 11gr2,Performance Tuning,Golden Gate,Data Guard, RHEL 4.4, OID, OEM, Export/Import, SQL, SQL Developer,Shell Scripting.

Responsibilities:

• Involved as SME for supporting PeopleSoft application databases on 4 node RAC cluster.
• Monitor the performance of production systems and utilize appropriate tools to identify tuning requirements.
• Experience with troubleshooting database performance and query tuning.
• Able to work independently and deliver high quality results when given a set of requirements.
• Configuration and implementation of Bi-directional and Uni-directional replication Golden Gate based replications through GGSCI and troubleshooting replication issues.
• Migration of Oracle 10g and 11g databases from HP-UX to AIX servers using Datapump,Rman and Golden Gate.
• Performed RAT(Real Application testing) on 10g databases in HP-UX before upgrading and migrating to 11g version in AIX to identify performance issues.
• Provide root cause analysis of production issues, investigation & implementation of security initiatives.
• Implemented the Oracle 11gR2, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Involved in monitoring the database related activities using 12C OEM Grid Control.
• Refresh data from production to non-production environment at the request of application team using Datapump utility and RMAN.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Applying latest Patch Set Updates on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment including rman backups.
• Strong performance analysis on AWR, ADDM, ASH and advisory views and periodic database instance performance review and tuning recommendation.
• Extensive Performance Tuning, Memory (SGA) Tuning, Avamar backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Confidential, Dallas, TX

Oracle DBA

Environment: Oracle 11g,10g and 9i, SAP,Performance Tuning,Golden Gate,Data Guard, AIX 7.2, Windows 2008 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Avamar,Datapump,Shell Scripting.

Responsibilities:

• Involved as SME for SAP application databases datacenter migration effort for over 100 databases.
• Gather information from client about Oracle database environment in preparation of migration and transition.
• Install and maintain Oracle 11g,10g and 9i databases on Aix 7.2 and Oracle 11g on Windows 2008.
• Configuration and implementation of Bi-directional and Uni-directional replication Golden Gate based replications through GGSCI and troubleshooting replication issues.
• Upgraded oracle databases from 9i to 10g and 10g to 11g using both manual method and DBUA.
• Migration of Oracle 10g and 11g databases from HP-UX to AIX servers using Datapump,Rman and Golden Gate.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard fail over and switch over cases.
• Administration and Support of the oracle databases after migration effort.
• Provide support to developers with troubleshooting and performance tuning, including System Global Area (SGA) analysis, latch contention analysis, disk subsystem tuning, and Structured Query Language (SQL) tuning of Oracle and custom views and queries.
• Refresh data from production to non-production environment at the request of application team using Datapump utility.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Implementing Database Security, Management of role-based security.
• Applying latest Patch Set Updates on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment including rman backups.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups. Backed up system and user databases and restored them as required and create database users and roles and implemented appropriate user security.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Confidential, Richmond, VA

Oracle DBA

Environment: IBM-AIX 5.1 & 6.1, HP-UX 11.31& 11.23, Oracle 11gR2, 11gR1, 10g, and 9i, Oracle RAC (11.2.0.2, 11.2.0.3), Golden Gate, Oracle Enterprise Manager 12C (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g, 11gR2 RAC on IBM-AIX, LINUX, HP-UX, Solaris.
• Upgraded oracle databases from 9i to 10g and 10g to 11g using both manual method and DBUA.
• Migration of Oracle 10g and 11g databases from HP-UX to AIX servers using Datapump, RMAN and Golden Gate.
• Performed RAT(Real Application testing) on 10g databases in HP-UX before upgrading and migrating to 11g version in AIX to identify performance issues.
• Implemented the Oracle 11gR2, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Upgraded 2 Node RAC from 11.2.0.2 to 11.2.0.3 including standby database.
• Applying patches, patch sets, critical patch updates and PSUs for multiple databases.
• Configuration and implementation of Bi-directional and Uni-directional replication Golden Gate based replications through GGSCI.
• Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM) 12C.
• 24x7 remote support and on call support for Production databases.
• Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN.
• Implemented oracle Resource manager to minimize the excessive CPU load.
• Automating the daily routine activities and Schedule maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs.

Confidential, Westerville, OH

Oracle DBA

Environment: RedHat Linux,HP-UX Itanium, Oracle 11g, Oracle Enterprise Manager (OEM), RMAN, Import/Export, Data Guard, ASM, AWR, TOAD, ERWIN, SQL Developer,Unix Scripting, SQL*Plus, HP Data Protector, Time Finder Cloning, HP Operations Manager

Responsibilities:

• Supported Oracle 11gR2 RAC databases on HP-UX Itanium and Linux 5 and 6 servers.
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 10TB on RAC.
• Installed and upgraded from 11.1 to 11.2.0.3 RAC database with the latest Oct PSU on Linux 6.4 for symantic security application.
• Scheduled maintenance jobs by creating/developing Unix shell scripts and Oracle scheduler jobs.
• Cloned 11grR2 RAC Production databases for UAT environments using Transportable Tablespaces.
• Re-engineered production schema from ERWIN to both Toad and SQL developer data modelers.
• Configured RMAN Hot and Cold backups with HP Data Protector media management.
• Proactive database monitoring by using OEM grid control.
• Implemented Security user management, privileges, roles, profiling, auditing, authentications etc.
• Refreshed schemas from production to lower environments with re-mapping tablespaces for partitioned objects.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Worked on both ASM and cooked filesystems for managing data in SAN.
• Documented the issues/resolutions/process details with maintaining them up to date.
• Created and troubleshoot DB Links’ issues in Oracle for communicating with external databases.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Involved in capacity planning and resource planning.
• Generated weekly performance reports to identify and solve the problems with performance.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Performance tuning of database (overall Performance gain) which includes optimization of UNIX Kernel, Oracle INIT.ORA, Oracle SGA, I/O balancing and memory.
• Implemented oracle Resource manager to minimize the excessive CPU load.
• Involved in team management, team building exercises for the DBA team.

Confidential, Berwyn, PA

Oracle DBA

Environment: HP-UX, Windows 2000/2003, and Linux, Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clearcase, SQL*Plus, PL/SQL, SQL*Loader

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Installed and created 11g databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Performed Conversion of data from Post Gre SQL to Oracle
• Query optimization for reporting and ETL
• Created & Managed Jobs using AutoSys Job Scheduler
• Extensive UNIX Shell scripting in csh, Pro*C
• Planned version control of production source code using Clearcase
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database.