SUMMARY

• Over 17 years of IT experience as Oracle DBA Lead on several full cycle Oracle database and E - business Suite (11i/R12) implementations
• Extensive Oracle DBA Experience from Oracle Versions 7.1.3.4 to 12.2.0.2
• Extensive Oracle Apps DBA experience ranging from EBS versions 10.x thru R12 and databases ranging from version 7.x thru 11g.
• I worked in transitioning several multimillion revenue customers to Oneneck data centers.
• Managed very large global environments as large as 14TB
• Managed the DBA Group Activities of the Shifts.
• Identify all issues in team and provide continuous support to all members according to Technical operating standards.
• Supervise TEMPeffective working of production personnel and prepare TEMPeffective production schedules and ensure compliance to all company policies.
• 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.
• Extensive experience in installation of EBS, Demantra, Weblogic, Agile PLM, OBIEE, Discoverer
• 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. Working on 12c RAC setup.
• 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, data migration, computer operations, systems engineering, SDLC 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 backup catalog.
• Setup administration scripts to monitor the environment ranging from external component (CRS, ASM, File system, 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 for database operations and monitoring.
• 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

Oracle DBA-Sr Service Engineer/Manager

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.
• Experience in the installation, configuration and maintenance of ASM and RAC environments
• Experience implementing, monitoring and managingData Guard and RMAN.
• Provided support on a wide range of database development functions inASMconfiguration, 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 TEMPeffectiveness 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.
• Installed R12.1.3 on Oracle Linux 5.4; configured external iSupplier portal.
• Installed Oracle Demantra 7.3.1.4, Agile PLM, Obie, Weblogic, Tomcat, Discoverer
• Upgraded EBS 11.5.10 to R12.1.3 with DMZ and load balancers.
• 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.
• Installed Demantra 7.3.1.4 and 7.3.1 With distributed Engines on Oracle Linux
• Well versed in all Demantra installation, performance and upgrade issues.
• Created scripts to monitor Distributed Engines performance
• Automated Demantra Clone process
• Upgraded Demantra 7.3.1 to 7.3.1.4
• Extensive experience in tuning Demantra Database, Engines and application
• Configured and implemented disaster recovery procedure including RMAN and DataGuard
• Managed 17 Production and Non-Production ERP environments ranging from Oracle 11i to R12 instances.
• Implemented OEM 12c
• Implemented partitioning and local indexing on Key Demantra Tables to improve performance.
• Migrated Various customer environments to Cloud Solutions like OVM,VMware, Reliacloud
• Prepared Re-usable EBS and Database templates to use in Cloud Environments. A EBS 12.1.3 template on OEL can be used for multiple customers without fresh install of 12.1.1 and upgrade to 12.1.3.
• As a member of Problem management team involved in addressing various high visible issues
• Worked with Oracle Financials Functional team on resolving various functional issues
• Concurrent manager troubleshooting
• Configuration of Sabrix

Confidential

Oracle DBA Architect Various

Responsibilities:

• Re-engineered change management process for client. Created change management standards documentation.
• 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
• Monitored databases and performs tuning enhancements to optimize their performance.
• 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.
• 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 dat would ensure complete release success by extensive interaction with development and co-ordination with various other teams.
• Implemented Data masking to secure data in TEST/DEV environments
• Developed Data purge mechanisms working along with Development team.
• Worked with Functional teams on implementing Supply chain and Property management modules

Confidenti

Oracle Applications DBA

Responsibilities:

• Managed the DBA Group Activities of the Shift.
• Identify all issues in team and provide continuous support to all members according to operating standards.
• Supervise TEMPeffective working of production personnel and prepare TEMPeffective production schedules and ensure compliance to all company policies.
• Coordinate with Functional and process teams ensuring compliance to all protocols and maintain quality.
• Prepare vacation schedule of Resources maintaining continuous production Operations.
• Manage and prioritize all production processes and implement all production plans.
• Automated EBS Clone, and various other process to reduce operations foot print
• Worked with Clients to identify, install and troubleshoot extended support requirements.
• Extensively worked on production support deliverables support
• Analyzed staffing requirements and ensured efficient compliance to production schedules and budget for all production process
• Participation in Management by Objectives process
• Ensure compliance to all local policies to achieve all production objectives and provide appropriate feedback

Confidential

Sr. Oracle Applications DBA -

Responsibilities:

• Team lead of offsite operations
• Developed and maintained TEMPeffective relations with all company employees at various levels of organization
• Worked on EBS 11i Production support environment
• Implemented Shareplex
• Worked on EBS upgrade from 11.5.8 to 11.5.10.2
• Worked in Data Warehouse environments
• Worked on Capacity planning using capacity planner
• Installed and Configured oem
• Code migration using Kintana
• Implemented Daily Database refresh using BCV

Confidential

Oracle Applications DB

Responsibilities:

• Worked on EBS 11i Production support environment
• Upgrade EBS 11.5.6 to 11.5.10.2
• Worked in Data Warehouse environments
• Worked with Developers, Functional team in implementation projects
• Implemented APM
• Printer setups, Concurrent manager tuning.
• Worked on EBS 11.5.8 Implementation Project
• Printer setups, Concurrent manager tuning.
• Involved in Hospital management system Software and Database management
• As a oracle dba worked in database building, Sizing, Tuning, Backup processes
• Worked as a VB, ASP developer