*

AJAY JAIN

Skills Highlight:

Applications: Oracle EBS R12.2/R12/R11i (Financials/ Supply Chain/ HRMS/ CRM/ iProc, iExpense etc) RDBMS: Oracle RDBMS 19c,12c, 11g, 10g, 9i, 8i, 8.x, 7.x Tools: OEM, Oracle Tools, Splunk, Jira

O. S.: Linux Red Hat 8 and 7, UNIX (AIX, Solaris, HP), Windows Life Cycle: Requirement Analysis, Gap Analysis, System Testing, User Acceptance & Implementation Other Products: TOAD, SQL Developer, DB Artisan, BMC Patrol, MS Project, Visio, Jira, Languages: SQL, PL/SQL, C, Unix Shell Programming

Documentations: Write Standards, Policies, Procedures and Guide Lines Scripting: Unix/Linux Shell Scripts, PL/SQL procedures for Database and EBS Applications Backup / Recovery: Custom Shell Scripts, RMAN, EMC BCV’s, and Standby Databases Other: Excellent, written, communication skills. High levels of initiative and assertiveness. Effective interpersonal, team building /meetings communication skills. And providing Action Plans and Deliverables. Work with Oracle Support and Vendors to raise and resolve issues Summary:

Over 25 Years of IT, 20+ Years in Oracle EBS Apps, performed over dozens of implementations, which encompasses installing, upgrading, and supporting Oracle EBS software and the associated Oracle Technology stack in a multi-tier environment along with patching, upgrades, including 3rd party applications. Supported large teams of Developers & Business users. Prepared technical documentation for all the tasks, enforced coding standards, SOX compliances, created knowledge base repository, share the knowledge with team. Well versed with Oracle EBS and DB architecture. Able to organize work efficiently and work well under stress, changing priorities, time constraints and multi-tasking. Guide / help DBAs and Developers as needed Education:

M.S. in Mechanical Engineering Wayne State University, Detroit, Michigan Project Experience:

Major Retailer New York

Apr 2019 – Current: Tech Lead, System Architect, Sr. Oracle Apps DBA, EBS Security Manager Supporting Oracle Production env EBS 12.2.5 / 19c Database with DMZ Node running on MS Azure Cloud Servers along with multiple QA /DEV env + DR using Active data guard. Oracle EBS System consists of many inbound and outbound interfaces with Oracle Cloud WMS, Kafka, Fastly etc. Connect to Warehouse RF Gun devices. It is heavily Oracle EBS customized system. Modules in Use: Financials (GL, AP, AR, Cash, FA etc.), Supply Chain /Discrete Mfg. (INV, PO, BOM, OM WIP, WMS, Quality, Shop Floor, MFG Execution etc.), iSuppliers etc.

Performed platform migrations end to end of 4 TB Database from Solaris to Linux, to MS Azure Cloud Source System = Solaris EBS R12.2.5 /12c Database Target System=MS Azure Cloud EBS 12.2.5 / 19C Database with latest Patch Sets, JAVA, TLS configurations and performed Performance Tuning after migrations Managed Oracle EBS Server, Database, Applications and Responsibility Security enhancements and enforcements including User level. Stay on top of applying Quarterly Security CPU Patching and relevant upgrades. Oracle EBS WebLogic Server management. Performed setup DR of Oracle EBS with Logical Server Names using Standby database / data guard to quickly restart DR system with minimal effort. Tested failover and switchover of Oracle EBS System. As part of DR Config, daily synch of Oracle EBS between Prod and DR. Wrote Oracle EBS Development Standards for customizations and migrations, followed Sox Compliance Provide support to current and new projects and help to plan and execute in timely manner. Wrote many Unix Shell scripts for various purposes. Automated Start, Stop of the Databases and Oracle EBS Application monitoring using shell scripts Routine Tasks:

• Provide Support to DBA and Development teams and Used Jira for CRs and SRs 2

• Troubleshooting production /development issues and provide causes and solutions

• Quarterly, perform EBS databases storage analysis, capacity planning, apply CPU patches

• Archiving and purging Custom Data, frequent cloning of Lower env using RMAN duplicate

• Setup Workflow OAUTH 2.0 / TLS configuration, management, and troubleshooting

• Apply patches to Apps Tier using ADOP, opatch and bsu utilities

• WebLogic administration, deploy custom Application builds

• Proficient on commonly used AD and FND utilities adconfig, cpadmin, adadmin etc.

• Implemented Java Web Start (JWS) to use 64-bit JRE and use any web browser

• Wrote and implemented Development Standards, Change Control process and Best Business Practices policy and procedures

• Implemented Java Code Signing Cert, Java upgrade, Single common EBS wallet for TLS/SSL

• Use JIRA and other utilities for ticketing and project deployment State Street Bank, New York City

May 2011 – Apr 2019: Sr. Oracle Applications DBA

Production support DBA for Oracle EBS R12 and many other Enterprise Applications Databases running on Oracle 11g/12c. Upgraded Oracle EBS Applications R12.1.3/ Database 11g to R12.2 / 12c. Provided Production and Development support of applications and databases. Performed weekly/on demand Cloning of EBS env using RMAN, hot, cold backups. Regular working schedule includes: System Administration, performance tuning, managing, and maintaining EBS applications using change control process and development team support, troubleshoot and develop Oracle Forms and Reports for Oracle EBS. Patch EBS Applications as needed.

Created many standards: EBS customizations & development, database maintenance and security policies. Provided support for E&Y audit and compliance, scramble sensitive data in non-prod env. Migrated applications/databases to different servers and OS versions.

Broadridge Financial Solutions, New York

Sep 2008 – May 2011: Sr. Oracle Applications DBA

