Manager Oracle
Resume:
SACHIN AMBARDEKAR
************@*****.***
Professional Summary
* Around 14 years of experience as Senior Oracle DBA and Oracle Apps/eBusiness DBA/Manager.
* Involved in vital planning for infrastructure setup.
* Managed team of DBA’s (infra structure) on site and off site. DBA categorized of Administration, Production, Change Management and On-call support.
* Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
* Responsible for securing database; implemented role-based security and audits; implemented encryption of tablespace (TDE), data scrambling.
* Managed the full database deployment life cycle including development, testing (including UAT), and pre and post-production environments according to quality standards
* Performed Single node and Multi-node installations R12 on Exadata and Exalogic machines.
* Strong knowledge in Oracle Apps/eBusiness Architecture 11i & R12, Oracle 9i, 10g & 11g Database Concepts, 11gR2 RAC database, Disaster recovery (data guard), Backup & recovery, Performance tuning, SSO, SSL Implementations, DMZ setups, Autoconfig, Concurrent Manager and Adutilities such as adpatch and adadmin.
* Extensive experience in Oracle Apps/eBusiness point release upgrades (11.5.8/11.5.9 to 11.5.10.2), R12 upgrade, Database upgrades, 11i Tech stack component upgrades.
* Extensive experience on patching and cloning the EBS application and database.
* Exposure on troubleshooting Oracle Apps Components like forms, Apache, Concurrent Manager, Reports Server and Discoverer.
* Experience in monitoring Database and Oracle Apps/eBusiness environments, UNIX shell script, Solaris/Linux basic administration.
* Performed OBIEE 11g install.
* Good understanding of Oracle support models, very good team player with exposure of team management.
* Exposure to Oracle application server 10g concepts and architecture.
* Strong Technical background with excellent problem solving skills.
* Involved in the full implementation cycle of Oracle application 11i, R12.1.3 and R12.2.4.
* Strong knowledge on installation and configuration of Oracle Fusion Middleware Products on HA (SOA Tech tack, Weblogic, AIA, OSB, PIP, ODI, MFT).
* Installation and configuration of Oracle Enterprise Manager Grid control 10g, 11g and 12c for monitoring to manage and automate the alerts based on thresholds. Utilized OEM components (Diagnostics Pack, Tuning Packs etc.) for analyzing the database activities and improving the performance.
* Implementation of iPayment, iStore module with Oracle application 11i & R12.
* Installation and integration of Demantra 7.3 with E- Business Suite R12.1.1
* Installation of Governance, Risk & Compliance Control (GRCC) 8.6 and Configuration Controls Governor (CCG) 5.5.1
* Performed performance tuning of the database for the accepted level. Implemented database performance monitoring tools.
* Supported users and developers; developed queries; and optimized their stored procedures
* Certifications include Oracle Certified Professional on 9i and 11g.
* Worked extensively on Backup & Recovery online/offline using RMAN, User-Managed physical/logical backups using Import/Export. Along with performing DR drills.
Academics
* Bachelor of Engineering.
Professional Certification
Oracle9i and 11g Certified Database Professional.
Knowledge
Technologies
Extensive experience in Oracle database version 11g, 10g, 9i and 8i, E-Business Suite administration R12 (12.0.4, 12.1.1, 12.1.3, 12.2.3, 12.2.4), 11i (11.5.9, 11.5.8), Oracle Grid Control 11g/10g, Demantra 7.3, OBIEE 11g, Oracle SOA 11g/12c, ODI12c, MFT 12c, IPM 11g, AIA 11g, PIP 11g, Weblogic 10.3.6, Sun Solaris, Linux, HP – UNIX, AIX, Windows NT4/2000, Exadata X5-2 and Exalogic X5-2
Project Role
In-depth knowledge of database and application upgrade, DBA track lead, DBA best practices documentation, project coordination and tracking, release management, technical team training, full development life cycle support
Application Modules
Finance, Manufacturing, Purchasing, Order Management, Supply Chain, Project Costing, Project Billing, HRMS.
Professional Experience
Organization
Designation
Duration
Hitachi Consulting
Manager, Specialized Services
November 2010 – Till Date
US Jade Corp.
Sr. Consultant
April 2010 – October 2010
RCM Technologies
Lead Database Administrator
October 2008 – April 2010
KGF Associates Inc.
Sr. Consultant
September 2006 – October 2008
L&T Infotech
Sr. Software Engineer
April 2004 – July 2006
Trisha Software
Trainee/Software Engineer
August 2001 – March 2004
Project Profile
Company Name
Hitachi Consulting
Clients
Multiple projects for different client
Role
Manager/Infrastructure/DBA Lead
Duration
(10/2010) – Present
Environment
Oracle E-Business Suite R12.2.3, R12.2.4, R12.1.3 Oracle database (RAC and non-RAC) 11gR2, 12c. Fusion middleware 11gR1, OSB, PIP 11.1, Application Integration Architecture, IPM Suite 11gR1, 12c (weblogic, SOA and ODI), Enterprise manager cloud control 12c, Exalogic X5-2, Exadata X5-2 RAC database, (12.1.0.3.0), SSO, ATG, UCH, Demantra 7.3.4.1, Oracle Enterprise Linux 5.4, 6.1, 6.7, Oracle Sun Solaris 10, Oracle Governance, Risk & Compliance Control 8.5.1, 8.6, Configuration Control Governor 5.5.1
Contribution
Infrastructure lead for the implementation of Oracle Applications Finance,
Primary EBS DBA for implementation of Oracle Applications Finance, Manufacturing and Supply Chain modules.
Primary EBS DBA for upgrading Oracle Applications successfully from 11.5.10.2 to R12.2.3.
Lead the DBA team and act as subject matter expert in guiding client team members.
Optimizing the downtime for maintenance by coordinating with the different application teams involved in the maintenance activity.
Installation of R12.1.3 as well as 12.2.4 on Oracle database 11gR2.
Installation of R12.2.4 with database 12.1.0.2 on Exalogic and Exadata servers and converting database into 2 node RAC database and 4 node application tier.
Installation of Fusion middleware 12c (12.1.0.3) with database 12.1.0.2 on Exalogic and Exadata servers and converting database into 2 node RAC database and 2 node application tier.
Installation of SOA (11.1.1.6.0) suite, OSB (Oracle Service Bus) 11.1.1.6.0, PIP (Process Integration Pack) 11.1 and integration with AIA 11.1.1.6.3.
Installation and configuration of Oracle Grid Control 11g and enterprise manager cloud control 12c.
Prepared instance planning, infrastructure architecture diagram, patch application process, code migration process, process standardization, documentation, build schedule instance refresh strategy and instance life cycle.
Upgraded database from 10g to 11gR2.
Created custom application for customizations in R12.1.3 and R12.2.4
Involved in implementing and managing backup & recovery strategies.
Responsible for analyzing and designing the process to implement the patches.
Interaction with team to assist them in troubleshooting their problems related to Oracle Applications and Oracle Databases.
Responsible for documenting important scripts and administration of server environment.
Responsible for conducting weekly meeting with clients, DBA teams both onsite as well as offshore.
Worked on STAT tool for code migration from Dev to higher environment.
Applied NLS translation synchronization patches.
Extensively working on SRs using the Oracle Metalink for key Issues.
Wrote UNIX shell scripts like start-up / shutdown etc. and setting up the cron jobs.
Supported the development team not only with EBS related issues on multi node application tier (5 node) and RAC database (4 node) but also on other technologies like SOA, ATG, ODI, UCH etc.
Performed patching, cloning, code migration, printer setup, troubleshooting and performance tuning through Enterprise Manager Cloud control.
Troubleshooting on SSO 11g and ISG services.
Daily Activities (Monitoring OS File system usage, Concurrent Managers, alert logs, Concurrent Managers logs, Tablespace usage, TNS, Apache, Forms and Reports Services).
Participated in production Cut Over planning.
Built disaster recovery site on RAC and Non-RAC systems.
Installation of GRCC 8.5.1/8.6.and CCG 5.5.1.
Installation of and configuration of Golden Gate 12.2.1.0.0
Installation of MySQL database 5.6.25
Company Name
US Jade Corp
Project Name
Oracle Application – EBS 12.1.1 Upgrade
Role
Sr. Consultant
Duration
(04/2010) – (10/2010 )
Environment
Oracle Applications 12.0.4/12.1.1, Oracle Database 11g (11.2.0.1), Oracle SOA 11g, Demantra, Red Hat Linux 4.5, Putty.
Jade Global is a premier Advisory, Integration, Testing, Cloud & Consulting Services, Business Solutions and IT Outsourcing Company that services clients across multiple technology platforms. Jade’s global team of experts successfully deliver business and technology solutions across diverse industries to drive customers' long term growth and success.
Contribution
Installation of Oracle Fusion Middleware Components. (SOA techstack, WebLogic)
Upgraded the Oracle Application R12.0.4 to R12.1.1.
Installation and integration of Demantra 7.3 with Oracle Applications 12.1.1.
Integration of SSO with E-Business Suite R12.
Interaction with users, developers to assist them in troubleshooting their problems related to Oracle Databases.
Designed backup & recovery strategies for all Oracle instances.
SQL Tuning of databases and experimenting with parameters on test systems, to ascertain the performance change in the Application with full load.
Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
Maintaining archive data on appropriate storage devices.
Analyzing and validating database objects.
Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
Involved in creating user manual document
Company Name
RCM Technologies
Client
Multiple clients
Role & Team Size
Lead Oracle Applications DBA / 8
Duration
(10/2008) – (04/2010 )
Environment
Oracle Applications 11i (11.5.9, 11.5.10.2), R12 (12.0.4, 12.1.1), Oracle Database 9i/10g/11g, Oracle SOA 10g, Oracle Discoverer 10g, HP-UX B.11.00U, Solaris, AIX 5.3, Red Hat Linux 4.5, Putty.
RCM Technologies was a premier single-source provider of business and technology solutions with a strong vertical focus offering an integrated suite of services through a global delivery platform. Long recognized as a leading technology innovator–Oracle provides an integrated suite of applications that can provide companies with immediate access to complete, high quality business information.
Contribution
Managed team onsite and offshore Oracle APPS DBAs and implemented new process as and when required.
Worked with multiple clients simultaneously.
Capacity planning and H/W architecture.
Installation of Oracle Application R12.0.4/12.1.1 with Database Release 10.2.0.4/11.1.0.7 on single node and multi-node
Upgraded the Oracle Application R12.0.4 to R12.0.6 and database from 9i to 10g and 11g.
Configured DMZ external server for iStore implementation
Installed and Configured Oracle Discoverer 10g for developing reports as per business requirements
Installed and Configured VeriSign software for iPayment implementation.
Configured and implemented the setup of Oracle Enterprise Manager (OEM) to monitor both Oracle Application 11i and R12 and Database.
Configured Mobile Application Server in Oracle Application Release 12 to use RF gun device
Performance tuning on Application and Database level.
Cloned other Instances (Test and Dev) for various iterations before moving the code migration to Production Instance
Applying the patches and troubleshooting based on the functional requirements
RMAN setup and monitoring through shell scripting
Writing UNIX shell scripts like start-up / shutdown, tablespace check etc. and setting up the cron jobs.
Installation of Oracle Fusion Middleware Components. (SOA techstack, WebLogic, Identity Management, Portal, Discoverer)
Worked with functional team on HR/Payroll implementation project.
Company Name
KGF Associates Inc
Client
Multiple clients
Role & Team Size
Sr. Consultant
Duration
(09/2006) – (10/2008 )
Environment
Oracle Applications 11i (11.5.9, 11.5.10.2), R12 (12.0.4, 12.1.1), Oracle Database 9i/10g/11g, HP-UX B.11.00U, Solaris, AIX 5.3, Red Hat Linux 4.5, Putty.
KGF Associates has been recognized as the leading IT Services firm focusing on Oracle applied technology solutions for mid-market companies. Long recognized as a leading technology innovator–Oracle provides an integrated suite of applications that can provide companies with immediate access to complete, high quality business information.
Contribution
Installation of Oracle Application 11.5.9, 11.5.10.2 with Database Release 9.2.0.8/10.2.0.4 on single node and multi-node
Upgraded the Oracle Application from 11.5.10.2 to R12.1.1 and from R12.0.4 to R12.0.6 with database from 9i to 10g and 11g.
Configured DMZ external server for iSupply implementation
Installed and Configured VeriSign software for iPayment implementation.
Configured and implemented the setup of Oracle Enterprise Manager (OEM) to monitor both Oracle Application 11i and R12 and Database.
Performance tuning on Application and Database level.
Cloned other Instances (Test and Dev) for various iterations before moving the code migration to Production Instance
Applying the patches and troubleshooting based on the functional requirements
RMAN setup and monitoring through shell scripting
Writing UNIX shell scripts like start-up / shutdown, tablespace check etc. and setting up the cron jobs.
Support the development team as well as 24x7 support to the production database in shifts for multiple clients.
Company Name
L&T Infotech, India
Client
Multiple clients
Role & Team Size
Sr. Software Engineer
Duration
(04/2004) – (07/2006 )
Environment
Oracle Applications 11i (11.5.9, 11.5.10.2), Oracle Database 9i/10g, Solaris, Red Hat Linux 4.5, Putty.
L&T Infotech is a global IT services and solutions provider. They provide the winning edge to the clients by leveraging our Business-to-IT Connect and Deeply Committed People. Parent company is Larsen & Toubro Ltd. (L&T), a technology, engineering, manufacturing and construction conglomerate, with global operations.
Contribution
Installation of Oracle Application 11.5.9, 11.5.10.2 with Database Release 9.2.0.8/10.2.0.4 on single node and multi-node
Upgraded the Oracle Application from 11.5.10.2 to R12.1.1 and from R12.0.4 to R12.0.6 with database from 9i to 10g and 11g.
Configured DMZ external server for iSupply implementation
Installed and Configured VeriSign software for iPayment implementation.
Configured and implemented the setup of Oracle Enterprise Manager (OEM) to monitor both Oracle Application 11i and R12 and Database.
Performance tuning on Application and Database level.
Cloned other Instances (Test and Dev) for various iterations before moving the code migration to Production Instance
Applying the patches and troubleshooting based on the functional requirements
RMAN setup and monitoring through shell scripting
Writing UNIX shell scripts like start-up / shutdown, tablespace check etc. and setting up the cron jobs.
Support the development team as well as 24x7 support to the production database in shifts for multiple clients.
Company Name
Trisha Software, India
Client
Multiple clients
Role & Team Size
Software Engineer
Duration
(08/2001) – (03/2004 )
Environment
Oracle Database 8i/9i, Windows Server, Red Hat Linux 4.5, Putty.
Project - Upgrade JDE oneworld to JDE XE and oracle 8i to oracle 9i – Client Lafarge Plasterboard, Bristol, UK
To facilitate the business Lafarge has implemented the enterprise solution provided by JDE Oneworld. The modules implemented are financials, sales & distribution and manufacturing. JDE was using Oracle 8i as a database.
The project was to upgrade JDE oneworld to JDE XE and oracle 8i to oracle 9i; it was decided to do the upgrade in phases, in first phase Oracle upgrade and in the second phase JDE.
Project – Installation of Oracle database and forms for payroll system - client Bajaj Plastics Limited, India
The project involves maintaining the monthly payroll of employees of a company functions. Maintaining the employee attendance, recording daily working hours, Calculation for standard deduction & net salary.
Contact this candidate