SUMMARY

• Has managed team of 30 DBA and provided support for 3700+ customer databases with 24/7 coverage.
• Well experienced in leading pool of DBA team and has interpersonal communication skills and technical documentation skills.
• Has experience in setting up oracle servers in amazon cloud environment.
• Built 11gR2 databases & DR setup in Amazon Cloud.
• Used Oracle Secured Backup for Cloud database backups.
• Restore and Recovery of oracle database in Cloud environments.
• Very good in troubleshooting oracle database performance issues, critical outages.
• Planned and Implemented RAC 5 node for fortune 500 pharmaceuticals organization
• Addition and Deletion of Nodes in Real Application Clusters
• Troubleshooting and Resolving of Oracle RAC database issues on cluster environments
• Installed and configured 10g OMS R3 and Agents on all servers and configured the servers for all the database processes to be monitored on the 10g grid OEM.
• Upgraded OMS 10g and agents from R3 to R5
• Administered Oracle Databases in UNIX, LINUX, SOLARIS, AIX and WINDOWS Platforms
• Installing database security patches, backup and recovery operations.
• Rich experience on up gradation from 8i, 9i to 10g and 10g to 11g.
• Installation and Configuration of Oracle Application Express (Formerly HTMLDB).
• Upgraded APEX 2.0 to 3.1.2, 3.2 on multiple databases.
• Upgraded of RMAN catalog from 10g to 11g to support 11g database backup.
• Has Depth knowledge on database restore and recovery operations.
• Installation and configuration of Oracle GoldenGate.
• Configure DDL and object level replication between oracle databases resides in remotely.
• Setting up oracle physical data guard for clients.
• Troubleshooting of oracle data guard issues.
• Installed Windows 2003 64 bit Clusterware and SQL Server 2005 /2008
• Planned and tested the restoration of Critical database on Quarterly basis for DR activity.
• Installed and Troubleshooting of Oracle Internet Directory v9.2.0.4
• Administration and troubleshooting of SQL 2000/2005 /2008 Server databases
• Upgraded MeDDRa and whoDD dictionary on drug Safety Production databases.
• Excellent understanding of project management and tracking of issues.
• Experience in leading pool of DBA team and has interpersonal communication skills and technical documentation skills.
• Has deep knowledge on Documentation and process on pharmaceutical environments
• Involved in process streamlining and generation of metric reports for upper management team.

TECHNICAL SKILLS

RDBMS: Oracle 7.3, 8.1.7, 9.2.0.4, 9.1.0.1, 10.1.0/ 10.2 , 11.1.0.6/11.1.0.7 ,11.2.0.2, 11.2.0.3 and SQL Server 2000, 2005,2008 and 2012

Operating Systems: HP Unix 10.2, 11.x, Solaris 2.8 and 2.9, Red Hat LINUX AS 2.3, 9,IBM AIX 5.1, 5.2 and Windows 2000 / 2003

Database Tools/Utilities: ADDM, AWR, RAT, DATAGAURD, STATSPACK, TKPROF, ORACLE EM, RMAN, TOAD, ERWIN, Datapump, Putty, SQL Loader, SSH, SFTP and SQL Navigator, Goldengate

Web Server: Weblogic, Apache and Microsoft IIS

PROFESSIONAL EXPERIENCE

Confidential

Lead DBA

Responsibilities:

• Manage Vendor team to deliver the work effectively and timely fashion.
• Work with development team and review application design and recommend improvement.
• Architecting and planning of oracle database layouts for SAS hosting applications.
• Review usage of oracle products and purchase licenses and new products to reduce the cost spend on oracle licenses.
• Recommend suitable hardware and architectural changes for high available and scalable environment.
• Building oracle database servers for production and development environments.
• Installing Oracle 11gr2 Clusterware and configuration for optimal performance
• Implemented 12c cloud control for database administration and monitoring
• Performance tuning of 2.3 TB size OLTP databases on two node RAC environment
• Optimization of Database backup and reduced RTO of the database
• Implemented oracle TDE for encryption of application critical data’s.
• Installed and configured MYSQL databases for e - learning applications.
• Setup monitoring for MYSQL in AWS RDS cloud and administration.
• Perform backup and recovery of MYSQL databases.
• Working with development team and provide guidance for better query writing.
• Evaluated oracle golden gate for Zero Downtime upgrade on schema changes.
• Implementation of Oracle Active data guard for DR solution
• Implemented Evault cloud backup for databases.
• Supporting MSSQL 2008 server instances for BI solutions
• Schedule administrative jobs using active batch scheduler.
• Work with management team to upgrade database software
• Applying database patch to fix oracle bug’s
• Review oracle quarterly patch release and take necessary action.
• Evaluated Amazon RDS services for QA and Development environments
• Evaluated and performed POC on mongodb and Cassandra databases.
• Involved in testing and evaluating of NOSQL databases.
• Administration of BIRST Analytics and reporting environment.
• Strong knowledge of ITIL concepts and Servicenow ticketing tool
• Implemented oracle partitioning for data archival and performance purpose.
• Design and create reporting schemas using oracle Materialized views for reporting purpose.

