Vinay Kumar

Phone: 913-***-****

Email: acxydc@r.postjobfree.com

QUALIFICATION HIGHLIGHT

Experienced Technical Specialistacts as an Oracle EBS DBA Lead liaison between Business and IT to build a bridge with innovative solutions. These innovative solutions result in increasing the product’s competitive edge in the market place, gain operational efficiencies, and higher return on investments.

CORE COMPETENCIES

●Technical Specialist with around 10 years of experience with Client Support & Business Services in Oracle EBS Applications R12 and 12c Database. Strong analytical and problem solving skills in EBS Application Database.

●Strong experience on Performance Tuning and troubleshooting issues on Oracle Database and ERP Application.

●Participation in Client Presentations, Proposal Defense and Analyst Presentations

●Compliance->Oracle Security(CPU/PSU)patch application on all the environments (Both Primary and DR) as and when released by Oracle.

●Worked on Database Utilities like Import/Export, Patch installs, Monitoring ERP Applications.

●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

●Upgrade -> Database upgrades from 11.2.0.3 to 12.1.0.2.

●Backing up database objects using Exports & Imports

●Planning for Backup and Recovery of database instance and maintaining Hot Backups, Cold Backups.

●Hands on Experience on other applications like J.D.Edwards, Markview, Vertex

●Oracle Database Performance Tuning Experience and improving the system performance

●Strong experience in supporting (24X7) production, development, unit test,integration test and certification test environments (Total of about 50 ERP instances)

●Cloning - Clone of Oracle Database SIT,UAT and Production instances.

●Patching - Patching all EBS and DB in SIT, UAT and Prod instances including post patch analysis and owning the patch management.

●Backup - Backup scheduling and Backup Monitoring.

●Coordinated and led sessions with SMEs to discuss requirement and designs.

●Interaction with the clients and users and attending the client meetings for business requirements

●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,11i

Databases

Oracle Database 12c, Oracle Database 11g

Tax Application

Vertex O Series 7.0

Invoice Process Application

Markview 8.0

Operating System

AIX,Linux,Solaris

PROFESSIONAL EXPERIENCE

Client: Black & Veatch, Overland Park, Technical Specialist Sep 2013 – Till Date

Project: Black & Veatch is an American multinational energy corporation.

Responsibilities

●Provide Application Support and Maintenance (ASM) Services for Oracle, Markview and Vertex Applications.

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

●Managing the lead Onsite DBA role and handling the offshore team with daily/weekly status calls to close the issues within the SLA.

●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)

●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 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 12c, AIX, Toad

Client: CITI, Tampa, FL, Senior Apps DBA Consultant Dec 2012 – August 2013

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.

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

Client: Pernod Ricard India Pvt Ltd (PRIPL) May 2011 – October 2012

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

Client: Plethico Process Management (PPM) Feb 2009 – May 2011

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.

Client: ABAN Limited May 2007 – Jan 2009

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.

EDUCATION QUALIFICATION

Master of Computer Applications 2005-2008 ( Anna University, Chennai – INDIA)

Bachelor of Science 2002-2005( Sri Krishna Devaraya University, Anantapur – INDIA)

Contact this candidate