SUMMARY:

• Technically sophisticated and business - savvy Oracle EBS DBA/core DBA with around 10 years IT career reflecting strong leadership qualifications coupled with “hands-on” expertise. Maintains focus on achieving bottom-line results while formulating advanced technology and business solutions to meet a diversity of needs. Good Team player and excellent interpersonal/communication skills.
• Having Sound IT Experience as Oracle EBS DBA and Oracle DBA and connected systems such as Vertex, Markview, WebLogic etc. Strong analytical and problem solving skills in EBS Application
• Expertise in Database Administration and System Administrator.
• Hands on Experience on Vertex Tax Software Application.
• Database Upgrade from 11g (11.2.0.3) to 12c (12.1.0.2) and within 11g versions (from 11.2.0.2 to 11.2.0.3).
• Strong experience in supporting (24X7) production, development, unit test, integration test and test environments
• Cloning - Clone of all Oracle EBS and DB Instances from PROD to UAT.
• Upgrade Oracle AS(Application Server) from 10.1.3.4 to 10.1.3.5
• Patching - Patching all EBS and DB patches in SIT, UAT and Prod instances including post patch analysis and owning the patch management.
• Backup - Backup scheduling and Backup Monitoring.
• Experience on Weblogic Administration
• Performing Quarterly and Monthly Outage Activities in Production environment for system performance.
• Extensive knowledge on application administrator activities in 11i/R12 Oracle E-Business Suite.
• Experience on Fusion Middleware components like 10 AS, SSO, OID, WebLogic, OAS.
• Experience as On-Call 24x7 and day-to- day support EBS Order management, FA, GL and production DBA support, application/development DBA.
• Strong Troubleshooting & Problem analyzing skills proven under high-pressure environments.
• Experience in monitoring and maintaining Server uptime to ensure the least possible unavailability of the databases to avoid downtime to the clients.
• Refreshing the Test/Dev environments with production data whenever required
• Participation in Client Presentations, Proposal Defense and Analyst Presentations
• Compliance->PSU patch application on all the environments (Both Primary and DR) as and when released by Oracle.
• Handling SSO Login Issues
• Strong Shell scripting ability used for automation of repeated manual work.
• Knowledgeable to design and Implement the Disaster Recovery Solutions.
• Managing the Concurrent Managers and its operations by triggering automated scripts for concurrent requests running on daily basis, purging concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Administration and managing the Oracle Instance using custom scripts and Oracle Enterprise Manager (OEM) database control and OAM.
• Disaster Management-> Setup implementations for DR, Recovery steps and participation on DR Exercise.
• Flexible to 24x7 operations, Good in analyzing an issue and preparing reports/documents.
• Hands on Experience on other applications like Vertex, Markview,J.D.Edwards
• Proficient in using third party applications like Kintana, Markview and Oracle applications like Workflows (EBS 11i).
• Experience for handling tickets related to blocking, performance issues.
• Interaction with the clients and users and attending the client meetings for business requirements
• Presented the company services to clients - Showcased drivers and value that supported the business case for the total cost of ownership to the customer.
• Plan and write structured sections of a proposal (RFP) for IT Services Projects Industry
• Assume full responsibility for accurately and completely populating proposal contents as required by deadlines including proper review and edits to technical documents
• Ensure high availability of Oracle Applications & databases by setting up DR Standby.

TECHNICAL SKILLS:

ERP Applications: Oracle EBS R12.2,R12, 11i

Databases: Oracle Database 12c, Oracle Database 11g

Tax Application: Vertex O Series 7.0

Invoice Process Application: Markview 8.0

Fusion Middleware: Weblogic, OAS, SSO, OID

Operating System: AIX, Linux, Solaris

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS DBA/Architect

Responsibilities:

• Monitor, maintain, and tune all administrative/facilities managed databases used for critical university business processes
• Involved in upgrading Linux from RHEL 5 to RHEL 7 and database using Virtual Snap copy method.
• JRE Upgrade and Java Web Start (JWS) implementation in EBS Applications.
• Upgrade -> Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA
• XML gateway and Jagger implementation in EBS R12.
• PSU Patching - > EBS (Apps, 10.1.2, 10.1.3) and Database patching on every quarterly basis.
• Take a lead role in analyzing designs, developing tests, maintaining, customizing, & implementing applications and systems, and associated (required) 3rd party products based on user needs and with the analysis/resolution process of production level database issues
• Customize Oracle Application to clients’ requirements
• Take supporting role in providing analysis/recommendations for the implementation of new applications or the modifications of existing applications
• Assist the Applications DBA with the development of policies and procedures as they relate to Database Administration/Management
• Experience with, but not limited to, installing, patching, integrating, cloning and providing day-to-day operations support for multiple environments configured withOracle 12 EBS, Oracle 12c, 10g iAS, WebLogic 12c, MarkView 8.2 and OAM
• Strong understanding of performance tuning and configuring Oracle ERP products -Ability to proactively work with clients and other technical support staff to resolve production issues
• Detail oriented with ability to operate under pressure to produce timely, standards compliant, work products
• Willingness to multi-task multiple priorities with minimum direction and supervision ---Effective at working as a team member or individual contributor
• Excellent written and verbal communication skills
• Implemented best practices for securing database environment.
• Monitoring the regular backups and free up the archive logs space.
• Maintenance->Monthly and Quarterly Activities that involves clearing middle tier logs and service bounce, Workflow service bounce. Also involves planned maintenance and unplanned issues handling.
• Handling Fusion Middleware components in Production environment.
• Applying Security EBS application patches in Fusion Middleware technology stack.
• Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
• Interaction with the clients and users and attending the client meetings for business requirements.
• Coordinate with Oracle On-Demand on Service Request Resolution and implement application setups during routine deployments and upgrades.
• Maintain Oracle Applications and database administration tasks for administering Oracle EBS R12 and database version 11g in Production/Non-Production environment for Upenn.
• Ensure high availability of Oracle Applications & databases by setting up DR Standby.
• Configuring Workflow Notification Mailer, Database Alert Notifications, Unix based notifications.

Environment: Oracle EBS Applications R12, Oracle Database 11g/12c, Weblogic 12.1, RHEL5,RHEL7, Markview 8.2.0.2

Confidential

Sr.Oracle EBS DBA

Responsibilities:

• Provide Application Support and Maintenance (ASM) Services for Oracle, Markview and Vertex Applications.
• Involved in implementing Rapid Install and Rapid Clone utilities in Oracle apps.
• Implementation ->Upgrade Database from 11.2.0.3 to 12.1.0.2.
• Responsible for Managing Oracle EBS Order Management Application Database administration, DB health monitoring & Daily checklist update
• Daily monitoring of production systems through OEM 12c and Cron scripts
• Good Experience in Patch Analysis using Patch Wizard with latest Info bundle for exact files/components upgrade/install as well as Patch Analysis using Patch Application Files b.ldt for pre-requisites and f.ldt for patch delivering file information.
• Experience with OrderManagement(OM), General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR) PurchaseOrder(PO), Inventory (INV).
• Checking Alert log and other logs for errors & trouble shooting it accordingly.
• Keep Monitoring Database active and inactive sessions.
• Enrolling users, assigning roles and profiles, maintaining system security through monitoring user access to the database.
• Oracle applications R12.2 patching and cloning
• Implemented best practices for securing database environment.
• Monitoring the regular backups and free up the archive logs space.
• Planning for Backup and Recovery of database instance and maintaining Hot Backups, Cold Backups and backing up database objects using Exports & Imports
• Managing the lead Onsite DBA role and handling the offshore team with daily/weekly status calls to close the issues within the SLA.
• Maintenance->Monthly and Quarterly Activities that involves clearing middle tier logs and service bounce, Workflow service bounce. Also involves planned maintenance and unplanned issues handling.
• Handling Fusion Middleware components in Production environment.
• Applying Security EBS application patches in Fusion Middleware technology stack.
• Third level Application/Database Support - Ticket Analysis, Issue Resolution, Key Liaison with IT and Functional for day-to-day support and Month-end Financials Close Support(AP, AR, FA, GL, Projects, Order management)
• Privileging Database users and managing the database security using Database vault
• Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
• Interaction with the clients and users and attending the client meetings for business requirements.
• Enable Audit vault across the environments for monitoring, Security and to control users on database level.
• Coordinate with Oracle On-Demand on Service Request Resolution and implement application setups during routine deployments and upgrades.
• Implement the Key Vault for handling secure data in encrypted format at database level.
• Maintain Oracle Applications and database administration tasks for administering Oracle EBS R12 and database version 11g in Production/Non-Production environment for Black & Veatch.
• Ensure high availability of Oracle Applications & databases by setting up DR Standby.
• Configuring Workflow Notification Mailer, Database Alert Notifications, Unix based notifications.

