We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Professional Summary

  • Over 8+ years of experience in Oracle databases (8i/9i/10g/11g) administration, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, Unix, HP-UX, AIX, LINUX and Windows 2000/NT.
  • Expertise in Installation, maintenance, upgradation, administration, backup and recovery of Oracle RAC Databases.
  • Experience in managing very large multi TB OLTP and Data warehouse databases
  • Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
  • Extensively worked on migrating databases from 8i to 9i, 9i to 10g and 10g to 11g.
  • Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing and Snapshot physical standby.
  • Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
  • Experience on installation and configuration of Golden Gate.
  • Experience in installing and managing Oracle Enterprise Manager Grid Control.
  • Expertise in Performance Tuning by using tools/utilities like Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, sql tuning Advisor, Autotrace, TKPROF and Statspack.
  • Successfully configured and managed Physical Standby Database using Oracle DATAGUARD for High availability.
  • Experience in basic and advance replication using Oracle Streams.
  • Performed capacity planning to create and manage database environments.
  • Excellent experience in cloning/refreshing oracle databases for development and testing.
  • Expertise in data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
  • Extensive experience on Partitioning tables and creation of the Indexes on large tables to improve the Performance.
  • Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers to implement business logics of oracle database.
  • Experience in automating day to day operations using Shell.
  • Experienced in heavy data loading from flat files to oracle tables using SQL* loader.
  • Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, capacity planning and documentation.
  • Experience in debugging deadlocks and other database inefficiencies using SQL Profiler.
  • Expertise in maintaining Database Security and auditing.
  • Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
  • Project Documentation, creation and adhering to standards of Implementation and Project management
  • Excellent interpersonal skills, team player, aggressive, hard working and result oriented.
  • Supported the system 24x7, Ability to work beyond regular hours.

Technical Skills

DBMS & RDBMS : Oracle 8i, Oracle 9i, Oracle 10gR2, Oracle 11g R2 and SQL server.
High Availability, Tuning : Oracle 10gRAC with ASM, Streams, DataGuard, OEM 9i, 10g, 11g,
And Monitoring Product LogMiner, Tkprof, Statspack Reports, AWR, ADDM and ASSM
Operating Systems : Solaris (8/9/10), AIX (5.1, 5.2, 5.3), Linux RHEL (3x, 4x, 5x),
HP-UX (10.x, 11.x) and Windows98/NT/2000/XP
Tools & Utilities : Toad, RMAN, EXP/IMP, EXPDP/IMPDP and SQL Loader
Data Modeling Tools : Erwin and ODI
ETL & Reporting tools : INFORMATICA and COGNOS
Backup Tools : VERITAS, NetBackup and HP OmniBack
Programming Languages : SQL, PL/SQL, Unix Shell Scripting, c, c++, java, HTML and XML

Education / Training / Certification

Bachelor of Technology
Received training in Oracle 9i and Database Administration
Oracle Certified Associate (OCA) - Database Administrator

Professional Experience

Confidential, San Leandro CA Jul’ 2011 – Till Date
Role: Sr. ORACLE DBA

Responsibilities:

  • Administering more than 50+ Production databases of size ranging from 100GB to 7 TB on RHEL and solaris.
  • Provided 12x7 on call support for mission critical databases.
  • Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
  • Installed fresh 11.2.0.1 and 11.2.0.2 RAC databases on ASM.
  • Responsible for migrating 7TB 3 node RAC database from 10.2.0.4 to 11.2.0.2.
  • Migrated 7TB 10.2.0.4 standalone database to 3 node RAC.
  • Performed capacity planning to create and maintain the database environments.
  • Installed and configured Active Data Guard 11g using physical standby for high availability databases.
  • switchover and switchback of oracle primary and standby databases.
  • Setting up RMAN and Data pump backups and Monitoring.
  • Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms_stats.
  • Proficient in troubleshooting node reboots in Oracle RAC Environment
  • Responsible for refreshing Non-prod environment from production using RMAN and Datapump utilities.
  • Performed SQL query tuning and optimization.
  • Performed database tuning and optimization using tools such as Explain plan, sql tuning advisor and SQLT.
  • Tuned memory structures such as the database buffer cache, shared pool, and library cache.
  • Responsible for rebuilding and re organization of tables and Indexes for better performance.
  • Installed and configured SharePlex for replication.
  • Expertise in applying Patches for both Grid and Oracle Homes.
  • Supporting and coordinating with Application and development team regarding deployments.
  • Automated stats collection at table level based on their size’s of table’s in schema using scheduler window.

