We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

0/5 (Submit Your Rating)

St Louis, MO

SUMMARY

  • Oracle Certified Professional wif over seven years of extensive experience on Oracle 11g/10g/9i Database Administration UNIX (HP - UX, Solaris, Linux, AIX) & WINDOWS Operating systems.
  • Installing/Configuring and Maintaining Oracle Real Applications Cluster (RAC) database on 2 node & 3 node clusters.
  • Extensive experience in Installing/Configuring/Maintaining Oracle Enterprise Manager Grid Control for enterprise monitoring.
  • Experience in Database Migration & Upgradation from 9i/10g to 11g.
  • Experience wif Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard and Oracle Data Pump.
  • Expertise in Data warehousing Concepts & Data Mining which includes extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications dat manage the process of gathering data and delivering it to business users.
  • Expertise in Performance tuning production databases and performing routine DBA functions like space management, extents and invalid objects.
  • Extensive experience on Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g (10.1.0.2)
  • Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
  • Configured physical and logical Standby Database (Data Guard) and tested for business continuity plan and Disaster recovery plan.
  • Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Experience in Online Transaction Processing (OLTP), Online Analytical Processing (OLAP), Decision Support System (DSS) database systems & implementing and managing Very large databases (VLDB).
  • Supporting ETL teams/ Configuration and administration of Informatica ETL
  • Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
  • Experience in generating OracleMaterialized viewsto replicate data and to cache expensive queries in a data warehouse environment.
  • Extensive DBA experience in supporting multiple instances of Oracle database including Development, Reporting, Data Warehousing, User Acceptance Testing & Production.
  • Experience in Cloning/Replicating production database using RMAN & OEM Grid control.
  • Experience in Backup/Restore and Disaster recovery using RMAN & OEM Grid control.
  • Experience in Loading and Unloading of data using utilities like Export, Import, Data Pump Export & Data pump Import.
  • Expertise in enhancing performance, availability and manageability of a wide variety of applications by Partitioning, reducing cost for storage of large amounts of data.
  • Experience wif Oracle Management Agent & Oracle Fail Safe.
  • Expertise in Oracle Maximum Availability Architecture (MAA), in achieving high HA wif low cost and complexity.
  • Experience on Installing/Configuring Oracle Golden Gate.
  • Experience in handling Peoplesoft environment.
  • Extensive noledge in working wif the Tools like OEM, TOAD, ADDM, Export/ Import, Stats pack, SQL * Loader, SQL Analyze, TKPROF, AWR, Explain Plan.
  • Expertise in daily batch & Report monitoring, Space management, Index rebuilds and statistics collection.
  • Expertise in writing backend Procedures, Functions Packages & Triggers using PL/SQL and data modeling.
  • Experience in analyzing database and rebuilding indexes to improve database performance.
  • Created Primary database storage structures (Tablespaces), Primary objects (Tables, Views and Indexes) and created users, roles and profiles.
  • Implemented and monitored daily, weekly and monthly batch jobs in database.
  • Excellent analytical, interpersonal and communication skills wif desire to excel.
  • Fast learner, hardworking wif Systematic thinking ability and solution oriented approach and a versatile team player.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000. VMware.

RDBMS: Oracle 8i/9i/10g&11g, RACSQL Server 2000/2005/2008.

Applications: Oracle Applications 11i and R12.

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, EMC NetWorker, Erwin, Power designer, TOAD, DBArtisan, Oracle SQL Developer, Netezza, Golden Gate, Banner, Forms, Reports,TIVOLI.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL.

Others: Pac2000, VNB, VVM, BMC Patrol, Peregrine

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

  • Responsible for 24X7 production database support and monitoring.
  • Installed/Configured/Patched Oracle 11g RAC (2—4 node) in several UNIX environments across various highly visible and critical financial applications.
  • Installed/Configured ASM instances for various Production Databases.
  • Installed/Configured Oracle 11g Dataguard across various RAC/Standalone Production environments.
  • Installed/Configured/maintained Oracle Golden Gate as per organizational standards
  • Upgraded Databases from 10g to 11g in the AIX and Solaris environments.
  • Migrated/Cloned 10TB Database from Solaris 5.9 to 5.10 using RMAN Duplicate and Oracle Dataguard.
  • Installed/Configured OEM Grid Control to monitor various databases for their growth, tablespace threshold limits and various parameters as part of preventive maintenance activities.
  • Applied various recent DST,CPU/PSU Patches across several RAC/Standalone databases.
  • Extensively used Oracle Datapump (EXPDP/IMPDP) for refreshing Dev/UAT environments wif Production Data.
  • Performed backup and recovery operations wif and wifout RMAN catalogue, including implementing DR for several production databases and creating duplicate databases.
  • Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and OEM GC.
  • Performed capacity planning to deliver a pre-determined optimal/consistent user experience, provided backup strategy for several databases.
  • Installed/Configured TIVOLI (monitoring tool) across several Production environments for efficient Monitoring of the database activities like tablespace thresholds and Database health checks.
  • Supporting teams ETL / Configuration and administration of Informatica ETL.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Performed system testing and integration testing of large Data Warehouse application.
  • Worked wif Transparent Data Encryption (TDE) in Oracle 10g R2 to encrypt sensitive data wifin the data files wifout access from the OS.
  • Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
  • Maintaining schemas and partitioning tables, created and maintained materialized views.
  • Importing data from flat files into database using SQL* loader and External Tables.
  • Planned and supported various outage/maintenance activities as a part of Enterprise Change Management.
  • Mentored/Supported various application teams and Junior members of our DBA team.

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 11.0/10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Golden Gate, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker, Peregrine, TIVOLI, Toad, DBArtisan

