We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume

Columbia, MD

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.

Hire Now