We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume

Plano, TX

Summary

Over 7 years of experience in information technology which includes Oracle Database Administration and administration of UNIX and windows environments.

  • Oracle Database Administration on 24x7 critical production and large databases using Oracle 10g RAC, 11g RAC, 9i, 8i.
  • Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Standby Database Data Guard for large financial applications.
  • Installing and configuring ASM for the RAC storage implementation.
  • Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP-UX/IBM-AIX/Windows platforms and creating databases.
  • Cloning database from production to test and development.
  • Creating standby databases for disaster recovery and reporting purpose.
  • Experience in Patching the Oracle Software and Databases.
  • Upgrade/Migration of databases from Oracle 9i to 10g, 9i, 10g to 11g.
  • Experience working with Export/Import, Data pump.
  • Experience with Partitioned Tables.
  • Working experience in OLTP and DSS environments.
  • Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup, RMAN incremental backups.)
  • Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
  • Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
  • Performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM.
  • Replication using Oracle Golden Gate, Oracle Streams.
  • Experience in capacity planning and benchmarking.
  • Experience in hot/cold backup mechanisms, EMC BCV concepts
  • Knowledge on Oracle Support processes for technical requests with Metal ink.
  • Result oriented, self-motivated, Team player, ability to work independently.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.

Technical Skills

Databases : Oracle 8i/9i/10g RAC/11g RAC, SQL Server 2000/2005, Teradata.
Operating Systems: Red Hat Linux 4.x, 5.x, Sun Solaris 8, 9, 10,, HP-UX 10.x, 11.x,
IBM-AIX 5.1, 5.2, 5.3, Oracle Enterprise Linux, Windows
Languages : SQL, PL/SQL, UNIX Shell Scripting
Oracle Tools : RMAN, ASM, OEM Grid Control, TOAD, SQL*Loader,
Golden Gate, Streams
Hardware/Storage : EMC BCV, VERITAS Netback up, Tivoli Storage Manager (TSM)

Education

Bachelors of Technology (B.Tech) in Computer Science

Professional Experience

Confidential,Plano, TX Feb 2010 – Till Date
Role: Sr. Database Administrator

Responsibilities:

  • 24x7 Oracle Production Database Administration.
  • Installed, configured and maintained Oracle Databases and Applications.
  • Oracle 11g/10g RAC installation, configuration and support.
  • Table Partitioning, Creating Locally managed Table spaces.
  • Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
  • Worked with Materialized views.
  • Applying patches for both Server side and Client side.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
  • Migrated databases from HP-UX to IBM AIX.
  • Standby Database (Data Guard) setup and configuration.
  • Global operations and maintaining database.
  • Using expdp/impdp for export and import.
  • Creating and maintaining Materialized Views for replication.
  • Refreshing/cloning databases using RMAN.
  • Created package for Online Redefinition of tables for every day column additions and conversion of tables to partitioned or non-partitioned tables.
  • Working alongside programmers and contributing to the development process; Enabling and analyzing trace files for debugging issues.
  • Defining and Setting backup and recovery procedures.
  • Responsible for continuous database monitoring and reorganization for ensuring performance.
  • Partitioning large objects to improve the performance and manageability.
  • Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
  • Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL , Data Guard, ASM and OEM
  • Proactive monitoring of databases and applying RDBMS patches, security patches.
  • Writing Shell Scripts for managing day-to-day activities.
  • Usage of Partitions to improve the query performance and manageability.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Installation and configuration of Oracle Client software and Tools.
  • Installation, configuration and administration of Golden Gate Replication.
  • Replication using Oracle Streams
  • Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environnent: Oracle 10g RAC/11g RAC, OEM (Grid Control), Oracle Data guard, Golden Gate, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, SQL*Loader, Import Export, AIX, HP-UX, Sun Solaris and Red Hat.

Confidential,Sunnyvale, CA Dec 2008 – Jan 2010
Role: Database Administrator

