We provide IT Staff Augmentation Services!

Lead Oracle Dba Resume

Dubuque, IA

PROFESSIONAL SUMMARY:

  • Over 5 years of solid IT experience.
  • Over 4 years of Oracle DBA experience which includes experience in 10g, 11g and RAC.
  • OCA Certified on Oracle 10g, OCP Certified on Oracle 10g.
  • Implementation and maintenance of Grid Control.
  • Implementation and maintenance of RAC.
  • Proficient in NT and all flavors of UNIX.
  • Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
  • Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
  • Proven experience in upgrading and migrating mission critical databases both manually and with DBUA (8.x.x.x / 9.x.x.x / 10.2.0.1 / 10.2.0.3 / 10.2.0.4)
  • Experience in data (hot and cold) backup and recovery procedures.
  • Experience in schema management, tablespace, datafile and extent management, as well as user and privilege management.
  • Extensive experience with VLDB (Very Large Databases) with clear understanding in large table partitioning.
  • Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
  • Managing Database Structure, Storage Allocation, Table/Index/BLOB segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Comfortable with both command-line and GUI interface.
  • Experience in managing BLOB segments
  • Load balancing in RAC nodes using TAF
  • Possess strong UNIX skills; light administration skills.
  • Possess excellent written and oral communication skills.
  • Configured and Implemented Physical Standby on 10g Databases (Data Guard).
  • Planning and scheduling Backups and taking Logical Backups (with Export/Import).
  • Tablespace point in time recovery TSPITR.
  • Transportable Table Space (TTS) migration AIX to Linux
  • Manage Backup and Recovery Program for all Oracle Databases. Install, implement and configure RMAN. Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
  • Regular practice of Disaster Recovery Scenerios.
  • Work independently and as well working extremely well with other teams and the customer on a daily basis
  • Provided database technical consultation to other teams
  • Effective communication skills with Project manager, account team, and customer on technical issues and resolutions
  • Implementing ASM file system and its maintenance
  • Adding node to RAC environment.
  • Deleting node(s) from RAC environment
  • Troubleshoot network issues to connect to database.
  • Troubleshoot performance issues by generating statspack report.
  • Provided 24/7 support whenever on call.
  • Dealt with Oracle by opening an SR or calling their customer support whenever necessary.
  • Written custom made scripts to send archivelogs to multiple locations (before Dataguard came in picture)
  • Restored databases on different hosts.

CERTIFICATIONS:
OCA (Oracle Certified Associate) version 10g
OCP (Oracle Certified Professional) version 10g

TECHNICAL SKILLS:

Languages

SQL, PL/SQL

Script and Markup Languages

Unix bash shell programming, ,

OS & Administration

Sun Solaris, HPUX, Linux, VMWARE, AIX, Windows

Database

Oracle 8i, 9i, 10g, 11g

Utilities

Concepts and Administration

Data Guard (Standby)

Real Application Cluster (RAC)

Automatic Storage Management (ASM)

Applications

Peoplesoft, JdEdwards, Java, Lawson

PROFESSIONAL EXPERIENCE:

Confidential, IA Feb' 10 - Present

Project Name: DBA Support
Project Description: Daily Database Administration Tasks.

