Oracle Data

AMIT AGGARWAL

*** ***** **, ****** *****, PA ****6

(H) 412-***-****, (C) 412-***-****, **********@*******.***

SUMMARY Sr. Technical Architect/DBA with 23+ years of Global IT experience managing projects, designing architecture, administering databases, analyzing business processes, developing & implementing applications for 24x7 high-availability solutions. Designed & implemented eBusiness Suite architecture for multi node RAC & OBIEE, Fusion, SSO on various Unix and Windows VMware platforms, with in time & budget. Specialize in working with high-paced datacenters environments with onshore/offshore teams. Also participated in SOX audits, change management, process improvement and security management.

EDUCATION MS in Business (Info. Systems), VCU, Richmond, VA, GPA 3.8

Start Date: 08/27/2001 End Date 05/03/2003 Graduation Year 08/20/2005

BS (Computer Science) from MDU, India, June, 1992-96 GPA 3.6

CERTIFICATION Oracle Cloud Infrastructure Foundations 2020 Associate June, 2020

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Certified Professional (OCP DBA) for Oracle 9i/8i/8.0 & 7.3.

TRAININGS Attended Oracle 10g RAC for Administrators R2 from Oracle Univ.

TECHNICAL SKILLS

Operating Systems: Linux, Windows, HP-UX, Solaris 10/11, AIX

RDBMS: Oracle 19c, R12.x, 11gR2,10g, 9i, 8.x and 7.3, Oracle 10gAS, 9i iAS,

Oracle Application Server - Administration,

Weblogic Administration

Oracle Applications R12.2, R12.1.x, 11i, 11.0.3

Employment History

Sr. Application DBA/Architect, Cintra Software Nov’15 – Date

As a Sr DBA Architect, I am responsible for maintaining all Prod and non-Prod systems.

Worked on on-prem to OCI IaaS migration for EBS 12.2.5

Planning architecture for EBS 12.2 new implementation, SOA other 3rd party applications.

Upgrade 12.1.3 to R12.2.9 & database from 19.3 to 19.5 and maintaining current Prod systems.

Converted the database to PDB/CDBs.

Apply RPC, CPU and PSU patches and automating them.

Experience in software and firmware maintenance of both the DB and Storage servers in the Exadata database machine including upgrades and patching.

Managing 2 node RAC on 12c and 3 node Apps with load balance and iSupplier

Performance tuning the jobs and SQL queries.

Provide and implement performance tuning recommendations of all components in Exadata database machine

Implement DR instance with Active Data-Guard

Installation, Support and upgrade to 12.x on 2 node RAC and ASM storage

Worked on SOX Audit issues for clients

Supported 2 node RAC on Exadata DL360 G7 that has 4 x 146GB

Managing EBS R12.2 activities like Patching, Cloning, Replication, System Administration, troubleshooting in High Availability (HA) and Disaster Recovery (DR) environments

Installation and configuration of APEX, Weblogic and FMW, SOA, Oracle Service Bus

Independent Consultant July’14 to Nov 15

Worked on various small contracts supporting EBS clients.

Apps DBA/Architect, RJT Solution Beacon Mar’13 – July’ 14

I was leading the project with below responsibilities:

Coordinate and manage offshore Apps DBA team

Client interfacing role and communication

Involved in pre-sales activities to acquire new clients.

Upgrade 11.5.7, 8.1.7 Database on windows platform to migrate to Linux and upgrade to R12.1.3

Cross platform upgrade on 11i to R12.1.3 for EBS instance with 2 node RAC and ASM

Installation and configuration of Fusion Middleware and SOA Suite

Installed, configured and tuned various SOA Suite Domains and Clusters contains Admin Servers, SOA Servers, BAM Servers

Implemented OEM 12c for a US based airlines

Backup and achieve Oracle Primavera 2012 database

Implemented SSO using OAM, OID 11.1.1.6 and Active directory.

Installed and configured 11gR2 - 2 node RAC with ASM

