SUMMARY

• Over 7 years of IT experience, mainly Oracle Database Administration experience including 10g, 11g, 12c,18c and 19c on Standalones, RAC and Exadata( X4 & X7).
• Experience with various database Backup and Recovery methods like transportable tablespace(TSPITR), Export/Import and Flashback Technologies.
• Experience in the field of Database Technology with experience in designing, developing implementing Databases.
• Worked on Standalones, RAC and Exadata(X4,X6,X7) and Oracle on AIX.
• Upgraded databases with legacy applications from 11g to 19c.
• Worked on Exadata X6 & X7 machines including Half Rack and Full Rack.
• Direct upgrades from 12c to 19c on RAC
• Migration of data from Exadata X4 and X6 machines to Exadata x7 machines
• Good understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Oracle Database Administration experience including Oracle Exadata, Oracle Enterprise Manager Cloud Control 12c & 13c, 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.
• 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 and 12c & 19C RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Deep experience in designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN).
• Knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Excellent knowledge on v$ performance views and command line skills to identify information about sessions, wait events, system performance etc.
• Tuned applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, or debug and also identifying the poor SQLs, histograms, row chaining & row migrations and tune accordingly.
• Great 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.
• Good 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 Dataguard 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.
• Experienced in plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Experienced in collecting performance statistics using Statspack /AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Excellent in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
• Good analytical, problem solving, communication and interpersonal skills.
• Ability to demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis and capable of working independently as well as in a team, with little or no supervision.

TECHNICAL SKILLS

Hardware Server: Oracle X4/X6/X7 full rack Exadata machine, IBM PowerPC, X64 box, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-900

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

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

RDBMS: Oracle 9i to 19c RAC/ASM/EXADATA

Data Replication: Oracle GoldenGate 11gR2, 12c, 19c

Tools: / Utilities: Oracle 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, Louisville, KY

Oracle Database Administrator

Responsibilities:

• Support many databases running Oracle 12c & 19c on Standalones & RAC environments.
• Upgraded RAC databases from 12c to 19c
• Setup a two RAC Cluster with Oracle 12c, used for BI and Archive
• Create documentation to support the 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
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Refresh of data on demand from Production to Non-production(Dev, Test and UAT).
• Tune database instances and applications and recommend changes to improve database performance.
• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Constantly resolving performance with the use of OEM,Toad,AWR,ADDM and ASH
• 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.
• Setup Active Dataguard with Oracle 12C
• Migration of databases to 12C from Oracle 10g&11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities srvctl,crsctl,adr and 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.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, and Crontab.
• 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.

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Golden gate, ASM and CRS.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the 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 Datapump 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 Datapump, 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 the 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 the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the 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 the 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, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Managed and supported many databases including an 8 Node Exadata on X4 from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.0.
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
• Migrated using datapump from 10g to 11g
• Used g RMAN to create standby databases.
• 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 the Oracle 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.
• Used AWR, ADDM, ASH, SQLTUNE to troubleshoot database issues
• 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 databases.
• 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 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, Tablespaces, Schemas as needed.

Confidential, Camel, IN

Oracle Database Administrator

Responsibilities:

• Supported AHhalf RACk Node Exadata on X6s from Development, Test, and UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.5.
• 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 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 the Oracle 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.
• Created database Objects, Tablespaces, Schemas as needed.