Candidates About

 

Shivoam Nilkar

Summary:

·         Seasoned Oracle Apps DBA with over 10+ years of experience in designing, implementation, administration, performance tuning, backup/recovery, production support, troubleshooting, testing, installation, cloning, patching, upgrades, multi-node installation/migration, Parallel Concurrent Managers (PCP). Maintenance of Oracle E-Business Suite (11i/R12.1.x/R12.2.x) - Oracle DB (9i/10g/11g/12C) on RHEL, HP-Unix, Sun Solaris, IBM AIX, Oracle Linux and Windows platforms.

·         RAC, Oracle Automatic Storage Management (ASM), Oracle Exadata Machine, Data Guard, Export/Import, Datapump, RMAN, Oracle Enterprise Manager (OEM), STATSPACK, AWR, Explain Plan, TKPROF, UNIX Shell Scripting etc.

·         End-to-End design & implementation of Enterprise Asset Management in Oracle Apps R12.1.3, Set up and managed Very Large Database (VLD) sizes ranging from 2TB to 8TB.

·         Worked for multiple Fortune 500 clients located across geographies like USA, UK, India, South Africa and has directly managed a delivery team of Oracle, Oracle Application DBA’s in onsite-offshore model.

·         Solutions architect, technical architect, infrastructure management & data center setup, capacity planning, designing, purging and archiving solution, database sizing, performance tuning etc.

·         Experienced in Global Delivery, Managed Database Services and Distributed Delivery Model.

·         Good knowledge of Oracle ERP Cloud, Oracle Fusion Middleware and Oracle Enterprise Management Cloud Control 12c as well as Amazon Web Services - EC2/RDS.

 

Technical Skills:

 

EBS/RDBMS:              Oracle Apps R12.1.x/R12.2.x/11i, Oracle DB 12C/11g/10g/9i, WebLogic.

Solutions:                    Oracle Financials (AP/AR/GL/FA), RETAIL, INV, HRMS etc.

Operating System:      Red Hat Linux, Sun Solaris, IBM AIX 5L, Windows etc.

Virtualization:                        VMware, Oracle VM, Cisco VPN, VNC Server etc.

Tools:                          CommVault, NetBackup, Kintana, TOAD, SQL Developer, PuTTY etc.

CM:                             Appworx, Automic, Bugzilla, CA Service Desk, Altiris, DELL Stat.

Other:                                     AD utilities, OAM, OEM, Tomcat, iSmart, UPK, Shell scripting, MS Office.

 

 

Professional Experience:

 

 

Project – TJX, Massachusetts, US.                                                                            09/17 – Till date

Consultant

The TJX Companies, Inc. (NYSE: TJX) is an American multinational off-price department store corporation, headquartered in Framingham, Massachusetts.

 

·         Oracle DB upgrade - Oracle 11g to 12C. Oracle EBS upgrade – Oracle Apps R12.1.3 to R12.2.6.

·         New R12.2 AD utilities – ADOP, ADOPMON, ADOPSCANLOG, ADOPREPORTS etc.

·         Troubleshooting ADOP patching failures, ADOP phase failures etc.

·         EIS Patching. NLS, HR Global & EOY Payroll patching. RAC CPU/PSU rolling upgrade.

·         Sensitive data masking using DBVault – Oracle Wallet functionality.

·         Reviewing new RFPs, listing queries, proposing appropriate solutions.

·         Creating BOM spreadsheet, optimizing output vs costs.

·         Oracle Advanced Security, OID, OAM, PIM, IA etc.

Environment: Oracle Applications R12 (12.2.6) single-node/multi-node, Modules (AP, AR, GL, HRMS), Oracle 12C, DMZ, SOA Suite (Oracle BPEL), RedHat Enterprise Linux 7.

Liquor Control Board of Pennsylvania, Harrisburg, PA.                                             09/16 – 04/17

Consultant

The Pennsylvania Liquor Control Board (PLCB) is an independent government agency that manages the beverage alcohol industry in Pennsylvania. The board comprises of 650+ stores and has implemented Retail 13 (13.2.8).

·         Upgrade of Oracle EBS Suite from R12.1.3 to R12.2.5.

·         Upgrade of Oracle Database from 11g to 12c.

·         Installation of Oracle Enterprise Database Server Version 11g/12c.

·         Creation of Retail Database using Oracle Retail Database Template.

·         Installation of Oracle WebLogic Server (Version 10.3.6)

·         Configuration of Oracle Weblogic Server (i.e. Create managed servers for Oracle RMS, Configure Node Manager)

·         Creation of Weblogic Domain for (Allocations, ReIM, RSL, BI Publisher & RPM)

·         Installation of Oracle ReIM Application (13.2.8).

·         Installation of Oracle Allocations (3.2.8)

·         Installation of Oracle Retail Price Management (RPM)

