SUMMARY:

• Oracle 12c and AWS Devops Certified Professional with 11 years of experience for diverse industry sectors - Banking, Airlines, Insurance, Health, Manufacturing, Food industry
• Proficient in assortment of technologies including Oracle, MySQL, PostgreSQL, Linux and in-depth knowledge of MSSQL server like import/export and replication of data, scheduling jobs, database backup
• Knowledge on NOSQL Mongo database and Hadoop administration
• Excellent experience in installation and configuration of Oracle 10g,11g,12c on AIX, UNIX/LINUX, Sun Solaris and Windows environment.
• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, Multi-Node RAC, shell scripting, and documentation.
• Experienced in using 10g, 11g and 12c features of Data pump, Flash Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and RecycleBin
• Created and managed PostgreSQL databases
• In-depth knowledge of Worked on Amazon IAM, EC2, EBS, S3, Glacier, RDS, ELB, VPC, Route 53, Config, CloudWatch, Cloud trail, Redshift.
• Applied PSU July 2017 patches on Oracle 11g databases Applied the Cluster ware (GI), Database (RDBMS) Patches and one-off patches using opatch on Linux, AIX servers.
• Expertise in configuration and maintenance of oracle enterprise manager (OEM) 12c cloud control.
• Experience as On-Call 24x7 production DBA support to monitor or trouble shoot any issues during the oncall period and perform and monitor any off-peak hour’s activities
• Created and Managed RACONE Node on ODA databases
• Building Oracle Stand by databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery
• Experience in migrating MySQL/Oracle databases to AWS
• Design roles and groups for users and resources using AWS IAM
• Involved in Golden Gate unidirectional set up for Oracle database
• Managed Unidirectional Oracle steams for schema-based replication
• Used Flash-Back Technology as a fast alternative to performing incomplete database recovery and to activate standby database in 10g (11g snapshot standby)
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning, Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, SQL TRACE
• Experience in Mysql database creation non-GTID and upgrade from 5.5 to 5.6 version
• Proficient in working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases, Data Guard Broker.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN)/Network Attached Storage (NAS) for storage management
• Excellent knowledge in hot/cold backup and recovery and cloning of databases using RMAN
• Used oracle transparent encryption(TDE) to encrypt tables that contains PII data
• Skilled in performing Logical backup using Traditional export/import and Data pump export/import along with managing wallets as part of Transparent Data encryption(TDE).
• Worked with team of DBAs in migration of databases from oracle 10g to Oracle 11g on and 11g to 12c different platforms.
• Worked on Oracle GRID Control and 12c Oracle Enterprise Manager
• Experience on database administration of Oracle database systems on Exadata servers
• Refreshing the Production over the Dev, UAT and keeping the Test Instances in sync with other Instances in both Oracle and Mysql databases
• Created the jobs using SHELL scripting for database migration, refresh and reporting, then scheduled them as job streams through cron jobs and Maestro jobs
• Performed Database Administration of all database objects including tables, indexes, views, packages and procedures
• Debugged Complex database objects like Stored Procedures, Functions and Triggers using SQL and PL/SQL

TECHNICAL SKILLS:

Operating Systems: IBM-AIX, Windows, RHEL 5/6, HP-UX, Solaris

Database: Oracle 10g/11g,12c, ODA 11g, 12c, MySQL 5.6, PostgreSQL, Mongo DB MS-SQL

Oracle Tools: Expdp/impdp Veritas NetBackup on Linux, DB verify, Oracle Enterprise Manager grid control(OEM12c), DBCA, Oracle streams, Explain Plan, ADDM,AWR,SQLTRACE,SRVCTL,ASM CRSCTL,DBMS REDEFINITION,DBMS SCHEDULER,TOAD

Tools: Vantive, BMC Remedy 7.1, Maestro, Tivoli(TSM), Service Center, SM9 Ticketing tool, Data Protector, Putty, WinSCP, ftp, sftp, BMC, NetBackupLanguages: SQL, PL/SQL, Unix scripting

PROFESSIONAL EXPERIENCE:

Confidential, OHIO

Oracle DBA

Responsibilities:

• Responsible for Oracle Database Administration to provide application operation support services.
• Applied PSU Patches on 11g Oracle databases
• Reorganization of tables, indexes for defragmentation of tablespaces using shrink and export import methods
• Implemented RMAN Backups, Creation of catalog database.
• Performed RMAN cloning from Prod to non-prod databases
• Experience with upgrade and migration from oracle 11g to 12c
• Involved in trouble shooting of databases as part of performance tuning
• Resolved application connectivity issues along with long running jobs consuming high CPU which resulted in bad performance
• Experienced in Space Management, Resource management and Capacity Planning.
• Responsible for migration of data and implementing structural changes from development servers to production servers using Datapump
• Diagnose and troubleshoot Database problems and failures.
• Configured Data guard-broker and involved in registering of databases in Data guard broker using utility DGMGRL.
• Monitored the databases using OEM 12c
• Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), and Data Guard to ensure maximum availability and data protection.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training
• Written scripts for the automation of backups and cloning
• Created Tables, Views, Constraints, Index
• Responsible for implementing Load Balancing in RAC Database and to make health checks in RAC instances using Crsctl and Srvctl utility
• Tested and debugged Oracle PL/SQL packages

Environment: Oracle 11g,12c RMAN, OEM, Shell Scripting, Remedy, Linux, 11g Grid Control, Veritas net backup, Tivoli backup, Data pump, DBCA

Confidential

DBA

Responsibilities:

• Served as DBA in managing about 80+ medium- to large-scale Oracle databases
• The project has reduced downtime for databases by allowing switchover, fail over and recovering databases due to hardware or network failures for Oracle databases
• Rebuilding MySQL slave server with non-GTID
• Migrated MySQL database to AWS using MySQL dump
• Backed up and Recovered of the Oracle Database and Archive logs using RMAN
• Applied PSU patches for 11g,12c oracle databases
• Provided support for deployment releases to application team
• Actively working with other teams for Server Consolidation & Database Consolidation
• Daily tasks include resolving the incident tickets received from the Monitoring team using remedy and Vantive Tools
• Completion of Service Requests and security forms received from clients on regular basis for database activities
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability
• Refreshed Couchbase database on windows using GUI
• Converted physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database
• Created standby database on a Exadata server
• Skilled in performing Logical backup using Traditional export/import and Datapump export/import along with managing wallets as part of Transparent Data encryption(TDE).
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan and SQL tuning advisor. Worked with application team in solving various performance tuning issues
• Maintained RMAN catalog server and registered databases in catalog server.
• Migration of oracle databases on different platforms using RMAN and Data Pump
• Assisted developers in getting database connection from the client using SQL *net.
• Customization and development of K- shell (Korn Shell) scripts scheduled through Crontab for reporting and monitoring the database activities
• Trained team members and acted as DBA adviser for major HA projects has resulted in 95% successful implementations

Environment: Oracle 11g RMAN, Linux, Remedy, Vantive, Sun Solaris, Couch base, Exadata.

Confidential

DBA

Responsibilities:

• Migrated oracle/Mysql databases to AWS (Amazon web service)
• Upgraded Oracle database to 12c from 11g
• Migration of Mysql 5.6 databases using Mysql dump to AWS environment
• Rebuilding Mysql slave server for 5.6 version with non-GTID
• Created Unix shell scripts for schema refresh and database backups and scheduled using cronjobs
• Applied PSU patches for Oracle databases for OLTP environments
• Monitored the production/non-production Mysql alert logs for database errors
• Resolved application connectivity issues raised when using scan listener
• Using the flashback feature to roll back the database at particular time as per requirement
• Database Troubleshooting for oracle errors with oracle support using RDA
• Migrated the new databases using the RMAN active duplication, recovered and restored data files and archive logs for Dataguard troubleshooting sync issues.
• Identifying waits and bottlenecks at the database and OS level.
• Worked on Index Rebuild, DDL update, Created Triggers, Created Tables, Indexes, DB links, sequences etc.
• Cloned/Refreshed Database environments to test, development and QA
• Environments using RMAN and data pump
• Worked on Switchover from primary to standby with/without DG broker during maintenance.
• Extensively used Data Pump at schema level and Database level for moving data from Solaris to Linux during migration
• Migrated the databases from stand alone to 2 nodes RAC on ASM file system
• Created indexes on the tables for faster retrieval of data to enhance database performance
• Worked on Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Monitoring and Troubleshooting of Database Replication issues
• Extensively used Oracle 11gR2 features - Real Application Testing, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, SQLPerformance Analyzer, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
• Customization and development of K- shell (Korn Shell) scripts scheduled through Crontab for reporting and monitoring the database activities
• Interacted with the users and Troubleshooted the problems related to the privileges.

