PROFESSIONAL SUMMARY:

• I am a results - oriented IT professional with a career focus in database administration with extensive experience on various relation database management systems takes leadership role in planning, installing and implementing innovative business process and system solutions using state-of-the-art approaches, technology and s from Confidential .
• Possess strong analytical, collaboration, communication, decision-making and organization skills.
• 14 years of experience as DBA supporting various databases including Oracle APPS (R12/11i), Oracle (10g/11g/12c/18c RAC), PostgreSQL (8.x to 9.5.x) & MongoDB.
• Expertise in Installation, Upgrade & Performance tuning of Oracle Applications 11i/R12 and Fusion Middleware 12c/11g.
• Expertise in Installation, Upgrade & Performance tuning of PostgreSQL databases on-premise and AWS EC2 Instances.
• Experience with cloud-based environments/databases (AWS & Oracle).
• Experience in full lifecycle implementations of client/server, Database application project analysis, business analysis, development as well as traditional software development methodologies.
• Expertise in applying Maintenance packs, Cumulative updates, Interoperability patches & Family packs using adpatch/adop.
• As an Oracle DBA (18c/12c/11g/10g) expertise in Installation, Performance tuning, Backup and Recovery, RDBMS Patching, Auditing & Security, 9i/10g AS configuration, Database Upgrades & migrations.
• Integrated Oracle E-Business Suite Release 12 with Oracle Access Manager 11g Release 2 & OID using Oracle E-Business Suite Access Gate.
• Expertise in Oracle EBS System Administration to manage concurrent managers, application user setup, defining responsibilities, value sets, registering forms & reports, custom application registration & printer setup.
• Proactive monitoring and performance tuning of production databases using Oracle Enterprise Manager (OEM) and scripts.
• Setting up Standby Database/Data Guard to protect against failures.
• Design and implementation of Backup & Recovery using RMAN and scripts.
• Expertise in performance tuning of large databases and SQL/PLSQL programs.
• Good knowledge on Oracle Manufacturing (INV, PO, OM, BOM ), Oracle Financials (AP, AR, GL, FA) & Oracle HRMS.
• Hands on experience in situations where on-call 24 x 7 support for mission critical databases and Production support required.

TECHNICAL EXPERIENCE:

Operating System: HP-UX, Linux, AIX5L, Sun Solaris & Windows2000/NT

Databases: ORACLE 10g/11g/12c/18c, Exadata 12c, EDB PostgreSQL, Real Application Clusters (RAC 11g/12c/18c), Aurora Postgres, Amazon Redshift, MongoDB, SQL Server 2000/2005

Applications: Oracle E-Business Suite R12/11i, Fusion Middleware 12c/11g, IAM, OBIEE, OAM, OID, SSO, WebLogic, Oracle Workflow, Demantra, Manufacturing (INV, PO, OM, BOM ), Oracle Projects & Oracle HRMS

Tools: SQL PLUS, SQL*Loader, Export & Import utility, Data Pump, RMAN, Data Guard 9i/10g,Tkprof, TOAD, Stats pack, AWS SCT/DMS, pgAdmin, Oracle reports, OAM, Kintana, MS Office, XML Publisher, Informatica ETL, Data Guard &OEM

Languages: SQL, PLSQL, Perl &Shell Scripting, C, C++, VB, JAVA, ASP, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Sr. Database Administrator

Responsibilities:

• Design, Install and maintaining multiple production database of versions Oracle11g/12c/18c RAC & PostgreSQL(8.x to 9.5.x) residing on various operating systems.
• Designed, developed and maintained PostgreSQL databases on-premise and EC2 Instances.
• Administration of various databases on cloud-based environments (AWS & Oracle).
• Migration of on-premise Oracle databases to Amazon Aurora using AWS Database Migration Service and AWS Schema Conversion Tool (AWS SCT).
• Installation, configuration, upgrade and maintenance of 11g/12c/18c RAC Non RAC databases.
• Shell scripting and working with Unix administrators for automation using Ansible with python.
• Performance tuning of SQL/PLSQL programs and assisting developers with code migrations.
• Perform routine database tasks without the GUI Interface.
• Developed scripts for database monitoring and tuning procedures.
• Installation and support for SQL Server 2000/2005.
• Applying security patches and cloning/refresh activities.
• Control and monitor disk space allocation for all production and non-production databases.
• Performance tuning of very large databases of size in Tera bytes.
• Creating and maintaining oracle user ids and security roles.
• Assisting application developers with tuning SQL in applications and stored procedures.
• Handling Alliance cases for resolution of client issues within the service-level agreements (SLA's).
• Configuring and maintaining Disaster Recovery (DR) Databases.
• Provided 24 x 7 on call support for Production databases.

Environnent : Oracle Financials Apps R12/11i, Oracle 11g/12c/18c RAC, PostgreSQL (8.x to 9.5.x), Amazon Redshift, Aurora Postgres, Fusion middleware(12c/11g), pgAdmin, IAM/OID, SSO, SQL Server 2000/2005, OBIEE, RMAN, Informatica ETL, SQL/PL SQL, OEM, UNIX(HP-UX, Sun Solaris, IBM AIX 5L)

Confidential, Richmond, VA

Sr. DBA

Responsibilities:

• Implementation and production support for multiple databases of size in Tera bytes.
• Cloning of Oracle Applications 11i/R12 using rapid clone and autoconfig.
• Installation and configuration of oracle financials for new business units.
• Applying security patches and bug fixing of Oracle Applications using adpatch.
• Performance tuning of very large databases of size in Tera bytes.
• System Administration activities like manage concurrent managers, application user setup, defining responsibilities, value sets, registering menus, forms, reports & printer setup etc.
• Configuring and taking backups using RMAN & BCV’s.
• Migration of 9.2.0.8 database and 10g Application server from HP-UX PA-RISC to HP-UX Itanium.
• Capacity planning and monitor disk space allocation for all production and non-production databases
• Assisting application developers with tuning SQL in applications and stored procedures.
• Capacity planning for all our Production EBS & NON EBS instances.
• Performance tuning of SQL/ PL SQL programs. Identifying the issues and guiding development team.
• Handling tickets for resolution of SEV1/SEV2 issues within the service-level agreements (SLA's).
• Provided 24 x 7 on call support for Production databases.

Environment: Oracle Apps 11i(11.5.9,11.5.10.2),R12, SQL Server, Oracle SOA Suite, RMAN, Oracle 9i/10g11gg RAC & Non RAC, OEM, SQL/PLSQL, UNIX & WINDOWS

Sr. DBA

Confidential, Richmond, VA

Responsibilities:

• Installing, configuring and monitoring of multiple instances of versions Oracle financials 11i/R12.
• Cloning of oracle applications 11.5.10.2.
• Patching of Oracle Applications using adpatch for bug fixing.
• Performance tuning of very large databases of size in Tera bytes.
• Applying security patches and closing of Oracle applications 11i/R12 and database versions 9i/10g/11g RAC & Non RAC
• Configuring discoverer 10g with oracle applications and maintaining.
• Assisting application developers with tuning SQL in applications and stored procedures.
• Capacity planning for all our Production EBS & NON EBS instances.
• Performance tuning of SQL/ PL SQL programs. Identifying the issues and guiding development team.
• Configuring and tuning concurrent managers.
• Provided 24 x 7 on call support for Production databases.

Environment : Oracle Apps R12/11i(11.5.10,11.5.10.2),Oracle 8i/9i/10g/11g RAC, SQL Server 2000/2005, RMAN,Discoverer 10g, SQL/PL SQL, OEM, HP-UX, Sun Solaris, AIX & Windows

DBA

Confidential

Responsibilities:

• Installed and maintained oracle applications 11/R12 and databases 9i/10g/11g RAC & Non RAC .
• Cloned Oracle Applications using Rapid Cloning from different environments like Dev, Test, QA and PROD.
• Performance turning of production and non-production databases.
• Applying security patches and closing of Oracle applications 11i/R12 and database versions 9i/10g/11g RAC & Non RAC
• Assisting developers with SQL/PLSQL performance tuning.
• Involved in research and applying maintenance, family patches using shell scripts.
• 24X7 support for databases and production operations teams.

DBA

Confidential

Responsibilities:

• Monitoring of multiple production databases residing on various operating systems.
• Performance tuning of very large databases of size in Tera bytes.
• Applying security patches and bug fixing for Oracle financials application databases.
• Handling Alliance cases for resolution of client issues with in the service-level agreements (SLA's).
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Statspack.
• Developed a tool for daily health check of production databases using shell scripting and HTML.
• Configuring and maintaining Disaster Recovery (DR) Databases.
• Worked on TAR, coordinating with Oracle for SEV 1/2 issues.
• Provided 24 x 7 on call pager support for Production databases.

Environment : Oracle Apps R12/11i,Or acle 9i/10g RAC, SSO, Portal,RMAN,SQL,PLSQL, Unix

Confidential

DBA

Responsibilities:

• Providing production and development support as Oracle database administrator.
• Performing routine databases tasks without using GUI Interface.
• Upgrading oracle databases from 9i to 10g and 11g RAC/Non RAC.
• Control and monitor disk space allocation for multiple databases.
• Assist application developers with tuning SQL in applications and stored procedures.