·         Configuring application based parameters for tuning Oracle Retail product for optimum performance.

·         Code migration from non-production environments to Production environments.

·         Troubleshooting Oracle SIM Application Performance Issues.

·         Applying Oracle SIM Application Patches (SIM Client & SIM Wavelink – handheld devices)

·         Establish Partitions for Oracle Retail Tables (Table size from 60GB to 100GB)

·         Create Users & Tablespaces required for Oracle Retail i.e. (RETEK_DATA & RETEK_INDEX)

·         Install RMS13.2 Base Schema & Upgrade RMS13.2 Base Schema to 13.2.8

·         Installation of Oracle Example CD (This is required for RMS Batches)

·         Installation of Oracle Retail RMS Batches (Base Version 13.2) & Upgrade to RMS Batches (to 13.2.8)

·         Install Oracle Internet Directory & Setup for Oracle Retail SSO.

·         Maintain & Manage OID LDAP (Using ldapadd, ldapsearch, ldapmod, ldapdel) for user management.

·         Using Oracle Performance Tools (Database level I/O Calibration & Oracle Orion Tools for measuring disk I/O).

·         Use of Oracle utility expdp & impdp for loading data from Oracle Retail Version 12 to Oracle Retail Version 13.

·         Manage, Maintain & Administer Database size of (RMS – 2TB, SIM 500GB)

·         Reorganization of table for optimum performance of objects.

·         Gather Schema level stats periodically to manage overall database health.

·         Tuning IBM AIX OS Parameters specific to Oracle10g & 11g DB.

·         Tuning of Oracle Batches (from several hrs to min’s), Custom Code

·         Install and configure Oracle Enterprise Grid/Could Control 12C/13C to monitor multiple databases.

·         Implement and maintain database security (create and maintain users and roles, assign privileges)

·         Perform database tuning (init.ora parameters) and performance monitoring

·         Setup 10046 Events for Performance Issue.

·         Setup and maintain documentation and standards

·         Plan growth and changes (capacity planning)

·         Trouble shooting Issues and provide support to development & functional teams

·         Interface with Oracle Corporation for technical support.

·         Patch Management and Version Control

Environment: Oracle Retail 13 Modules (RMS, ReIM, Allocation, SIM, RIB, ReSA, RPM, RPAS, OBIEE, BPEL & RDW), Oracle Fusion Middleware, Oracle Identity Management, SOA Suite (Oracle BPEL), IBM AIX 6.1 & 7.1, Appworx (8.1), OneAutomic, RedHat Linux 5.3.

 

Project - Northern Power Grid (UK), New Castle/Leeds, UK                                      09/14 – 06/16

Consultant       

NPG runs the electricity distribution network that provides power to customers in the North East, Yorkshire and Northern Lincolnshire - UK.

 

·         Created, modified and managed Technical Architecture docs like TA090, TA110, TA120, TA140 and TA150. Also, deployment docs like MD120, DA090 etc.

·         Implemented Oracle E-Biz R12 with SSO and Oracle Rest Data Services (ORDS).

·         Configured and implemented OBIEE for reporting & analytics and iSmart Geo Mapping tool in integration with Tomcat Apache.

·         Managed and administered Oracle Weblogic instances.

·         Data loading activities of more than 30 million Assets and 300 million Asset Attributes amounting to appox 4.5 TB of data.

·         Implemented change requests (enhancements & defect corrections) and ensured that coding standards are always maintained. This included the development and maintenance of software customizations, user interface, standard/custom reports etc.

·         Oversaw 100% compliance of meeting SLA's and KPI's in accordance with master services.

·         Established work plans and schedules, and then managed the design, development, testing and deployment of application enhancements and software releases.

·         Reduced labor hours by automating monitoring system.

·         Provided QA support to development team with new releases and code changes.

·         Maintained complete documentation of the all code changes as per the needs of the Client.

Environment: Oracle Applications R12 (12.0.6/12.1.3) single-node/multi-node, Modules (eAM, AP, AR), Oracle 10g/11g, ASM, DMZ, SSO, ORDS, Weblogic 11g, Oracle Business Intelligence EE 11g, Glassfish, iSmart, Oracle User Productivity Kit, RedHat Enterprise Linux 5.2, IBM AIX.

 

 

ROLTA India Ltd, Mumbai                                                                                            09/14 – 12/15

Software Project Leader-L3

Projects in parallel with Northern Power Grid through Rolta India

 

·         Production instance upgrade– Oracle DB from 10g to 11g and Apps from R12.0.6 to R12.1.3.

·         Configured external DMZ node using reverse proxy for careers site https://careers.rolta.com

·         DAS configuration with Glassfish clustering.

·         ORDS implementation on Glassfish.

·         Implemented Advance Security Operation Procedures.

·         Sensitive data masking using DBVault – Oracle Wallet functionality.

