Manager Oracle

VIJAY JHAMTANI

Mobile: +91-997******* Email: *********@*****.*** *********@*****.***

LinkedIn: www.linkedin.com/in/vijayjhamtani

A technocrat with nearly two decades of experience in IT Project Management, Oracle Database and AWS Cloud with excellent program Management skills EXECUTIVE SUMMARY

A competent and resourceful technical professional with Total 18 years and 15 years of relevant experience in Solutions Architecture, Project/Project Management, IT Operations, Database Management, Technical Support, and People Management. Working with cross-functional project team and stakeholders around the globe to develop and drive Informational Technology program to successful completion. Long term experience in Cloud Database and Program manager skills for motivating and organizing team of varying size, specialty and cultural origin in a manner that has earned a long-standing record of excellence and reputation with proven ability to integrate technical expertise and business knowledge. Effective communicator with attention-to-detail, problem solving and interpersonal skills. CORE COMPETENCIES

IT Strategic Planning Project/Program Management IT Transformation

Operations Management Oracle Database Management Process Improvement

Stakeholders’ Management Training & Mentoring Team Management TECHNICAL STRENGTHS

Oracle Database AWS RDS Oracle Enterprise manager Oracle Goldengate Data guard RAC MS SQL server MySQL Linux windows Nagios Toad Tableau Atlassian Service now Splunk ITIL CMDB ACADEMICS

Master of Computer Application University of Bhopal 1999 77 %

Bachelor of Science University of Bhopal 1995 70% CERTIFICATIONS

Oracle Goldengate Certified in 2008

Pursuing AWS Solution Architect Associate

TRAINING PROGRAMS / WORKSHOPS ATTENDED

EMBARK (Leadership Program)

Oracle Enterprise Manager

Goldengate Adminisration from Goldengte

AWS Solution Architect (Associate)

EXPERIENCE DETAILS

INFOSYS LTD, PUNE, LEAD CONSULTANT DEC

2012 – JAN 2020

Client : - Pfizer (Pune), Hoegh Autoliners AS (Oslo-Norway, Pune)

Leading Global Database Team and designing/migrating AWS Database cloud based solutions .

Mentoring the onsite and offshore team on all new enhancements.

Managing the development & maintenance of documentation including departmental policies, procedures & periodically service reports as it relates to IT Operations. Drive continuous improvement for ITSM (IT Service Management).

Experienced in assessment, planning, design, documentation, change control and team lead for various IT projects with best practices and methodology of ITIL. Managing and creating documentation in Atlassian, Sharepoint and eRoom.

Shaping Business relationship with RFP and RFI activities for Database Solution Track. Coordinating with stakeholders from each track, creating technical as well as commercial response documents, and responding to RFPs and RFIs.

Responsible for Client Management and Reporting.

Designed and implemented overall data architecture for data replication using oracle database and goldengate.

Responsible for performing data analysis activities to capture data requirements and representing them in formal and visual way through data models.

Troubleshooting technical issues with respect to data migration, upgrades and disaster recovery. Oracle database Performance Tuning with high data volume environments.

Worked extensively on AWS RDS with Oracle, MYSQL database performance tuning.

Installing, configuring and troubleshooting oracle database, OEM, goldengate in heterogeneous environments. Identify key risks and mitigation for all issues.

Providing technical support on Oracle database related technologies such as AWS RDS, Golden Gate, database upgrades, migration, Performance Tuning, Standby, Backup and Recovery, user management, RMAN, Oracle Enterprise Manager, Flashback, Data pump, Database security etc.

Responsible to manage, build and mentor a strong Database team of Oracle and MS SQL Server to provide professional and quality support to various client. Architecting, managing and supporting 24x7 high availability.

Monitoring and fine-tune the performance of production database to ensure consistent response time and throughput.

TECH MAHINDRA LTD., PUNE, SR. DATABASE ADMINISTRATOR MAY 2011 TO DEC 2012

Client : - British Telecom (Pune)

Responsible for oracle Database Administration and Architect.

Develop replication strategy for continuous data movement and integration.

Responsible for technical and architecture for oracle database.

Define data strategy for warehouse users. Provided star schema solution for workflow.

Setup, Configuration, Monitoring of Oracle Goldengate, Oracle Enterprise Manager Grid Control. Carry out database administration activities.

Coordination with Oracle Support and different stakeholders to troubleshoot oracle and Goldengate issues,

Actively worked in SQL/DB Performance Tuning, Analyzing Performance issues with AWR/OEM. Worked on Database Space Management and recovery manager.

Delivered database scripts for health monitoring, database creation,

Created Documentation for L1,L2 database activity.

Technical mentor for database team.

CMC LTD., DELHI, DATABASE ADMINISTRATOR MAR 2005 TO MAY 2011

Client: American Express (Phoenix-Arizona), Travel Impression (Whitehall-Pennsylvania), National Highways authority of india(Delhi)

Carried out database administration activities. Handled single sign on critical and big sized Oracle databases.

Worked on different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import, Datapump for Backup activities.

Automation of database monitoring and performance related reports using various Unix shell scripts and OEM report. Job Scheduling with OEM, crontab.

Database Monitoring and performance tuning the queries using AWR, Explain Plan, TKPROF, Auto trace and Oracle Enterprise Manager Grid Control.

24x7 production support DBA worked on a primary/ secondary rotation. Performed Oracle Database migrations and upgrades with latest version.

Training and Implementation Support for Oracle Goldengate to upgrade database from oracle 9i to oracle 10g with zero downtime.

Overall Involved in Provide consulting, engineering, implementation, architect and support for database availability, Data Guard and Oracle Goldengate, performance tuning, User Management, Backup-Recovery. HINDUSTAN TIMES LTD, NEW DELHI, SR. TECHNICAL MANAGER SEP 2002 TO FEB 2005

Worked as a Database Administrator for Media Management Legacy System Software in Oracle 9i. Extensive worked of BEx reporting using SAP-BIW. Worked on Structures, templates, Exceptions, top & bottom query, variables maintenance, Yield Growth Projection, Market share Analysis in Business Warehouse tool. Carried out Standard Database Administration Activity, SAP BW Support, Training for Legacy system, Designing Documents. Worked on product improvement plans based on Oracle DBA knowledge about performance tuning. Handled backup/recovery, Database Security, Export-Import. Generating Problem Solving queries and providing requested Information in report format.

PERSONAL DETAILS

Date of Birth : 04/10/1975

Marital Status : Married

Permanent Address : K-II, Meenakshi Residency Idgah Hills, Bhopal, Madhya Pradesh, 462001 Current Address : Puraniks Abitante B-803, Bavdhan, Pune Passport Details : S7714416 Hold passport valid till May/2028 ; issued by OSLO (Norway)

Contact this candidate