SUMMARY:

• Over 10 years’ of experience in IT Industry working as a DBA in multiple industries
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g, and 12C with experience in very large scale database environment and mission critical large OLTP and OLAP systems.( size=10TB)
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and and 12CRAC and standby database for High Availability and Disaster Recovery purpose.
• Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g/12C RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware administration, Configuration and Patching.
• Good experience Mysql, Mysql Cluster, Mysql router, Mysql Replication, Mysqldump, Mysql Enterprise Backup, Mysql Enterprise Monitor
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Materialized views, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) & Cloud Control (12c,13c) for database monitoring/performance/diagnostics.
• E xtensive experience in database Backups RMAN ((Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
• Good experience in writing/editing UNIX Shell Scripts.
• Good Experience in PATCHING AND UPGRADATION and upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g, 11g to 12C.
• Successfully migrated Databases To Amazon Cloud System.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
• Installed and Configured Vmware ESX
• Good knowledge on ITIL standards and best practices.

TECHNICAL SKILLS:

Operating System: Red Hat Linux, Unix, Solaris, HP-UX, AIX, Windows 2003/XP/7/8.

Databases: Oracle 9i/10g/11g/12c,RAC 10g/11g/12c, MS Access, Mysql 5.5/5.6/5.7,Mysql Cluster, MsSql Server( ),Mongodb

Virtualization Technologies: VMware, Oracle Virtual Machine

Languages: SQL, PLSQL, UNIX shell scripting, Ant scripting, Batch Scripting

Web Servers: Apache Tomcat, Web logic, Jboss

Tools: and Utilities(ORACLE): Oracle Cloud Control (12,13), Oracle Grid Control, Oracle Enterprise Manager, Sql Developer, PL/SQL Developer, Import/Export, Data pump, ODI, Database Vault, Oracle Label Security SQL * Loader, SQL Trace, OEM, Explain Plan, Oracle data reduction, Dataguard,Oracle Streams, HA, Snapshot Standby, Mysql Replication, Statspack, Golden Gate, AWR, ASH, ADDM, RMAN, Oracle Secure Backup, FTP, TKPROF, Amazon RDS, AWS Migration Toolkit, Flashback, Partitioning, Mysql Enterprise Backup, Mysql Dump, Mongodb Replication, Oracle Goldengate(11,12), Mysql Enterprise Monitor, Performance Tuning, Disaster Recovery, OLTP, OLAP, Datawarehouse, ASM, CRS, SRVCTL, Sql Loader, Bash, Data Mining, Sql, PL SQL, Top, AWK, SED, Veritas, CVS, SVN, Oracle Weblogic, Jboss, TomcatOther Tools: SQL Developer, OEM, VMware, putty, TOAD, WINSCP

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work
• Extensively worked on multiple 12C RAC environments on ASM, 12c DATAGUARD setups & RMAN
• Applied quarterly PSU Patches to RAC/Non-RAC databases.
• Upgraded from 11.2.0.4 to 12.1.0.2 GRID Infrastructure
• Space Management in ASM Diskgroups, Addition of new disks etc
• Troubleshooted RAC, DATAGUARD, and ASM issues
• Creation of new RAC databases, conversion from single instance to RAC
• Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases
• Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover
• Perform DR drills e.g. Switchover/Switchback using DG Broker etc.
• Created and Installed 12C Confidential /PDB RAC
• Consalidated a lot of databases in one Place like PDB
• Upgraded RAC-Dataguard setups from 11.2.0.4 to 12.1.0.2
• Setup and configured OEM 12C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Support RAC & Single Instance Production/Stage/Dev databases on (Redhat, Solaris, And Vmware environments)
• Installed and configured Goldengate replication. Perform zero downtime migrations
• Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp
• Configured RMAN backups for databases and schedule them through Crontab
• Resolved common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc
• Performance Tuning of problem queries
• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
• Installed and Configured Oracle Active-Active Goldengate 12.2
• Configured from Oracle 11g to Mysql 5.6 replication via Goldengate 12.2
• Configured Oracle Goldengate 12.2 from Oracle11g (windows platform) to Oracle 11g (Solaris sparc platform) replication
• Installed and Configured Galera Cluster
• Upgraded Oracle GoldenGate from 11.2 to 12.2
• Implemented and maintained Database security (create and maintain users and roles, assign privileges)
• Implementation of High Availability Solutions with Oracle 11g, 12c Rac, Physical and Logical Standby Databases and Replication using Oracle Streams
• Installed and Configured Oracle Database Vault
• Migrated Physical Oracle Databases to Virtualization Environments (Vimware) in Linux Redhat
• Used oracle data reduction to perform column masking to prevent sensitive data
• Migrated Oracle Database 11g To Amazon RDS
• Successfully implemented AWS Migration toolkit to migrate Databases To Amazon Cloud System
• Installed and configured Maxscale for failover and loadbalancing For Galera Cluster
• Created Xtrabackup incrimental backups for Galera cluster
• Used mysqldump for exporting mysql ( schemas, tables....)
• Installed and Configured Mysql Enterprise Monitor installed agents to mysql instances to monitor Mysql Databases

Confidential

Senior Oracle DBA

Responsibilities:

• Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work
• Extensively worked on multiple 11gR2 RAC environments on ASM, 11g/12c DATAGUARD setups & RMAN
• Applied quarterly PSU Patches to RAC/Non-RAC databases.
• Applied CRS Bundle patches/PSU to CRS on RAC clusters.
• Upgraded from 11.2.0.2 CRS/ASM to 11.2.0.4 GRID Infrastructure
• Space Management in ASM Diskgroups, Addition of new disks etc.
• Troubleshooted RAC, DATAGUARD, and ASM issues
• Creation of new RAC databases, conversion from single instance to RAC
• Installed and Configured 2/3 Node 11gR2 setups with ASM on Linux & HP-UX
• Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases
• Setup 11g Standby database setups, Active Data guard
• Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover
• Perform DR drills e.g. Switchover/Switchback using DG Broker etc.
• Upgraded RAC-Dataguard setups from 11.2.0.4 to 12.1.0.2
• Setup and configured OEM 12C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Support RAC & Single Instance Production/Stage/Dev databases on (Redhat, Solaris, And Vmware environments)
• Installed and configured Goldengate replication. Perform zero downtime migrations
• Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp
• Configured RMAN backups for databases and schedule them through Crontab
• Resolved common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc
• Performance Tuning of problem queries
• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
• Installed and Configured Oracle Goldengate 12.2 on (windows, linux and unix platforms)
• Configured from Oracle 11g to Mysql 5.6 replication via Goldengate 12.2
• Configured Oracle Goldengate 12.2 from Oracle11g (windows platform) to Oracle 11g (Solaris sparc platform) replication
• Configured Oracle Goldengate MsSql to Oracle (linux platform) replication
• Upgraded Oracle GoldenGate from 11.2 to 12.2
• Implemented and maintained Database security (create and maintain users and roles, assign privileges)
• Migrated Physical Oracle 11g databases to Virtualization (Oracle Virtual Machine)
• Implementation of High Availability Solutions with Oracle 11g, 12c Rac, Physical and Logical Standby Databases and Replication using Oracle Streams
• Installed and Configured Oracle Database Vault
• Migrated Physical Oracle Databases to Virtualization Environments (Vimware) in Linux Redhat
• Created and Configured Oracle Data vault
• Created and configured Relams, Command Rules, Rule Sets, Factors integrated with Oracle Label Security for Oracle data Vault
• Used oracle data reduction to perform column masking to prevent sensitive data
• Migrated Oracle Database 11g To Amazon RDS
• Successfully implemented AWS Migration toolkit to migrate Databases To Amazon Cloud System
• Installed and configured Mysql (5.5, 5.6, 5.7) Mysql instances
• Installed and configured Mysql Cluster configured Load balancing with Mysql router, created backup with ndb backup
• Crreated backup with Mysql enterprise backup for Mysql databaseses
• Used mysqldump for exporting mysql ( schemas, tables....)
• Installed and Configured Mysql Enterprise Monitor installed agents to mysql instances to monitor Mysql Databases

Confidential

Senior Oracle DBA

Responsibilities:

• Installed Real Application Cluster Databases (4 different cluster database)
• Installed and Configured Physical standby database for Production Databases
• Installed and Configured Application Servers (Jboss)
• Created and Scheduled Rman and expdp Backups for Production Database and Application servers
• Created and Installed Mysql database for integration for other organizations
• Created and Scheduled Backups for Mysql database
• Created and Installed CVS server
• Created and Installed Development Environment (Database and Applications)
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 9i to Oracle 10g environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Confidential

Oracle DBA

Responsibilities:

• Created and Installed Oracle Real Application Cluster Database (with 2 nodes)
• Installed and Configured Physical standby database for Production Database
• Installed and Configured Application Servers (Jboss, Dal, Eyeks, Oturum)
• Created and Scheduled Rman and expdp Backups for Production Database
• Created and Installed Development Environment (Database and Applications)
• Created and Scheduled Backups for Application servers
• Created and Installed CVS server
• Migrated All previously Installed Databases into one Production Database
• Created and Configured Automated Document Management Systems
• Managing and maintaining Oracle databases running on Linux
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Installed and Configured Sql Server replication and log shipping
• Installed and Configured Sql Server 2005
• Upgraded All Sql 200 servers to 2005 and migrated all Databases to SQL 2005