Responsibilities:

  • 24x7 Oracle Production Database Administration including Oracle 10g RAC
  • Installed, configured and maintained Oracle Databases and Applications.
  • Installing and configuring ASM.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
  • Experience using Export/Import and Data pump for migration of databases.
  • Working with Oracle 9i and 10g partitioned tables.
  • Standby Database (Data Guard) setup and configuration.
  • Creating and maintaining Materialized Views for replication.
  • Cloning Oracle databases from Production to Development, Test
  • Refreshing/cloning databases using RMAN.
  • Working alongside programmers and contributing to the development process
  • Defining and Setting backup and recovery procedures.
  • Responsible for continuous database monitoring and reorganization for ensuring performance.
  • Partitioning large objects to improve the performance and manageability.
  • Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK, AWR, ADDM
  • Writing Shell Scripts for managing day-to-day activities and automation of backup.
  • Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environnent: Oracle 11g RAC/10g RAC/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, SQL*Loader, Import Export, AIX, HP-UX, and Red Hat.

Confidential,St. Louis, MO Oct 2007 – Nov 2008
Role: Database Administrator

Responsibilities:

  • Supporting production database system 24*7.
  • Oracle DBA, Primary point of contact for client for production database support.
  • Installation and Configuration of Oracle 10g RAC.
  • Migrating Oracle databases from windows to Linux.
  • Developer Environment Setup, Support, Cloning and Refreshes.
  • Performed database cloning to setup test and development database.
  • Used RMAN for backup and recovery. Performed backup validations using RMAN.
  • Implemented Hot, Cold and Logical backup plans.
  • Proactive database monitoring using 10g grid control.
  • Installation of Oracle RDBMS server software and version upgrades.
  • SQL tuning using Stats pack, AWR, Explain plan, Tkprof.
  • Installation, Configuration and Maintenance of Logical and Physical Standby databases.
  • Ensuring that all databases are backed up on a regular basis. Fix backup failures, address and implement resolutions.
  • Conducting sizing & capacity planning for Oracle databases.
  • Storage and space management including table spaces and data files.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Applied patches to Oracle Database 10g,9i.
  • Monitoring Growth of tables and undertaking necessary re-organization of database objects when required.
  • Responsible for optimizing the queries and application tuning
  • Oracle Database monitoring, troubleshooting and resolved the issues.
  • Management of schemas, objects partitioning the tables & indexes.

Environnent: Oracle 10g RAC/9i/8i, OEM (Grid Control), Oracle Datagaurd, ASM, RAC, PL/SQL, RMAN, Datapump, SQL*Loader, HP-UX, Sun Solaris, AIX, RedHat Linux.

Confidential,Hyderabad Jun 2004 – Aug 2007
Role: Oracle DBA/Developer

Responsibilities:

  • 24x7 Oracle Production Database Administrations.
  • Managing, troubleshooting and resolving oracle database and applications issues.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • Working alongside programmers and contributing to the development process.
  • Planning and recommendations for optimum performance.
  • Extraction of data from flat files into Oracle Database using SQL*Loader.
  • Defining and Setting backup and recovery procedures.
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Tuning and balancing I/O by monitoring file system and table space I/O statistics.
  • Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
  • Written SQL, PL/SQL functions, procedures, packages and triggers.
  • Monitoring and managing the Storage Usage by Resizing Older Table spaces, Creation of New Table spaces and relocation of data files for better Disk I/O.
  • Writing Shell Scripts for managing day-to-day activities and automation of backup.
  • Optimal Space utilization in table space by avoiding fragmentation.
  • Usage of Partitions to improve the query performance and manageability.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Monitoring of database objects like rollback segments, temp segments and table spaces.
  • Automated the process of analyzing tables.

Environment: Oracle 10g/9i/8i, OEM (Grid Control), PL/SQL, RMAN, Data pump, SQL*Loader, Sun Solaris, RedHat Linux, Windows.

Hire Now