Confidential, Santa Clara, CA Feb’ 2010 - Jun’ 2011
Role: Sr. ORACLE DBA

Responsibilities:

  • Involved in administering more than 450+ Production databases of size ranging from 200GB to 350 TB on RHEL.
  • Provided 12x7 on call support for mission critical databases.
  • Worked on Multiple RAC clustered environments ranging from 2 nodes to 16 nodes per cluster.
  • Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
  • Involved in fresh installation of 11.2.0.1 and 11.2.0.2 RAC databases on ASM and NFS file systems.
  • Migrated oracle RAC databases from 10.2.0.4 to 11.2.0.2.
  • Responsible for Migrating a 4TB 3 node RAC database from 10.2.0.4 to 11.2.0.2 on NFS storage
  • Performed capacity planning to create and maintain the database environments.
  • Installed and configured Data Guard 10g, 11g using physical and logical standby for high availability databases.
  • Migrated oracle 9.2.0.8 databases to 10.2.0.4 from windows to Linux
  • Migrated 4TB 10.2.0.4 standalone database to 2 node RAC
  • Responsible for adding a node to a 4 node Cluster.
  • As part of BCP certification did switchover and switchback
  • Installed 11g (11.1.0.1) Grid control on RHEL 5U3
  • Installed agents on database servers and configured enterprise manager.
  • Configured UDM’s for monitoring the databases.
  • Involved in administering Oracle Streams bi-directional replication at table level.
  • Configured Oracle Streams bi-directional replication at schema level between databases located in different colo’s.
  • Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30+ production databases.
  • Migrated database from ASM to Non-ASM using RMAN.
  • Recovered datafiles from block corruption using RMAN.
  • Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms_stats.
  • Proficient in troubleshooting node reboots in Oracle RAC Environment
  • Presented White paper on upgrading 10.2.0.4 RAC databases to 11.2.0.1 to Yahoo DBA team
  • Responsible for refreshing Non-prod environment from production and later automated the process through a script.
  • Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
  • Tuned memory structures such as the database buffer cache, shared pool, and library cache.
  • Responsible for rebuilding and re organization of tables and Indexes for better performance.
  • Installed and configured of Golden Gate.

Environment : Oracle 10g RAC, 11g RAC, 9i, SQL server 2005,2008, SUN SOLARIS 9,10 and RHEL 5.x, HP-UX 11

Confidential, Columbus, OH Apr’ 2008- Jan’ 2010
Role: Sr. ORACLE DBA

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Senior DBA, Primary point of contact for client for database and configuration management related issues.
  • Installed and Configured Oracle 10gR2 two node RAC.
  • Installed, configured and administered Automatic Storage Management (ASM).
  • Database cloning from Production to Test and Development environments.
  • Administered and managed Production, Test, and Stage and Development databases involving more than 100 applications.
  • Installed and configured Goldengate.
  • Dealt with Web based OLTP systems.
  • Review database environments, such as database settings, monitoring oracle user processes.
  • Installed and configured Data Guard 10g using physical and logical standby for high availability databases.
  • Adding and deleting nodes using Oracle Universal Installer (OUI).
  • Created Physical standby database from hot backup of primary database and wrote shell scripts for backup and cloning.
  • Worked with a team for replicating databases using Quest Shareplex.
  • Used Oracle Streams for data replication between oracle databases.
  • Responsible for Migrating Oracle database from 9.2.0.7 to 10.2.0.4
  • Daily database administration tasks including backup and recovery.
  • Tuned memory structures such as the database buffer cache, shared pool and library cache.
  • Developed Backup & Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
  • Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
  • Provided all kinds of Production DBA support as well as development team support to various tasks.

