SUMMARY

• Oracle 12c and AWS Devops Certified Professional with 11+ years of DBA experience for diverse industry sectors - Banking, Airlines, Insurance, Health, Manufacturing, Food industry
• Proficient in assortment of technologies including Oracle, MySQL and Linux
• Proficient inOracleDatabase Administration activities such as installation of 10g,11g,12c, Upgrades, Migrations, Patches, Cloning, Performance Tuning, RAC, shell scripting, and Flashback technology, Datapump, snapshot
• Solid experience in disaster recovery, Database backup concepts and options such as RMAN-managed backup with or without catalog, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies
• Experience in writing liquibase scripts as part of deployment automation.
• Knowledge on MSSQL, PostgreSQL, NOSQL and trained in Hadoop administration and Mongo database
• In-depth knowledge of Worked on Amazon IAM, EC2, EBS, S3, Glacier, VPC, Route 53, Config, CloudWatch, Cloud trail
• Worked on deployment automation for Oracle databases using Bamboo tool via liquibase.
• Created database and user creation automation scripts for Liquibase job using Git-hub/bamboo
• 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 for standalone and RAC databases.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 12C cloud control and have hands on experience in monitoring databases using OEM 10g/11g.
• Created and Managed RACONE Node on ODA databases
• Building Oracle Stand by databases, both Active Data guard and for disaster recovery along with work experience with Data guard broker
• Involved in Golden Gate and oracle streams unidirectional set up for Oracle database
• Experience in MySQL database creation non-GTID and upgrade from 5.5 to 5.6 version
• Experience in managing wallets as part of Transparent Data encryption(TDE) and managed PII data
• Created the jobs using SHELL scripting for various database activities
• Performed Database Administration and debugged for database objects includingtables, indexes, views, packagesandprocedures using PL/SQL

TECHNICAL SKILLS

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

Database: Oracle 10g/11g,12c, ODA 11g, 12c, MySQL 5.6

Oracle Tools: Expdp/impdp Veritas NetBackup on Linux, DB verify, Oracle (OEM, DBCA, Oracle streams, Explain Plan, ADDM, AWR, SQLTRACE, DBMS SCHEDULER, TOAD, SQL developer

Tools: Vantive, BMC Remedy 7.1, Maestro, Tivoli(TSM), Service Center, SM9 Ticketing tool, Data Protector, Putty, WinSCP, ftp, sftp, BMC, NetBackup, MEM, liquibase-bamboo, Github

Languages: SQL, PL/SQL, Unix scripting

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Oracle DBA Team Lead

Responsibilities:

• Sector Lead and SPOC for Oracle databases, over 3000+ databases spread across North America sectors
• Involved in providing KT to team members, handling/presenting high level meetings with client/Stake holders regarding planning/migration strategies and cascading it to team later.
• Mentored small technical oracle DBA team about the project knowledge and ensured they meet the target activities.
• Applied PSU patches on all the Oracle databases for all the sites located at the HUB’s all over North America
• Actively working with other teams for Server Consolidation & Database Consolidation
• Daily tasks include resolving the incident tickets received through OEM and alerts from ticketing tool
• Oracle Enterprise Manager 13C was deployed for Oracle DB monitoring capabilities.
• Database Technologies like Oracle Real Application Clusters, Oracle Data Guard /fast start failover, Oracle Automatic Storage Management, Oracle Internet Directory, Oracle Enterprise Manager, Oracle RMAN were implemented.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents.
• Configuring and Monitoring RMAN backups and performing recoveries.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.

Environment: Oracle 11g,12c, sql developer, OEM, Shell Scripting, Aix, Linux, PDSM

Confidential, Pittsburgh, PA

Logical DBA

Responsibilities:

• Supported Oracle/MySQL databases both on-premises and AWS.
• Deployed code to various environments using bit bucket/bamboo
• Written automation script for schemas export of 3 different databases using dbms utlility.
• Responsible for db/user automation script using Github/liquibase-Bamboo.
• To perform day-to-day activities wrote sql queries/procedures and for reporting purpose
• Installed MEM 8.0 to monitor Mysql databases.
• Responsible to create RMAN catalog and setup backups using catalog for oracle databases.
• Involved in Mysql replication by building slave database for Mysql 5.6 version.
• New database creation in 18c (12.2.0.2) both standalone/RAC and cdb-pdb based.
• Schema refresh for 12c database using datapump
• Resolved database issues for Oracle databases as part of on-call DBA for both RAC and standalone databases.
• Produced DB Links in Oracle for communicating with external databases.
• Written PL/SQL stored procedures as per the application requirement

Environment: Oracle 11g,12c, sql developer, OEM, Shell Scripting, Jira, Linux, Liquibase, MEM, Bamboo, Agile, XML

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 export import methods
• Performed RMAN cloning from Prod to non-prod databases
• Experience with upgrade and migration fromoracle11g to 12c on standalone and RAC databases.
• Done Installation and configuration of Golden Gate on 11g database for the replication.
• WorkedwithIAMservice creating newIAMusers & groups in AWS environment
• 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
• Diagnose and troubleshoot Database problems and failures.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.

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

Confidential

Sr. Oracle/MySQL DBA

Responsibilities:

• Served as DBA in managing about 80+ medium- to large-scale Oracle databases
• Rebuilding MySQL slave server with non-GTID
• Migrated MySQL database to AWS using MySQL dump
• Backed up and Recovered of theOracleDatabase and Archive logs using RMAN
• Applied PSU patches for 11g,12c oracle databases
• 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).
• Worked with application team in solving various performance tuning issues
• Migration of oracle databases on different platforms using RMAN and Data Pump

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

