SUMMARY

• Nearly 20 years of IT experience DBA on several full cycle Oracle E - business Suite (11i/R12) implementations
• Extensive Oracle Apps DBA experience ranging from EBS versions 10.x thru R12 and databases ranging from version 7.x thru 11g.
• Managed VLDB global environments as large as 7TB
• Lead DBA supporting implementations and upgrades of EBS 11i to R12 including platform migrations.
• Extensive experience in Leading Oracle Apps DBA supporting Financials, HRMS, Supply Chain and Manufacturing modules.
• Responsible Lead DBA for benchmark testing of global environment using Lode Runner tool.
• Provided a health check of production EBS to address many instability and performance issues and documented findings and implement recommendations.
• Versed all UNIX based platforms
• Actively participate with project management team in strategic planning, goal setting and monitoring, providing status updates on a regular basis.
• Aggressively ensures Service Level Agreements (SLA) goals are successfully met by DBA team
• Proficient in multiple, large RDBMS Administration, Server Installation & Performance Tuning, Security Management, Backup & Recovery, Data/Code Migration & Data Integration of Oracle11g,10g/9i/8i/8.x/7.x.
• Extensive experience withRACinstall and configuration using ASM onOracle10g/11g database.
• A highly skilled and detail-oriented Oracle Database Administrator with a broad-based expertise in the areas of RAC(real application clusters), Data Guard, Data Replication, oracle applications administration, Backup /Recovery, change Management, project management, data migration, computer operations, systems engineering, SDLC, data modeling and programming/applications development.
• Detail-oriented team player and having customer-focused service approach with a proven record of delivering support and services ahead of schedule. Repetitively successful in assisting through complex and technical environments.
• Hands-on experience in Oracle Standby databases and setting up Data Guard.
• Experience in performance tuning techniques, backup and recovery processes, database design and management, client interaction and support.
• Strong troubleshooting & problem analysis skills proven under high-pressure environments.
• Setup and register databases with RMAN for daily full hot backups and frequent Archivelog backups using catalog.
• Setup administration scripts to monitor the environment ranging from external component (CRS, ASM, Filesystem, Network, DB Connectivity) to internal DB components (Session Info, SQL execution info, Memory usage, Tablespace storage).
• Efficient in standardizing best database practices, processes and auditing databases for security. Expert in development of Unix Shell Scripts (K, Bourne, C Shells) for database operations.
• Responsible for interfacing, communicating and collaborating with client stakeholders, system architects, system engineers and software engineers to establish a clearly defined and comprehensive view of all data and relationships necessary to support the system.
• Excellent communication, project management and organization skills.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Extensive experience inmission-critical and 24/7 supportofOracle11.x(installing, performance and tuning, architecture and feature recommendations)
• Extensive experience and expertise in deploying and supportingOracleutilizing Linux and Solaris 9, 10, 11.
• Experience in the installation, configuration and maintenance of RAC environments
• Experience implementing, monitoring and managingDataGuard and RMAN.
• Provided support on a wide range of database development functions in aRACconfiguration, including running test queries, troubleshooting database problems, maintaining version control of database entities, advising customers on new database features, and leading studies to evaluate the effectiveness of current database methods and procedures, investigation of issues arising from data loss and corruption.
• Performed role of Sr. Oracle Apps DBA for multiple clients. Below is a summary of project narratives:
• Installed R12.1.3 on RHEL Linux 5.4; configured external iSupplier portal. Installed and configuration of Oracle Access Manager for Single Sign on integration with OID 11g and Active Directory.
• Upgraded client running 11.5.8 to R12.1.2 along with platform migration from Solaris to RHEL 5 with ASM. Installed and configured Oracle SSO 10g with CA Siteminder, OID 11g and Weblogic 11g.
• Implemented upgrade from EBS 11.5.10.2 to R12.1.2 while also upgrading underlying database.
• Member of the pre and post GO LIVE team for production support. Resolving underlying GO LIVE performance issues.
• This is a 3TB environment on Oracle Solaris 10. Installed and configured Weblogic 11g and OID 11g. Implemented Financials and HRMS modules.
• Upgraded client from 11i to R12 on a 4 node 11g RAC with ASM.
• Installed ASCP on Linux RHEL 5. Installed Demantra 7.2.0.2 on Windows
• Configured and implemented disaster recovery procedure including RMAN and DataGuard

Confidential, West Palm Beach, FL

Sr. Oracle Applications DBA

Responsibilities:

• Managed 17 Production and Non-Production ERP environments ranging from PeopleSoft, Oracle 11i to R12 instances. These environments are all Oracle Solaris 10 based utilizing zone partitioning technologies. Provided 24x7 support
• Implemented 2 non-production environments using ASM (RAC 11g)
• Created and defined non-global zone partitioning for upgrade projects.
• Solaris System Administrator responsible for creating user accounts, patching and mount points in non-global zones
• Configured RMAN and Netbackup for all SUN servers and ERP environments (PeopleSoft and Oracle)
• Re-engineered change management process for client. Created change management standards documentation.
• Client has outgrown current backup solution and thus I coordinated a team to evaluate viable replacement backup solutions.
• Defined and implemented standards for instance strategy. Trained development teams on deployment strategy.
• Identified and resolved critical application issues including those relating to performance, Work Flow, forms, reports and concurrent processes.
• Assisted developers and/or users with identifying performance issues and tuning queries and scripts
• Experience in configuring, installing and maintain RAC implementations
• Experience in Oracle application server infrastructure suite of products bundled with 10gAS
• Monitored databases and performs tuning enhancements to optimize their performance.
• MaintainOracleGrid Control monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Monitored trouble ticketing system to ensure reported issues are resolved in a timely manner.
• Performed database related activities: troubleshooting, recovery, tuning of the database, user security, RDBMS software installation and upgrades, resolvingOracle errors and failures, auditing activities, and resource utilization.
• Participated in semi-annual disaster recovery tests and make recommendations for improving secondary site activation procedures. Confidential
• Provided technical input to software developers and end users in the areas of hardware and database capabilities.
• Monitor all database activity for operational improvements to include, but not limited to; CPU, Disk and Memory utilization, replication and consistency of all parameters across the enterprise.
• Managed access to databases to ensure corporate security practices are followed.
• Ensured all databases are backed up per SLA (Service Level Agreement) specifications.
• Implemented changes into production environment per established change management processes.
• Responsible for release management that would ensure complete release success by extensive interaction with development and co-ordination with various other teams.

Confidential - Denver, CO

Sr. Oracle Applications DBA

Responsibilities:

• Worked with Client to identify, install and troubleshoot extended support requirements.
• Identified over 450 patches which required installation.
• Client using HPUX11 and the Financials module.
• Delivered several pre-production and production instances able to acquire extended support status and documented patches, problem patches and solutions.

Confidential, Largo, FL

Sr. Oracle Applications DBA

Responsibilities:

• Managed upgrade project from 11i/10g to R12/11g HA multi-country/multi-language implementation on AIX in an 11g RAC environment.
• Architected and implemented 11g RAC in all non-production environments.
• Re-engineered change management process for client. Created change management standards documentation.
• Defined and implemented standards for instance strategy. Trained development teams on deployment strategy.
• Identified and resolved critical application issues including those relating to performance, Work Flow, forms, reports and concurrent processes.
• Instituted proactive performance monitoring measures (using ADDM, AWR) to ensure SLA performance goals.
• Conducted benchmark testing to stress published performance measures.
• Performed cloning activities to build development and test environments
• Architected and implemented Disaster Recovery procedures in compliance with SLA availability clauses which included RMAN setup and configuration and DataGuard installation.
• Implemented EBS security that leverages technical options with customers’ requirements.
• Performed installation and configuration of the GRC Software
• Completed impact analysis of apps and database upgrade
• Upgrading 10g databases into 11gR2 by using both silent mode and DBUA utility
• Installing and configuring Oracle Enterprise Manger
• Analyzed the database objects using TOAD and assigning and altering the profiles of the Database schemas for security purposes.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Short Term project tasked to evaluate existing DataGuard configuration.
• Client was experiencing problems with stalled SQL Apply processes in production and needed assistance resolving this issue.
• Collaborate with onsite staff to evaluate and recommend configuration changes relating to DataGuard environment.
• Completed a technical assessment of findings and recommendations.
• Implemented recommendations in test environment as Proof of Concept.

Confidential, Fairfax, VA

Sr. Oracle EBS DBA/ Data Architect

Responsibilities:

• Short Term project tasked to complete Performance and Stability assessments of several production configurations. 95% of suggested modifications implemented and resolved several performance issues with various concurrent manager reports.
• For another client resolved Log Gaps whenever occurred in Production - Standby (DataGuard) environments. Also during major releases disabling the DataGuard broker configuration and enabling it back after the successful deployment and synchronize both Primary and Standby DBs.
• Regularly interacted with senior or executive management on matters concerning several technical areas, divisions, and/or customers.
• Mentored DBA to assure performance monitoring and tweeting of all environments.
• Configured OEM to monitor and set alerts for all CRP environments.
• Collaborate with onsite staff (DBA and Sys Admins) to evaluate and recommend configuration changes relating to load balancing, failover and fault tolerance

Confidential, Laurel, MD

Sr. Oracle Apps DBA/Sys Admin

Responsibilities:

• Team Lead DBA supporting upgrade and migration of the Oracle EBS 11.5.9 (9i) on a Solaris platform to Oracle EBS 11.5.10.2 (10g) on a RH Linux platform.
• Implementation included all Financials and HRMS modules.
• Worked in conjunction with Business users, Super Users and Project Management Office to resolve all issues prior to GO Live as well as after.
• Responsible for the on-demand patching of all non-production environments
• Provide daily production support for EBS after Go Live
• Used OEM to monitor the performance of PROD and performance test environments.
• Coordinated efforts of offshore talent.