SUMMARY

• 8+ years of experience in Oracle as Core / Application DBA with Programming skills.
• Implemented and Supported Applications like Oracle EBS R12, Siebel, SAP ERP (Operations, Financials, HCM), CRM, Jira Databases sizing from 20GB to 16TB.
• Experience of managing 1500 plus Oracle Databases.
• Supporting towards Oracle 11g Databases and Oracle R12 Application side for the deployments of Confidential legacy payroll to get migrated to Oracle Payroll.
• Upgraded and Patched Confidential Applications servers and Databases.
• Designed, Implemented and rolled out UAT, Development and Production databases according to applications database parameters specification for Confidential Trucks & Busses Payroll application.
• Installed and Migrated Shell’s T&S standalone database from VMware server to Exadata server from 11g to 12c.
• Setup full SAP ERP application databases for Confidential IT and H&M with 3 node RAC configuration.
• Configured and supported Physical standby and Streams replication for Financial and Attendances management Databases and for some important tables of Confidential Factory India and Sweden.
• Setup and implement backup and recovery strategy for the applications using RMAN.
• Good Experience in Installation, Configuration, Up - gradation, Migration, Patching and Administration of 12c / 11g / 10g / 9i, RAC, Data Guard and Streams Databases.
• Migrated Shell’s trading application databases (Oracle 11g and 12c) from Physical server to VMware server using Golden Gate.
• Excellent experience in Requirement Analysis, Design and Implementation of Oracle Databases for customers Application with High Availability solutions.
• Coordinate directly with Customer, Application teams and other Infrastructure support teams to build and troubleshoot the environment on timely.
• Analyzed, Tested, Implemented and Documented new patches required to support the different environments.
• Designed, Developed and Maintained database models and schemas for business application projects.
• Has excellent experience on setting encryption by oracle Encryption technique Transparent Data Encryption (TDE).
• Performance Tuning and Enhancements at Database and Application layers using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
• Capacity planning to track the growth of Databases and Utilization of Server resources on different types of storage and servers
• Optimization & Consolidation of Application databases in 12c Multitenant database architecture.
• Develop and maintain documentation for various systems, processes, procedures and infrastructure configuration.
• Write and maintain database stored procedures, packages, triggers and views.
• Provide troubleshooting and root-cause analysis for database related issues.
• Working experience External Tables and SQL Loader to extract the flat file data.
• Participated in Change Management process including deploying changes to databases in all environments as requested, following change management procedures as well as assisting in managing and improving the process.
• Proactively identify and corrected fragmentation, index re-organization, database refreshes, and database consistency checks and automate them for future usage.
• Provide knowledge transfer to team members, Operations, and Support personnel.
• Partnering with various internal and external groups (business, infrastructure, vendors etc.) for problem resolution as well as implementation of new projects/initiatives.
• Work as part of a team and provide 7x24-support on rotational basis.
• Good interpersonal, collaboration and problem solving skills.
• Ability to work effectively in a flexible, changing and challenging environment, manages multiple activities and priorities and work well under pressure.
• Well-developed analytical problem-solving and decision-making skills with the ability to systematically test and debug software, hardware and network issues with minimal assistance from tech support.
• Good project management skills with the ability to establish priorities and make adjustment to meet deadlines.

TECHNICAL SKILLS

RDBMS: Oracle 9i, 10g, 11g, 12c

Oracle High Availability: RAC, Golden Gate, Data Guard, Streams

Database tools: OEM12c, 10g, RMAN, ASM, SQL Developer, TOAD, LDAP, OID, Data Guard Broker and Observer, SQL*Loader, Data Pump

Applications Supported: Oracle EBS R12, SAP ERP, CRM, Siebel

Middleware: SOA, OSB, Oracle BPM, Oracle Identity Manager

Programming Skills: SQL, PLSQL, Shell Scripting

Systems: VMware, Exadata, Linux, Solaris, AIX, Windows Server

Web Servers: WebLogic and WebSphere Business area

Production DBA: BFSI, Telecom, Automotive and Oil & Gas Sector

Ticketing tools: BMC Remedy, Service Manager, Vinst, Peregrine

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Upgraded, Patched and Cloned Oracle application R12 Test, UAT and Production servers.
• Working on Confidential Oracle Database environments for the enhancement towards auditing and advices on Resource usage and data protection.
• Recommended various changes to Disaster recovery configuration for EBS environment and waiting for management approval for the implementations.
• Providing technical help and advices to multiple IT and development teams.
• Coordinate with the Project Manager and Application Team members to understand the performance issues and troubleshoot them. Extensively using OEM 12c, AWR, ADDM, ASH reports and Server side utilities.
• Design, Develop and Maintain Backup and Recovery policies, Disaster recovery plan, and perform disaster recovery tests.
• As per daily routine troubleshooting and providing root-cause analysis for database and Application server related issues.
• Developing and maintaining documentation for various systems, processes, procedures and infrastructure configuration

Confidential

Senior Database Administrator

Responsibilities:

• Review design specifications of Oracle databases with respect to Application requirements.
• End to end database development activity from planning phase to designing.
• Ensure the database design follows the database naming standards.
• Ensure all database source codes and models are identical across the Application environment.
• Deliver sustainable, supportable Project databases.
• Provide L3 or escalation support problem tickets resolution, RCA's.
• Optimization & Consolidation of Application databases in 12c Multitenant database architecture.
• Design, Develop and Maintain Backup and Recovery policies, Disaster recovery plan, and perform disaster recovery tests.
• Design, Develop and Maintain database models and schemas in support of business application development projects or system acquisitions.
• Installed and Migrated Shell’s T&S standalone database from VMware server to Exadata server from 11g to 12c.
• Own Trading database standards, Process and representatives in Database Governance body.
• Configured Streams bi-directionalreplication for Financial Reimbursement Database tables in between U.S, U.K, Netherland and India IT Hub Locations.
• Performance Tuning and Enhancements at Database and Application layers.
• Capacity planning to track the growth of Databases and Utilization of Server resources.
• Work as part of a team and provide 7x24-support on rotational basis.
• Develop and maintain documentation for various systems, processes, procedures and infrastructure configuration.
• Design and develop complex scripts, stored procedures and programs to support business applications.
• Follow ITSM process for Incident, Change and Problem Management.

Confidential

Senior Database Administrator

Responsibilities:

• Designed and Implemented HA and DR Strategies for Sweden and Greensboro (US).
• Performance Tuning and Enhancements at Database and Application layers.
• Optimization and Enhancements of applications hosted on Oracle Databases.
• Saved thousands of Swedish Krona by a research and applying fixes towards existing scripts and monitoring objects to eliminating false On-Call Calls and Incident Tickets. Awarded as “ Confidential Start Q4 2014” for this work.
• Designed, Implemented and Migrated Oracle databases for Costing, Billing and Management Applications of Korea, China and Lyon (France) sites to Sweden Datacenter. Awarded as “Spot Award Q3 2014”.
• Designed, Implemented and rolled out UAT, Development and Production databases according to applications database parameters specification for Confidential Trucks & Busses Payroll application.
• Setup full SAP ERP application databases for Confidential IT and H&M with 3 node RAC configuration for Sweden Database center.
• Configured and supported Physical standby and Streams replication for financial and Attendances management Databases and for some important tables of Confidential Factory India and Sweden.
• Awarded with “Spot Award” for my firm decision towards database restarts for replication databases of Confidential ’s Financial Applications due to bug in UNIX servers.
• Developed and Maintained Backup and Recovery policies, Disaster recovery plan, and perform disaster recovery tests.
• Design, Develop and Maintain database models and schemas in support of business application development projects or system acquisitions.
• Excellent experience in Requirement Analysis, Design and Implementation of Oracle Databases for customers Application with High Availability solutions.
• Expert in Installation, Configuration, Up-gradation, Migration, Patching and Administration of 12c / 11g / 10g / 9i, RAC, Data Guard Databases.
• Build, troubleshoot and maintained Physical, Logical and Active Standby Databases with DG Broker and Observer.
• Performed Manual data guard switchover, failover activities and Via DG Broker too.
• Excellent experience in Deploying 12c Production database in multitenant frame work.
• Successfully implemented audits for users as per the business requirements.
• Good knowledge & troubleshooting skills for PL/SQL procedures, functions and triggers.
• Good knowledge and hands on experience in Capacity Planning.
• Good on Database maintenance activities like table re-org, index-reorg, etc.
• Was always first choice of Global Team lead for WAR ROOM from Database team.
• I was only DBA from India site to work on Problem cases.

Confidential

Database Administrator

Responsibilities:

• Reviewing and implementing the change requests for CPU patching, database parameter changes.
• Performing daily health check of the business critical databases.
• Performing database backups as a part of a change request.
• Troubleshooting and creation of RCA report for P1 issues related to database.
• Involved in various critical application Release Deployments.
• Troubleshooting all critical database alerts from monitoring systems.
• Checking backup report and troubleshooting error related to backups.
• Troubleshooting the issues related to RAC.
• Implementation of Database Security as per the Company Global policies.
• Raising SR with Oracle Support for critical internal errors.
• Health checks of the database as a part of database compliance standards.

Confidential

Database Administrator

Responsibilities:

• Install and maintain databases in development, test, training and production environments.
• Monitor multiple databases and applications using internal and external tools.
• Proactively Monitor Database Performance.
• Provide troubleshooting and root-cause analysis for database related issues.
• Setup and maintain documentation and standards.
• Monitor database activity and file usage, and ensure databases function properly.
• Provide weekend and after hours coverage for critical databases and applications on an “as-needed” basis.
• Troubleshoot problem areas (in person, by telephone, or via e-mail) within service levels on a level I and/or II basis.
• Participates in Change Management process for deploying changes to databases in all environments as requested.
• Perform database maintenance tasks such as index & Table re-organization, database consistency checks, gathering of statistics, database refreshes.
• Proactively identify, track, manage, and resolve software and technical issues.