Lead Architect/Apps DBA, GE Electrical & Lighting Oct’11 – Jan’13

Contract : ITC

As a technical lead, I am responsible for the following:

Implementing EBS 12.1.3, VCP ( 12.1.3.7), OEM 12c, OTM, Demantra, GRC,APCC, DR activities

Implemented iSupplier and iProcurement on DMZ server

Implemented Single sign-on (SSO)

Leading and mentoring the Apps DBA team

Migration of database on Exadata

Implemented DR strategies for the Exadata Database machine

Designing the architecture

Work with Storage, Platform and Functional teams.

Implemented iSupplier in a DMZ environment, Shared APPL_TOP

Tuning Oracle EBS and VCP for peak performance

Sr. Technical Architect, AT&T Jul 2006 – Oct 2011

Responsibilities:

As a technical lead, I am responsible for designing architecture and capacity for high volume transaction instances with multi-node Apps and RAC databases for AT&T datacenters. Work with the team that supports 100+ clients on Oracle Apps ranging from R12 to 11.5.x. I am also involved with mentoring/coordinating with off-shore teams.

Projects Managed:

Designed the architecture, performed installation of Rel 12 on HP-UX Itanium for – TJX companies.

Implemented SSO for VCP, Demantra and OTM supporting 1000+ concurrent users.

Designed & Installed R12.1.3 ERP and ASCP instances on Linux 5 platform.

Managed multiple projects for cross-platform upgrade of 11.x to R12.1.x

Upgraded 11.0.3 to 11.5.10.2 with split configuration

Installed and configured 10gAS on Linux platform

Installed and configured OBIEE 10.1.3.4.1 with Informatica & DAC

Analyze and determine the feasibility of leverage the OEM solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions

Installed and configured GRC ( GRCM & AACG)

Installed & supported AACG and GRCM on 11.5.10 environment.

Installed and configured 10gAS R3 SOA on HP-UX Itanium.

Installed RAC on a cluster using OCFS2 for 10g databases using ASM

Configured various i-modules( iSupplier, iExpense, iStore) for different clients, using Netscaler and Reverse Proxy servers.

Installation, configuration of Vertex in ERP instances. Applied monthly Sales data update from Vertex.

Support 11.5.10.2 and 11.5.x on various flavors of UNIX

Upgrade databases from 8.x to 10.x, Helped developers upgrading applications involving Proc*C, OCI.

Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions

Troubleshooting DBA issues and performance tuning different components of applications including – database, Forms, Apace, JVM etc.

Installation and configuration of Discoverer and SOA suite.

Sr. Apps DBA, Mittal Steel, USA Oct 2005 – Jun 06

