SUMMARY

• 11+ years of professional experience in IT in the areas of Oracle database administration, Oracle Exadata, Oracle ZFS, Oracle RAC DBA, Oracle 10g Application server administration, Oracle Enterprise Manager (OEM), OAM (Oracle Access Manager), Oracle discoverer administration, Oracle WebLogic Administration and Oracle Applications DBA 11i/R12
• Hands on experience in Exadata X5/X6 Nodes, Oracle ZFS storage Appliances
• Hands on experience in MySQL 5.5, 5.6 database environment build and support
• MySQL Installation and cluster and standalone servers and configured MySQL database monitoring through Nimsoft and ServiceNow
• MySQL database error scanning in mysql.log and logfile size monitoring.
• MySQL database monitoring automation like mysqld process, uptime, threads count, max used connections etc.
• Automation scripts for MySQL slow queries and, inno db locks monitoring
• Hands on experience in setting MySQL Master - Master and Master-Slave replications setup and MySQL database backups using mysqldump and direct copying. Mange MySQL User accounts and granting/revoking privileges
• Hands on Experience on Oracle Real Application Clusters (RAC)
• Hands on experience in Oracle Golden Gate, Oracle to Oracle and Oracle to Heterogenous environments
• Experience in managing engineering and production support functions for Oracle, MSSQL and MySQL database technologies.
• Experience in leading Exadata implementations, database migrations and on-going Exadata support.
• Extensive work experience includes Implementations, Upgrades, Support and Maintenance of Oracle databases 8i/9i/10g/11g and Oracle 12c and Oracle 11i/R12 E-Business Suite, associated Oracle Technology Stack and Oracle Database in a multi-tier/multi-node environment. Worked during various phases of SDLC such as Requirements and Analysis, Design and Construction, Testing, UAT
• Hands on experience in Microsoft Azure, Creating Subscriptions/VM’s/Azure SQL DB’s/Key Vault management.
• Installation of Oracle Apps11i & R12 (single/multi node) on Unix Environments.
• Installed and Configured Oracle Golden Gate replication from Oracle to Kafka environment
• Installed and Configured Oracle Golden Gate replication from Oracle to Big Data Hadoop Filesystem
• Implementation of two nodes Oracle RAC on Linux with ASM.
• Experience in Oracle Applications upgrade from 11.5.10 to R12 and preserving the customizations
• Implementation of setting up the Oracle Data Guard in Oracle Applications R12 and 11i for disaster recovery.
• Up gradation of Oracle databases from 9i to 10g and 10g to 11gR2.
• Installation of standalone Oracle 10g/11g Grid control and configure the alerts to monitor databases
• Implementation of DMZ server on 11.5.10.2 and R12.
• An excellent team player having very good relationships with the various teams within the organization.
• Worked on 24/7 high availability environments.

TECHNICAL SKILLS

Oracle Applications: Oracle Exadata, Oracle Database, Oracle RAC, Oracle E-Business suite 11i/R12

Database: Oracle 12c/11g/10g/9i/8i, MSSQL 2008/2012 and MySQL 5.5

Database HA: Oracle RAC, Dataguard, DR setups

Tools: Oracle 12c grid control/Oracle Enterprise Manager 11g / Oracle 10G Application server, SQL Developer, Workbench and Toad

Languages: SQL, PL/SQL

Operating System: Sun Solaris 5.8, 5.9 and Red Hat Linux AS 4 and 5, Windows NT/XP/2000

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle database administrator

Responsibilities:

• Analyzes, tests, and implements physical database design focusing on Oracle RDBMS systems
• Installed and configured Exadata X5/X6 Quarter racks.
• Configured Oracle ZFS storage appliances.
• Installed and Configured Oracle Golden Gate replication from Oracle to Kafka environment
• Installed and Configured Oracle Golden Gate replication from Oracle to Big Data Hadoop Filesystem
• Upgrade of the database environments from 11.2.0.4 to 12.1.0.2
• Migration of Oracle databases from AIX to Exadata environment
• ZFS snapshot cloning
• Installed Percona MySQL on standalone server for TALEND application
• MySQL Master and Slave replication setup
• Maintaining MySQL Log Files
• Backing Up, Copying, and Recovering MySQL Databases
• Starting Up and Shutting Down the MySQL Server as per the maintenance schedules
• Creating new users in MySQL database and granting privileges
• Supporting Critical production Oracle databases 11.2.0.4 and 12.1.0.2 RAC environments
• Cloning/Refresh of Oracle Databases and EBS environments from production to DEV/TEST/QC environments
• Dataguard environment setup for all the critical production databases
• Configured Microsoft Azure and created subscriptions/Resource groups
• Created VM’s in Microsoft AZURE and Azure SQL db.’s
• Supporting Business critical EBS applications which are running Oracle EBS R12 environments
• Follows the guidelines mutually established by the host countries, and IT Management
• Responsible for the setup, patching, debugging, upgrading and installation of database software and the applications that run on that system as well as any 3rd party tool sets as they relate to application users
• Documents and maintains consistent and current patches across all Oracle Environments for each country and application
• Audits the current environments, provides capacity planning and implements best practices, which may include establishing new standards and procedures
• Ensures data recovery, maintenance, data integrity, and space management through adherence to policies, procedures, and standards relating to database management
• Maintains and develops backup and recovery processes for Oracle RDBMS systems, using RMAN, EMC BCV, IBM XIV snapshots, or scripts for online and offline backups and recoveries
• Installs, upgrades, maintains, monitors, patches, and tunes Oracle RDBMS systems
• Implements, maintains, and utilizes monitoring and alerting systems, such as Oracle Enterprise Manager (OEM) and custom Korn Shell scripts
• Develops and maintains Korn Shell scripts to aid in the performance of assigned duties
• Maintains a working knowledge of and administers solutions using Oracle Dataguard/Standby Database technology

