PROFESSIONAL SUMMARY

• 16+ years of experience in Oracle Database design, administration, support, upgrade and migration.
• Expertise in Installation, configuration and administration of Oracle 9i, 10g, 11g, 12c standalone/RAC databases and standby databases on various environment like Solaris, Linux, HP, IBM AIX and Windows. Expertise in database migration, applying patches, db capacity planning, backup strategy planning and tuning of critical database environment and good experience in ZDLRA/RMAN Utility.
• Led and managed DBA and technical team in onsite - offshore model with tight SLA Schedules, ticket resolution within agreed upon SLA schedules, also as a consultant closely worked with fortune 500 companies like Confidential, Confidential Inc, Confidential, Confidential, Confidential P&G, Confidential etc., customers for any business requirements, Database upgrade, day-to-day database and server support activities.

TECHNICAL EXPERIENCE

• Good experience in Oracle database upgrade and migration, 24X7 production support, implementation and administration of Oracle databases (8i, 9i,10g,11g and 12c Standalone/ RAC) on various environment Sun Solaris, Linux Red Hat advanced server, HP and windows.
• Experience in Data Guard setup and RAC DG setup and FSFO configuration
• Experience in Oracle Advanced Replication/Oracle Streams/Oracle Golden Gate (uni-directional and bi-directional)
• Experience in patch implementation(Manual/OEM) on various environment.
• Experience in Oracle Software installation
• Experience in ORACLE 13c/12c and 11g OEM Grid control implementation and configuration, Agent installations and configuration.
• Experience in RMAN backup and recovery implementation
• Experience in 11g RAC setup and RAC patching and RAC upgrades.
• Experience in Database performance tuning and optimization, Database cloning / overlay to recover lost objects.
• Experience in Disaster Recovery Drills and Quarterly recovery test to perform to validate the backups on tape
• Experience in Zero Data Loss Recovery Appliance(ZDLRA) and good knowledge in Exadata
• Experience in Mongo DB and Netezza.
• Excellent analytical, logical and inter-personal skills

PROFESSIONAL EXPERIENCE

IT Database Services

Confidential, San Diego CA

Responsibilities:

• Managing 100 + enterprise-level Oracle 11g and 12c database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Designed, implemented and supported various Multi-Rac Node 11gr2 OLTP and Data Warehouse database for Confidential Chipset Technology E-Business Suite R12 application across Sun Solaris and Red Hat Linux systems
• Designed and Implemented Oracle Disaster Recovery Solutions with 11g/12c Data Guard, Active Data Guard using DG Broker and Real-Time apply.
• Installed/upgraded and configured oracle GoldenGate unidirectional table level / schema level between homogenous oracle to oracle rdbms replication.
• Architect and Implement Enterprise Manager 12c and enabled Enterprise-Wide monitoring of all Databases and Hosts across Confidential .
• Implemented Oracle RAC from the scratch, installation/support experience for Oracle 11i and other Oracle DB based solutions. 24x7 support experience Standby/Data Guard.
• Hands on in OEM Grid Control, Explain Plan, Tkprof, AWR, ADDM, ASH and SQL Tuning Advisor (sqltrpt) utilities to find and tune the top wait events, top sql’s by elapsed time, CPU and IO Creating index, Sql profile and SPM to improve the query performance.
• Implemented ZDLRA (Zero Data Loss Recovery Appliance) for all prod databases and providing support.
• Implemented Database Hardening as per industry standard to have secure environment.
• Patch implementation through OEM.
• Mongo DB v.3.4.1 installation and configuration and providing support.
• Netezza 7.2.1.3 refresh from Prod/ Script Migration.

Environment: Oracle 10g, 11g, 12c databases, Golden Gate 11g on Sun Solaris and Linux Red Hat advanced server, Windows servers.

IT Database Services

Confidential, Los Angeles CA

Responsibilities:

• Managed and monitored Oracle Databases 10G/11G/12C in 24x7 (OLTP & Data Warehouse) in Prod and Non-prod using OEM Grid control and Panopta tool.
• Upgraded database from 11.2.0.3 to 11.2.0.4 prod and non-prod databases using traditional upgrade, and applied quarterly PSU patches periodically.
• Managed and supported database backup and recovery using RMAN. Design and implement of database backup strategy and performed backup and recovery using RMAN for prod and non-prod development databases.
• Cloned Duplicate production database into Test/Development database using RMAN
• Provided support to the team for performance tuning activities
• Implemented Oracle TDE tablespace encryption, network data encryption and Oracle wallet.

Environment: Oracle 10g, 11g, 12c databases on IBM AIX servers.

Product Support

Confidential, Cincinnati, OH

Responsibilities:

