SUMMARY

• Senior Oracle Database Administrator with over Eleven (11) years of experience in database administration, design, development, replication, data modeling, performance tuning, and high availability solutions of Oracle Database versions 8i,9i,10g,11g,12c, 18c and 19c.
• Strong Information Technology Professional with a Master of Computer Applications (M.C.A.) focused on Computer Science from Confidential University.
• 3+ Years of Golden Gate, RAC, ASM experience on including installation and maintenance of application environments, managing complex replication topology.
• 2+ Years of Experience with Team Management, Have played a Team Lead Role for Handling 40 members of the teams in Oracle, SQL and DB2 Towers, Outstanding communication and troubleshooting skills.
• Holds many Oracle Technical Certifications and Functional Certifications in Information Technology.
• Exceptional and proven database management skills with experience in managing Oracle builds, upgrades/migrations, database security, disaster recovery, patch management and Golden Gate in a large complex Linux, HP - Unix, Solaris, Windows, and AIX environment, and Experience working with VMware and Oracle Virtual Machine (VM).
• Expertise in database design, architecture, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning, and database security.
• Experience in developing end-to-end Oracle Golden Gate, single-instance (ASM) builds, configuring OEM Cloud Control 12c, 13c, OEM upgrade, Patches and Data Guard including Active DG and Snapshot Standby.
• Experience with configuration, load balancing, backup/recovery, sizing and space management, PL/SQL tuning, diagnostics, Shell Scripting and proficiency in the use of Oracle’s Enterprise Manager.
• Expertise in database security - database audit, user profiles, security patch updates, and PCI/PII Data encryption.
• Experience with Net Backup, Networker, ZDLRA, and RMAN database backups, ASM, ACFS, SAN storage.
• Experience with My Oracle Support (MOS)/MetaLink for Oracle SR, Patch, Software download.
• Exceptional skills in evaluating the latest Oracle products and state-of-the-art technologies.
• Experience with Agile, Kanban for project workflow, task updates, and team collaboration.
• Extensive experience with IBM MAXIMO, Manage Now, Remedy, service desk and on-call tools for problem/incident management and on-call support.

TECHNICAL SKILLS

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

Hardware & OS: Oracle Linux, HP-UNIX, AIX, Solaris 9, 10, Windows 2000/2003.

Programming: Basic Shell Scripts.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet

Oracle Tools & Utilities: RMAN, Data Pump, OEM Cloud 12c, 13c, Grid Control. Oracle, SQL * LOADER.

Others: VM Clusters, Net Backup, Networker, ZDLRA.

PROFESSIONAL EXPERIENCE

Infra Technology Specialist

Confidential, Omaha, NE

Responsibilities:

• Responsible for administrating & maintaining a very large (TB) Oracle database.
• Providing database assistance and support for multiple Application Teams.
• Establish and maintain sound backup and recovery policies and procedures.
• Responsible for managing and supporting all Production, Development, Perf, CAT and Staging instances of Oracle Version 10g,11g,12c, 18c and 19c Database.
• Responsible for Upgrading older version databases to 18c and 19c.
• Responsible for Database design and implementation as per client requirement.
• Responsible for Implement and maintain database security (create and maintain users and roles, assign privileges).
• Responsible for performing SQL Query Optimization, database tuning and performance monitoring.
• Responsible for Upgrading the lower version database up to the latest Release.
• Responsible for Administering and Maintaining Standalone, RAC, Physical Standby and Golden Gate Database Instance.
• Responsible for Applying Database Patching Periodically as per Oracle recommendations.
• Performing Schema Refresh Periodically, as needed for Application Team.
• Responsible for Converting Physical Standby Database to Snapshot Standby to allow the application team for their release testing whenever needed.
• Responsible for Maintaining and Administrating the Database Monitoring through OEM, and performing regular
• Responsbile for OEM Agent Upgrades, Applying Patches for OEM Cloud Control 12c and 13c.
• Responsible for Migrating the Backup Strategies like the Net backup to Networker and Networker to ZDLRA.
• Responsible for Configuration, Migration of ZDLRA, and Performing database restore from ZDLRA backup.
• Performing Database Recovery, Table Recovery (Using RMAN-12c) and Flashback Database whenever needed.
• Responsible for Database Refresh/Cloning through RMAN Duplicate, expdp/imdp, Cold Restore from PROD to Dev whenever needed for application team.
• Responsible for Creating a Standby Database using RMAN Active-Standby Duplicate Database.
• Responsible for Performing Daily Database Health Checkup and Resolve it if any issues found.
• Responsible for Performing Annual DR Testing using Snapshot Standby, Restore the entire database from cold backup to give the assurance to clients that we have a valid backup to recover the database anytime.
• Responsible for any new build request like Oracle Installation, Database Creation, Physical Standby, RAC, ASM and Golden Gate Configuration.
• Performing general technical troubleshooting and give consultation to development teams.
• Responsible for Plan growth and changes (Capacity planning) periodically.
• Responsible for Setup and maintain documentation and standards and evaluate Oracle features and related products.
• Working as part of a team and provide 24x7 support during Oncall Support.

