SUMMARY

• Experienced Confidential DBA with over 7 years, with strong emphasis on delivering world - class solutions across corporate.
• Mainly Confidential Database Administration experience including Confidential Exadata, Confidential Enterprise Manager Cloud Control 12c & 13c Release 2 (12.1.0.2), 11gR2 RAC on LINUX and Sun Solaris, Installation, Upgrading, Patching, sizing, creating Confidential Databases, and Confidential database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
• TDE (Transparent Data Encryption)
• DBA and well versed with SQA(Software quality assurance) life cycle, requirement gathering, deploying test cases development, also with Confidential EBS(E-Business Suite).
• Hands on experience in Confidential 9i, 10g, 11g,12c &19c RAC implementation & administration ( Confidential Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL,CRSCTL ASMCMD,CELLCLI 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 the 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 Confidential Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting Confidential databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sol’s for better performance.
• 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 the 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.
• Excellent Experience in installing and maintaining Confidential 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 the tablespace between different platforms using Cross platform transportable tablespace 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

Hardware Server: Confidential X2/X3/X4 full rack Exadata machine, Confidential PowerPC, X64 box, Hitachi, EMC, Confidential Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-900

Operating System: Confidential / Redhat Linux, Confidential AIX, HP-UX, Solaris

Languages: SQL, PL/SQL, Unix Shell Scripting Bash/Korn

RDBMS: Confidential 9i to 12c RAC/ASM/EXADATA

Data Replication: Confidential GoldenGate 11gR2, 12c, 18c

Tools: / Utilities: Confidential sql developer, Quest Toad/Spotlight, ERWin, Tivoli, RMAN, Logminer, TKPROF, AWR/ADDM/ASH, OEM12c, OEM 13c, Export, Import, Datapump, RMAN, SQL*Loader, DBCA, DBUA, and TTS

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Database Administrator

Responsibilities:

• Support over 100 databases running on RAC & Standalone running on Red Hat 7.6 ranging from Dev, Test, and UAT to Production environments, involving daily configuration and administration
• Both tables and schemas refreshes using Datapump, expdp and impdp.
• Use both Jira and ServiceNow for ticketting
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
• Setup standby databases by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Plan Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of Confidential enterprise manager 12c, Confidential management repository and deployed agents.
• Manage 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, Confidential contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Work closely with the Confidential developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Use Secure SCP & FTP extensively for the 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 the database performance on daily basis.
• Responsible for setup and implementation of 4 Node RAC on Linux in 19C.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Confidential 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.
• Create database Objects, Tablespaces, Schemas as needed.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

• Support many databases running Confidential 12.2.0.1 & 19c on Exadata environment, running on X7s with the use of Cloud Control 15C in monitoring.
• Create documentation to support the business and satisfy regulatory requirements.
• Plan and execute disaster recovery for company production systems.
• Research and solve Confidential with Confidential Support.
• Provide senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the 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.
• 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 Confidential Database versions 11g on Red Hat Linux
• Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the 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 the Production databases.
• Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents.
• Implemented Golden 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 Confidential 10g&11g.
• Implemented and maintained Confidential 11g Data Guard/standby databases for fail-over purposes.
• Also, worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
• Migrated OLAP databases close to 8TB with minimal downtime using Golden Gate and verified data integrity using Goldengate Validate tool for Linux 3 Node RAC.
• Database Services creation for distributing the 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 the 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 the test databases with the production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden 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 the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors.
• Generated Statspack/AWR reports using OEM 12C from Confidential 11g database and analyzed the reports for Confidential wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Confidential hints and creation of new indexes to improve the 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
• Tools Used: Confidential RMAN, Confidential 11g (11. 2.0.2), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Database Administrator

Responsibilities:

• DBA supported 8 Node Exadata on X4s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 7.0. Database sizes range from 2500GB to 7TB (in MANHATTAN, ODS & FIN, OC11, SCI & EDW environments).
• Both tables and schemas refreshes 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.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of Confidential enterprise manager 12c, Confidential 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, Confidential contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Confidential developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the 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 the 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 the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Confidential 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, Tablespaces, Schemas as needed.
• Database refresh from Production to dev, test and uat.

Confidential

Production Support Database Administrator

Responsibilities:

• Configured. Implemented & Deployed Confidential 11g (11.2.0.4) & Confidential 12C, single instances on Linux, Redhat, Solaris.
• The work involved overall Maintenance of Confidential Database, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Confidential files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Confidential 11g (11.2.0.4) on both Solaris and LINUX platforms.
• Creation and maintenance of database.
• Participate in daily scrum, sprint review, sprint demo, and planning meetings.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Confidential

Database Administrator

Responsibilities:

• DBA support for Clients running Confidential on standalones and RAC and RAC exadata for Middle EAST and South Africa Region. Reviewed Confidential SRs and helped the Support Engineers on Patching, Upgrade and performance issues.
• Helped upgrade from X2 to X4 for customers running Java, ODI,SOA and GIS on 8 nodes Clusters.
• Also helped o their 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 refreshes using Datapump, 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.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of Confidential enterprise manager 12c, Confidential 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, Confidential contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Confidential developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the 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 the database performance on daily basis.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Dataguard, 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 the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Confidential 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.