Environment: Oracle EBS Applications R12, Oracle Database 11g/12c, AIX, Toad Vertex 7.0,Markview 8.0

Confidential

Senior Apps DBA Consultant

Responsibilities:

• Patching-> Patching all ERP and non ERP instances post patch analysis and Owning the patch management.
• Experience in supporting (24X7) production, development, UAT environments.
• Performing Users Synchronization in all environments using SSO login details.
• Troubleshooting Ebiz login Issues.
• Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
• Troubleshooting Login Issues in the instances by interacting with user and resolve the issue.
• Object Migration-> Migration ownership, Migration of both SQL codes and AOL objects to non-prod instances and production instance using FNDLOAD and KINTANA Package.
• Troubleshooting Form issues using FRMCMP
• User Administration> User creation, User Modification policies and User End-date
• Vendor Management - Keep tracking of Escalated Incident's and follow up's to close the Incident's within the SLA.
• Attending Review Meeting's with Customer & Vendor's on Monthly Basis to meet the SLA for Good Service.
• Configure PCP (parallel concurrent processing), Monitor concurrent requests and concurrent manager for performance and resolve the same using SQL Profiles, Trace (10046 & 10053), AWR and ASH.
• Handling Fusion Middleware components like SSO,OID and weblogic.
• Implemented Archiving & Purge solutions for Oracle applications.
• Proactively identifying the performance issues and suggesting recommendations for the same.
• Handling issues raised by customers and provide assistance in resolving them. Also interacting with Oracle Support for technical assistance requests.

Environment: Oracle EBS Applications R12, Oracle Database 11g, Unix and Kintana

Confidential

Database Administrator

Responsibilities:

• Responsible for Managing Application Database administration, DB health monitoring & Daily checklist update
• Checking Alert log and other logs for errors & trouble shooting it accordingly.
• Keep Monitoring Database active and inactive sessions.
• Enrolling users, assigning roles and profiles, maintaining system security through monitoring user access to the database.
• Implemented best practices for securing database environment.
• Monitoring the regular backups and free up the archive logs space.
• Planning for Backup and Recovery of database instance and maintaining Hot Backups, Cold Backups and backing up database objects using Exports & Imports
• Monitoring file system storage and planning future storage requirements for the database system.
• RDBMS Patching using Opatch
• Vendor Management - Keep tracking of Escalated Incident's and follow up's to close the Incident's within the SLA.
• Cloning production environment’s for Development and Test environments as per schedule.
• JD Edwards CNC Activities like creating users and assigning roles.
• Package Build and Deploy activities on environments like DV, PY, PD in JD Edwards.
• Facilitated QA and UAT testing post development. Conducted defect triage meetings for claims intake, processing and reports
• Involved with release management in gathering all the documents for production implementation and supported the project during the warranty period

Confidential

Associate Consultant

Responsibilities:

• Oracle Applications Administration (R12, 11.5.10, 11.5.9)
• Performing Pre-patch analysis and patching EBS environment
• Enrolling users, assigning roles and profiles, maintaining system security through monitoring user access to the database.
• Cloning production environment’s for Development and Test environments as per schedule using Rapid Clone.
• Well versed in using Application utilities for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, fndcpass and adsplice etc.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Participate in pursuit status/review conference calls as required to collaborate with onshore & other members of the proposal development team
• Vendor and Partner management and co-ordination activities.

Confidential

Software Engineer

Responsibilities:

• Managing table spaces, users, roles, privileges.
• Maintaining stringent response / resolution SLAs.
• System Administration Activities.
• Performing Pre-patch analysis and patching EBS environment
• Enrolling users, assigning roles and profiles, maintaining system security through monitoring user access to the database.
• Cloning production environment’s for Development and Test environments as per schedule using Rapid Clone.
• Well versed in using Application utilities for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, fndcpass and adsplice etc.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Participate in pursuit status/review conference calls as required to collaborate with onshore & other members of the proposal development team
• Vendor and Partner management and co-ordination activities.