Confidential

DBA Operations Manager

Responsibilities:

• Managed a team of 30 DBA’s to support highly demanding environment.
• Provided support for 3700+ customer databases with 24/7 coverage.
• Lead Database CRT team to ensure all critical issues are addressed within SLA.
• Review monthly and quarterly database audit reports and compliance related issues.
• Implementation of SOX controls to host SOX compliance applications.
• Meet with client and gather project requirement and communicate with offshore team.
• Setting up oracle database servers on Amazon cloud.
• Building oracle 11gr2 database & DR setup on Amazon cloud servers.
• Using the Cloud for Oracle Database Backups.
• Creating a Key Pair for Authentication.
• Starting an Oracle Database Server.
• Updating the Oracle Secure Backup Installer.
• Backing up the Database to cloud.
• Restoring the Database from cloud.
• Provide 24/7 support for 3700+ oracle databases for J&J.
• Lead Critical Response Team to ensure all major outages are resolved within SLA.
• Resolve critical / major database outages and issues.
• Co-ordinate between offshore and onsite team and close the escalated issues
• Execution of project and co-ordination between DBA and application team.
• Tuning database for better performance using Oracle Tools and manual scripts
• Implementation of TDE for encryption in Oracle databases
• Up-gradation of database from lower version to oracle 11g R2.
• Problem troubleshooting and fixing production database issues.
• Handling escalated issues and following with DBA’s to close the pending issues.
• Installed and configured DDL replication with Oracle 11g Golden Gate
• Worked on Oracle 11g golden gate POC project and documented the results.
• Troubleshooting oracle golden gate replication problems and issues.
• Implementation of BCV backups and create scripts perform automated backups for mission critical databases.
• Worked on Servicenow ticket

Confidential

Lead DBA

Responsibilities:

• Lead for 5 member DBA team.
• Handling escalation and customer focus to make sure quality service is delivered.
• Planned and implemented RAC databases with 11g Clusterware
• Installed and Administered RAC databases on 5 node and 3 node clusters
• Deletion and Addition of RAC nodes
• Up gradation of Oracle Clusterware from 11.1.0.6 to 11.1.0.7
• Creation and administration of RAC services for Load balance and high availability
• Up gradation of RAC database from 10g to 11g.
• Installation of Oracle Management Grid Control 10g R3 and R5
• Installation 10g R3, R5 agent and configured with OMS Server for target monitoring and administration.
• Creation of 9i, 10g and 11g Databases using the customized script.
• Upgraded the databases from 9i to 10g, 10g to 11g.
• Apply rolling forward patch on RAC environments.
• Review and Applying CPU and One off security patches on different version of databases
• Installation of ASM instance and configuration of ASM disk group.
• Installation and up gradation of Application express 3.0,3.2 and 4 and Migration of HTMLDB application to Application express
• Administration of Oracle iAS component HTTP servers, OC4J and OMS processes. Maintenance of OMS repository for better performance.
• Automate development refresh using scripts to have read consistency in the Data from production
• Developed data pump export script implemented in all the 10g and above DB’s.
• Supported 350 remote databases using automated scripts
• Installed and Administered Microsoft SQL Server 2000 and 2005 with the size of 1TB.
• Backup and Recovery of MS SQL Servers databases.
• Up gradation of Meddra and WhoDD dictionary on Drug Safety production databases
• Provided 24/5 support and managed offshore team.
• Developed IQ/OQ scripts for all
• Provided extensive support of Oracle Argus Safety application upgrade from various versions.
• Create ER diagram using Embarcadero ER studio and publish through portal.
• Used Reverse engineering method to create ER diagram for already created databases.