SUMMARY

• Oracle Certified Professional with 9 years of experience in Oracle Database Administration includes Installation, Configuration, upgrades, Migration, Production Support, Patch management, Database Backup & Recovery, Data guard implementation, databases migration to Amazon cloud, Configuring and Managing Oracle 10g/11gR2 RAC databases with ASM features, Worked on various Oracle versions like 9i, 10g, 11gR2 and 12c Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows. ITIL 2011 Certified.
• MySQL Database Administrator with 3+ years of experience in MySQL Database administration on both development and production support projects including excellent troubleshooting and administration skills of Database Installations, Upgrade, Backup and Recovery on MySQL Master - Master and Master-Slave Replication on Unix Environments.
• Expertise in installing different versions of Oracle on Linux, Solaris and Windows operating systems.
• Installation and Configuration of Oracle Grid ASM (11gR2, 12c).
• Created and Configured Databases using ASM in 10g/11g R2/12c.
• Oracle 9i/10g/11g/12c Client Installation on Linux/Solaris/Windows Platforms.
• Oracle 10g/12c Agent Installation.
• Oracle 10g R2/11gR2 Databases Migration from (Solaris File System) to 11.2.0.3 on Linux (ASM) using Transportable Table space.
• Upgradation of Oracle 10g databases to Oracle 11g (10.2.0.4 to 11.2.0.2 & 11.2.0.3) and Oracle ASM from 11.2.0.2 to 11.2.0.3 and 12.1.0.2.
• Upgradation of databases from Oracle 9i/10g/11g to Oracle 12c.
• Refreshing Test and Development Databases using RMAN.
• Expertise on Remote Installation, Upgradation, Migration and Patching.
• Experienced in Installation & Configuration of BCP/DRP solutions (Business continuity plan & Disaster Recovery plan) as part of High availability.
• Expertise on Standby DB activation.
• Installation and configuration of Oracle Database Gateway for MySQL.
• Configuration of DB links between Oracle - MySQL DB’s.
• Experience working within standards and process driven environments.
• Installation and configuration/Administration of 2-node RAC environment.
• Converting standalone to RAC.
• Cluster expansion through node additions.
• Troubleshooting node evictions in RAC.
• Good Knowledge in RAC Concepts.
• Good Knowledge in Oracle Golden Gate.
• MySQL community, Standard and Enterprise Version 5x administration and support.
• MYSQL administration, installation, and configuration servers in Linux platform, including load balancing, clustering and automatic failovers.
• Expertise in Installation and configuration of MySQL Binaries version 5.1, 5.5, 5.6
• Implementation and Configuration of MySQL Replication (Master-Slave).
• Experience in Upgradation of MySQL replication setup from version 5.5 to 5.6 using MySQL UPGRADE and MySQLDUMP methods.
• Migration & Version Upgrade of MySQL Instances from Solaris (MySQL 5.1.48) to Linux (MySQL 5.5.23).
• Installation and configuration of PERCONA XTRABACKUP.
• Customize MySQL installations for optimal and multi-instance configuration.
• Monitoring MySQL databases using Oracle MySQL plug-in Oracle 12c Cloud Control.
• Migration of MySQL instances (5.5.30) from Mac to Linux using MySQLDUMP.
• Installation and configuration of MySQL Enterprise Backup 3.8 Utility.
• MySQL Database refreshes using MySQLDUMP.
• Expertise in MySQL Table level and DB level backup and restore activity.
• Expertise in MySQL user administration.
• MySQL Database Export/Import using MySQLDUMP & MySQL Enterprise Backup (MEB) utilities.
• Scheduling MySQL database full, incremental backups in CRON using PERCONA and MySQLDUMP
• Practical knowledge in MYSQL Cross Platform replication Setup (LINUX - WINDOWS)
• Experience in MySQL DB optimization.
• Good Knowledge in Percona Xtradb/Galera Clustering.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c, MySQL 5.1/5.5/5.6

MySQL Tools: MYSQLDUMP, MySQL Enterprise Backup (MEB), PERCONA Xtrabackup, MYSQLADMIN

Oracle Tools: QL*PLUS, Export/Import, Data pump, TKPROF, AWR / STATSPACK, ADDM, ASH, RMAN, SRVCTL, CRSCTL, ASM, RAC, OEM, TOAD 9.5/10.5/11, SQL Developer, OEM12c.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Senior Oracle/MySQL Database Administrator

Responsibilities:

• Responsible for database, client installation Software for 10g, 11g & 12c Enterprise Edition.
• Installed and Configured Oracle Grid ASM (11.2.0.3, 12.1.0.2).
• Attending daily/Weekly engagement calls.
• Maintaining the security of the DB.
• Refreshing Development and QA DBs with Production data.
• Implemented DPP's (Defect Prevention Process) to fix reoccurring issues.
• Created rule to get alerts from OEM to entire team.
• Applied patches on GI and RDBMS home.
• Performed restores as per the requirement.
• Monitoring and maintaining cluster DB’s for their Optimal Performance and trying to ensure 100% availability of the DB’s.
• Applying bug fix patches / CPU / PSU patches.
• 24X7 on-call support.
• Applying patches on 2-Node RAC environment.
• Managing CRS services.
• Migration of Oracle 9i/10g/11g databases from Solaris to Linux using transportable tablespace method and Export/Import Method.
• Upgraded Oracle 9i/10g databases to Oracle 11g (10.2.0.4 to 11.2.0.2 and 11.2.0.3)
• Up-gradation of ASM from 11.2.0.2, 11.2.0.4 to 12.1.0.2
• Upgraded databases from 11gR2 to 12.1.0.2.
• Monitoring and maintaining cluster DB’s for their Optimal Performance and trying to ensure 100% availability of the DB’s.
• Configured physical standby databases on ASM and Non-ASM Linux environment using RMAN.
• Standby Database activation.
• Configured DB link between Oracle - MySQL Databases as per application team requirement.
• Documenting: - Documenting Stored Objects, Maintaining Patch documents and Logging Issues online/offline
• Maintaining Oracle Design Standards: - Naming Standards (Instance, Database, Objects)
• Generating AWR & Statspack report for performance tuning.
• Generating Explain Plans for SQL statements resulting in higher CPU resources.
• Worked on performance issues.
• Syncing the Standby database with primary database in DR.
• Create databases for development, testing and production.
• Security Administration including the management of profiles, roles, users and their privileges.
• Cloning databases with various backups like Cold/Hot/Logical Refresh and RMAN Backup.
• Object/Schema level re-org whenever the fragmentation is found.
• Add/configure the database for database monitoring in Grid
• Experience in opening, managing, and resolving Oracle Service Requests.
• Document the POC and capture the evidences during Change control in Production databases and Validated Systems.
• Securing Oracle Databases by periodically changing System, Sys and schema passwords.
• Coordinate with applications support/development and operations team and support databases.
• MySQL community and Enterprise Version 5x administration and support.
• MYSQL administration, installation, and configuration servers in Linux platform, including load balancing, clustering and automatic failovers.
• Installed and configured MySQL Binaries 5.1, 5.5, 5.6 versions.
• Migrated & Upgraded of MySQL Instances from Solaris (MySQL 5.1.48) to Linux (MySQL 5.5.23).
• Installed and configured MySQL Enterprise Backup 3.8 Utility.
• Migrated MySQL instances (5.5.30) from Mac to Linux using MySQLDUMP.
• Installed and configured PERCONA XTRABACKUP.
• Implemented and Configured MySQL Replication (Master-Slave).
• Upgraded MySQL replication setup from version 5.5 to 5.6 using MySQL UPGRADE and MySQLDUMP methods.
• MySQL Database refreshes using MySQLDUMP.
• MySQL user administration.
• MySQL Database Export/Import using MySQLDUMP & MySQL Enterprise Backup (MEB) utilities.
• MySQL DB optimization using "mysqlcheck" program.
• Scheduled full and daily incremental backups in CRON using PERCONA and MySQLDUMP.
• Configured PERCONA backup for MySQL Slave instances.
• Customized MySQL installations for optimal and multi-instance configuration.
• Monitoring MySQL databases using Oracle MySQL plug-in in Cloud Control.
• Add/configure the MySQL Master/Slave databases for monitoring in OEM12c Grid.
• Created rules for Master and Slave instances to get alerts from OEM to entire team.
• Configured auto startup and shutdown of master and slave instances during maintenance.
• Monitoring Master-Slave Replication setup.

Confidential, New York, NY

Sr. Database Administrator

Responsibilities:

• Attended AWS Cloud Migration meetings and weekly status update calls.
• Involved in Data center migration from on premise to AWS Cloud.
• Installation and configuration of Oracle versions 10g/11gR2 and 12c on EC2 instances.
• Installation and configuration of MySQL 5.5 and 5.6 binaries on EC2 instances.
• Created Oracle 10gR2/11gR2 and 12c databases using DBUA, Export-Import and RMAN Cloning.
• Migrated Oracle and MySQL Databases from on premise to AWS Cloud.
• MySQL Master-Slave replication setup.
• Replication setup between On-premise and Amazon cloud databases.
• Configured PERCONA backup for MySQL Slave instances.
• Migrated MySQL instances (5.5.30) from Mac to Linux instances.
• Document the POC and capture the evidences during Change control in Production databases and Validated Systems.
• Documenting: - Documenting Stored Objects, Maintaining Patch documents and Logging Issues online/offline

Confidential, NEW YORK NY

Oracle DBA

Responsibilities:

• Responsible for installing Oracle Servers & Created Databases in 10g & 11g.
• Oracle 10g/11g Client Installation.
• Upgraded the database from 10.2.0.1 to 10.2.0.4.
• Working Closely with System administrators, developers, and technology Stack team Setting Profile Options (site level, User level).
• Backup & Recovery - Databases Backup through RMAN to tapes and restore from Tapes to disk, Import and Export.
• Weekly Refreshing environments from source environments.
• Mysql Database refreshes using MySQL dump.
• Securing Oracle Database by periodically changing System, Sys and schema passwords.
• Creation of table spaces, user maintenance by creation and granting of roles and privileges.
• ASM Disk group Administration.
• Gathering table, schema level statistics.
• Applying patches on 2-Node RAC environment.
• Managing CRS services.
• Upgrading Oracle 11.2.0.1.0 to the Oracle 11.2.0.4.0 database version.
• Moving Data between different Database versions by using Data pump utility.
• Monitoring the environments from OEM.
• Performed Cloning Activity for Databases from Production to Testing Environment.
• Database cloning using RMAN.
• Managing Standby Database.
• Scheduling maintenance jobs using DBMS SCHEDULER.