VINOD YADAV

Mobile: +**** 982*******~ E-mail: addwdp@r.postjobfree.com ; addwdp@r.postjobfree.com

LinkedIn prfile-https://www.linkedin.com/public-profile/settings?trk=prof-edit-edit-public_profile

Address: Kondivita new municipal Colony, MIDC, street -19,

Andheri (East), Mumbai - 400094,

Maharashtra, India

Passport No.: N3234814 Expiry Date: 22-Sep-2025

Nationality: Indian

Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate

Oracle Database Cloud Administrator Certified Associate

Oracle Infrastructure as a Service 2017 Certified Implementation Specialist

Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure administrator

Technical Architect/ Senior Oracle Apps DBA /Oracle Core DBA/Database Manager

SYNOPSIS

Database Architect with experience in Oracle Technologies

Current Project: Technical Architect and Oracle Cloud Environment Manager.

Experience comprises as a Technical Architect, Oracle Applications DBA, Oracle DBA and System Administrator.

Proposal writing and Technical Solution Validation.

Capacity Planning, Cloud implementation on AWS and oracle cloud, Oracle Database and Application Sizing.

Configuration Manager and Release

Oracle E-Business Suite, Oracle SOA 11g, Oracle Governance, Risk and Control (GRC), Oracle OBIEE 11g, Oracle Database 11g, Oracle RAC 11g R2, Oracle Data

Skills

Working knowledge in analyzing customer's business and technical requirements, assessing existing environment for Cloud enablement, advising on Cloud models, technologies and risk management strategies

Expertise in Linux administration and Working knowledge in setting up Linux based virtualization / cloud.

Experience on architecture, design of cloud solutions to address scalability, performance, security, availability, cost transformation requirements

Hands-on technical expertise on one or more of the following Public Cloud platforms: Amazon Web Services (AWS).Oracle IAAS and PAAS

Working knowledge in migration-deployment of applications to Cloud, re-engineering of application for cloud, setting up OS and app environments in virtualized cloud

Good exposure of VPC,AWS EC2, AWS RDS, AWS Red Shift, AWS S3, AWS ELB, AWS Networking, Google Cloud Platform,

On premise to cloud migration of oracle Database, EBS and other non oracle applications

Solution Architect and member of Solution architect team in Capgemini

Pre sales activity and worked on RFS’s

Web logic admin, SOA admin and OTM admin

RMAN,Backup & recovery, high availability and Performance tuning

Performance tuning

Competency lead for Database,EBS DBA and FM admin and Cloud Computing

solution for EBS,

Migration from Teradata and DB2 to mysql database, backup recovery and performance tuning of mysql database using mysql tools and SQLYOG tool.

Well versed with mysql tools for migration and admin

User management and storage management for oracle and mysql Database.

Basic knowledge of Hadoop and Mongo DB

Excellent written, verbal communication skills, presentation and collaboration skills

Team leadership skills

Incident Management, Change Management and problem Management

Certification and Professional Trainings

Oracle Database Cloud Administrator Certified Professional

Oracle Infrastructure as a Service 2017 Implementation Essentials

Oracle 9i,10g OCP

Oracle 11g Real application Cluster and Grid Infrastructure admin

EBS 12.1.3

ITIL V3 certified

Prince2 foundation

Capgemini Global Level1 Technical Architect

Training taken for Web logic admin,Big data Hadoop and Mongo DB admin

PMP Workshop

Engagement Manger workshop

Professional Experience

Capgemini India Pvt Ltd, Mumbai, India [Dec’06 –Present]

CAREER CONTOUR

Positions:

Project Name: Heathrow and Centrica and CCP- June-18 - current

Location: UK

Role and Responsibility: Technical Architect and Oracle Cloud Environment Manager

oHeathrow is using Oracle cloud for it various product, IAAS, PAAS as a service for Database and SAAS for OAC. My role as Environment Manager to manage various aspects of IAAS, PAAS and SAAS includes monitor and analyse storage, Manage promising of new instance in IAAS, manage backup and restoration. analyse and implement the patches for IAAS and DBAAS.

oOracle Cloud Infrastructure setup on CCP project and help client take advantage of automatic provision in terms of VM, Storage, Database and Network Configuration.

oAutomation for environment using packer and Terraform, automatic provision of Zabbix, Antivirus and some other native monitoring tool.

oPerformed the role of Technical Architect to design complete architecture for various new solution like database migration, upgrade of Linux system and design and implementation of new solution

oImplemented various performance tuning recommendation on Oracle Databases.

Project Name: Centrica - September-18 – current