Roles and Responsibilities: Daily activities of managing and troubleshooting High Availability Real Application 4 node cluster. Tuning SQL queries to improver overall cost of the query. Other responsibilities include refreshing schema and tables from production to non-production databases, patching up security and other application required patches. Created and managed ASM disk and disk groups using bind raw devices and ASMLib packages. Troubleshoot net connectivity issues.

  • Installed 10g and 11g databases and Clients on RHEL platform.
  • Upgraded CRS 10.2.0.1 to 10.2.0.4
  • Configure ASM packages on Linux.
  • Installed ASM disks.
  • Manage ASM diskgroups via ASMCMD and database control.
  • Managed 4 node RAC cluster.
  • Troubleshoot RAC issues with olsnode, crs_stat, crs_register, crs_unregister, crsctl check crs, crsctl check cssd, crsctl check crsd, crsctl check evmd, crstctl stop, crsctl stop, srvctl nodeapps, crsctl status, ocrconfig, etc.
  • TTS migrated Sun Solaris to Linux on 10g
  • Multiplex OCR and Voting Disk to different location for higher availability.
  • Add and delete node in RAC environment.
  • Stop and start nodes via srvctl and manually.
  • Reconfiguring Services via srvctl utility
  • Working with Oracle to solve multiple RAC issues.
  • Troubleshoot connectivity issues and solved listener configuration.
  • Worked with Unix Administrators to create new two Node RAC cluster.
  • Configure and installed Database Control.
  • Managed Agents for Database Control monitoring tool.
  • Troubleshoot OEM repository
  • Update sysman passwords to troubleshoot OEM connection issues.
  • Manage security and grants for database users.
  • 9i to10g upgrade.
  • Responsible for writing shell scripts to automate tasks.
  • Responsible for managing daily full backups.
  • Created scripts to transfer archivelogs to remote server for manual Dataguard purpose for Standard Edition database.
  • Use of Opatch for quarterly security patches and other patches for database.
  • User creation and giving proper grants and privileges.
  • Created profiles from grants and privileges.
  • Managed incremental and cumulative backups both from database control and shell scripts.
  • Export / Import using DataPump.
  • Analysis of requirements for hardware/software upgrades
  • Pre-Upgrade Planning, study and analysis of Applications and database
  • Refreshing tables/schemas on a regular basis.
  • Refreshed database from production to non-production.
  • Upgraded 10g R1 to 10g R2.

Environment: Production and Non-Production on Linux/HPUX and NT.

Confidential, Feb '09 - Feb' 10

  • Implemented 2 node RAC 10g on LINUX
  • High Availability Features for RAC.
  • Installed ASM disks
  • Monitor, administrator ASM, RAC.
  • Performed Database Administration using TOAD, Oracle Enterprise Manager, SQL scripts and DB Artisan
  • Performance Tuning of database, SQL tuning for Application
  • Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan
  • Physical and Logical database design.
  • Database sizing, Capacity Planning.
  • Analyze database objects.
  • Managed database sizes up to 5 TB
  • RMAN backup
  • Refreshing tables/schemas on a regular basis.
  • Refreshed database from production to non-production.
  • Export / Import using DataPump.
  • Analysis of requirements for hardware/software upgrades
  • Planning capacity for Oracle Streams
  • Troubleshoot OEM repository
  • Update sysman passwords to troubleshoot OEM connection issues.
  • Manage security and grants for database users.
  • Responsible for writing shell scripts to automate tasks.
  • Reconfiguring Services via srvctl utility
  • Working with Oracle to solve multiple RAC issues.
  • Troubleshoot connectivity issues and solved listener configuration.
  • Used TOAD for various database Administration tasks.
  • Used SQL*Loader to move data from flat files into an Oracle database.
  • Worked as secondary on-call DBA
  • 24/7/365 DBA support for 45-50 Oracle databases with users located all over the world
  • Installed, Migrated, configured and tested Oracle 10g databases in various environments
  • Erwin and Power Designer Modeling tool

Environment: SQL, SQL*Plus, 10g; Linux, HP UX, TOAD, OEM, GRID, DB Artisan

Confidential, Michigan Dec '08 - Feb '09
Oracle DBA Lead
Roles & Responsibilities:

  • Evaluate current backups
  • Re structure the database
  • Configure and manage Data Guard on Linux
  • Upgraded from 10.2.0.1 to 10.2.0.4
  • Perform Backup and Recovery thru RMAN.
  • Created multiple databases for Development and Testing.
  • TTS migrated from Linux to HP-UX 10g
  • Actively involved in designing/Testing of Disaster Crash recovery.
  • Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
  • Performed database cloning/exp/imp to setup identical databases in the production and development environments.
  • Used DBV utility to verify backups
  • Provided technical troubleshooting and give consultation to development teams.
  • Performed Database Refreshes and Database Copies for Development, Test and Production databases.
  • Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
  • Used top utility for overall performance of server in Linux

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g; Linux, Windows NT/2000, HP UX,TOAD, OEM

