Oracle Support

Meenakshi Aggarwal

**** ******** *****, ********, ** 15057

(C) 412-***-****

*********@*****.***

OBJECTIVE Seeking an opportunity as Oracle DBA.

SUMMARY Oracle Certified DBA with an extensive experience in Oracle Database Designing, managing and administering multiple databases on Unix & Windows platforms. I have extremely good skills in requirements gathering, analysis, data modeling, design and development of commercial systems under RDBMS environment and Client Server Architecture. My expertise involves in installing, administrating, configuring, maintaining, tuning, upgrade and support of e-Business Suite 11i and R12 databases. I also have experience in leading, mentoring and supporting developers and database administrators.

EDUCATION MS (Information Systems), VCU, Richmond, VA GPA 3.8 2001- 2003

CERTIFICATION Oracle Certified Professional (OCP in DBA)

TECHNICAL SKILLS

Hardware Platforms: HP-9000 series, Linux, Sun Sparc Station, Gateway ALRs

Operating Systems: HP-UX 11 & 10.20, Solaris 2.5, AIX, Windows 2003/2K/2008/2012

Languages: SQL, PL/SQL, Unix Shell scripting

Software & Utilities: 12c, 11g Grid, RMAN, 13c/12c OEM, SQL*Forms rel 4.5, Pro*C, SQL*Loader, Qwest Tools - I/Watch, SQL*LAB, Instance Monitor, Space Manager, Precise tools, Q-Diagnostics, Toad, Oracle Discoverer, Warehouse Builder, OLAP, Perl, SQL*Loader, TKPROF, Export/Import, Utlbstat & Utlestat, Statspack, AWR, Erwin

Networking: TCP/IP, SQL*Net

RDBMS: Oracle 12c, 11g, 10g, 9i, 8.x and 7.3, SQL Server 2000, Data Warehousing, PostGresSQL, ETL

Oracle Applications R12, 11.x and 11.0.3

SPONSORSHIP US Citizen

EXPERIENCE

Sr. Oracle DBA, ArcelorMittal, WV Feb. – Jun. 2017

I am working as a senior Oracle DBA consultant on part-time basis supporting various Oracle databases.

Responsibilities:

Supporting Oracle instances including – Production and testing.

Designed and supported custom built based applications following SDLC model.

Developed scripts to automate the cloning process.

Configured Hot and Cold backups for production instances

Upgraded 8/9i to 10g/11g/12c.

Install and configured 12c Oracle Fusion Middleware for custom application.

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

Configured and Managed Control M tool.

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

Participated in disaster recovery testing.

Scheduling/monitoring daily, weekly events/reports

Installed and configured 12c, 11g, 10g Grid control.

Lead Oracle DBA, Kollmorgen Oct. 2014 – Feb. 2017

I had worked and managed with off-shore team providing Production Oracle Applications support.

Responsibilities:

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

Implement RMAN and automate clone process.

Involved in customer integration.

Daily DBA duties

On-call support

Space and Storage Management

Support Development team

Code Migration

Cloning, patching & troubleshooting.

Scheduling/monitoring daily, weekly events/reports

Configuring Workflow, Printers and resolving issues.

Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier) (at DB/OS level optimization)

Monitor proactively to avoid potential issues

Supported DMZ architecture for i-modules – iSupplier, iSupport, including customization.

Support modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.

Sr. Oracle Apps DBA, Remote DBA Experts (RDBA), PA Oct. 2009 – Feb. 2014

I supported multiple projects on different platform having Production Oracle Applications. I managed new implementations and upgrades.

Responsibilities:

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

Cross-platform upgrade of 11.5.8 on 9i on Solaris to 11.5.10.2, 11gR2 on Linux.

Support R12 production instance.

Upgraded 12.1.1 to 12.1.3.

Installed, configured and supported R12 ASCP instances

Involved in customer integration.

Cloning, patching & troubleshooting.

Space and Storage Management

Configuring Workflow, Printers and resolving issues.

Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier)

Supported DMZ architecture for i-modules – iSupplier, iSupport

Support modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.

Support ADI, Discoverer.

Upgraded Discoverer from 4i to 11.1

Installed OBIEE. Support data warehouse, GRCM.

RMAN setup and support.

Support RAC instances.

Monitor proactively to avoid potential issues.

Standby database support using data guard.

Sr. Oracle Apps DBA, MittalSteel, Weirton, WV July 2006 – Oct. 2009

I worked as a senior Oracle APPS DBA consultant for MittalSteel USA. I am 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.

Supported ADI, Workflow configuration and administration, applying patches using adpatch.

Supported AR, AP, GL, OTL, OE, HR modules.

Supported custom built based applications.

Developed scripts to automate the cloning process.

Configured Hot and Cold backups for production instances

Upgraded 9i to 10g

Migration of 8.1.7.4 Database from US7ASCII to UTF.

Wrote script for automation of cloning processes from prod to non-prod.

Applied patches on apps and DB level

Monitor proactively to avoid potential issues

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

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

Installed and configured 10g Grid control & 10gAS.

Oracle Apps DBA, Fisher Scientific, Pittsburgh, PA Aug. 2003 – July 2006

Worked as Sr. Oracle Apps DBA with a global Bio-Medical organization, in Pittsburgh. I was responsible for supporting multiple 11i, 10g, 9i and SQL Server databases. My main responsibilities involved supporting & upgrading 11.0.3 to 11.5.10 on Sun Solaris. I also supported Data Warehousing related projects.

a) Oracle Apps DBA responsibilities

Support e-Business suite 11.5.10 (Financial and HR modules) on Sun Solaris Platform.

Installation, Cloning (Rapidclone), Patching of Oracle apps instances utilizing adpatch, autoconfig, admin etc.

Configured multi-tier architecture using load balancing.

Assist in the logical and physical designing of databases.

Participating in 24x7 On-call production support.

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

Configure ADI, apply Vertex patches, tuning Apache server, monitor concurrent managers

Performance tuning of Batch jobs and SQL queries, using Statspack, Explain plan, bstat/estat

Planning Backup and Disaster recovery strategies.

Maintenance and configuration of Oracle 11.5.10, Oracle 9i/8i, iAS, Forms server, Report server and Apache server.

Tar Management and On-call support for 24x7 environments.

b) SQL Server 2000 database responsibilities

Installation SQL server, creating database, administrating security aspects, Creating and scheduling DTS packages, schedule backups and restore databases to Pittsburgh data center.

Configured replication and scheduled replication jobs

Monitored scheduled jobs and provided troubleshooting efforts to fix broken jobs.

Installed and configured Analysis services (OLAP)

Refreshed cubes

References: Available on Request

Contact this candidate