Associate Operations Manager

Confidential

Responsibilities:

• Have done Oracle Database server migration from Linux to Solaris Server, Datacenter to Datacenter Migration.
• Worked as a Team lead to handled Oracle, SQL, and DB2 Teams.
• Supported various oracle databases that were running on 10g/11g and 12c environment.
• Performed Oracle Golden Gate Configuration, Administration and Maintenance.
• Configured and Administrated 3 node RAC in the AIX server.
• Have performed Oracle Grid, ASM Installation on the Standalone/RAC Clusters.
• Performed ASM Migration, Non-ASM to ASM Database.
• Performed general technical troubleshooting and give consultation to development teams.
• Followed Change Management processes to implement database configuration changes.
• Followed Problem Management processes to troubleshoot and resolve recurring issues.
• Monitored performance of database systems resources and query throughput Optimize SQL Code as necessary.
• Performed Oracle Flashback Technology.
• Performed Oracle Database Migration using Oracle Golden Gate, Transportable Tablespace, expdp/impdp Method from Solaris to AIX.

Lead Infra Engineer

Confidential

Responsibilities:

• Database Administration for Production, Test, Development, Staging and Standby Servers. Designing and Creation of new Oracle databases both Real Application Cluster and Standalone databases.
• Responsible for designing a database backup strategy for production, non-production.Databases as per Client requirements, perform database duplication and recoveryoperations through Recovery Manager (RMAN).
• Monitoring database performance problems using Oracle Enterprise Manager, tuning queryusing Explain plan, tkprof, AWR Reports, SQL Profiles, SQL Plan Management.
• Applying Oracle quarterly patches for Oracle 10g, 11g Cluster, Oracle Grid Infrastructureand Oracle databases and bug fix patches whenever recommended.
• Database Restore/Refresh from production to lower environment databases for business testing.
• Maintenance and troubleshooting of Oracle 2-node, 3-node Real application clusterdatabases of oracle version 10g,11g,11gR2 in AIX, LINUX Servers.
• Have done Upgrade of Grid Infrastructure (Standalone) databases from oracle version11.2.0.2 to 11.2.0.3 and Upgrade of 2-node Real application cluster database from 10g to 11g.
• Have done the configuration of Oracle Enterprise Manager 12c, agents and database plug-ins.
• Have applied Oracle Management Server patch and database plug-in home patches for fixing bugs as recommended by Oracle.
• Have set up Oracle Data Guard (Physical Standby) for Oracle 9i, 10g and 11g databases for disaster recovery purpose and performed Disaster Recovery activities successfully.
• Preparing necessary scripts, install packets for minor/major production release and have done production installations.

Technical Services Professional

Confidential

Responsibilities:

• Database Administration for Production, Test, Development, Staging and Standby Servers. Designing and Creation of new Oracle databases on Standalone databases
• Responsible for designing database backup strategy for production, non-production databases as per Client requirements, perform database duplication and recovery operations through Recovery Manager (RMAN).
• Monitoring database performance problems using Oracle Enterprise Manager, tuning query using Explain plan, tkprof, AWR Reports, SQL Profiles, SQL Plan Management
• Applying Oracle quarterly patches for Oracle 10g, 11g Cluster, Oracle Grid Infrastructure and Oracle databases and bug fix patches whenever recommended.
• Database Restore/Refresh from production to lower environment databases for business testing.
• Maintenance and troubleshooting oracle databases version 10g,11g,11gR2 in AIX Servers.
• Have done database upgrade from 10.2.0.4 to 11.2.0.2 and 11.2.0.2 to 11.2.0.3 versions.
• Have set up Oracle Data Guard (Physical Standby) for Oracle 9i, 10g and 11g databases for disaster recovery purpose and performed Disaster Recovery activities successfully.
• Preparing necessary scripts for database maintenance and housekeeping.

Officer

Confidential

Responsibilities:

• Monitoring the ticket queue and assigning the tickets.
• Monitoring the database alert log files and trace files for any error messages and Handling it.
• Monitoring daily and weekly backups for production Database, and Handling any backup failures.
• Monitoring tablespace size, adding data files,
• Monitoring Oracle Database Stats Gathering, Maintenance Jobs.
• Create Change Orders and following them for approvals.
• Oracle Database Creation and Maintenance.
• Oracle database Decommission.
• Raise the Service Request with Oracle for Database Assistance.
• User Creation, Deletion, Account unlock Handling and Kill session in Database.