SUMMARY

• DB Architect and Sr. Oracle DBA support for build, configuration, testing and production deployment of Data Center Disaster Recovery of Oracle databases on VMware for airline industry
• Physical and logical DBA support for very large terabyte sized OLTP databases
• Oracle 12c implementation on RAC, upgrade databases from lower versions to Oracle 11g/ 12c
• Oracle Exadata Database Resource Management (DBRM) and IO Resource Management (IORM) planning.
• Database Tuning
• Migrating low CPU/Memory bound Oracle 12c databases from 3 node RAC to single node VM on extreme IO storage devices
• Implementing RMAN Backup strategy and perform recovery of databases based on SLA
• Installing and configuring Oracle EM cloud12c, deploying agents on multiple hosts, configuring databases, setting up backups, monitoring alerts, creating library job templates, troubleshooting and resolving EM cloud12c host agent and OMS related issues
• Implementing Hybrid columnar compression for Data Warehouse database on Oracle Exadata engineered systems.
• Implementing Auto DOP on Exadata databases for improved parallel processing of queries
• Oracle Golden Gate installation, configuration, upgrade, troubleshooting of extract, pump and replicate related issues .
• Data Encryption at tablespace level from security standpoint to secure data such as SSN/Credit Card info etc.
• Implemented SecureFiles storage option on LOB based column objects in Oracle11g/12c databases
• Real application testing (RAT)
• Implementing vulnerability fix in Oracle as part of security threat of known risk on critical databases where PCI ( Payment card industry) policy is enforced.
• Applying Grid and RDBMS patches for traditional and Oracle Exadata engineered systems
• Setting up and configuring physical standby databases using Data Guard in Oracle 12c
• Performing root cause analysis of database related issues
• Agile DBA support to implement database changes as part of periodic release management
• Refresh non - production databases at schema and database levels
• Configure databases on ASM, file systems and raw devices
• Oracle DBA support on Windows servers
• Configuring databases on SAN, Netapp Filer, Extreme IO storages
• Setting up and testing of Oracle database disaster recovery.
• Oracle apps application DBA support ERP with modules such as OM, Oracle Incentive Compensation,CRM
• Skill to implement the business logic and process requirement of clients conforming to standards.
• Implement evolutionary methodologies such as agile, scrum in logical database management as part of SDLC
• Organize and participate in technical update on new DBA forums and technology awareness.
• Conduct capacity planning and sizing of database systems as per business needs.
• DBA support experience to interface with middleware products such as IBM WebSphere portal server, BEA WebLogic, JBOSS on JVM memory & connection pool size configuration related investigation
• Configure Oracle database and associated resources on VCS cluster with Solaris operating system as part of database failover for high availability.
• Oracle 12c multitenant proof of concept implementation and testing

TECHNICAL SKILLS

Databases: Oracle RAC 10g/11g/12c, Oracle 11g, 12c on VMware

Operating Systems: Linux, Sun Solaris, AIX, HP UX and Windows

Storage: NAS, EMC, Net App Filer, Exadata, Extreme IO

ERP: Oracle Apps 11.5.10 with modules GL,OE,OIC,OM,CRM

DBA Tools: DB Artesian V7.0, SQL Navigator, TOAD, EM Database Control, EM Grid Control and Quest Central, Statspack, AWR, Pl/SQL Developer, Precise (I3), Cygwin, Oracle EM Cloud12c, RAT

Apps DBA Modules: GL, OM, INV, AR and AP, HRMS Release 11.5.3, 11.5.8, 11.5.9, 11.5.10, CRM Release 11.5.4

ETL: Informatica, Ardent Data Stage

Data Modeling: Platinum ERWin 3.5

Backup Tools: SQL Backtrack 5.0, HP Data Protector, Verities Netbackup, RMAN, BCV, EMC Clone, EMC Data Domain Boost for RMAN, Actifio

Report: Brio, Crystal Reports

Development Tools: Developer 2000, All Fusion Harvest CM 5.1.1 Work Bench