Environment: Oracle 11g RMAN, OEM, Linux, Remedy, Vantive, MySQL

Confidential

DBA

Responsibilites:

• Provided 24x7 Oracle Production Database Administration.
• Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Creation of databases on ODA servers.
• Involved in RAC ONE NODE Database creation
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
• Migration to 12c database from 11g
• Converting single instance database to Real Application Cluster (RAC).
• Database creation & planning. Managing the physical design of the database.
• Monitored and involved in trouble shooting the golden gate process during the on-call periods
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Plan, coordinate, and implement network security measures
• Ensured Data Security by oracle Transparent Data Encryption (TDE) by creating and managing wallets
• Monitored the database using OEM 12C by creating threshold points and alerts to different teams to take care of alerts
• Managed wallets in RAC databases during activities like data pump refresh and server or database restart
• Implemented Oracle Goldengate (OGG) (classic capture) for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes
• Worked on flash back technology as part of the snapshot standby creation and during deployment scenarios
• Automatic Diagnostic Repository Command Interpreter (ADRCI) utility is a command-line tool that you use to manage Oracle Database diagnostic data.
• Created the jobs using SHELL scripting for database migration, refresh and reporting, then scheduled them as job streams through cron jobs and Maestro jobs
• Migrated the databases from stand alone to 2 nodes RAC on ASM file system
• Run SQL tuning advisor to compare execute plans and analyze them before enforcing the SQL profiles for optimizer to pick up best execution plan
• Created and managed PostgreSQL databases which involved changing parameter values, executing SQL statements, restarting database
• Refreshed PostgreSQL database using pg dump utility
• Provided support for deployment releases to application team
• Setting WAL archiving for recovery, HA and replication purpose
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Involved with installation and maintenance of ORACLE RAC and standby database for High Availability and Disaster Recovery purpose
• Maintained Oracle 11g Data Guard/standby databases for fail-over purposes
• Managed GUI based Postgresql databases on Vmware
• Encrypted the data in oracle databases using TDE column encryption and TDE tablespace encryption
• Developed Complex database objects like Stored Procedures and Triggers using SQL and PL/SQL
• Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan
• Database migration from 10g to 11g on different platforms on 12c ODA servers
• Involved in Golden Gate unidirectional set up for Oracle database
• Cloned/Refreshed Database environments to create patch, test, development and QA
• Environments using RMAN and data pump
• Monitoring the databases and servers are done using grid control and Service center tools
• Resolving the issues/alerts received during on-call periods
• Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
• Performing daily Health Check of the databases assigned as primary DBA
• Actively working with other teams for Server Consolidation & Database Consolidation
• Daily tasks include resolving the incident tickets received from the Monitoring team using DWNG tool
• Develop upgrade roadmap and perform upgrade of Database from 10g to 11g.
• Database tuning at the instance level using AWR, ADDM reports and OEM.
• Thorough understanding of architecture and operational mechanism of CRS, GNS, GPNP.
• Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting
• Managed database objects including tables, indexes, views, packages and procedures
• Involved in importing the production data to lower environments for testing purpose.

Environment: Oracle 10g,11g RMAN, OEM, ODA, RMAN, Linux, Remedy, Service center, Sun Solaris, Golden gate, PostgreSQL

Confidential

Oracle DBA

Responsibilites:

• Database creation & planning. Managing the physical design of the database.
• Allocating system storage and planning future storage requirements for the database system.
• Installing Oracle 11g, grid agent on various platforms.
• Upgrading the databases, catalog from 10g to 11g
• Applied the Cluster ware (GI), Database (RDBMS) Patches and one-off patches (for Bug resolution) using opatch on Solaris, RHEL and AIX servers.
• Provided support in managing Oracle streams databases
• Database refresh using RMAN, duplicate, logical backups.
• Providing Go live and post Go- live Support for Database performance related issues.
• DR test using SQL, DGMGRL and flashback method
• Schema and table refresh using Data Pump
• Databases Backup and Recovery using RMAN and Data Protector backups
• Using the flashback feature to roll back the database at particular time as per requirement
• Monitoring the databases and servers are done using grid control and Service Manager(SM9).
• Setup and configured Oracle 11g Physical Standby database (Data Guard) to ensure high availability
• Restored & Recovered datafiles from standby to primary using service
• Implemented TDE for database security
• Resolved standby database gap issues from RMAN.
• Monitored the database performance using OEM 12C by creating threshold points and alerts to different teams to take care of alerts
• Exported, Imported Schemas and Tables, Remapped Schemas and Tablespaces.
• Imported Schemas & Tables using network link.
• Database Administration activities such as upgrades, patches, Performance Tuning, script development and Documentation.
• Customization and development of K- shell (Korn Shell) scripts scheduled through Crontab for reporting and monitoring the database activities
• Worked on Flashback Tables & Databases.
• Worked on block corruption and fixed the corrupted blocks.

Environment: Oracle 10g,11g, OEM, ODA, RMAN, Linux, Remedy, Service center, SM9, HP backup tool, Sun Solaris

Confidential

Oracle DBA

Responsibilites:

• Maintaining more than 300 Prod/QA/Dev/LAB databases in 24X7 Environment.
• Database and server monitoring using grid control and BMC Patrol.
• Database creation & planning. Managing the physical design of the database.
• Allocating system storage and planning future storage requirements for the database system.
• Reorganization of tables, indexes for defragmentation of tablespaces
• Installing Oracle 10g, grid agent on various platforms.
• Upgrading the databases from 10g to 11g in standby environment. Catalog upgrade.
• Applying Oracle Patches using OPATCH. i.e. Bug Fixes, CPU and PSU Patches.
• Managing the High availability for the databases using HACMP.
• Creation of Physical standby databases for high availability
• Monitoring log apply services & log transport services.
• Encrypted the data in oracle databases using TDE column encryption and TDE tablespace encryption
• Configuring data guard for standby databases on 10g databases
• Backup and Recovery of the databases using RMAN and TSM backups
• Implemented Oracle Goldengate (OGG) (classic capture) for replicating data
• Providing Go live and post Go- live Support for Database performance related issues.
• Cloned/Refreshed Database environments to create patch, test, development and QA
• Environments using RMAN and data pump
• Managed wallets in RAC databases during activities like data pump refresh and server or database restart
• Implementing and managing Table Partitioning for Performance enhancements.
• Documentation of performed tasks for future reference.
• Performing daily Health Check of all the databases
• Monitoring and Troubleshooting of Database Replication issues
• Installation of OEM agent (11g) and OEM grid (Oracle Enterprise Manager), Monitoring tool for oracle databases.
• Automatic Diagnostic Repository Command Interpreter ( ADRCI ) utility is a command-line tool that you use to manage Oracle Database diagnostic data.
• Daily tasks include resolving the incident tickets received using Remedy
• Completion of Service Requests received from clients on regular basis for database activities includes which refresh of data, Data changes in database, database creations, RMAN backups failures
• Created the jobs using SHELL scripting for database migration, refresh and reporting, then scheduled them as job streams through cron jobs and Maestro jobs
• Worked with third party Maestro for any database related jobs failures
• DR Exercise Perform planned switchover and failover to physical standby database with and without Data Guard Broker

Environment: Oracle 10g,11g, RMAN, OEM, ODA, RMAN, Linux, Remedy, Service center, HP backup tool, AIX, Maestro backup tool, Citrix, WinSCP, Veritas net backup, Tivoli backup

Confidential

Oracle DBA Trainer

Responsibilities:

• Monitoring database and system health and performance.
• Monitoring alert log and trace files.
• Managing controls files and redo log multiplexing.
• Responsible for Oracle Database Administration to provide application operation support services.
• Documentation of performed tasks for future reference.
• Provided support to client by traveling to client sites, and rectifying the problems raised for current and prospective customers.
• Creation of user, roles and assigning privileges
• Documentation of performed tasks for future reference.
• Prepared daily, weekly and monthly reports for clients

Environment: Oracle 10g.RMAN, OEM, RMAN, Linux, Remedy, TOAD, Windows