Environment : Oracle 11g, Oracle 10g RAC, Oracle 9i, RHEL 4.x, IBM AIX 5.3, HP-UX 11

Confidential, NJ Aug’ 2006- Mar’ 2008
Role: ORACLE DBA

Responsibilities:

  • Provided 24x7 database supports for all systems.
  • Installed and Configured Oracle 9i/10g RAC.
  • Installed, configured and administered Automatic Storage Management (ASM).
  • Applied patches to the existing versions of Oracle.
  • Developed Environments setup using database cloning and refresh procedures.
  • Provided Oracle DBA support included Oracle database installation, upgrades, instance configuration, tuning, schema maintenance, troubleshooting and production monitoring.
  • Coordinated and Assisted in Database upgradation from 9i to 10g Release 2.
  • Developed backup recovery procedure/scripts for the Database through Log Archiving.
  • Performed day-to-day DBA tasks or managing Prod/Dev databases like Export/ Import, moving tablespaces, rebuilding indexes, synonyms, partitioning tables, etc.
  • Identified poorly performing queries using ExplainPlan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.
  • Managed the Schemas by creating various objects like tables, views, indexes and maintaining data integrity using constraints.

Environment : Oracle 10g RAC, Oracle 9i, Oracle 8i, LINUX, SUN SOLARIS 9, IBM AIX 5.2

Confidential, Los Angeles, CA Jun’ 2005- Jul’ 2006
Role: ORACLE DBA

Responsibilities:

  • 24x7 production database and applications support.
  • Upgraded multi terabyte databases from 9i to 10gConfigured disaster recovery site with physical standby database for high availability.
  • Perform capacity planning required to create and maintain database environments.
  • Created RMAN database backup and used OEM to manage the data, accounts and tuning. Used data pump technology to take the backups.
  • Configured Enterprise manager for centralized database monitoring and maintenance.
  • Cloning of databases from production to Dev & QA Databases using RMAN utility.
  • Partitioning of the large tables to reduce the access time and easier management.
  • Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
  • Monitored table space size, resizing table space, relocating data files for better disk I/O.
  • Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
  • Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
  • Performed data loads using SQL*Loader.
  • Used ERWIN for Logical Data modeling and creating physical database designs.
  • Replicated materialized views with fast refreshes for table replication.
  • Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
  • Installation of SQL Server 2005.
  • Troubleshooting oracle errors fine-tune database parameters and analyze STATPACK reports.

Environment: Oracle 10g, 9i, 8i, IBM AIX, and HP-UX

Confidential, Hyderabad, India Jul’ 2003- May’ 2005
Role: Jr. ORACLE DBA

Responsibilities:

  • Installation, Configuration and Administration of Oracle 8i/9i databases, MS SQL server.
  • Analyzed STATSPACK reports for optimization of DB performance periodically.
  • Created different types of Indexes (B tree, reverse key, IOT and function based etc).
  • Involved in backup/recover strategy designing and implementation
  • Performed hot and cold backups Performed in HOT and COLD backups of the databases and also the individual table spaces.
  • Configuring the database parameters, creation, reorganization, extending tablespaces, administer database security, create users, grant/revoke roles, privileges, extended database storage capacity, performance and monitor, reduce database fragmentation, manage data-files, rollback segments, extents and rebuilding indexes.
  • Applying patches.
  • Performed heavy data loads using SQL *Loader, Export, Import.
  • Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • Supported developers during batch jobs to increase rollback segments and archive log space for additional month end updates to the system.
  • Database analysis and design activities as a team with the Data Analysts.
  • Modified and defined database objects as per requirements.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment : Oracle 9i, 8i, 7.x, SunSolaris, HP-UX, Windows

References available upon request
Willing to relocate

Hire Now