Scripts: UNIX Shell Scripting, Oracle PL/SQL

HA Solution: Oracle Data Guard, VCS, Oracle 11g, 12c RAC

DB Admin Tools: OEM 12c, 13c, SQL Developer, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Responsibilities:

• Oracle 11g /12c RAC DBA support on Linux
• Oracle 11g to Oracle 19c upgrade project planning
• RAT for baseline measurements of Oracle 11g tuning sets to serve as a basis for Oracle 19c tuning set measurements
• Project planning for data replication during Oracle11g to Oracle 19c upgrade using Oracle GoldenGate to minimize upgrade downtime
• Oracle 64 bit 18c clients with ODAC and GAC configuration required for .NET framework / OLE DB /ASP.NET support
• OEM 12c to 13c upgrade

Confidential, Atlanta, GA

Oracle DB Architect /Sr Oracle DBA

Responsibilities:

• DB Architect and support for build, configuration, testing and production deployment of Data Center Disaster Recovery set up of Oracle databases on VMware for Delta Airlines Inc, Atlanta Georgia. Active Data Guard (ADG) set up implemented on VMware at DR site for the production filesystem database counterpart on primary site
• Implemented testing of full switchover cycle of Oracle databases in non-production environment as part of active data guard validation.

Confidential, ATLANTA, GA

Sr. Oracle DBA

Responsibilities:

• Setting up of Oracle RAC databases and upgrading to 12c
• Setting up of physical standby databases using Data Guard in Oracle 12c
• Migrating low CPU/Memory bound Oracle 12c databases from RAC to VM on extreme IO storage devices
• Tuning at the database and storage level and implemented index rebuilding strategy as part of performance improvement and database growth control
• Implemented SecureFiles storage option on LOB based column objects in Oracle11g/12c databases
• Database Resource Management (DBRM) and IO Resource Management (IORM) implementation for ETL Informatica application workloads
• Implemented advanced hybrid columnar compression (HCC) with Archive high, Archive low, Query high and Query low options on the Oracle Exadata engineered system databases
• Proof of concept on real application testing (RAT)
• Oracle Golden Gate implementation using VIP on RAC with dynamic port allocation at the replicat sites., upgrading Golden Gate from classic to integrated from version 11g to 12c, troubleshoot and resolve extract, pump and replicat related issues
• Patching at RDBMS and Grid level for both traditional and Exadata engineered system
• Applied vulnerability patch fix as part of security threat of known risk on critical databases where
• PCI ( Payment Card Industry ) policy is enforced.
• Agile DBA support to implement database changes as part of periodic release management

Confidential, BARTLESVILLE, OKLAHOMA

Sr. Oracle DBA

Responsibilities:

• Provided DBA support for the downstream (Oil refining and distribution of downstream chemicals)
• Performed in-place as well as out of place upgrades of databases from lower versions to 11g in dev/test and prod on AIX and Linux servers.
• Performed upgrades of databases set up as part of Oracle EM cloud12c DataGuard with multiple physical standbys
• Performed installation of Oracle 12c software in silent mode to multiple hosts through automated shell scripting.
• Performed CPU/PSU patch updates to Oracle 11g (11.2.0.3) dev/test and prod databases
• Developed, tested and deployed Unix shell scripts for performing certain database activity such stopping EM agent, database, patrol services during Unix server maintenance or OS level patching activity.
• Implemented data encryption at tablespace level
• Implemented OLTP compression for OLTP.
• Installed and configured and maintained Oracle Golden gate as part of homogenous replication in Oracle 11g
• Performed troubleshooting and resolved performance issues related application SQL tuning and database backup slowness.
• Performed extensive schema level refreshes using Oracle datapump.
• Performed full database refreshes using RAMAN duplicate backup based and active database based methods.
• Suggested best practice approach to troubleshoot and resolve database issues

Confidential

Sr. Oracle DBA

Responsibilities:

