SUMMARY

• Oracle Database Administrator over 10+ years of experience with strong emphasis on delivering world - class solutions across corporate
• Mainly Oracle Database Administration experience including Oracle Exadata, Oracle Enterprise Manager Cloud Control 12c & 13c Release 2 (12.1.0.2), 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
• Experience in TDE (Transparent Data Encryption) in both 11g wallet and 12C Keystore.
• DBA and well versed with SQA (Software quality assurance) life cycle, requirement gathering, deploying test cases development, also with Oracle EBS (E-Business Suite).
• Hands on experience in Oracle 9i, 10g, 11g, 12c, 13c, 18c and 19c RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience in RAC Cluster ware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL, CRSCTL ASMCMD, CELLCLI, TFA, ADRI, FAN and dcli
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN).
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Experience in teh field of Database Technology with experience in designing, developing implementing Databases.
• Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those SQL's for better performance.
• Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc.
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, or debug and also identifying teh poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Extensive experience in designing Logical and Physical data models for new developments using Erwin modeler.
• Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 11g&12c Grid Monitoring.
• Skilled in cross platform migrations from Windows to Linux, Solaris, HP and AIX Unix
• Excellent Experience in installing and maintaining Oracle Data guard to implement physical Standby Databases for Disaster Recovery.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
• Plugging teh table space between different platforms using Cross platform transportable table space Utility.
• Collecting performance statistics using Statspack / AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Excellent analytical, problem solving, communication and interpersonal skills

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, 12c, 13c, 18c, 19c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp / Imp /Data Pump, Log minerStatspack/AWR, DBCA, DBUA, ADDM, AWS, Oracle Migration Workbench, ErwinService now, Remedy, Large database environments.

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE

Confidential, NASHVILLE, TN

Senior Oracle Database Administrator

Responsibilities:

• Support many databases running Oracle 10g, 11g, 12c and 13c, 19c as well as on Standalones running on X6s with teh use of Cloud Control 13C in monitoring.
• Create documentation to support teh business and satisfy regulatory requirements.
• Plan and execute disaster recovery for company production systems.
• Research and solve Oracle with Oracle Support.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for teh various development versions of these applications.
• Train Associate and Junior DBAs in execution of database duties.
• Provide documentation and support for all aspects of maintenance and development.
• Supporting Oracle databases with teh following technologies: ASM, RMAN, RAC, and OEM.
• Supporting Oracle databases on Unix OS of either Oracle Linux, RHEL, Solaris, or AIX.
• Supporting Oracle database technologies; specifically, Gloden Gate, Active Data Guard, and Exadata database appliances.
• Good experience in RAC Cluster ware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL, CRSCTL ASMCMD, CELLCLI, TFA, ADRI, FAN and dcli.
• Setting up database backups, executing and monitoring those backups, and recovering databases from backups either in support of actual recoveries or disaster recovery exercises.
• Defined, developed, and implemented automated and repeatable processes to meet cloud data requirements, including those for availability, reliability, confidentiality, integrity, performance, scalability, auditing, and security using AWS tools and processes.
• Oracle Utility Application experience (CCNB, C2M, MDM, SOA, SGG, WebLogic, etc.)
• Supporting databases in VM environments with highly redundant, highly available systems
• Understanding and skills in supporting WebLogic, PeopleSoft, Oracle HCM, and Oracle Utility Applications.
• Understanding and skills in supporting databases with technologies such as Dell/EMC Data Domains, VM and/or Zones, CommVault or Dell Avamar backup solutions.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Manage movement of data between Dev, Test, UAT and Production.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from SQL Server to Oracle12C.
• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux
• Able to resolve teh performance issue in database 12c using full database caching and In-Memory Aggregation features.
• Hands on experience in cloning teh non-multitenant container database to pluggable database in 12c using teh PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11gRAC & 12C environment for teh Production databases.
• Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading teh 11g management agents to 12c agents.
• Implemented Gloden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Migration of databases to 12C from Oracle 10g & 11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Also, worked on Network data encryption to improve teh security and implemented SSL wallet to secure teh connections.
• Migrated OLAP databases close to 8TB with minimal downtime using Gloden Gate and verified data integrity using Glodengate Veridata tool for Linux 3 Node RAC.
• Database Services creation for distributing teh applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of teh exchanged partitions, dropping or truncating of old portions.
• Implemented Range, list and interval Partitioning for monthly partitioning of large tables.
• Developed RMAN Backup strategies for cloning teh test databases with teh production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting teh application using Gloden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved teh database performance issues.
• Experienced with ASM, adding, deleting disks to teh disk group.
• Supported development teams for all teh database related issues and handled teh critical issues like network failures and ASM DISK group errors.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed teh reports for Oracle wait events, time consuming SQL queries, table space growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve teh performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Coordinated maintenance activities including shutdown and startup of db's and ec2 instances
• Completed RDS backups before and after maintenance activities including upgrades and patching

