YadavKumar Sivakumar

Infrastructure Architect, Oracle Applications DBA, OID & OAM Administrator

Mail: adg2aa@r.postjobfree.com

Ph: +1-774-***-****

Professional Summary

** + years of experience with oracle Databases and other oracle applications

Oracle Certified Cloud Architect (Professional) and autonomous database specialist

Have experience working with various cloud environments

Very proficient in management of Oracle E-Business suite and Fusion Applications (OID and OAM)

Have good knowledge of upgrade and migration of EBS application and databases

Have in Depth Knowledge of Oracle Database Management

Have good command over the Linux and other Unix environments

Good with shell and python Scripting

Have experience leading a team, thereby training and coaching them

Can communicate very effectively and efficiently

Certified in Mongo DB management

Technical Skills

Languages : Python, Shell scripting and PLSQL

Cloud services : OCI, AWS, Azure,TCS Enterprise cloud

Databases : Oracle 11g, 12c on both stand alone and RAC, Mongo DB

Operating Systems : Linux (Mostly RHEL),Solaris, HP Unix, IBM AIX, Unix, Windows servers

Database Tools : OEM, Toad, RMAN, EXPDP/IMPDP

Applications : EBS R12.2, R12.1.3, 11i, OAM, OID, Weblogic servers

Professional Experience

Project Profile

Project : Multiple Projects including WMS/supplier management etc

Customer : Sensata Technologies

Period : oct, 2018 to till date

Role : Architect / oracle core and Apps DBA

Location : Attleboro, MA (Current), Chennai, India (till 14 Feb)

Responsibilities

Leading various migration projects withing TCS cloud

Working with sales team for new and upcoming RFP’s

Design solutions for new and upcoming projects

Regular maintenance of the Existing EBS 12.2.6 environments hosted on TCS Cloud

Planning Creation and upgrade of multiple new databases and related infrastructure for upcoming projects

Work closely with the Business to identify and help resolve the pinch points in various applications

Performance tuning for long running queries and forms

Regular Application patching on Oracle EBS R12

Regular Maintenance activities on OAM and OID applications

Worked on Various stages of SDLC

Mentoring and managing the team

Project Profile

Project : Corporate Supplier Management and Warehouse Management (R12.1 implementation and support)

Customer : Colruyt Group Services

Period : Apr, 2013 to sep,2018

Role : Lead Oracle E-Business DBA responsible for upgrade of 2 EBS R12.1.3 applications with OAM & OID

Location : Brussels, Belgium (Till 02-Jun-18), Chennai, India (Since 03 Jun 18)

Responsibilities

As a lead DBA performed end to end planning and execution of the upgrade of 2 existing E-Business applications from 12.1.3 to 12.2.6

Implementation and integration of Oracle Internet Directory (OID) and Oracle Access Manager (OAM) with EBS 12.2 instances

Designed the architecture for a 3 node EBS 12.2 application with 2 MWA nodes for warehouse management

Designed the architecture for a 2 node EBS 12.2 application with a DMZ for external users

Worked Closely with the Business to coordinate and manage the entire roll out of upgrade

Planned and executed the upgrade of EBS database from 11.2.0.4 to 12.1.0.2

Migrated the Application from RHEL 5.x and 6.x to RHEL 7.x

Received appreciations from higher management of business for on-time upgrade and delivery of the Applications

Implementation of Warehouse management system with Oracle MSCA (MWA)

Implementation of Multi node application (shared File system) in EBS 12.2

Automated OID role synchronization to seamlessly work with EBS instances

Regular cloning activities from Production to all the lower instances after upgrade to 12.2 Env

On-call support for the Applications.

Automated the check to validate the 40 MWA servers and 4 dispatcher processes in WMS to avoid failures

Custom built various automations to reduce the downtimes and increase the system stability

Automated various setups via templates in EBS

Re-org of production database to improve performance

Performance tuning for long running queries and forms

Regular Application patching on Oracle EBS R12

Regular Maintenance activities on OAM and OID applications

Worked on Various stages of SDLC

Project Profile

Project : SCPT (Supply chain transformation) and L3 support

Customer: Motorola Solutions

Period : Feb, 2009 to Mar, 2013

Role : Team Member Oracle DBA/Apps DBA,responsible of installation and configurations of Oracle 11g DBs as both RAC and standalone instances along with Management of Oracle E-Business suite R12 applications

Location : Chennai, India

Responsibilities

Regular Application patching on Oracle EBS R12.1 Running on oracle 11g R2.

Managing application roles and user profiles.

Database upgrade activities (from 10g to 11g).

Managing L3 activities on the DB like creating the DB, creating the users and profiles, configuring backups

Done extensive Oracle APPS Rapid Cloning on R12.1 environment.

Regular Database cloning activities from Prod to Dev

On-call support for the DBs and Applications.

Primary DBA for more than 30 Production Databases and Secondary for more than 30 Databases.

Applying Oracle patches to Databases as part of L3 activities

Maintaining the space usage in databases by adding OS disks to ASM disk groups and other space related activities.

General DB and Application maintenance activities.

Code migration activities for various custom tops in oracle Applications

Extensive Cloning and 11.2.0.3 installation on Solaris platform

Educational Qualifications

Year

Qualification

Institute/University

2005-2009

Bachelor of Technology (Information Technology)

Amrita School of Engineering, Coimbatore. India

Experience Summary

Year

Company

Role

Total Experience

Nov, 2009 - till date

Tata Consultancy Services

Oracle Apps DBA / Core DBA and Oracle Fusion MW applications (OID and OAM) Administrator

10 years 10 months

VISA Status

I am a H1B Visa holder and will require a sponsorship if selected.

Contact this candidate