Role and Responsibility: Oracle Database Administrator

oDatabase admin role of backup recovery, performance tuning, troubleshooting on database issue. Migration and upgrade of database from 10g to 12c on Azure Cloud.

Location: UK

Project Name : Brent Migration [Dec-17 – June-18]

Location: UK

Brent London Borough Council is the local authority for the London Borough of Brent in Greater London, England. It is a London borough council, one of 32 in the United Kingdom capital of London.

It is wide range of technologies which consists of EBS 12.1.3, WebLogic, SOA,OBIEE,GRC, RAC and standby database which needed to be migrated from One Oracle which contained data and setup for 7 councils in UK.

Role and Responsibility: Senior Application DBA

oDesigned and migrated lift and shift from one oracle to Brent councils from UK based oracle cloud to Brent datacentre on VMware.

oMigration of oracle RAC database, EBS 12.1.3, SOA, GRC and OBIEE to Brent councils.

oImplemented new Disaster recovery plan for councils. Setup of punchout and new SOA outbound interfaces were developed, tested and put in live.

Project Name : John Lewis Partnership [Feb -16 – Nov-17]

Location: India

JLP is top 10 retailers in the UK and it is one of the largest employee co-operative organizations of UK. Project scope includes AWS cloud migration, EBS 12.1.3 for Finance and HR,Web logic,webcenter and IDM development and support work .

Role and Responsibility: AWS Solution architect

oDesigned and implemented cost effective cloud solutions with AWS Virtual Private Cloud, EC2, ELB, RDS, DMS etc

oCreating data warehousing solution using AWS redshirt for data analytics purpose

oLoading data from S3 into AWS Redshift

oProviding No SQL databases such as Dynamo DB to development users

oArchitecting Cloud Formation templates for future use

oIntegrated on-premise data centre resources with AWS cloud

oSetting up multimode ERP on AWS cloud using EC2, ELB, VPC

oMigrated databases in AWS Cloud RDS

oSetting up DMZ for multi node environment

oInstallation of Retail application on AWS, user management and security management on AWS.

Project Name : IFFCO Duration [Nov-2015 onwards]

IFFCO is an innovative and integrated multi food products Group based in the United Arab Emirates. Scope of support in this project for EBS 12.1.3, SOA, Web logic, OTM, Siebel, Hyperion, UCM, Hive.

Role and Responsibility: Tower Lead for DBA

oPerformed all transition and started support for the project

oManaging DBA’ size of 6 DBA as a DBA tower lead and Database manager .

oCurrently we are supporting client on the basis of 16*7 on weekdays and 18*2 on weekends.

oUnderstanding all clients’ requirement and have already started suggesting SIP to client.

oPlan shift, weekend activity and major time for weekly and monthly activity.

oManaging all technical and issues and performance related issues for ASCP, and EBS

oSOA admin, Siebel,UCM and Hyperion admin

oWoking on RFC, presales activity for database and have been involved in attaining presales orals.

oCompleted POC of Advance compression, SOA upgrade, completed RPC patches, UCM DB upgrade and EBS DB upgrade.

oDeveloped 35+ shell scripts to proactively monitor the system performance and health to avoid any downtime and it has improved system availability downtime a lot

oCompleted index rebuild activity for major schema to gain performance and storage on production environment

oInvolved in tuning on performance issues in the system.

oResolved hive issues which was causing performance on EBS.

oLeading overall 5 EBS DBA projects and 25 DBA’s

Project Name : Smiths Medical Duration [March- 2015-Oct-2016)

Oracle application R12 support, Oracle ASCP, GRC and oracle 11g database support for

Role and Responsibility: Senior apps DBA and Project Lead

oPerformed all transition and started support for the project

oManaging DBA’ size of 5 DBA.

oCurrently we are supporting client on the basis of 16*7 on weekdays and 18*2 on weekends.

oUnderstanding all clients’ requirement and have already started suggesting SIP to client.

oPlan shift, weekend activity and major time for weekly and monthly activity.

oManaging all technical and issues and performance related issues for ASCP, and EBS

Krispy Kreme [ Sep2013 –Feb-2015]

This application landscape is based on multiple custom developed and legacy

Applications anchored by MACOLA ERP system that is at the end of the product life cycle and no longer supported.

Responsibility: Oracle Apps DBA

oResponsible for EBS R 12 installation and upgrade to 12.1.3, ASCP configuration and DB and Grid infrastructure upgrade from 11.2.0.2 to 11.2.0,4Optimize cloning and Patching of EBS suite automation of cloning,optimization of Concurrent manager