Confidential, NASHVILLE, TN

Oracle Database Administrator

Responsibilities:

• Support many databases running Oracle 10g, 11g & 12.2.0.1as well as on Standalones running on X6s with teh use of Cloud Control 12C in monitoring.
• Create documentation to support teh business and satisfy regulatory requirements.
• Plan and execute disaster recovery for company production systems.
• Research and solve Oracle with Oracle Support.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for teh various development versions of these applications.
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Hands on experience in Oracle 9i, 10g, 11g, 12c, 13c, 18c and 19c RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience in RAC Cluster ware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL, CRSCTL ASMCMD, CELLCLI, TFA, ADRI, FAN and dcli.
• Manage movement of data between Dev, Test. UAT and Production.
• Tune database instances and applications and recommend changes to improve database performance.
• Migration of data from SQL Server to Oracle12C.
• Configured high availability (failover) across AWS regions, read preference in Mongo dB replicate sets & backup and recovery database optimization and security maintenance.
• Installing, configuring, and administering Oracle RAC DBs version 19c and above, including teh designing, configuring and operation of n-node clusters, data recovery, and user/group/role definition.
• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux
• Able to resolve teh performance issue in database 12c using full database caching and In-Memory Aggregation features.
• Hand on experience in cloning teh non-multitenant container database to pluggable database in 12c using teh PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11gRAC & 12C environment for teh Production databases.
• Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading teh 11g management agents to 12c agents.
• Implemented Gloden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Migration of databases to 12C from Oracle 10g&11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Also, worked on Network data encryption to improve teh security and implemented SSL wallet to secure teh connections.
• Migrated OLAP databases close to 8TB with minimal downtime using Gloden Gate and verified data integrity using Glodengate Veridata tool for Linux 3 Node RAC.
• Database Services creation for distributing teh applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of teh exchanged partitions, dropping or truncating of old portions.
• Implemented Range, list and interval Partitioning for monthly partitioning of large tables.
• Developed RMAN Backup strategies for cloning teh test databases with teh production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting teh application using Gloden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration, and solved teh database performance issues.
• Experienced with ASM, adding, deleting disks to teh disk group.
• Supported development teams for all teh database related issues and handled teh critical issues like network failures and ASM DISK group errors.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed teh reports for Oracle wait events, time consuming SQL queries, table space growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve teh performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Coordinated maintenance activities including shutdown and startup of db's and ec2 instances
• Completed RDS backups before and after maintenance activities including upgrades and patching

Confidential, Goodlettsville, TN

Oracle Database Administrator

Responsibilities:

• Supported 6 Node Exadata on X4s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.5. Database sizes range from 500GB to 7TB (in MANHATTAN, ODS & FIN, OC11, SCI & EDW environments).
• Both tables and schemas refreshing using Data pump, expdp and impdp.
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
• Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
• Configured high availability (failover) across AWS regions, read preference in Mongo dB replicate sets & backup and recovery database optimization and security maintenance.
• Created a standby database by using RMAN Duplicate in order to reduce teh down time for teh PROD database during teh migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
• Managed agents using emctl utility and creating incident rules in enterprise manager 12c.
• Configuring administration groups, and creating template collections in oem 12c.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with teh Oracle developers for teh better performance in Applications, in writing teh Packages, Triggers and Indexes on teh tables.
• Used Secure SCP & FTP extensively for teh File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor teh database performance on daily basis.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through teh SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Created database Objects, Table spaces, Schemas as needed.
• Database refresh from Production to dev, test and UAT.

Confidential, FAIRFAX, VA

Oracle Production Support Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling teh Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring teh scheduled jobs.
• Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Gloden gate, ASM and CRS.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained teh data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all teh production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data Pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Successfully upgraded teh databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Used to run scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of teh databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Confidential, Memphis, TN

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 11.2.0.4 database on Linux VMware Servers
• Successfully performed migrations from Oracle 9i/10g to 11gR2 RAC (Real Application)
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Supported off-hour on call support for database related issues.
• Setup physical Active data guard on Linux 6.5, running Oracle11.2.0.4.
• Constantly monitor teh performance (V$ dynamic performance views at peak load) of teh Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 11gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling teh Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring teh scheduled jobs.
• Applied patches 11.2.0.3 and 11.2.0.4 DATA GUARD running on a 4 Node RAC
• Used to run teh scripts to check teh status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of teh databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained teh data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all teh production and development databases.