Senior Oracle DBA Resume Dallas, TX - Hire IT People

SUMMARY

Oracle DBA Core / Apps, with around 10+ years of experience in Oracle Core / Apps Database Oracle 9i, 10g,11g &12C. Golden Gate 12.2, SharePlex. ERP Apps 11i, R12, R12.2. Oracle10g 11g OCE
AWS Certified SysArch Associate. Worked as a Production DBA for US, UK & Middle East Clients. Maintaining and Supporting Large Production Environments 2000+ Production databases for multiple clients, in a 24/7 environment providing on call support for Adhock requests as and when required.
Possess good communication and client facing skills. Good exposure in configuring & maintaining databases with different flavors of UnixOS (HPUX, SOLARIS, AIX) Linux (RHEL, OEL) & WINDOWS.

TECHNICAL SKILLS

Solaris 10, HP UX, OEL, RHEL AS 4.x/5.x, IBM AIX, Windows NT. SQL Plus, Toad, APPWORX, Remedy, Xming, ETL Shell, Perl, PL/SQL.
Oracle 9i/10g/11g/12C.
Mongo DB, PostgreSQL
RMAN, OEM, DBCA, DBUA, Date pump (expdp/impdp)
Oracle Goldengate, Oracle Streams, Quest SharePlex.
Database from 10g to 11g to 12C
Performed Golden Gate Upgrade from 11.2.1 to 12.2
Performed Oracle ERP Application Upgrade from 11.5.10.2 to 12.2.2
Migration of Database from onpremise to AWS Cloud & Solaris to Linux
Oracle E - Business Suite 11i/ R12 (11.5.10.2,) (12.1.3) (12.2.2)
OAM, OWM, ad-utilities, f60gen & fndcpass, Discoverer for reporting. SOA, WebLogic Server

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Dallas, TX

Responsibilities:

Implemented Bidirectional Golden Gate Replication in Prod across Multi Datacenter.
Migrated Non-Prod Environments from on premise to AWS Cloud.
Migrated Nonprod Environments from Oracle to Nosql Databases (Mongo DB & Postgres).
Configured Oracle Database Vault for All user access to the database.
Worked on Multiple Data Replication tools SharePlex, Golden Gate and Oracle streams.
Performed Business Resiliency exercises annually.
Worked on ASM Cluster Build and RAC Setups.
Configure Standby Dataguard for production database.
Configured Ec2 Instances in AWS for Oracle Databases.
PSU & CPU Patching. working with Oracle support for resolving issues after patching
Performance Tuning and Automating Jobs using Cron, Shell Scripts, Perl and PL/SQL scripting.
Capacity planning and forecasting capacity requirements based on existing statistics

Senior Oracle DBA

Confidential, Dallas/TX, USA

Responsibilities:

Golden Gate Configuration and upgrade for Heterogeneous production and lab databases.
Configure New Servers with Cluster Build and RAC Setups
Configure Standby Dataguard for production database.
Scheduling DB Blackouts for database maintenance activities
PSU & CPU Patching. working with Oracle support for resolving issues after patching
Cloning of single & multimode Production instance to Test & Dev instance
Capacity planning and forecasting capacity requirements based on existing statistics

Senior Oracle ERP DBA

Confidential

Responsibilities:

PCP configuration and load balancing. Moving IM from one node to another when required,
Cloning of single & multimode Production instance to Test & Dev instance
Scheduling Cronjob for backup. Weekly DB Refresh & Schema refresh of Test & Dev Environments from production using RMAN & BC backups.
Routine maintenance activities like roles and privileges and application maintenance using AD Utilities. (adpatch, adadmin, admgrpch, adctrl, adident), f60gen & fndcpass.
Patching shared APPL TOP and handling patching issues. Applied OPatch for, family packs, PSU, CPU patches on Test & Production environments, working with Oracle support for resolving issues.
Monitoring database and apache load during load testing, fine-tuning the memory parameters and Restoring Database from the golden copies etc.

Senior Oracle ERP DBA

Confidential

Responsibilities:

Migration from Windows to Linux Platform and 32 bit to 64 bit OS.
Have worked Database Upgrade from 9i to 10g.
Performed Application Upgrade from 11.5.10.2 to 12.1.3
Implemented DR for standby DB on Oracle 10g Standard edition.
DB Refresh & Schema refresh for Test & Dev Environments.
Scheduling Cold Backup, Hot backup using RMAN, BC backup and Recovery of the database
Index rebuilding to improve performance and Index usage monitoring.
Capacity planning and forecasting capacity requirements based on existing statistics
Cloning of single & multimode Production instance to Test & Dev instance
Deployed Jsp & Java files, Handling Adhock requests.

Associate Consultant

Confidential

Responsibilities:

Involved in installation, troubleshooting and Database monitoring.
Administer all database objects, including tables, indexes, views, packages & procedures.
Export/import full database, schemas and tables.
Cloning of Database for Test Purpose.
Create and maintain Oracle database required for development, testing, and production usage.
Backup & Recovery using physical backup, logical backup of database and schema.
Database re-organization as required to assist performance and ensure minimum downtime of the database
Installation and Manual DB Creation, Schema and File Managements, Ad hoc requests