Environment: Oracle Applications R12 (12.0.6/12.1.3) single-node/multi-node, Modules (AP, AR, GL, HRMS), Oracle 11g, DMZ, Glassfish, RedHat Enterprise Linux 5.6/5.2.

 

 

FirstRand Services, Mumbai/Johannesburg (SA)                                                          04/12 – 08/14

Sr. Oracle Apps DBA

FirstRand Service is a subsidiary of FNB - Listed on the JSE and the Namibian Stock Exchange, FirstRand Limited is one of the largest financial institutions in South Africa, and provides banking, insurance and investment products and services to retail, commercial, corporate and public-sector customers through its portfolio of leading franchises, which include FNB, RMB, WesBank and Ashburton Investments.

 

·         Migrated Oracle DBs to Exadata servers.

·         Production instance upgrade from 10g to 11g and R12.0.6 to R12.1.3

·         Successfully completed 11gR2 Grid Infrastructure - CRS upgrade.

·         Configured OEM Cloud Control 12c for server/database/instance/services monitoring.

·         Created & configured databases on ASM. Created a Database Manually and with DBCA.

·         RMAN full/archive backup/restoration & troubleshooting.

·         Implemented Shared APPL_TOP configuration.

·         Configured Data guard at Remote location.

·         Managed and administered Oracle WebLogic instances.

·         Performed Switch over and Switch back on Oracle Applications 11i and R12.

·         Oracle application cloning (Multi node to Multi node and Multi node to Single node).

·         Database Re-Org and Space Management.

·         Installed and configured OEM/Gird for Oracle 10g/11g/12c support.

·         Applied CPU patches, Database patches and database maintenance activities etc.

·         Troubleshot and monitored working with Metalink etc.

·         Database auditing & tracing for securing the instance.

·         Did trouble shooting and resolved issues related to database, applications, server, network etc.

·         Tuned SGA components, resource intensive query, OS level parameters, web server etc.

·         Worked with the IT team and other stakeholders to plan, prioritize, and execute initiatives within the IT operations portfolio.

·         Used SQL loader utility for loading data through CSV files to Oracle Tables.

·         Provided status reporting of resource and support, project activities; tracking and reporting of defined performance and availability metrics.

·         Identified opportunities for improved process control, implementing best practices and cross-team collaboration.

·         Participating in Client meetings, planning for infrastructure setup which involved geographically dispersed sites across the nation.

·         Installed and configured the Oracle Databases (with high availability) in multiple environments.

·         Maintained knowledge of Oracles current and future products/ solutions offerings for the specialist practice area.

·         Generated the relevant material, e.g. white papers, in order to develop and share knowledge.

·         Conducted performance and HA testing to ensure client SLAs are met.

·         Carried out root cause analysis of Database/SQL performance problems and recommend a solution for Production.

·         Provided on-call support for any urgent performance issues in production environment.

Environment: Oracle Applications R12 (12.0.6/12.1.3) single-node/multi-node, Modules (AP, AR, GL, FA, MWA), Oracle DB 11g, Oracle Exadata, RAC, ASM, OEM, OBIEE 11g, RedHat Enterprise Linux, SUN Solaris, IBM AIX.

 

 

CoreServices (USA), Mumbai                                                                                                     08/10 – 04/12

Sr. Oracle Apps DBA

CoreServices is an Oracle Platinum Partner, provides award-winning Oracle Hosting and Consulting services to its clients worldwide including 3rd party business operation solutions, information systems, Managed and Remote DBA services, Disaster Recovery solutions, Oracle Consulting solutions for new implementations and upgrades, Oracle Business Intelligence solutions, and Cloud Services.

 

Lead DBA for major clients: Arthur J Gallagher, Cal Dive International, Inc., CareOne, Conservation International, DMX Inc., F5 Networks, Intelligrated, NetVersant, Snap-tite Inc., Synventive, Trinity Logistics Corporation, World Finer Foods RMS, Y.M.C.A., YSI Incorporated etc.

 

·         Oracle Apps cross platform migration.

·         Implemented Shared APPL_TOP configuration.

·         Upgraded Oracle DB from Version 8i/9i to 10.2.0.4 & 11.2.0.4.

·         Migrated Oracle DB 32bit to 64bit.

·         Upgraded EBiz Suite from Oracle Apps 11i/R12.0.6 to R12.1.3.

·         Implemented Nagios for automating Server/Database/Network monitoring & alerting.

·         Managed multiple instances of Oracle EBS 11.5.9, Rel12 and RDBMS across varied versions and platforms (9i/10g/11g) on ASM and file system.

·         Managed Database backup & restore for large database on ASM and file system through RMAN and custom script on Veritas NetBackup.

·         Worked with Email Center, Oracle applications server 10g, Oracle Discoverer etc.

·         Configured & Managed Oracle Application Server 10g.

