SUMMARY

• 15+ years of experience in Oracle Database design, administration, support, upgrade and migration.
• Expertise in Installation, configuration and administration of Oracle 9i, 10g, 11g,12c RAC database and standby database 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 RMAN Utility.
• Experience in Oracle database upgrade and migration, 24X7 production support, implementation and administration of Oracle databases (8i, 9i, 10g, 11g and 12c) 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 11g, 12c RAC setup and RAC patching and RAC upgrades.
• Experience in hardware capacity planning, Oracle upgradation, Data migration, Replication, Oracle failsafe, database/application server performance tuning and Backup strategy planning.
• 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 RMAN backup and recovery implementation
• Experience in ORACLE 12c and 11g OEM Grid control implementation and configuration, Agent installations and configuration.
• Experience in implementing ORACLE STREAMS(uni - directional and bi-directional )and managed Operational, Historical and reporting databases
• Experience in implementing ORACLE REPLICATION(Multi-master replication )
• Experience in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.
• Experience in implementing ORACLE STREAMS(uni-directional and bi-directional )and managed Operational, Historical and reporting databases
• Experience in ORACLE GOLDEN GATE, DIRECTOR and VERIDATA installation and configuration
• Experience in MS SQL Server 2005/2008 in Production, QA and Development environments and Good knowledge on SQL Server 2012/2014.
• Experience in Weblogic server 6.x,7.x and 10.x installation and configuration and troubleshooting issues.
• Involved Oracle Fusion Middleware Products Oracle 11g Identity & Access Manager implementation & Administration and integrated Oracle Access Manager (SSO) with Ebiz.
• Experience in patch implementation on various environment.

TECHNICAL SKILLS

Databases: Oracle 12c,11g, 10g, 9i, 8i, 8.x, 7.x, 6.0 MS SQL Server 2005 and 2008

Languages: C, C++, Java and J2EE

Application server: Oracle 9iAS Release 2, Websphere MQ, Web logic, iPlanet

Tools: and Utilities: OEM 2.2, Forms6i, Reports6i, SQL*Loader, Oracle Workflow, Oracle PL/SQL, Designer 6i,Developer/2000,Discoverer 3.1(Administration & User) Visual Basic 5.0

ERP Applications & Tools: Oracle Applications - 11i, 11.0.3, 12.0.6, 12.1.1

ETL Tools: Informatica (Power Mart & Power Center)

Decision Support Tools: Business Objects, Brio, Web Intelligence and Apache

Web Technologies: Weblogic, IBM Websphere MQ

Fusion Middleware: IDM, OIM, OAM, SOA, OBIEE and SSO

Replication: Golden Gate, Streams and Oracle Advanced Replication

Hardware: Sun Fire V880, Sun Ultra Enterprise 3500, Sun Ultra Enterprise 250/450, Acer Altros19000 DDE Org Supermax RISC Plus IBM, Dell 6600, Compaq Proliants, Compaq DL580, IBM Netfinity

Operating Systems: Sun SPARC Solaris 2.x, Linux Red Hat Advanced server, HP-UNIX, IBM AIX Unix Windows 2000 advanced server, Windows XP, Windows 2003 and Windows 2008

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

GDS Product Support

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.
• 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 dataguard with real time log apply.
• Experienced in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.
• Perform 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.
• Upgraded databases from 11G(11.2.0.4) to 12C (12.1.0.2) including upgrades for Production, Dev and Test databases on Linux 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.

Confidential, Houston, TX

BBST Product Support

Responsibilities:

• 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, 11G to 12C including upgrades for Production, Development, Dataguard, 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.
• Migrate 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.
• Experienced in Oracle Golden Gate installation, configuration and troubleshooting the gg issues.
• Experienced in Oracle Golden Gate Veridata and Director Installation and configuration.
• Experienced in management and database administration of Oracle database applications on Exadata platforms
• Create and maintain oracle Dataguard database with physical standby using RMAN for the critical and production database. Monitor and manage effectively the Dataguard, RAC and ASM databases.
• Perform 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.
• Restore and recover 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.
• Perform 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 also increase SGA.
• Performance tuning analyzes and maintains statistics for the database using DBMS STATS utility. Tune SQL for better performance by using explain plan and create indexes wherever necessary.
• Experienced in using Explain Plan, Tkprof, STATSPACK, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve database performance.
• Involved the database Capacity Planning for the future business growth requirement and suggest the input value to customer
• Provide 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 table spaces.
• Estimate space requirement, create required table spaces, data files and tempfiles. Checking alert log files trace files and analyze and fix the issues to avoid the impact on system performance.
• Applying Oracle Quarterly CPU Patch, Bug fix Patch periodically for the development and production servers, and also apply patches on Dataguard, RAC and ASM databases.
• Manage 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.
• Installing and Configuring of MS SQL
• Setting up and maintaining Log shipping.
• Backup user databases and perform database restore and run consistency checks from SQL Server and application
• Scheduling of maintenance Jobs (Daily, Weekly, Monthly) As per the as client request
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
• Backup verification.(Daily and Weekly)
• Monitor SQL Server services status, Application log, Jobs, SQL Server Logs, Dead locks/Blocking
• Monitoring of Disk space where physical databases are stored
• Creation of Jobs & Maintenance Plans
• Monitoring Production server issues, troubleshooting and resolving the incidents.
• Maintaining server and database level user security privileges.
• Setting up and Monitoring Backup jobs.

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, MS SQL Server 2005, 2008 on Windows Server 2003 and 2008

Confidential, Washington DC

Database Production Support

Responsibilities:

• 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.
• Upgrade 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.
• Installed and configured weblogic 6.x/7.x for supporting java based applications.
• 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. Physical standby databases on 10g databases and Oracle streams on 10g databases Tools: OEM, Toad. Informatica (Power Mart & Power Center) and Brio reports

Confidential, Santa Clara, CA

Database Support

Responsibilities:

• 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.