Confidential, St Louis, MO

Sr. Oracle DBA

Responsibilities:

  • 24X7 Interaction wif Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement.
  • Involved in RAC administration including Installation of Oracle 10/11g, Database cloning, tuning, patching, monitoring concurrent manager processing.
  • Installing/Maintaining/Configuring ASM Environment and Migrating Several Non ASM systems to ASM.
  • Cloned Very Large Databases from Production to Development/Test clusters.
  • Configured/Set up Monitoring through OEM GC as part of database preventive maintenance, the database growth, alert logs and archive log destination space.
  • Upgraded/Migrated Databases from 9i/10g to 11g in the SAP Environment.
  • Configured Oracle 10g Data Guard for RAC production systems.
  • Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Installed/Configured Oracle streams to propagate information wifin and in between several databases.
  • Strong noledge in developing, designing and implementing data mining models using neutral networks and logistic regression.
  • Performing Backups and Recoveries using RMAN/Conventional hot backups and EMC Networker.
  • Excellent technical and analytical skills wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
  • Created and maintained Materialized views for improved query performance.
  • Implemented oracle high availability solution using Oracle Physical & Logical Standby.
  • Refreshed using Export, Import, Hot, Cold and RMAN backups from Production to non-prod Environments.
  • Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
  • Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
  • Used data pump import/export utility of ORACLE to create other development and test databases.
  • Maintaining schemas and partitioning tables.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experienced wif Space Management and Security.
  • Supported application team to solve any issues in Production Environment.
  • Importing data from flat files into database using SQL* loader and External Tables.

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 11.0/10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker.

Confidential, Plainsboro, NJ

Oracle DBA

Responsibilities:

  • 24X7 Interaction wif Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement.
  • Worked on oracle 10g to 11g upgrade project wif low maintenance window and applied patches to various databases.
  • Involved in RAC administration including Installation of Oracle 10/11g, Database cloning, tuning, patching, monitoring concurrent manager processing.
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Extensively used Oracle Enterprise Manager to monitor multiple instances, SQL loader for loading data to databases, export/import utilities for data transfer between schemas/databases.
  • Implemented Transparent Data Encryption (TDE) for data protection at operating system level.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events wifin managed databases from legacy server to production server.
  • Installed/Configured Oracle Golden Gate - HP Non Stop Server.
  • Upgraded/Migrated several databases from 9i/10g to 11g.
  • Worked on all phases data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Strong noledge in developing, designing and implementing data mining models using neutral networks and logistic regression.
  • Cloned very large database to development cluster from production cluster.
  • Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM.
  • Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose
  • Installed/configured 10.2.0.5 OEM Grid Control.
  • Responsible for providing technical expertise in data integration for software packages such SAP/R3
  • Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Performing Backups and Recoveries using RMAN/Conventional hot backups.
  • Supporting teams ETL / Configuration and administration of Informatica ETL
  • Implemented oracle high availability solution using Oracle Physical & Logical Standby.
  • Performing database re-organizations as required assisting performance and ensuring maximum uptime of the database.
  • Created and maintained Materialized views for improved query performance.
  • Performed capacity planning, provided backup strategy for remote production database.
  • Performed Oracle Database and SQL/PLSQL tuning using SQL TRACE, EXPLAN PLAN, AWR, ADDM and ASH report.
  • Performed database recovery in various scenarios ensuring least downtime.
  • Performed health checks on the database at periodic intervals.
  • Improved query performance by analyzing query by creating indexes and using hints.
  • Creating PL/SQL packages, procedures and database triggers.
  • Supported application team to solve any issues in Production Environment.

Environment: Oracle 11g/10g/9i, Linux, Solaris, HP-UX 11.0/10.2, AIX, Windows NT, SQL Developer, PL/SQL, Shell scripting (Bourne/ Korn/ C), OEM GC, Statspack, ERWin, RMAN, AWR, ADDM, EXPLAIN PLAN, TK Prof, Dataguard, DataPump, SQL*Loader, EMC NetWorker.