24x7 development and production support, troubleshooting and performance tuning of single global instance load balanced Oracle Applications R12.1/11g database, R11i/10g database Provided 3rd Party Products Support for Markview, Applimation, Vertex, Orgplus, Single Sign on using CA SiteMinder.

Daily operational and support included: Cloning, Patching, Backup and Recovery, Change Control Process, Sysadmin support, Technical Support. Performed Upgrades of Applications R12 from R11i databases: 11g from 10g, Database Reorg Annual Tasks included DR Test, Compliance/ Audit, Capacity/Storage Planning etc. Follow best business practices, performance, tuning of instances. Experience writing SQL and UNIX shells scripts Calyon Investment Bank, New York City

Jul 2006 – Sep 2008: Sr. Oracle Applications DBA

Lead DBA for Oracle EB Applications R11.5.10.2 with Oracle database 9i/10g and Enterprise Reporting Database. Routine tasks included cloning of instances, change management, patching, database backup and recovery using custom scripts, RMAN and EMC BCV/Replication Manager, monitoring, performance tuning, admin utilities, users, and development team support. Responsible for developing, implementing, and overseeing database policies, standards, and procedures to ensure the integrity and availability of databases and their accompanying software. As R11i System administrator, performed all AOL setups and system monitoring. Knowledgeable about underlying Oracle Applications database architecture schemas/products and database objects. In addition to DBA tasks, many other tasks were performed: Performed migration and consolidation of multiple schedulers (ISE, Poly Center, $Universe, Control M Scheduler) complex batch jobs running on multi platforms (Unix/Linux/VMS/Windows). Cendant Inc., NJ

Feb 05 – Jul 06: Sr. Oracle Applications DBA / System Admin Worked on Cendant’s main Oracle EBS database split to newly formed Wyndham Worldwide company. Provided support to large development team for Wyndham customizations. Patched the env as needed including HR. Created a new Production Database on prod server and went live with all customizations. Created Development and naming convention standards and enforced the standards to development team. Created/cloned/refreshed multiple development instances for conversion and UAT testing. Used EMC Time Finder for backup and recovery. Also supported System teams in Datacenter at Phoenix, AZ. 3

Credit Lyonnais Bank, New York City

Dec 2002 – Jan 2005: Sr. Oracle Applications DBA

Performed new implementation of R11.5.7 / Oracle 9i & a separate Enterprise Reporting instance. Converted existing main frame based financial system to Oracle Apps. Wrote custom shell scripts to perform efficient database backups. Patched R11i to latest releases. Automated batch jobs by using “Dollar Universe” scheduler to setup jobs across multi nodes & multi platforms (Unix, NT). Developed Reports using Oracle Reports and Discoverer and customized Oracle Forms. Cloned & refreshed R11i & Reporting instances. After implementation did performance tuning, knowledge transfer. R11i System Administrator, created GL Accounting Security

National Grid, NY

May 1999 – Dec, 2002

Sr. Oracle Applications DBA / System Admin

R11i (11.5.7) /Oracle 9i/ 9iAS Suite, Production (1200 users) & Development Support for multi-instances running on Multi-Tiered Load Balanced servers. Providing support for Financial/ Supply Chain/HRMS/Payroll, iProcurement/ XML Gateway/ e-Business Suite. Lead DBA for upgrade & maintenance. Installed & configured 9iAS (Oracle 8.0.6/Forms Services/Reports Services/Oracle Discoverer 4.1/Server Integration/ Single Sign-On/ Portal 3. /XML/Business Intelligence/Internet File System/Apache 1.3.19/Web Cache/Containers for J2EE). "Load Balanced" Middle Tier (Application Servers running on Sun), HTTP Server & Form Server using CISCO Switch.

Extensively worked with Supply Chain modules such as INV, BOM, MRP, AP, PO, WIP, and CE. Installed, Configured. Applied latest Family Patch sets including Discrete Manufacturing, Procurement, Order Management, Projects & Financials. As R11i DBA, responsible for upgrade of Oracle Applications from 10.7SC to R11i (11.5.6/11.5.7) running on Oracle 9i. As a part of upgrade performed several test iterations prior to Production run. Performed the following tasks as Upgrade Architect / DBA. Performed Recovery of Production Database from Media Failure. McKinsey & Company, New York City

Sept 1998 - May 1999

Sr. Oracle Fin Applications DBA

Performed full implementation of Oracle Financials /HRMS R10.7 as DBA from development to production. Did stress test, tune database & long running reports, optimizing concurrent manager job scheduling, transfer data from legacy to Interface Tables of Oracle modules, supporting large team of functional & developers. Proficient in using applications utilities ADADMIN, ADRELINK, ADAIMGR, ADCTRL, ADPATCH. Created Custom Concurrent Managers, Programs/Executables/Request Groups, Custom Responsibilities/Menus/Data Groups, Custom Tables/Packages/Procedures/Functions, and Custom Printer/Printer Drivers/Printer Styles. Oracle Corporation

Aug 1995 - Sept 1998

Oracle Applications DBA

Worked as Oracle Fin Apps DBA for multiple clients across nation. Tasks included installation, setup, dba implementation support for of Oracle Financials, Supply chain, HRMS Upgraded RDBMS & Applications, Cloned the databases from production to Disaster Recovery, Performed Sys Admin Installed 16.1 client on CITRIX & resolved several Citrix related problems CLIENTs:

GT Interactive Services, New York NY

Chase Manhattan Bank New York, NY

Defense Logistics Agency (DLA) Dept of Defense, Virginia Marsh and McLennan Co. Hoboken, NJ

Visa Status: U. S. Citizen

Contact: ad4nwh@r.postjobfree.com / 516-***-****

Contact this candidate