PROFESSIONAL SUMMARY:

Oracle lead Oracle Applications DBA and a strong team player with 9 years of award winning experience in improving the business’s Application and database system infrastructure availability, functionality and performance by using the systematic and demonstrable approach of sound support, maintenance and diagnostic methodology. Executed the projects tasks in various capacities such as solution architect, building proof of concept & prototype, planner, coordinator, mentor and Application and database system administrator. Met the goals and produced exceptional team results through excellent interpersonal, communicational and analytical skills.

• 9 years of experience working as Oracle Applications DBA.
• Installation and configuration of Oracle 9i/10g/11g2 and 12c RAC on Windows, Unix and Linux platforms.
• Administering Oracle E - business suite 11i/R12.1/R12.2.
• Migrated/Upgraded several databases from 9i to 10g, 10g to 11g and from 11gr2 to 12c.
• Oracle Exadata administration supporting multiple database RAC environments.
• Knowledge in single node and multi node installations of Oracle Applications R12 and R12.2
• Proficient in scheduling jobs, patches, alerting for databases and also database administration through OEM12c and 13c cloud control.
• C loning Oracle EBS Application on various platforms
• Excellent experience in performance tuning using STATSPACK, EXPLAIN PLAN, SQL TRACE, TKPROF, ASH, AWR and ADDM reports.
• Configured and administered many installations of Data Guard and Active Data Guard.
• Successful in Providing 24x7 On-call Support for Production databases on rotation basis.
• Excellent experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
• Experienced in network troubleshooting and administration.
• Patching Oracle EBS Application and Oracle RDBMS.
• Extensive interaction with Business Analyst, Managers, Developers, QA and End Users.
• Excellent communication Skills.
• Creating and reviewing documentations for change management, implementation plan and proof of concept (POC).
• Maintenance application - iAS, Forms and Reports, Concurrent etc.
• Proficiency in identifying database performance issue and providing resolution.
• Installed, configured and managed several RAC databases in oracle 10g, 11g and 12c
• Extensive knowledge on database administration of Oracle 10g, 11g, 12c with experience in very large-scale database environment and mission critical large OLTP and OLAP systems.
• Extensive knowledge of Oracle cloud control 12c and 13c Architecture, Framework, and Infrastructure.
• Extensive working experience with Oracle supports for bugs & issue resolutions.
• Excellent experience with Unix Shell scripts to automate database operation.
• Hands on experience on LDAP implementation and setting up mirror mode replication.

TECHNICAL SKILLS:

Oracle Engineered System: Exadata, ZFS appliance

Operating Systems: RHEL 5.3/6.0, Aix 5.3/6.1/7.1, Windows Server 2003/2008

Oracle E: business suite 11i/R12.1/R12.2.

Storage Technologies: Oracle ASM

Databases: Oracle (9i,10g, 11g, 12C)

Tools: & Utility: Oracle cloud control (OEM), TOAD, SQL Developer, Oracle Performance pack, SQL *Plus, RMAN, Putty, Office 2003/2010, Export/Import, Data Pump, SQL*Loader, ASMCMD, NID.

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, MI

Senior EBS DBA/Architect

Responsibilities:

• Support multiple mission critical RAC databases running on Exadata machine.
• Maintained database backup and recovery procedures that support business continuity.
• Performed Databases Refresh using RMAN duplicate and Schema level refresh from Production to UAT and DEV Environments for testing Purposes.
• Applying OPatch,One-off Patch,Patchset and CPU/PSU Patch on Oracle 11g Software.
• Cloning of applications for various environments.
• Configure custom top for Oracle EBS.
• Bouncing the Hyperion and Weblogic services.
• Configuring workflow with Microsoft Office 365.
• Performed monthly partition maintenance like truncating partitions and adding new partitions.
• Supported migration of databases from non-Exadata environment to Exadata machine using different migration strategies such as Data Pump, RMAN and Data Guard.
• Installation and Configuration of 13c Cloud Control and deployment of agents to targets.
• Applied quarterly patches and one-off patches on regular basis.
• Performed application Query tuning using utilities ADDM, AWR, ASH, Explain Plan, SQL Tuning Advisor and suggested the best access path for the SQL queries.
• Involved in Upgrade Oracle ERP database from 11g to higher patch set or higher version like 12c.
• Supported a 24X7 production support and on call rotation.
• Respond to database alerts and perform Root Cause Analysis (RCA).
• Provide training to junior DBAs and Developers on Oracle best practices