Confidential, Philadelphia, PA

Database Administrator

Responsibilities:

  • Responsible for 24 X 7 Production database administration, support and monitoring.
  • Installation, configurations of multiple Oracle 10gR2 RAC environments wif Oracle Clusterware(CRS) on two node clusters starting from scratch.
  • Migrated several RAC systems to ASM.
  • Moved terabytes of database(ASM) from old SAN to new SAN frames.
  • Installed and configured Oracle Enterprise Manager 10G Grid Control for enterprise monitoring.
  • Upgraded/Migrated Several databases from Oracle 9i/10g to 11g.
  • Configured Oracle 10g Data Guard for RAC production systems.
  • Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Installed/Configured Oracle streams to propagate information wifin and in between several databases.
  • Excellent technical and analytical skills wif clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Worked on all phases data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Performed system testing and integration testing of large Data Warehouse application.
  • Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
  • Created and maintained Materialized views for improved query performance.
  • Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM GC.
  • Refreshed using Export, Import, Hot, Cold and RMAN backups from Production to non-prod Environments.
  • Dealt wif Oracle Support/Support Requests (SR), to support business operations and enhance business values.
  • Performed Capacity planning to deliver a pre-determined optimal/consistent user experience.
  • Applied Critical Patch Update (CPUs) every quarter in rolling mode wif no downtime.
  • Performed Automation of Startup Shutdown on all Production and Development Database.
  • Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
  • Used data pump import/exposure utility of ORACLE to create other development and test databases.
  • Maintaining schemas and partitioning tables.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experience wif Space Management and Security.

Environment: Oracle 10g RAC, Oracle 9i/10g/11g, ASM, SQL Developer, ERWIN, HPUX, AIX, Solaris, SQL server, Shell Scripts, Toad, StatsPack, SQL*Loader, Data Pump, Data Guard, TK Prof, VNB, VVM.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

  • 24x7 Oracle Production Database Administrations.
  • Installing and Configuring of Oracle 9i/10g RAC
  • Managing, troubleshooting and resolving Oracle Databases, RAC and applications issues.
  • Setup and configure Standby database (Physical & Logical) for high availability.
  • Upgrading/Migrating Oracle 9i database to Oracle 10g/11g. Installing Oracle Patch. Migrating production database to new server.
  • Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and archive log destination space by setting up alerts through OEM GC
  • Taking Backups on scheduled time and monitoring scheduled Backups.
  • Performing Backups and Recoveries using RMAN/ conventional hot backups.
  • Performed Oracle Database and SQL tuning using SQL TRACE, EXPLAN PLAN, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).
  • Applied several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
  • Used Export and Import ofdatabases for Logical backups and restores.
  • Applied Critical Patch Update (CPUs) every quarter in rolling mode wif no downtime.
  • Designed the logical and physical database.
  • Involved in User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking System/object privileges, roles, auditing user actions in the database.
  • Cloning databases for development and testing.
  • Coordinated wif the developers in customizing the modules.
  • Created and maintaining materialized views.
  • Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
  • Finding and resolving me/O bottlenecks, Heavy data loading jobs.
  • Implemented oracle high availability solution using Oracle Physical & Logical Standby.
  • Performed health checks on the database at periodic intervals.
  • Importing data from flat files into database using SQL* loader and External Tables.

Environment: Oracle 10g RAC, Oracle 9i/10g/11g, ASM, ERWIN, HP-UX, Solaris, AIX, SQL Developer, RMAN, Shell Scripts, Toad, SQL*Loader, Data Pump, Data Guard, Staspack, AWR, ADDM,TK Prof, SQL Trace, Explain Plan, VNB, VVM.

Confidential

Oracle Developer

Responsibilities:

  • Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
  • Modified, maintained and developed the SQL codes to develop new enhancements.
  • Written packages, triggers, stored procedure and functions for the following modules products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
  • Loaded traffic data logs into staging tables using SQL loader and shell scripts
  • PL/SQL coding for Exception Handling and duplicate data maintenance.
  • Used Triggers in Customizing Error conditions.
  • Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
  • Developed PL /SQL code for updating payment terms.
  • Develop and maintain the documentation to support the team and business.
  • Creation of Forms, Pop-up Menus and maintaining Master Detail relation-ship.
  • Used various LOVS (List of Values) and record groups at various points in runtime.
  • Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
  • Development of client side program units and sharing them among multiple applications for processing business logic in the database.
  • Testing all forms, PL/SQL code for logic correction
  • Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.

Environment: Oracle 9i/10g, Windows NT, HP-UX, Sun Solaris, AIX, SQL Developer, SQL*Loader.

We'd love your feedback!