Confidential

Lead Administrator

Responsibilities:

• RMAN cloning for the database refresh
• Database Upgrades and Migrations from 11g to 12c
• Exadata X5-2 implementation and migrate the databases from AIX to Exadata
• Implementation of Oracle Instantis Enterprise track
• 12c OEM upgrade from 11g
• Oracle Golden Gate implementation and setup replication form Oracle to Non-Oracle
• Upgradation of Oracle EBS 11i to R12.2
• Providing 24*7 support and maintenance of critical Oracle Database environments
• Security patches (PSU/CPU) deploy on Oracle databases.
• Involved in Cloning and patching of oracle applications R12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and
• Various oracle application environments.
• Involved in capacity planning and physical and logical database design
• Performance tuning of queries which is taking long time to complete.
• Enterprise Manager11g/12c and Oracle Grid cloud control 12c, Oracle EPM, Oracle GRC, Oracle Instantis.
• Implementation of Oracle GRC and integration with Oracle E-Business suite 11i and R12
• Involved in Implementing High availability oracle applications R12 using PCP (Parallel concurrent
• Processing), 11g RAC and Data guard.

Confidential

Team Lead, Senior Oracle Applications DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.10 to 12.1.3 preserving the customizations.
• Involved in Cloning and patching of oracle applications R12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Applying patches on Oracle E-Business suite instances to resolve application related issues like HR, Payroll and Irecruitment issues.
• RMAN cloning for the database refresh.
• Installed Percona MySQL on 2 node cluster environments for aaa.com website
• Salve to Master Switch over configurations and document the process
• Identified the permanent solutions for MySQL-Maximum Users Connections Reached issues
• MySQL Master and Slave replication setup
• MySQL Innodb Engine Performance Tuning
• Maintaining MySQL Log Files
• Backing Up, Copying, and Recovering MySQL Databases
• Starting Up and Shutting Down the MySQL Server as per the maintenance schedule
• Involved in SYSADMIN activities like creation of users, assigning responsibilities and administering concurrent managers.
• RMAN cloning for the database refresh.
• Performed Database Upgrade from 10.2.0.4 to 11.2.0.2
• Performed Database Upgrade from 11.2.0.3 to 12.2.0.1
• Installed and Configured Oracle grid 12c Control.
• Involved in the strategy and planning of database application for future releases.
• Involved in capacity planning and physical and logical database design
• Performance tuning of queries which is taking long time to complete.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms
• Creating tablespaces and planning the location of data, monitoring the table space growth periodically.
• Database recovery, moving data files to different locations.
• Monitoring the scheduled backups, check the backups in case of failures
• Refreshing (Clone) Oracle Database for testing and implementation.
• Checking the Data files Consistency using DB verify utility.
• Taking Cold Backups.
• Export/Import of Tables, Users and Databases.
• Involved the required DBA activities for Database, Application and Interaction with Oracle Developers to assist them in troubleshooting their problems.
• SQL*Loader.
• Resolving issues involved with reports, concurrent managers, requests and printers
• Performed database administration and user/security management. Resolve issues related to client/server connections.
• Tuned the slow running concurrent requests and defined concurrent managers.
• Performed feasibility study and recommend pros/cons for high availability configuration including design and implementation.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice
• Customizing autoconfig templates according to the environment requirements.
• Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance activities
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Worked on multi-node RAC DB and multi-node Mid-tier Apps.
• Performance tuning on DB and Applications.
• Complete documentation on DBA activities

Environment: Oracle Applications 11.5.10, 12.1.3, Oracle 9i/10g/11g/12c, Oracle Enterprise Manager11g and Oracle Grid cloud control 12c.