Oracle Dba Disaster Recovery
Resume:
Meenakshi Aggarwal
Oracle Certified Professional – OCP
AWS Certified Cloud Practitioner 2022 - Udemy
SUMMARY
Results-driven Oracle DBA and E-Business Suite Architect with 23+ years of experience in designing, administering, and optimizing complex Oracle environments across Unix/Linux and Windows platforms. Oracle Certified Professional (OCP) and AWS Certified Cloud Practitioner with extensive experience in both on-premise and cloud infrastructures, including Oracle Cloud and AWS EC2.
Demonstrated success in leading cross-functional DBA teams (onshore/offshore), delivering scalable and secure database solutions for mission-critical enterprise applications. Adept in installation, configuration, upgrades, patching, backup & recovery, performance tuning, and security hardening of Oracle EBS (11i, R12.x), 12c/19c enterprise databases, and OEM 13c.
Proficient in implementing high availability and disaster recovery strategies using Oracle RAC, ASM, Data Guard (physical/logical standby), and ACFS for rapid cloning and storage efficiency. Expert in performance tuning using AWR, ADDM, and OEM Cloud Control, with scripting skills in PL/SQL, Shell, and Perl for automation and database health monitoring.
Strong communicator with experience collaborating with developers, architects, and business stakeholders to align IT strategy with organizational goals.
EDUCATION
MS (Information Systems), VCU, Richmond, VA 2001- 2003
PROFESSIONAL SKILLS
Managed a team supporting the project from onshore and offshore.
A deep working understanding of the Oracle E-Business Suite and it’s underlying technology stack, as well as that of related Oracle components (Portal, Single Sign-on, Fusion Middleware, OBIEE etc.)
Excellent planning, organization, and personal time management skills
Scripting skills with shell, perl, PL/SQL or other Linux/Windows based utilities for automation.
Excellent communication, presentation, organizational, and planning skills
Lead to a solid solution that fits the requirements of the customer, based on knowledge, skills and experience
Multi-Year Experience as Application Architect / software developer in addition to skills as Infrastructure Architect
Interact at all levels of clients' organizations. Strong verbal, written, and interpersonal communication skills
Strong communicator, capable of working effectively with technical staff, users, and management
WORK EXPERIENCE
Lead EBS Oracle DBA, Nautical Bowls Pittsburgh Sept 2024 – Present
I manage and support the IT department for installation, configuration, upgrade and performance along
with supporting day-to-day operation.
Set up the servers to support Oracle databases, Supporting Oracle R12.2 instances on AWS.
Clone EBS instance to dev/test environments and Sandbox.
Manage policies and standards.
Participate in SDLC supporting applications system development life cycle.
Tools & Features and OS used: Unix, Windows, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Senior Oracle DBA Consultant - Curtiss Wright July 2024 – Sept 2024
Evaluate Enterprise Command Center (ECC) and Orbit Analytics
Install and setup ECC on R12.2 ERP environment.
Configure Orbit Analytics for reporting to replace discoverer tool.
Upgrade 11.5.10 ERP/EBS to R12.2
Upgrade 11g Oracle database to 19C
Installed, configured and setup Oracle databases on AWS cloud.
Migrated on-premise Oracle databases to AWS cloud-based Oracle databases.
• Migrate databases and ERP application to new Linux servers.
• Supervised the application management and application development systems for production support and system
upgrades.
• Managed user permissions security in the database environment.
Tools & Features and OS used: Unix, AIX, Windows, AWS, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Project Delivery Senior Consultant - Strategy and Analytics, Deloitte Corporation May 2021 – July 2024
Supported Verizon, Transamerica, Spirit Aero-Orbit on supporting and Migrating on-premise Oracle databases to AWS EC2 cloud
Managed onshore/offshore DBA team with respect to planning, coordinating, and implementing the execution of system management and its deliveries.
Participated in key decision making with higher leadership.
Acquired and built the team of DBAs for a new implantation for a global client.
Supervised the application management and application development systems for production support and system upgrades.
Managed user permissions security in the database environment.
Managed database objects, including Service Accounts, Schemas, tables, indexes, views, synonyms, sequences, packages, procedures, functions, and triggers, to ensure they are valid and organized in a fashion that will deliver adequate performance and have adequate space on 19c/12c instances.
Plan, install and co-ordinate architect for Production on-cloud migration.
Set up Data Guard for failover.
Performance monitoring and troubleshooting supporting various large databases using 13c OEM tool
Observe AWR, Statspack, ADDH and various other parameters to proactively maintain database’s performance.
Upgrade databases on Amazon Aegon AWS platform
Script various database health monitoring and automating the cloning using PL/SQL, Perl and K-shell.
Data restore and recovery on AWS
Troubleshoot to maintain the Oracle functionality during upgrades.
Troubleshoot and Performance management via AWR/OEM.
Plan and execute data purge periodically using external tables.
Provide recommendations and strategies to application owners to improve performance and scalability of database components. This includes upgrades and performance improvement.
Design a disaster recovery strategy for the Oracle architecture
Performance tuned custom application code, using latest features of extended stats.
Mentor the team and knowledge share.
Supported TransAmerica as contractor of Symphony Consulting, WI for a year that later continued as FTE on Deloitte Corp.
Managed user permissions security in the database environment.
Manage database objects, including Service Accounts, Schemas, tables, indexes, views, synonyms, sequences, packages, procedures, functions, and triggers, to ensure they are valid and organized in a fashion that will deliver adequate performance and have adequate space on 19c/12c instances.
Change control procedures to maintain the SDLC.
Performance monitoring and troubleshooting supporting various large databases using 13c OEM tool
Observe AWR, Statspack, ADDH and various other parameters to proactively maintain database’s performance.
Upgrade databases on Amazon Aegon AWS platform
Data restore and recovery on AWS
Participate in Emergency changes implementation for Business integrity.
Troubleshoot to maintain the Oracle functionality during upgrades.
Troubleshoot and Performance management via AWR/OEM.
Plan and execute data purge periodically using external tables.
Assisted Oracle Sysdba GTS team and application team to resolve the application errors as a result of upgrade to 19C from 12C.
Provide recommendations and strategies to application owners to improve performance and scalability of database components. This includes upgrades and performance improvement.
Design a disaster recovery strategy for the Oracle architecture
Performance tuned custom application code, using latest features of extended stats.
Set up Vertex and wallet for data lake.
Tools & Features and OS used: Unix, AIX, Windows, AWS, Jira, Version Control, Control M, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Sr. EBS Oracle DBA/Architect, Dobler Consulting, FL Nov. 2020 – April 2021
Provide recommendations and strategies to application owners to improve performance and scalability of database components. This includes upgrades and performance improvement.
Design a disaster recovery strategy for the Oracle architecture
Supported EBS 12.2.3, 12.1.3 on HP Itanium, AIX, Linux servers including ACFS file system.
Performance tuned custom application code, using latest features of extended stats.
Install, configured OEM 13c.
Set up Vertex and wallet.
Upgrade from 12.1.3 to 12.2.4.
Implemented and integrated of Oracle Configurator (CZ Schema).
Upgrade database 12c to 19c.
Support Multi-tenant databases.
Analyze strategic objectives, current application development roadmap and provide expert technical leadership to optimize and align IT enhancement initiatives with organization’s overall strategy
Managed offshore team of five DBAs.
Clone EBS Prod instance to dev/test environments.
Communicate and coordinate with business team and offshore DBAs for effective SLA deliveries.
Database performance tuning, database monitoring, and database backup & recovery
Gathers information about the organization’s work processes and information flows
Working Knowledge of configuring Data Guard Physical Standby Database / Logical Standby database, using offline backup, RMAN, Active database
Apply Critical patches using adop, opatch utilities.
Installation, testing, implementation and patching EBS instances.
Tools & Features and OS used: Unix, Windows, AWS, Version Control, CAB, Jira, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Lead EBS Oracle DBA, Mathsmart, Pittsburgh Aug. 2017 – Nov. 2020
I manage and support the IT department for installation, configuration, upgrade and performance along
with supporting day-to-day operation.
Supporting Oracle R12.2 instances including – Production and testing.
Set up the servers to support Oracle databases.
Manage policies and standards.
Configure backup and restore.
Install, upgrade and apply critical patches on server and databases.
Upgraded 12.1.0.2 to 12.2.0.1
ETL, data-warehousing and reporting
Batch loading nightly jobs
Setup Disaster recovery and document
Experience with OEM Cloud control 13c.
Extensive experience maintaining database performance and tuning for improved system health.
Tools & Features and OS used: Unix, Windows, Sql Plus editor, Jira, ServiceNow, Control M, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Lead EBS Oracle DBA/Architect, ArcelorMittal, WV Feb. 2017 – Aug. 2017
Supporting Oracle instances including – Production and testing.
Supported and maintained Oracle Applications E-Business Suite 11.5.10,11.5.10.2 and R12:12.0.4,12.1.3,12.2.0,12.2.2,12.2.3 and Oracle Databases 9i,10g 11gR1/R2,12C.
Proactive monitoring for performance and database management maintenance.
Setup DMZ on r12, 11i configured on AIX, Linux, Solaris servers with ACFS file system.
Apply Critical patches using adop, opatch utilities.
Tuning, maintaining 12c, 11g, 10g, 9i Oracle non-apps databases using OEM, statspack and Explain plan.
Good hands-on experience in executing Patching, Refreshes Upgrades.
Expertise in Oracle E-Business Suite, Administering Shared APPL TOP Parallel Concurrent Processing.
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
Upgrade, 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.
Standby database support using data guard. Participated in disaster recovery testing.
Scheduling/monitoring daily, weekly events/reports
Independently installed and configured 12c, 11g, 10g Grid control.
Tools & Features and OS used: Unix, Windows, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Lead EBS Oracle DBA, Kollmorgen, VA Feb. 2012 – Feb. 2017
Supporting eBusiness instances including - Production, acceptance, test and development.
Migrated Databases and servers in-house using AWS to support backup and restore of large databases.
Apply quarterly Oracle critical patches.
Managed Off-shore team
Implement RMAN and automate clone process.
Architect Oracle environments, and Data Guard technologies for site critical databases, including configuration, failover testing, tuning, monitoring, and creating standards & documentation.
Involved in customer integration.
Daily DBA duties
On-call support
Space and Storage Management on Solaris and Linux servers with ACFS file system.
Support Development team
Code Migration
Improve and automate the existing processes.
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.
Tools & Features and OS used: Unix, Windows, Jira, ServiceNow, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Sr. Oracle Apps DBA, Remote DBA Experts (RDBA), PA Oct. 2009 – Feb. 2012
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, AIX, Solaris servers including ACFS file system.
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.
Migrated database heterogenous servers.
RMAN setup and support.
Support RAC instances.
Clustered Oracle Database for high availability and disaster management.
Monitor proactively to avoid potential issues.
Standby database support using data guard.
I supported multiple projects on different platform having Production Oracle Applications. I managed new implementations and upgrades. I served many clients including Salesforce, RMU, Wesco, etc.
Tools & Features and OS used: Unix, Windows, Control M, Version Control, Saleforce, Jira, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Sr. Oracle Apps DBA, MittalSteel, Weirton, WV July 2006 – Oct. 2009
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.
Tools & Features and OS used: Unix, Windows, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, ACFS file system, RAC setup, Disaster recovery, Standby database (Physical & Logical setup), data guard, Shell and Batch scripting.
Oracle Apps DBA, Fisher Scientific, Pittsburgh, PA Aug. 2003 – July 2006
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.
Tools & Features and OS used: Unix, Windows, Control M, Sql Plus editor, Sql Navigator, Sql Developer, Toad, OEM Grid, RMAN, Disaster recovery, Standby database (Physical & Logical setup), Shell and Batch scripting.
Contact this candidate