SUMMARY:

• Over 17 years of IT experience as Oracle DBA Lead on several full cycle Oracle database and E - business Suite (11i/R12.2) implementations. Growth oriented and explored and implemented several applications like EBS, Demantra, Agile plm4p, Obiee, Informatica.
• Extensive Oracle DBA Experience from Oracle Versions 7.1.3.4 to 12.2.0.2, GI, ASM, OEM, Standby database, Data guard Broker, Database partitioning, Pluggable database, container database.
• Extensive Oracle Apps DBA experience ranging from EBS versions 10.x thru R12.2.6 and databases ranging from version 7.x thru 12c.
• Installed and transitioned Oracle Applications 12.2.6 (EBS & FMW) in multi node DMZ environment to Production support team.
• Install, Patch and Clone Oracle e-Business Suite Applications & Database system for Development, QA and Production environments on advanced platform: Oracle Engineered Systems Exadata.
• Optimize physical design and environment for different access methods and performance.
• Monitor performance and provide recommendations for schema enhancements using Oracle Enterprise Manager and more advanced utilities and features of Exadata Storage like smart scans.
• Design, create and tune physical database objects to support normalized and dimensional models, maintaining the referential integrity of the database
• NoSQL and Graph DBs: Cassandra
• Monitor and tune the enterprise network for optimal performance, working with developers in tuning with PL/SQL.
• Providing SOX/PCI DSS/IA/HIPPA compliance support by implementing security best practices on all applications and databases.
• Develop database management productivity tools, including database monitoring procedures and utilities. Installed Nagios monitoring.
• Monitored EBS using various monitoring platforms like Nagios, OEM, BMC Petrol, Nimsoft.
• Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup.
• Setup PCP (Parallel Concurrent Processing) and Load Balancing configuration within Oracle E-Business Suite QA and Production Environments Installed on RAC.
• Mentor and develop skills of Application Database Administrators and Associate Database Administrators.
• Develop and test disaster recovery procedures using advanced DB features like Active Dataguard.
• Perform Oracle Database backup and recovery using Oracle Recovery Manager Tool, recover point, EMC BCV tools.
• 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, Worked on code deployment procedures.
• Identify all issues in team and provide continuous support to all members according to Technical operating standards.
• Supervise effective working of production personnel and prepare effective 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 with RAC install and configuration using ASM on Oracle 10g/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

• Extensive experience in mission-critical and 24/7 support of Oracle 11.x(installing, performance and tuning, architecture and feature recommendations)
• Extensive experience and expertise in deploying and supporting Oracle utilizing Linux and Solaris.
• Experience in the installation, configuration and maintenance of ASM and RAC environments
• Experience implementing, monitoring and managing Data Guard, RMAN and Goldengate.
• Provided support on a wide range of database development functions in ASM configuration, 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.
• 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. .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

• Implemented ASM (RAC 10g)
• Implemented Data guard
• Implemented Oracle database vault
• Configured RMAN and Veritas Netbackup for all Unix Servers and ERP environments
• Installed EBS R12
• 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, resolving Oracle 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 that 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

Confidential

Oracle Applications DBA

• 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 effective working of production personnel and prepare effective 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

• Team lead of offsite operations
• Developed and maintained effective 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 DBA

• 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.

Confidential

Oracle DBA

• 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