Confidential

Sr. Oracle/MySQL DBA

Responsibilities:

• Applied PSU patches for Oracle databases for OLTP environments
• Involved in migration of 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
• 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.
• Worked on Switchover from primary to standby with/without DG broker during maintenance.
• Extensively used Oracle features Oracle Data Pump, big file tablespaces, new OEM Grid Control, Database Control, AWR, ADDM, Flashback Database
• Customization and development of K- shell (Korn Shell) scripts scheduled through Crontab for reporting and monitoring the database activities

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

Confidential

Sr. Oracle/PostgreSQL DBA

Responsibilities:

• Provided 24x7OracleProduction Database Administration as part of on-call DBA.
• Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Creation of databases on ODA servers and applied patches on ODA servers.
• Involved in RAC ONE NODE Database creation
• Ensured Data Security by oracle Transparent Data Encryption (TDE) by managing wallets
• Monitored the database using OEM 12C by creating threshold points and alerts to different teams to take care of alerts
• Worked on flash back technology as part of the snapshot standby creation and during deployment scenarios
• 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
• Refreshed PostgreSQL database using pg dump utility
• Cloned/Refreshed Database to create patch, test, development and QA environments.
• Maintained Oracle 11g Data Guard/standby databases for fail-over purposes
• Managed GUI based Postgresql databases on Vmware
• 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 using RMAN and data pump
• Database tuning at the instance level using AWR reports and OEM.

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

Confidential

Oracle DBA

Responsibilities:

• Database creation & planning. Managing the physical design of the database.
• 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, Datapump.
• Using the flashback feature to roll back the database at particular time as per requirement
• Setup and configured Oracle 11g Physical Standby database (Data Guard) to ensure high availability
• Involved in optimizing SQL statements using Indexes and Hints.
• 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
• 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

Responsibilities:

• Maintaining more than 300 Prod/QA/Dev/LAB databases in 24X7 Environment.
• Database and server monitoring using OEM 11g and BMC Patrol(Remedy)
• Installing Oracle 10g, grid agent on various platforms along with database creation & planning.
• Allocating system storage and planning future storage requirements for the database system.
• Reorganization of tables, indexes for defragmentation of tablespaces
• Upgrading the databases from 10g to 11g in standalone environment.
• Applying Oracle Patches using OPATCH. i.e. Bug Fixes, CPU and PSU Patches.
• Creation of Physical standby databases and configuring Data guard for high availability
• Backup and Recovery of the databases using RMAN and TSM backups
• Cloned/Refreshed Database environments to create patch, test, development and QA environments using RMAN and data pump
• Installation of OEM agent (11g) and OEM grid (Oracle Enterprise Manager), Monitoring tool for oracle databases.
• Created the jobs through cron jobs and Maestro jobs
• DR Exercise Perform planned switchover and failover to physical standby database with and without Data Guard Broker

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

Confidential

Oracle Application DBA Trainee

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.
• 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
• Prepared daily, weekly and monthly reports for clients

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