SUMMARY:

• 14+ years of experience in IT services - Oracle Applications and Database Administration. Experience in Installing, patching, backup, recovery and troubleshooting various Oracle databases and Applications.

PROFESSIONAL EXPERIENCE:

Lead Database Administrator

Confidential, FL

Responsibilities:

• Migrating EBS and Databases from On-prem Solaris to AWS Cloud Infrastructure
• To be the technical lead and debug various environments issues independently. Needs to lead some projects as well and act as a mentor to the team members
• Managing SQL server databases
• Install, Configure, Patch and Support EBS Applications, Databases and Fusion Middleware stack on different releases most of the times much ahead of the products released to Customers
• Updating Database from 12c to 19c RAC PostgreSQL.
• Configuring SSL for EBS application.
• Enabling SSO for Form and Reports Application using OAM.
• Perform day-to-day Database Administration and ensure integrity, security and availability of applications environments
• Work with the team members across various time zones to ensure a smooth task handover across different regions
• Develop scripts to automate functions, processes and monitor database performance
• Performing database management including Monitoring, Backup, Data Recovery, Performance Tuning

Principle Database Engineer

Confidential

Responsibilities:

• Debug various environments issues independently .Lead projects as well and mentor team members
• Install, Configure, Patch and Support Fusion Applications, Databases and Fusion Middleware stacks on different releases most of the times much ahead of the products released to Customers
• Perform day-to-day Database Administration and ensure integrity, security and availability of applications environments
• Work with the team members across various time zones to ensure a smooth task handover across different regions
• Develop scripts to automate functions, processes and monitor database performance
• Experience of performing database Order management including: Monitoring, Backup, Data Recovery, Performance Tuning

Lead DBA consultant

Confidential, MI

Responsibilities:

• Upgrade EBS 12.1.3 to 12.2.10
• Upgrade EBS 12c DB to 19c
• Monitoring and Backup SQL server Databases.
• Upgrade WAM current version to latest.
• Performing backup and recovery activities
• Install and configure Oracle Database for WAM
• OAM and OID configuration installed, Single Sign on configured for Oracle WAM Application.
• Split centralized business data into two organizations based on plants.
• Responsible for Laydown new WAM infrastructure 1.9.1.2
• Configure Load balance environment using Weblogic for Forms Reports Cluster.
• Apply quarterly CPU patches to Apache Exadata Database and Weblogic
• Integrate AD with OID and schedule auto synchronization
• Administration and Management of WAM high available environment.
• Raising S.Rs and coordinating with Oracle Support staff.
• Installed and configured MS SQL Server and PostgreSQL

Confidential, KY

Responsibilities:

• Performed maintenance and Application System administration tasks such as Defining Responsibilities, purging Concurrent manger log files, User session Limits, Managing Concurrent programs and requests Purge Obsolete workflow data, Organizing Programs into request groups, defining data groups, Managing concurrent Programs by defining managers, scheduling requests to run at regular intervals, Cost based Optimization in applications, gather schema statistics and table statistics, administration of workflow to administer the workflow enabled processes.
• Backup and recovery of both application and database.
• Install SQL server and administration
• Resolve performance issues, user issues and network related issues.
• Apply quarterly CPU patches to Database and Weblogic MongoDB
• Perform ad patch for application patching, switching to run/patch file system to reduce application down time
• Code migration for custom development from production environment to Development and vice versa
• Work with Oracle Support team by raising SRs

DBA Consultant

Confidential

Responsibilities:

• Being part of the Change Management and Planning team responsible for documenting steps and estimate time for activities for smooth & error free execution including customer specific steps.
• Mandatory mentioning of Back-out plan for each activity.
• Working on Niche production Oracle GRC for SR support.
• Categorizing activities as Patching, Configuration Management, and Data Change.
• Support for Capacity Planning, Performance Tuning, Database Architecture, Data Modeling, Logical-Physical Design, and backup-recovery of enterprise-wide database applications.

Sr. DBA Support Engineer

Confidential, KY

Responsibilities:

• Involve in Frequent Monitoring of alert log, system log, for information or errors and resolve the same based on the logs
• Online / Offline backup of database using the archive logs and the sun operating system backup using at command.
• Planning and Administration of backup and recovery strategies and Involved in the Disaster recovery Plan in the event of database crash to recover without any loss of any data.
• Provided sr. level technical expertise in system administration, application administration and automation using Unix shell scripting.

DBA Associate Consult

Confidential

Responsibilities:

• Coordinating withOracleTechnical Team to resolve any issue relating to ERP
• Using AD utilities to maintain applications by compilingAppsSchema, Maintain Application Object menu, maintaining snapshots of the application using ad admin and ad patch utilities for application of patches
• Upgrade Oracle Applications from 11i to R12.0.6
• Creating Test environment through cloning production environment for developer to test on live date.
• Configured ASM on RAW storage