SUMMARY

• Over 8 experience on Oracle Database Administration with strong emphasis on delivering excellent solutions across the IT companies & other institutions.
• Working on Exadata X6, X7 * X9 machines which included Half Rack and Full Rack.
• Migrating databases from Exadata X2 and X3 machines to Exadata x6 machines
• Good understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Enterprise Manager Cloud Control 12c & 13c 11gR2,12C and 19C 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 12C& 19C .
• 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 RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Extensive experience in 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.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Good knowledge of 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 the poor SQLs, 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,.
• Skilled in cross platform migrations from Windows to Linux, Solaris, HP and AIX unix
• 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.
• Good experience in RAC Cluster ware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL,CRSCTL ASMCMD,CELLCLI and dcli
• 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.

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 Enterprise Linux / 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 Golden Gate 11gR2, 12c, 198c

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, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Support many databases running Oracle 11g, 12.2.0.1 and 19C on Standalones & Exadata environment, running on X7s with the use of Cloud Control 13C in monitoring.
• 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 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 Oracle 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, 11g RAC & 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 Oracle 10g&11g.
• Implemented and maintained Oracle 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 GoldenGate and verified data integrity using GoldenGate Veridata 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, and 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 Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle 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: Oracle RMAN, Oracle 11g (11. 2.0.2), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• DBA supported 6 Node Exadata on X4s from Development, Test, and 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 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.
• Database refresh from Production to dev, test and uat.

Confidential, Cincinnati, OH

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump 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 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”.
• 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.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

• Managed and supported many databases including an 8 Node Exadata on X2 & 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).
• Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
• Used RMAN Duplicate and EXPORT/IMPORT data from 10g to 11.2.0.4.
• 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.
• Created database Objects, Tablespaces, Schemas as needed.