I worked as Sr. Oracle Apps DBA consultant thru Hudson Group for Mittal Steel USA (world's largest and most global steel company). As a lead oracle DBA working on multiple projects supporting Oracle Apps and non-apps databases. My main responsibilities include performance tuning databases.

Responsibilities:

Supporting eBusiness instances including - Production, acceptance, test and development.

Installed and configured 11.5.10 with 10g instance, SSO, Sensor Edge server, BPEL server and portal server. Tuning iAS and Forms server

Integrate 11i instance with 10g AS and Portal for SSO

For financial users installed and configured ADI ver 7.2.3, Workflow configuration and administration, applying patches using adpatch.

Installation of Vertex in 11i instances and monthly support by applying monthly tax updates.

Configured Hot and Cold backups for production instances

Involved in Printer setups, monitoring concurrent managers, Apache tuning and configurations.

Extensively used Oracle Application Manager (OAM) for monitoring of 11i processes.

Installed and configured Oracle 9i Lite and configured it with 11.5.10 ( used Sensor based technology for a research project)

Tuning, maintaining 10g, 9i Oracle non-apps databases using statspack and Explain plan.

I also worked as on-demand Performance DBA for NAS (National Steel USA) thru Hudson group to monitor the performance of their production databases on VMS and recommending solutions to their DBA team.

Sr. Apps DBA, Express Financial Services Oct 2004 – Oct 2005

Worked as full time Sr Apps DBA(Team Lead) supporting multi-tier E-Business Suit (11.5.10 & 11.5.9) on Linux platforms. Involved in customized application running on 10g and 9i databases. Modules currently implemented: HR, Payroll, Benefits, AP, AR, GL, OTL, iExpense, FA. Helping the implementation team in Financials and HR modules. Day-to-day responsibilities include:

Install, backup, configure, clone of 11i instances (Autoconfig enabled) on Linux. Applied HR patches.

Involved in upgrade to 11.5.10 and RAC for failover.

24x7 Sysadmin support role in installation, configuration of failover solution - 9i RAC, data guard, 9i AS, Workflow, Discoverer 4i, Forms and Reports 6i

Choosing third-party vendors products to meet the Enterprise needs eg Evergreen, Vertex.

Configured Vertex for HR and Payroll modules. Applied monthly tax updates from Vertex.

Discoverer installation, administration and managing security, developing views and reports

Installation & configuration of ADI, Web ADI, Vertex patches and monthly tax updates.

Tuning SQL batch jobs, concurrent managers, and Apache servers.

Supporting/troubleshooting implementation team with Forms and Reports 6i

Implementation of Check printing software Evergreen.

Autoconfig enabled the instances for cloning. Configuration of ADI and Request center.

Tools used on a day-to-day basis are adadmin, adpatch

Project Leader, Dicks Sporting Goods Oct 2004 – Oct 2005

I worked as Project leader for developing Warehouse management system software for the distribution center with 3 people team. I got involved in the complete life cycle of the project. Started with project planning, analysis, design of STAR schema, establishing entity relationships between tables. Then we developed the ETL logic using stored procedures and triggers for capturing OLTP transactions and loading into data warehouse thru a staging area. Data was massaged and analysis was done to store into final data mart for Micro strategy reports. Extensive use of materialized views to refresh OLTP data to datawarehouse. The database size of OLTP was about 200 GB and Data-warehouse was about 500 GB. Developed procedures to provide nightly feeds to the data warehouse. Materialized views were used to snapshot the data between systems. There were a total of about 100 reports for the distribution center which helped in Inventory management for the goods.

Technologies used: Oracle 10g, ETL tools and scripts, Erwin, Toad, Micro strategy, PL/SQL and SQL. I was also involved in fine tuning SQL queries and load jobs to achieve peak performance.

ALCOA, Pittsburgh, PA July 2002 – Oct 2004

Contract : CEI

Worked as a Senior Oracle DBA providing technical support for financial & manufacturing databases (APS, AR, AP). This includes supporting 11i eBusiness suite, Vantive CRM, Maximo and other in-house developed applications using Oracle 9i and 8i databases including 9i RAC. The databases are on HP-UX 11i & Windows 2000 platform. Also worked on a Datawarehouse project using ETL to transfer data from OLTP to Data Mart. Worked extensively on Unix shell scripts and SQL & PL/SQL scripts for Extraction, transformation and Loading process.

Responsibilities:

Installation and configuration of Oracle 11.5.8, 11.0, Oracle 9i/8i, iAS, Forms server, Report server and Apache server. Supporting VLDB upto 1 TB in size, team size of 40 DBAs

Installation and configuration of Windows 2000 servers and installing production databases on Win 2000.

Administrating Windows and Unix based databases for peak performance. Monitor health check reports.

Extensive worked on tuning SQL queries and database parameters using Statspack.

Cloned databases and Oracle Applications environments as needed

Upgraded ERP database from 7.3.4 on HP-UX 10.20 to 8.1.5 on HP-UX 11.0 in the server partitioned mode, then to 8.1.7.2, 8.1.7.4, 9.2.0.4

Developed Procedures, Packages, Functions, triggers and Materialized views using new functionality of 9i.

Provided 24x7 On-call DBA support.

Created hot / cold backup scripts for multiple production, patch, test, dev databases

Configuring RMAN for Database Backups

Involved in patching/cloning 11.5.8 production apps instance to the development box.

Participated in planning and design of data center relocation project by moving some of the high visible, users intensive 24x7 databases to Pittsburgh data center for consolidation.

Troubleshooting collection and planning errors in APS

Application System Administration

Tar Management and support with Oracle Support via Metalink.

Using statspack for Database Performance Tuning

CapitalOne, Richmond, VA Nov. 2000 – June 2002 Contract : Stopka & Associates

Worked as a Sr. Oracle DBA(Team Lead) as a consultant, providing technical leadership in mentoring the team of DBAs and developers, supporting multiple databases upto 500GB that utilizes file systems and raw devices. Production databases are 24x7 run in MTS mode. The databases are Oracle 9i, 8.x (OPS & non-OPS) running in HP-UX 11.0 and Windows NT 4.0 environment. Production database is a two node cluster providing high availability solution using Oracle Parallel Server. Design and develop a process for transferring OLTP data to data-warehouse.

Responsibilities:

Support and maintain 365x 24 x 7 mission critical instances on multiple systems, on Oracle 9i and 8i. Support OLTP, Data-warehouses and Oracle Parallel Server databases ranging from 500GB to 3TB. Install, configure and upgrade Oracle 8.x to 9i in HP-UX environment, supporting more than 2000 concurrent users. Capacity planning of Oracle databases. Create and manage databases achieving optimal performance, planning backup & disaster recovery scenarios, fine tuning of databases and SQL queries. Constant monitoring of health check reports and troubleshoot the production problems, design and develop batch jobs for extraction, transformation and loading (ETL) of data from OLTP to Data Warehouse. Design, develop and implement Data Warehouse for information analysis needs.

State of WI, Madison, WI Dec. 1999 – Nov. 2000

Contract : Transtech Inc.

Worked as a Sr. Oracle DBA consultant, supporting multiple databases (Production, Development and Training). Production databases were Oracle 8.0.6, 24x7 ran in archivelog mode in MTS environment. Successfully upgraded the databases from Oracle 8.0.6 to Oracle 8.1.6.

Responsibilities:

Moved the development databases to the production. Supported production and development environments, designed backup and disaster recovery strategies. Developed E-R Models for relational databases using Erwin. Other responsibilities included identifying bottlenecks in the databases and tuning batch jobs & SQL scripts. Migrated production databases between HP-UX servers using hot backup and transportable tablespaces. Applied patches and upgraded databases to Oracle 8.1.7. Successfully recovered production databases using hot backups. Responsible for leading, mentoring and supporting database administrators.

US CoastGuard, Washington DC Nov. 1998 – Sept. 1999

Contract : Transtech Inc.

As an Oracle DBA, supported multiple Oracle 7.3 databases (Production, Pre-production and Training). Upgraded the databases to Oracle 8.0.4 in NT/Sun environment. The H/W implementation on the production database included ALR machines (6 CPUs) with RAID 5.

Responsibilities:

Monitored the performance of databases using the OEM tools, planned, implemented and documented the backup & disaster recovery strategies. Migrated the databases from Oracle 7.3 to Oracle 8.0. Developed and implemented backup and recovery procedures for the databases. Wrote scripts to automate the process of backing up the databases. Maintained the regular backups (hot and cold backups & logical backups) & troubleshoot the production related issues.

NIIT Ltd. New Delhi, India. Jul. 1996 – Oct. 1998

Responsibilities as Oracle Developer/DBA:

Responsible for managing and administrating Oracle 8.0 & 7.x databases. Developed scripts for database backup and recovery, managed security for the data and users, gathered system requirements. Monitored databases to achieve peak performance. Installed, implemented, tuned and troubleshoot Oracle 7.x & 8.0 databases on Windows NT. Worked as a Subject Matter Expert for the Oracle CBTs (Oracle 8.0 & 7.x). Conducted several in-house training and presentations. Prepared program specifications, developed procedures, functions, packages & triggers.

REFERENCES: Available upon request.

Contact this candidate