SUMMARY:

• Extensively used Database Administrative tools like, Oracle Enterprise Manager (OEM), SQL - Loader, SQL*DEVELOPER, TOAD for tuning and monitoring purposes.
• Production support, database management and performance tuning
• Worked on different Oracle database versions (10g, 11g, 12c, OEM, and 18c)
• Create and manage databases on EC2 and RDS, and manage S3 and EBS storage
• Data warehouse for data consolidation OLAP and ETL worked as a team member for 24/7 support with on call rotation in PROD, QAT and DEV environments
• Good experience in applying Critical Patch Update (CPU) for security and Patch Set Update(PSU) for security and bug fixes using OPatch utility.
• Participated in Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Oracle Flashback Technology to recover logical corruptions and Performance Tuning ( I/O, Memory & SQL Tuning etc) by using tools/utilities such as AWR, ADDM, Explain Plan, Autotrace, TKPROF.
• Excellent in Hot/Cold Backup with or without catalog, full backup, incremental, cumulative backups, Recovery and Cloning of databases using RMAN.
• Extensive knowledge with OLTP and OLAP systems.
• Manage application such as Enterprise Business Siute..EBS
• Data loading using external tables, SQL*LOADER, Logical and physical backups using full export, DATAPUMP.
• Configured Master-Slave replication and monitored on-going replication
• Installed, configured, and maintained Goldengate on Oracle 11g, 12c for disaster recovery and data protection purpose
• Ansible for automation of scripts across servers
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.
• Manage applications like PeopleSoft and EBS

TECHNICAL SKILLS:

Databases: Oracle 11g, 12c, OEM, 18c

Operating Systems: Linux, Centos7, Windows HP - UX, AIX, RHEL

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM, Cluster control

Languages: PL/PLSQL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer Crontab.

PROFESSIONAL EXPERIENCE.

Confidential, McHenry, IL

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.
• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.
• Data warehouse solution for large databases for data consolidation, intended for OLAP and BI, ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADER
• Migrated databases from Filesystem to Automatic Storage Management (ASM).
• Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Automating Alerts, using SQL to set thresholds and triggers.
• Debugging SQL work with developers to fine tune sql/pl to enhance performance
• Experience in Creating Physical and logical database design Data Models using Erwin Tool.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Programming in shell to create shell scripts that automate the database backups and maintenance.
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Worked on Active data guard, Fail over and Switch over cases.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.
• Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints.
• Performance monitoring and Database/Instance/ clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.

Confidential, Monroe, LA

Oracle Database Administrator

Responsibilities:

• Created tablespaces, tables, indexes, set privileges and user logins on oracle databases.
• Perform maintenance activities like checking auto vacuum jobs, and customized vacuum on certain tables.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activities
• Implemented shell-scripts for automation of day to day activities.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.
• Created and managed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL developer and SQL navigator.
• 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.
• Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Created Physical Standby databases, performed Failover and Switchover using Data Guard Broker and manually when required.
• Involved in Oracle Golden Gate installation, configuration, and monitoring.
• Designing/developing/maintaining database schemas.
• Developed, modified, and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.
• Oracle Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from Oracle 10g - 19c.
• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.

Confidential, Minneapolis, MN

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Oracle Production Support Database Administrator
• Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.
• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.
• Migrated databases from Filesystem to Automatic Storage Management (ASM).
• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.
• Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Programming in shell to create shell scripts that automate the database backups and maintenance.
• Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.
• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.