·         Managed and administered Oracle Weblogic instances.

·         Configured & maintained Parallel Concurrent Processing (PCP).

·         Cloned Oracle application (Multi node to Multi node and Multi node to Single node).

·         Applied CPU patches, Database patches and database maintenance activities etc.

·         Applied NLS/language patches in Oracle Apps.

·         Database auditing, Tkprof, AWR, ADDM, ASH reports etc.

·         Troubleshooting of Discoverer issues.

·         Cloned RPA of Database for exact point-in-time recovery & absolutely minimal downtime.

·         Cloned Oracle Apps instances using Rapid clone and manual cloning.

·         Troubleshooting of Workflow related Errors.

·         Managed Production support including monitoring and tuning of Application database performance for mission critical system.

·         Front end development & reporting using Developer 10g, Discoverer, Application Desktop Integrator, Developer V4 etc.

·         Resolved datablock corruption, redo-log corruption, controlfile corruption etc.

·         Disaster recovery and runtime solutions.

·         Database/Apps patching as per the requirement (Project/Version Upgrade/Bug Fix/CPU)

·         Applied Oracle DB/Forms patches using OPATCH utility.

·         Wrote scripts for Automated backups, alerts etc.

·         Performance Tuning of Application & Database.

·         Database auditing & tracing for securing the instance based on client’s requirement.

·         Participated in Team building activities which included training other team members, conducting KT sessions, new product seminar, interviewing new candidates etc.

Environment: Oracle Applications R12 (11i/12.0.6/12.1.3) single-node/multi-node, Modules (AP, AR, GL, FA,MWA, HRMS), Oracle DB (8i/9i/10g/11g), Oracle HRMS, Supply Chain, OBIEE 11g, Hyperion, Discoverer, Nagios, RedHat  Enterprise Linux, SUN Solaris, IBM AIX.

 

 

NDS USA LLC, Mumbai                                                                                             02/10 – 08/10

Oracle Apps DBA       

 

Project - Tempur-Pedic (USA), Mumbai                                                                  

Tempur-Pedic International, Inc. is a manufacturer and distributor of mattresses and pillows made from viscoelastic foam. The company is headquartered on the Coldstream Research Campus in Lexington, Kentucky.

 

·         Installed Oracle Application 11.5.10.2 on Linux Red Hat Enterprise Server 3,4.

·         System Administration Activities.

·         Created Users & Assigned the Responsibilities.

·         Registered Custom Applications& Reports.

·         Audited Tables.

·         Printer configuration at application level.

·         Monitored Concurrent Requests.

·         Backup/Recovery of Applications.

·         Cloned the Application.Application Patching.

·         Performance Tuning of Application & Databases.

·         Installed Oracle 10g on Windows OS.

Environment: Oracle Applications R12 (12.0.6) single-node/multi-node, Modules (AP, AR, GL), Oracle DB (10g/11g), RedHat Enterprise Linux etc.

Clover InfoTech Pvt. Ltd., Mumbai                                                                              12/07 – 02/10

Technical Associate

 

Project: TechProcess Solutions Ltd.   

TechProcess is one of India’s leading payment solutions and services companies. Their payment property www.billjunction.com is India’s first electronic bill presentment and payment (EBPP) service site.

·         Oracle 11i, R12 Apps Installation, applied Patch Sets, System Administration and Cloning of Database and applications.

·         Implemented Shared APPL_TOP in R12.

·         Performed Switch over and Switch back on oracle Applications R12.

·         Installed and created Oracle databases in different platforms like Sun Solaris, Red Hat Linux, Oracle Enterprise Linux, Windows 2000/2003/NT etc.

·         Implemented Auto Config, Rapid clone.

·         Regular Cloning/DB Refresh activities.

·         Backup & Restoration of Oracle Apps environment (Cold Backup, Hot backup, RMAN Backup)

·         Did troubleshooting of Oracle 11i, R12. 

·         Participated in Client meetings.

·         Implemented security measures and prepared documentations.

·         Created Users & Assigned the Responsibilities.

·         Registered Custom Applications& Reports.

·         Co-coordinated with Oracle Corp. in case of any technical issue resolution through SR.

·         Wrote Shell Scripting, Batch Files for automation.

·         Used Flashback, RMAN etc.

·         OS and Database level Security hardening as per requirement.

 

Project: Hathway Cable & Datacomm Ltd.                                                               

Hathway Cable operations straddle across key Indian geographies and offers cable television services across 140 cities and towns and high-speed cable broadband services across 21 cities.

·         Installed Of Oracle Database.

·         Backup/Restore/Recovery of Database, Sizing of Disk Space.

·         Wrote Shell Scripts.

·         Created new Oracle Application environment. Also did the Upgradation  & Cloning.

·         Applied Patches and Maintained Oracle Application.

·         Supported Development/QA Members.