oTaking care of OBIEE installation for version 11.1.1.7.0 as well as GRC, PCG and CCG configuration for EBS.

oPerform SYSADMIN job of adding user, request, request groups and others

oProviding MWA support, cloning, patching, troubleshooting, optimizing and managing security features for EBS.

oTroubleshooting any application issue and working with users, Code Migration.

oStandby Database configuration, good hands on RMAN.

Project Name : Cornwall Government council UK [Jul’11 – Aug’13]

Cornwall council is government authority in UK which provides a range of

services including information, telephone advice clinics, and outreach clinics in locations throughout Cornwall and specialist in depth support.

Responsibility:

oWorked as Team Lead in the project, managed 5 projects and 8 DBA as well as supported Oracle and 12.1.3 EBS instance.

oImplemented GRC for web logic, Weblogic Admin as well as MORE4APPS and also integrated SSO/OID with oracle EBS.

oResponsible for DMZ configuration on two node architecture, database creation, user admin, storage management and tablespace management

oPerformed backup and recovery for database as well as import and export of Discoverer.

oTook care of Hyperion, ORGPLUS and OBIEE Production support activity which contains availability of application.

Project Name : Stagestors Corporation USA [Nov-2011 – Jan-2013]

Stage stors is retail shop network in USA.

Responsibility: Completed EBS upgrade from 11.5.10.2 to 12.1.3, implemented OATM on FIN and HR instance and performed backup and recovery for database.

oResponsible for database creation, user admin, storage management, tablespace management as well as application server management

oHandled cloning of EBS for 11i and R12 instance, HRMS patches analysis and application as well as also managed RMAN backup and recovery operation.

Project Name : House of Fraser

Client Name : UK

Duration : Apr’10 – Aug’13

Description : House of Fraser is the chain of retail shops in UK and they have different

Domains like supply chain, multichannel, HR and Finance.

Responsibilities:

oWorked as a Team Lead in the Project, managed Oracle EBS 11.5.10.2 and 12.1.3 production support and completed database upgrade from oracle 10g to 11gR2.

oPerformed Cloning of EBS, DMZ, BPEL and Discoverer, patch analysis and implemented patch path which included HRMS patch and Ireland patch

oImplemented OATM on FIN and HR system did application upgrade from 11.5.10.2 to R12 as well as DR testing for HOF.

oResponsible for HRMS and Ireland patches, implemented baseline patches and JRE upgrade and DMZ configuration for I-Supplier and cloning of DMZ.

oTook care of database creation, user admin, storage managements, tablespace management, created database, tablespace as well as monitored the space management in database

oPerformed backup and recovery for database and import and export of discoverer handover by performing export of EUL and import of files.

oSupported Oracle application server creating OC4J component, deploy forms, deploy reports and also monitored application DBA performance tuning.

oManaged objects, schemes, monitored the health check for the database and provided the support accordingly.

Project Name : Visteon

Client Name : Visteon USA

Duration : Dec’06 – Mar’10

Description : In this project there are different domains like Purchase, SAP, MP&L, Legacy,

PD and the DRDA is one gateway which continuously downloads the data from Mainframe DB2 to oracle for end user to see the data.

Responsibilities:

oMigrated project from UDB db2 to MySQL database and from Teradata to Oracle database.

oWorked as Project Quality Lead and managed, configured and maintained quality document for the project as well as involved in quality control reporting process.

oSupported the user managements, monitored download process of the DRDA and provided support in regards to the Oracle database and downloads.

oSupported database availability as well as monitored the health check for the database and provided the support accordingly.

oTook care of database creation, user admin, storage managements, tablespace management, and also managed schemas.

oPerformed backup and recovery for database and also looked after the performance tuning or oracle database and managing memory parameter.

oDatabase migration, backup, recovery and performance tuning for oracle and mysql database

oManaged migration of data from DB2 to MySQL and DB2 to Oracle using migration tool SQL ways; provided MYSQL database support windows server and Linux server.

PREVIOUS EMPLOYMENT

Mar’96 – Nov’06 Rolta India Ltd Production Executive

Projects:

Successfully completed the following projects:

TELUS

GTO OMAN, MOPTT (Ministry Of Post Telecommunication and Telegraph)

SCHOLASTIC

2002 MCA from IGNOU

1993 B.com from Mumbai University

PERSONAL DETAILS

Driving License No. : MHO2-20140028834

Passport Number : N3234814

Issue Date : 23-09-2015

Expiration Date : 22-09-2025

Interests/Hobbies : Reading

*References available on request

Contact this candidate