• Provided DBA support to implement Oracle database move between upstream (Oil exploration) and downstream applications interfaced with SAP and some non-SAP systems worldwide
• Migrated several hundreds of test/dev/prod Oracle 10g/11g databases as part of UpStream to DownStream split support using RMAN clone method on AIX/Sun Solaris/Linux OS platforms with Data Domain EMC storage.
• Installed Oracle EM grid control agents, BMC patrol agent, Oracle 10g/11g binaries on several Unix servers as part of new server deployment setup for migration from Upstream to DownStream.
• Setup, scheduled and optimized database backups using EM Grid Control Release 5 for the migrated databases.
• Setup and configured primary and standby databases as part of DataGuard setup for several production 10g/11g production systems using Oracle EM Grid control.

Confidential

Sr. Oracle DBA

Responsibilities:

• Extended DBA support to implement database changes as part of periodic release management
• As a core DBA evaluated index usage as part of database tuning initiative to improve performance of large OLTP systems of Health and Human Services, State of Texas - Austin.
• Automated Oracle performance data (AWR) save process. Developed process to save Oracle 10g performance data for trending analysis
• Participate in various performance initiatives through coordinated load and stress tests of Texas State portal, Texas integrated eligibility redesign system databases
• Conduct regular schema and database level refreshes of full size environments
• Customized DBA monitoring scripts as part of best practices to identify wait-events and wait time of long running queries on system slowness during online window
• Responsible for managing 3 Node RAC clusters on Sun Solaris 10 of Production and non-production Oracle databases of sizes upto 4.5 TB
• Extend knowledge transfer to DBA team members to handle issues during crisis.
• Extend DBA support to conduct capacity planning and database growth forecast analysis
• Involve in Data Modelling using Erwin to implement schema design changes as per functional and business needs
• Participate in code review and suggest tuning options to save significant time during production code drop
• Involved in Oracle 11g test upgrade

Confidential

Sr. Oracle DBA

Responsibilities:

• As part of Macy’s division consolidation, took part in providing primary DBA support to project production database growth and allocate necessary space for merging employee records from multiple production databases to a single large database before consolidation implementation, provided best practices from tuning perspective for better execution of PeopleSoft payroll scheduler jobs.
• Extended 24X7 DBA support
• Upgraded Oracle 9i to Oracle 10gR2 in Solaris 9
• Installed, configured and administered oracle 10g iAS
• Configured and maintained logical standby database using Oracle Data Guard
• Installed and configured Oracle down Streams between local and remote databases on AIX
• Configured RMAN backup to tape for all the oracle10g databases on Unix
• Involved in managing a two-node oracle 10R2 production RAC clusters on IBM AIX OS
• Configured a test database for KRONOS time management application conforming to vendor provided documentation from Oracle DBA perspective.
• Implemented an alternate work around to create oracle materialized views from Oracle 10g database to Oracle 9i database as there is a bug in oracle to use ANSI JOINS in 10g database pointing to 9i database using database links.
• Implemented DBA best practices to overcome excessive wait events from tuning and monitoring perspective
• Involve in regular schema level refresh from production to development database environments
• Implemented Oracle 10g key features such as Flash recovery area, Flash back, Data pump in Oracle 10R2 based databases
• Applied Jan 2008 CPU security patch on oracle 10.2.0.2 databases
• Migrated Oracle databases from HP Unix to Linux OS using export method

Confidential

Sr. Oracle DBA

Responsibilities:

• Configured two node Oracle 10g release 2 RAC cluster with ASM on Red Hat Linux and AIX V5.3 OS.
• Configured database and archive log backups using EM database control.
• Tuned redo logs and performed trouble shooting of RAC database related issues.
• Applied DST (Day light savings) patch using Opatch on Oracle 10g databases.
• Applied CPU (Critical patch update) using Opatch on Oracle 10g databases.
• Installed Oracle 10g release 2 and upgraded it to latest 10g patch set on Solaris 9
• Documented procedures as part of DBA support.
• Re-located database flash recovery area from one file system mount point to another.
• Configured export backup using data pump.
• Installed, configured and administered oracle 10g iAS
• Extended 24X7 DBA support for oracle databases on Windows 2003 Servers.