Oracle Apps DBA OCI AWS
Resume:
SUNIL YADAV
Kapolei HI 96707
Phone: 808-***-****
**********@*****.***
Key Skills:
CURRICULUM VITAE
Oracle Apps DBA E-biz suite 11i, 12.1.3,12.2.5+, RDBMS 7, 8,9i, 10g, 11g, 12C on AWS and OCI hosting RAC, ASM, Golden Gate, ODI, OBIEE, WebLogic, Exadata, Administration, Maintenance, Upgrades, Migrations, Tuning and Support on various Unix platforms.
Work Experience – 15+ years
Velocity Technology Solutions
Honolulu, Hawaii
Designation: Senior Oracle Applications DBA
Duration: 23rd Jan 2017 – Current Date
Environment: Oracle Applications DBA 11i (11.5.10.2), R12.1.3, R12.2.5 Oracle 10g/11g/12c on AWS and OCI hosting Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Developer, Oracle Discoverer 10g/11g, OBIEE.
Responsibilities:
• Support / Patching / Upgrade / clone work for around 95 clients as Senior APPS DBA
• Upgraded 11g/10g Oracle Database to 11.2.0.4/12c Database.
• Provided support for Oracle Applications, OBIEE, AGILE, HYPERION.
• Cloning and Patching of Oracle Databases and Oracle Applications 11i/R12
• Troubleshooting the issues raised by user community and development.
• Installed latest version of APEX using Glassfish in EBS.
• Worked on Workflow Administration and issues.
• Resolving issues related to Web server, forms, reports, Discoverer.
• Perform Applications administration using AD utilities.
• Discoverer 11g configurations, EUL work activities.
• Resolved issues on Concurrent Managers, Worked on concepts of Apache and Forms Server issues.
• Explain plan, Tkprof, Stats pack, CPU load AWR report generations,
• Oracle Applications Manager (OAM) work around and issue solving.
• Evaluate Oracle features and Oracle related products
• Perform application tuning and performance monitoring
• Perform general technical trouble shooting and give consultation to development teams
Oracle India Pvt. Ltd.
Designation: Principal Advanced Support Engineer
Duration: 21st Sep 2015 – 9th-Jan-2017
Clients:
IFFCO
Bharti Airtel Ltd
L.G Electronics
Central Board of Excise and Customs
Godfrey Philips India Ltd
Tata Cummins India Ltd
Maruti Udyog Ltd
Uninor India
Berger Paints
Punjab National Bank
Department of Income Tax
Responsibility:
Oracle Advanced Customer Services for Administration, Upgrades, Migrations, Maintenance and Support, DR drills, Performance Tuning, Integrations, Disaster Recovery planning of Oracle Apps 11i, 12i, 12.2.4, 12.2.5, RDBMS 7, 8,9i, 10g, 11g, 12c, RAC, Golden Gate, WebLogic on various flavors of UNIX and Exadata systems.
Computer Technology Resources Inc., California, USA
Designation: Senior Oracle Application DBA
Duration: 21stFeb 2013 – 14th Sep 2015
Clients:
GUESS USA
Responsibility: Upgrade of Oracle Apps ERP 12.1.2 to 12.2.4
Capital Source Bank
Responsibility: EBS Upgrade from 11.5.10.2 to R12.1.3, Discoverer 10g to 11g upgrade, Oracle Applications Migration from 32bit to 64bit Operating System
Emtek Products, Inc.
Responsibility: EBS Production Support for 11.5.10.2, Migrations, Cloning, Patching, Performance Tuning, Database upgrade from 10g to 11gR2.
Oracle India Pvt. Ltd.
Designation: Senior Consultant
Duration: 5th Jul 2010 – 14th Feb 2013
Clients:
Bharti Airtel Ltd
L.G Electronics
Central Board of Excise and Customs
Godfrey Philips India Ltd
Tata Cummins India Ltd
Maruti Udyog Ltd
Uninor India
Berger Paints
Punjab National Bank
Department of Income Tax
Responsibility:
Oracle Advanced Customer Support for Administration, Upgrades, Migrations, Maintenance and Support, DR drills, Performance Tuning, Integrations, Disaster Recovery planning of Oracle Apps 11i, 12i, RDBMS 7, 8,9i, 10g, 11g, RAC on various flavors of UNIX.
Infosys Technologies Ltd.
Designation: Technical Lead
Duration: 15th Jan 2007 – 15th Jun 2010
Clients:
Emerson Electric Co. – 20th Jan 2009 to 14th Jun 2010
Responsibilities:
Support and maintain Oracle Applications 11.5.10.2 and R12 instances.
Clone instances for Data Center move.
Working in 24*7 environments.
Planning and scheduling various activities with the client and team.
Troubleshoot problems
Citibank -- Tampa, Florida, US – 9th Jun 2008 to 9th Dec 2009
Responsibilities:
Change management lead for 15 applications.
Worked in 24*7 environments and managed offshore team.
Planning and scheduling various activities with the client and team.
Responsible for handling escalated tasks.
Implement critical changes in Production and UAT environments for critical applications.
Weekly status report and call with client.
Version controlling using tools.
Troubleshoot problems with team members.
United Airlines (UAL) – 8th Jul 2007 to 6th Jun 2008
Responsibilities:
Implementation of Oracle Apps 11.5.10.2
Implement and support 2 node RAC with 3 application tier servers.
Deploy EAR files and support Discoverer
Install NLS patches when new language support is required.
Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
Apply database and applications patches.
Perform SQL tuning.
Assist developers with coding PL/SQL.
Received Infosys Esteem award for best managed project category.
Fanuc America Corp. – 16th Jan 2007 to 7th Jul 2007
Responsibilities:
Support of Oracle Apps 11.5.10.2 environment
Kintana Migrations planning and implementing in all environments
Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
Apply database and applications patches.
Assist developers with coding PL/SQL.
WNS Global Services
Designation: Database Administrator
Duration: 25th Sep 2006 – 10th Jan 2007
Client: FMFC (First Magnus Finance Corporation) A leading mortgage and finance organization
Responsibilities:
Responsible for administration, maintenance and tuning of Production, development, Testing and UAT Databases,
on Oracle 9i and Oracle 10g running on Linux platform.
Involved in deployment projects, following the complete SDLC cycle. Major client interaction and
organization process compliance.
Responsible for successful testing and delivery of all work in assigned area, including compliance with
methodologies and policies.
Coordinate application release & implementation steps with engineering and support teams
C.S.C – Computer Sciences Corporation
Designation: Engineer – System Support
Duration: 7th Feb 2005 – 11th Aug 2006
Client: National Grid Transco U.K.
Responsibilities:
Responsible for administration of more than 100 Oracle databases which are business critical in 24X7 environment with Oracle RDBMS versions 7,8i,9i and on various platforms such as Sun Solaris,HP-UNIX,VMS,WindowsNT.
Managing standby-contingency systems, refreshing the Fix-on-Fail environments on regular basis and as per the request from client.
Administrating and resolving issues related to Oracle Application Server and identifying improvements with established procedures and processes. Working with the Development team to develop patches to fix data discrepancies in the database.
Implementing scheduled changes to the database objects as a part of projects.
Satyam Computer Services Ltd., Hyderabad
Duration: 7th April 2003 – 7th Dec 2004
Designation: Engineer Networking & Systems
Responsibilities:
Part of Oracle DBA team to support and maintain intranet application on Oracle 9i.
Going through the requirements and coming up with database design and application architecture.
Installing, configuring, administering and securing production server as well as Backup server.
Coming up with custom-tailored backup/restore and recovery plans for production server.
Troubleshooting performance issues and fine-tuning queries.
Convergys India Services Pvt. Ltd.
Duration: 18th March 2002 - 27th March 2003
Designation: Technical System Support
Responsibilities:
Planning, Implementing and performing Backup and Restore strategies.
Disaster recovery planning and implementation
Security planning, implementation
Establishing Link/Remote Server for data access across servers using distributed queries.
Creating jobs to automate repetitive tasks, database maintenance and data transfer.
Certifications:
AWS Cloud Practitioner
Oracle Cloud Infrastructure Associate (in progress)
Oracle Certified Professional - (oracle 9i)
Oracle 9iAS Basic Administration
Oracle Database 10g RAC for Administrators
Microsoft SQL Server 2000 MCP certified dba
Education:
University of Pune Aug 1997 – May 2001
Bachelor of Engineering (Electronics)
Contact this candidate