Confidential, Missouri July '07 - Dec '08

Oracle DBA Lead
Roles & Responsibilities:

  • Implemented 2 node RAC 10g on AIX. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring
  • High Availability Features for RAC.
  • Installed ASM disks
  • 24/7 support.
  • Worked on DATA WAREHOUSE database 3.0TB.
  • Upgrade 3.0 TB Data warehouse Database from 8K block size to 32K block size to optimize performance in PROD.
  • Worked on DATA WAREHOUSE and OLTP
  • Upgraded from 10.2.0.1 to 10.2.0.4
  • Created multiple databases for Development and Testing.
  • Actively involved in designing/Testing of Disaster Crash recovery.
  • Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
  • Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
  • Performed database cloning/exp/imp to setup identical databases in the production and development environments.
  • Created and maintain users, roles and privileges.
  • Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
  • Perform Backup and Recovery thru RMAN.
  • Applied patch (opatch utility) in PROD and TEST and DEV. environments
  • Performed Export/Import through Data Pump.
  • Used Grid Control for Monitoring 45+ database.
  • Provided technical troubleshooting and give consultation to development teams.
  • Performed Database Refreshes and Database Copies for Development, Test and Production databases.
  • Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
  • Used Oracle 10g, AWR & ADDM to monitor database activities and performance tuning.
  • Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts and DB Artisan
  • Unix Shell Scripting for ETL and CDW.
  • Used NMON and TOPAS for performance and monitoring in all AIX environment.
  • Used nmon_analyzer tool to analyzes the captured performance data.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i, 9i, 10g; AIX, Linux, Windows NT/2000, HP UX,TOAD, OEM,SQL Developer

Wells Fargo Feb' 05 - July' 07

Project Name: DBA Support
Project Description: 24/7 DBA Support

Roles and Responsibilities: Responsible as an Oracle DBA for installation, administration, tuning and recovery, of Oracle 8.x/9.x, databases. Setup and monitored, Oracle backups using export/import, cold/hot backups, Standby Database and RMAN. Extensive automated data uploads, from multiple flat data files, using SQL*Loader. Provided Oracle schema design, development and tuning support to the development team's for Oracle backend programming on major network management. Creation of Clone databases for high availability. Resolved connectivity issues on Oracle, Client/Server. Extensive use of monitoring tools like STATSPACK, UTILESTAT & UTILBSTAT, Oracle Enterprise Manager, Performance Monitor etc for the performance tuning. Other responsibility includes:

  • Responsible for administration and supporting Oracle database on Sun Server.
  • Installed, upgraded, migrated and configured Oracle 8i and 9i database.
  • Installed and configure Oracle 10.0.1 on Sun SPARC/Solaris 8 64 bit server for development.
  • Configure RAC environment for multiple sets of 4 database instances in Oracle 9.2.0
  • Successfully created Development/Test databases, create schema, users, create database objects, security management etc.
  • To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 9.0.2 on SPARC/Solaris 8 - 64 bit server
  • To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 10.0.1 on SPARC/Solaris 8 - 64 bit server
  • Performed database tuning with StatsPack, Sqltrace, tkprof
  • Set up and maintain automatic hot standby database for disaster recovery (DR)
  • Cloned Database and transfer data between Production and Development database
  • Estimated database capacity managed system disk space and system resources.
  • Implemented hot backups and recovery procedures using RMAN.
  • Setup Oracle Enterprise Manager and STATSPACK to support monitoring and performance diagnosing
  • Created scripts to monitor database alert activities, growth, and key performance indicators.
  • Created scripts to automate and standardize various database maintenance tasks.
  • Provided guidance to developers on data design, query tuning and security issues.
  • Designed and implemented disaster recovery and backup/restoration procedure using Shell scripts
  • Unix shell scripting to exp/imp schemas
  • Provided technical troubleshooting and give consultation to development teams.

Environment: Oracle 8i/9i, Sun Solaris, Oracle Enterprise Manager, Solaris, HP UNIX, PL/SQL, TOAD and SQL *Plus.

Hire Now