• Implemented and supporting N-way schema level replication using Oracle Streams
• Troubleshooting the database issues in Production, Test and development databases
• Software Installation and applied required patches.
• Upgraded DB in production environment using Golden Gate for zero downtime.
• Creation of databases for Production and Test servers, backup configuration and implementing daily admin scripts.
• Configured RMAN backup for all production servers.
• Implemented backup strategy for regular online backups on production databases.
• Created 11g standby database using RMAN and configured data guard with real time log apply.
• Experienced in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.
• Performed Quarterly recovery test to perform to validate the backups on tape.
• Cloned/Duplicated databases using RMAN backups whenever required by business.
• Done the database/schema refreshes from production databases to test/development servers.
• Worked on performance tuning for Prod database when required.

Environment: Oracle 10g, 11g and 12c databases on Linux Red Hat advanced server, Windows servers.

Product Support

Confidential, Houston, TX

Responsibility:

• Extensive knowledge of Oracle Database Administration in Oracle 8i/9i/10G/11G and Managing Oracle Databases in 24x7 (OLTP & Data Warehouse) environment, working in Production, Development and Data Warehouse environment.
• Extensive knowledge in database upgrade from Oracle 8i to 9i, 9i to 10G, 10x to 10y, 9i to 11G and 10G to 11G including upgrades for Production, Development, Data guard, RAC and ASM databases.
• Extensive knowledge on database backup and recovery using RMAN. Design and implement of database backup strategy and performed backup and recovery using RMAN for production and development including the Dataguard, RAC and ASM databases.
• Extensive knowledge of taking logical backup for database/schema/tables using export/import, and expdp/impdp utility.
• Migrated oracle databases successfully into cross platform operating system using export/import, expdp/impdp utility.
• Implemented uni-directional schema level replication using Oracle Streams and troubleshooting the capture and apply issues.
• Created and maintained oracle Data guard database with physical standby using RMAN for the critical and production database. Monitor and manage effectively the Dataguard, RAC and ASM databases.
• Performed switchover or failover for Dataguard database whenever is required. Troubleshoot dataguard database related issues/failures.
• Clone/Duplicate production database into Test/Development database using RMAN including Dataguard, RAC and ASM databases.
• Restored and recovered successfully production databases in Dataguard, RAC and ASM environment using RMAN. Convert successfully oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.
• Performed Disaster recovery test frequently as per customer requirement using RMAN for the critical production databases. Restore and recover the critical production databases with in the stipulated time at DR site.
• Plan and Implement backup strategy using Hot, Archive log, Cold and Export based on the business requirements.
• Performance Tuning, monitor all database status including CPU, Memory, I/O, Space Management. Tune database memory by increase db cache size, shared pool size, pga aggregate target and increase SGA.
• Performance tuning analyze and maintain statistics for the database using DBMS STATS utility. Tune SQL for better performance by using explain plan and create indexes wherever necessary.
• Involved the database Capacity Planning for the future business growth requirement and suggest the input value to customer
• Provided 24*7 database support to customer and ensure database administration on production, testing and development databases. Monitor and manage space for archive log, data files and tablespaces.
• Estimated space requirement, create required tablespaces, datafiles and tempfiles. Checking alert log files trace files and analyze and fix the issues to avoid the impact on system performance.
• Applied Oracle Quarterly CPU Patch, Bugfix Patch periodically for the development and production servers, and apply patches on Dataguard, RAC and ASM databases.
• Managed Offshore and Onsite DBA Services including management of client work activities, understanding overall client and business deliverables.
• Activity Status Monitoring and delivery.
• Participated in preparing Service Level Agreements and ensure Compliance.
• Preparation and review of Call, Task Trackers and Metrics in correspondence to SLA Adherence and preparation of causal analysis and action plans on SLA deviation.
• Prepare and Review Process documents for process improvements including ensure compliance with all laid down processes and procedures by all team members.
• Team Management, Team Performance Management and Training plan.

Environment: Oracle 8i, 9i, 10g,11g and Oracle 10g and 11g RAC databases on Sun Solaris, Linux Red Hat advanced server, HP and windows servers. Sun Cluster HA oracle 11g databases and 11g Enterprise Manager Grid control and Oracle Golden Gate 11.1.1.0, Golden Gate Director and veridata on 11g databases.

Database Production Support

Confidential, Washington DC,

Responsibility:

• Database services and troubleshooting the issues in Production, Test and development database servers.
• Oracle Software Installation and applied required patches.
• Creation of databases for Production and Test servers, backup configuration and implementing daily admin scripts and adding databases to the OID servers.
• Upgraded database 9i to 10g versions.
• Installed oracle OMS Grid server and configured agent on all database to monitor the databases from central console, number of databases monitored using grid around 150.
• Agents were pushed from central OMS server.
• Configured RMAN backup for all production servers to tape using Galaxy utility.
• Implemented backup strategy for regular online/offline backups on production databases.
• Created 10g and 9i standby database using RMAN and configured dataguard with real time log apply.
• Implemented uni-directional and bi-directional schema level replication using Oracle Streams.
• Experienced in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.
• 10g RAC Implementation in development and test environments. (Linux platform)
• Perform Quarterly recovery test to perform to validate the backups on tape.
• Plan and perform recovery for Disaster Recovery Drill.
• Cloned/Duplicated databases using RMAN backups whenever required by business.
• Done the database/schema refreshes from production databases to test/development servers.
• Worked on performance tuning for Prod database when required.
• Provided support for onsite/offshore project developers and created and compiled objects based on the need.
• Implemented the security standards for all the production databases.
• Database health check for all production Database using shell scripts was done.
• Applied patch for 8x/9x/10g oracle versions in UNIX and windows platform.
• Automated shell scripts to do DB health check, logical/hot backup, standby sync and refresh objects based on user request.
• Monitoring the request queue and work allocation to team members.
• Preparation of consolidated Weekly/Monthly Lotus notes based Status report
• Monitoring and reviewing the SLA based work allocation on monthly basis
• Weekly on-call meeting with Onsite Team for Project updates.
• Preparation of RCA (Root Cause Analysis) report for identifying and correcting the exception if any.
• Updation of Requirement specifications document.
• Mentoring the technical knowledge project wise to team members.
• Preparation of project plan and implementation for new projects.

Environment: Oracle 8i, 9i, 10g on AIX 5L, Linux RHEL4, Windows 2000 servers. Oracle 10g Grid control on AIX servers.

Database Support

Confidential, Santa Clara, CA

Responsibility:

• Database support to customer base and troubleshooting issues in production, Test and Development environments.
• Developing scripts for monitoring the databases regularly and to send alert pages/mails to DBA team.
• Handling Technical Change Controls as per the requirements like applying upgrade patches, database upgrades and implementing audit recommendations.
• Periodic database health checkup and reviews with the application teams.
• Coordinating with data center in setting up backups for new databases and in periodic backup validation.
• Capacity planning for future storage requirements for the primary databases.
• Development/QA Database Refreshes from Production databases.
• Health check on databases using Statspack
• Migrating and upgrading to oracle 9.2. *, 10g.
• Modifying and enhancing shell scripts for cloning and database backups
• Interacting with the development team for various support activities.
• Database Performance Reviews with the Application teams.
• Implemented ORACLE Advanced REPLICATION (Multi-master replication)
• Table Re-organization and Index rebuilding.

Environment: Oracle 8i,9i,10g on HP UX- E9000/800, Sun Solaris 2.8, Linux 3.0.34, Windows 2000 servers and replication on 8i and 9i databases.

Oracle Cluster Database Support

Confidential, Peoria, IL

Responsibility:

• Coordinating Onsite-offshore DBA for day-to-day Confidential Database and business support
• Database migration from oracle 9i to 10g RAC database in Mission critical and RAC environment
• Implementing Enterprise manager new features for newly migrated 10g database
• Implemented Oracle 10g Application Server in testing and QA environment for new business
• Prepared detailed understanding document for Knowledge transition to offshore DBA
• Handling tickets individually for any DB critical and business issues
• Worked closely with Oracle support for any critical ORA errors and Patch issues
• Database upgrade and applying patch as on when required across the environment
• On-call support for any critical issues and server migration on non-business hours
• Support System admin during Change window for any critical business applications
• Managing and monitoring incoming DBA requests through ticketing systems
• Participating weekly Infrastructure meetings with Customer for future business requirements
• Refresh database from production to test environment as on when required
• Installation and configuration of Oracle client for business users as on when required
• Monitoring RMAN and hot backup of Mission critical and RAC databases.
• Hardware Capacity planning for future growth of database across the environment
• Organized weekly status meeting with team on pending issues and action plan

Environment: Oracle 8.1.7, 9i on Sun Solaris 2.8, Windows NT 4.0, HP 9000 Series HP-UX (64-bit) 11.0, AIX 5.1, Linux 3.0.34 servers.

Confidential

Responsibility:

• As a DBA, was responsible for Installation of oracle 8.1.7 on Windows NT and Sun Solaris 2.8
• Creation and maintenance of databases
• Creation of database schema Objects, Flat Tables, Partition Tables, clusters, Indexes, sequences, Synonyms according to the standard naming conventions
• As the person in charge of the database team, I designed the quality metrics for the database which includes the rules for fixing the size of tables, the schema objects naming conventions, code of conduct for writing SQL, backup strategy and other tuning tips
• Trouble shooting correction of application programs for bugs and performance tuning
• Tuned the database at Memory, I/O and Application Levels.
• Installation and Administration of Reports 6.i and Discoverer 3.i on Windows NT and Solaris 2.8
• Installation and Administration of WebLogic 5.1
• Installation and Administration of Netscape Directory Server 4.2(Ldap Authentication Server).
• Establishing and implementing sound Backup and recovery procedures
• Evaluate Oracle features and Oracle related products
• Providing 7x24 support when required
• Technical trouble shooting and give consultation to development teams
• Leading the team of database developers and guiding junior DBA's
• Table Re-organization and Index rebuilding.
• Sizing indexes and tables

Environment: Oracle 8.1.7, Reports 6.i, Discoverer 3.1, Web logic 5.1, NDS 4.2 on Windows NT and Sun Solaris 2.8 servers