Confidential

Consultant

Responsibilities:

• Cloning from Hot backup of database, Refreshing of Database and EBS Application.
• Implemented and maintained Oracle 12c Data Guard/standby database for fail-over purposes with high performance mode and done DR-Drill.
• Sync Application of DR with Production System using Data guard utility.
• Performance tuning of 11g database and application to minimize the high load requests.
• Implementation of Oracle security by creating roles and privileges.
• Assigning Roles to the Users, Assigning Responsibilities to users.
• Creating Menus, Users, Registering forms, reports, managing concurrent programs.
• Creating Schema objects like Tables, Views, Indexes, Synonyms etc.
• Creating Database Link.
• Using "ad" and “FND” utilities to manage the applications.
• Creating Schema objects like Tables, Views, Indexes, Synonyms etc.
• Analyze the patch set levels of instance to minimize the risk of bugs and other issues and apply hot and cold patch also for the language of Chinese.
• Help customer to minimize the downtime period by using various parameters & recommending the hardware sizing to meet the requirements.
• Schedule automated Hot RMAN Backup.
• Installation of Grid Software and SCAN configuration.
• Migration of Oracle database from Non-ASM environment to ASM environment.
• Implemented Data Guard/standby database on ASM File System with high performance mode and performed DR drill with DB and Application side.
• Troubleshooting Oracle connectivity issues.

Environment: Oracle Apps 12.1/12.2, Oracle Database (10g, 11g and 12c), IBM-AIX, RMAN, SQL*Plus, PL/SQL, Shell scripting, RHEL6.1/7.1, UNIX, SQL*LOADER, Oracle OEM, Putty, Data guard.

Confidential

Consultant

Responsibilities:

• Managing of oracle Application E-business Suite multi node setup.
• Daily monitoring, Daily Hot backup, Weekly cold back of Database.
• Purging Log files of Application and Oracle database.
• Cloning from Hot backup of database, Refreshing of Database, Patching (hot patch also).
• Printer configuration with Oracle Applications.
• Configure DR & Monitoring DR, Maintaining DR and periodically DR drill.
• Implementation of oracle security by creating roles and privileges.
• Assigning Roles to the Users, Assigning Responsibilities to users.
• Creating Users, managing concurrent programs.
• Creating Database Link.
• Resource monitoring, Space Management, SQL Tracing, formatting using TKPROF.
• Creating Schema objects like Tables, Views, Indexes, Synonyms etc.
• Upgraded the 11i production instance to R12.1.3 on a RAC environment with database hosted on Real Application Cluster on UAT and Development Environment.
• Clone Application instances on demand.
• Co-ordinate with OCS (Oracle Customer Support) Team for Oracle Apps Related Issues.
• Cloning from Hot backup, refreshing Two Node application and RAC ASM databases to Two Node application RAC ASM for UAT testing on AIX.
• Carried out performance tuning of database and application post go live to stabilize the environment.
• Implement Auditing and Application level security on EBS system.
• Enforced need of regular data purging processes from UAT and development, design and development, to deployment.
• SSL configuration was carried out on the UAT instance.
• Manage and troubleshoot daily performance issue on EBS multi-node Application with RAC DB.
• Implemented Radius Authentication for Databases.
• Troubleshooting Oracle connectivity issues.
• Schedule RMAN backup with Oracle Scheduler utility.

Environment: Oracle EBS 11i,12.1, Oracle Database (9i, 10g, 11g), Shell Script, PL/SQL, TOAD, SQL Developer, SQL loader, TKPROF, Windows 2003.

Confidential

24X7 Support Engineer

Responsibilities:

• Pro-active monitoring of all Production, Development & UAT instances
• Application of database and application patches as per functional requirements.
• Scheduling/Configuring backup scripts for rman, cold backup and export backup of production/uat
• Cloning of database and applications using rman/hot backup/cold backup on single and multi-node configuration
• Cloning from Single node to multi node & vice-versa on new servers.
• Table Re-org of databases periodically to reduce fragmentation