We provide IT Staff Augmentation Services!

Oracle Dba Resume

0/5 (Submit Your Rating)

Richardson, TX

SUMMARY

  • Oracle Professional with 6+ years of experience in Installation, Upgrade, Monitoring, Performance Tuning, Database Backup and Recovery, performance tuning on Linux, UNIX and Windows environments.
  • Oracle expertise includes in - depth knowledge of database architecture, evaluation of application products, development and SQL Performance analysis using Explain Plan, SQL Trace, Statspack, AWR and SQL Trace (10046/10053 ).
  • Excellent team player with good analytical, planning and interpersonal skills. Highly motivated, enthusiastic and self-starter.
  • Production Experience in administering Oracle 11g/10g/9i and upgrade from Oracle 9i to 10g and Oracle 10g to 11g.
  • Experience in Maintenance, Patching, Cloning and troubleshooting.
  • Experience as on-call 24x7 production DBA support, and worked On-Call rotation support.
  • Expert level day to support on 9i/10g/11g databases on heterogeneous platforms like UNIX, Linux, AIX and Windows.
  • Expertise in operational and maintenance Database Administrative tasks including installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indexes and performance tuning.
  • Proficient in troubleshooting performance issues and automating the daily maintenance activities by developing shell scripts using, SQL scripts.
  • Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
  • Extensively used Backup and recovery of Oracle databases using conventional methods and RMAN in different scenarios and experience with Oracle Flashback technology.
  • Expertise in implementing Standby Data Guard for disaster Recovery.
  • Experience in implementing 10g/11g RAC with ASM & Data guard for various instances and provided support in troubleshooting and monitoring.
  • Experience in writing procedures, functions, triggers and packages in Oracle database server.

TECHNICAL SKILLS

Operating Systems: Redhat Linux, Windows, Solaris, HP-UX, AIX.

Languages: SQL, PL/SQL, UNIX shell scripting, Perl scripting, AWK, C, C++, Visual Basics, Java.

Databases: Oracle 11g migration/10g migration/9i, SQL server, MS Access

Design & Development Tools: SQL*PLUS, TOAD, PUTTY, OEM, RMAN, SQL* Loader, IMP/EXP, DATA PUMP, PL/SQL developer, RAC.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Oracle DBA

Responsibilities:

  • Incident and problem ticket resolutions for tickets received from the Integrated Project Manager (IPM).
  • Responsible for handling Database Change Requests on all environments.
  • Handled Monthly production maintenance release.
  • Responsible for database Hot & Cold backups using RMAN, Export/Import Unix command line etc.
  • Implemented 11gR2 RAC on Development, UAT and Production in ASM.
  • Setup backup and recovery procedures and create primary objects including tables, views, indexes, etc.
  • Setup Golden Gate replication for reporting database.
  • Setup Golden Gate Active-Active Two way replication for Test database.
  • Creating users & roles and granting roles and privileges to users.
  • Performing Oracle upgrade to 11g from 10g in test environment and also Production environment.
  • Performing Listener Fixes in 10g (10204,10205) databases as well as 11g (11203) databases.
  • Migration of huge data from Production environment to Reporting using stored procedures and to development and test environment through EXPDP/IMPDP.
  • Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
  • Setup Oracle standby - Stream replication, Shareplex Replication and Oracle Golden Gate Replication.

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, RHEL, PL/SQL, Oracle Golden Gate, Shareplex, RAC, ASM, TOAD, SQL *Plus and SQL Developer.

Confidential, MT Laurel, NJ

Sr. Oracle DBA

Responsibilities:

  • Incident and problem ticket resolutions for tickets received from the Global Service Desk (GSD).
  • Responsible for handling Database Change Requests on all environments
  • Handled Quarterly production maintenance release.
  • Co-ordinate with development team to performance and tune the application and Database related issues using explain plan SQL trace and generating the reports.
  • Creating database on Solaris, and Linux, Design a Complete architecture of the entire database including production as well testing database.
  • Creating new user accounts, profiles, roles, and privileges and assigned to the user based on application team and providing security.
  • Creating Snapshots to get the remote database data into the local database for development and stress testing environments.
  • Implemented Partitioning on huge tables to improve the performance and reduce the maintenance.
  • Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding the index.
  • Transported tablespaces from production database and plugged-in it in development database for the usage of developers.
  • Responsible for database Hot & Cold backups using RMAN, Export/Import Unix command line dd etc.
  • Created physical standby database for disaster recovery
  • Implemented 11gR2 RAC on dev, qa and production in ASM.
  • Monitor alert logs, trace files and automated alarm generation for schema changes.
  • Setup backup and recovery procedures and create primary objects including tables, views, indexes, etc
  • Migrating Database from Raw Volumes to use ASM Disk groups.
  • Supported single instance & RAC databases on Raw Volumes.
  • Supported replication of databases using Shareplex.
  • Proficient in using Informatica Workflow Manager Tools like Task Developer and Workflow Designer. Trouble shooting and Error handling in workflows..

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, PL/SQL, Informatica, Shareplex,, RAC, ASM, TOAD and SQL *Plus.

Confidential, Taylor, TX

Oracle Database Administrator

Responsibilities:

  • Evaluating, Supervising and planning Oracle 9i/10g Database servers.
  • Installation of Oracle 11g, 10g, 9i under Linux and Windows 2003.
  • Upgrading to new versions, co-coordinating with hardware changes and applying database patches.
  • Oracle 9i/10g upgradation for 64bit for Windows 2003, DB cloning.
  • Installed and configured OEM Grid control.
  • Re-organizing the database architecture to work efficiently and for better response time.
  • Performed Online and Offline database backups on schedule.
  • Backup plan designing and implementation using RMAN backup technology.
  • Implemented backup strategies which involved taking an incremental level 0 backup of the database every week, a level 1(cumulative) backup every night, and enabled the block change tracking feature.
  • Database creation, database refreshing/reorganization, sql statement tuning.
  • Worked in the matters of performance issues, major reorganizations and auditing the required down times.
  • Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
  • Migrated flat files from different sources into Oracle Database using SQL*Loader.
  • Performed Cross Platform transformation of the databases.
  • Extensive use of data moving utilities like export/import.
  • Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Implemented single source one way replication using Oracle Stream.
  • Worked with Real Application Cluster (RAC) with ASM database for various instances.
  • Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
  • Successfully providing 24x7 supports for production, development, and test database.
  • Train users/developers from time to time regarding the environment they are supposed to work on, training on database coding standards.
  • Planned and acquired the new technologies for evaluation and implementation.

Environment: Oracle 9i/10g/11g, OEM Grid Control, RMAN, RAC, SQL*Loader, Import/Export, Data Guard, SQL*PLUS, Perl, Shell Scripting, Redhat Linux ES4 and Sun Solaris.

Confidential, Houston TX

Oracle Database Administrator

Responsibilities:

  • Installation of Oracle 10g, 9i under Linux and Windows, Upgrading to new versions and applying patches as required.
  • Creating Database, Tablespaces, Rollback Segments etc.
  • Installed and configured OEM Grid control.
  • Extensively used data moving utilities like EXPORT/IMPORT, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
  • Performed Online/Offline database backups.
  • Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
  • Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.
  • Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.
  • Monitoring frees space in tablespaces, Archivelog destination, Database/Listener availability, Blocking Locks monitoring etc.
  • Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
  • Physical and Logical Database design, entity modeling and architecture.
  • Implemented Data Guard to ensure high availability, data protection and disaster recovery.
  • Setup Oracle standby - Stream replication.
  • Worked with Real Application Cluster (RAC) database in test environment.
  • Tasks involved extensive usage of Unix Shell Scripting.
  • Successfully providing 24x7 supports for production, development, and test database.
  • Performed Cross Platform transformation of the databases.
  • Created service request with Oracle Support for technical assistance.

Environment: Oracle 9i/10g, OEM Grid Control, RMAN, SQL*Loader, RAC, Import/Export, Data Guard, streams, SQL*PLUS, Shell Scripting, Redhat Linux ES4 and Sun Solaris.

Confidential, Philadelphia, PA

Oracle Database Administrator

Responsibilities:

  • Installed, Upgraded and Configured Oracle 9i/8i.
  • Creating Database, Tablespaces, Rollback Segments etc.
  • Creating users & roles and granting roles and privileges to users.
  • Writing Procedures, Functions, Triggers and Packages.
  • Capacity Planning, Estimating Database Size and SGA size.
  • Designing and developing backup and recovery strategies.
  • Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
  • Successfully recovered corrupted databases.
  • Enhanced overall performance by performing SQL tuning.
  • Tuned the Database and applications using AWR, ADDM, and STATSPACK.
  • Allocating system storage and planning future storage requirements.
  • Monitoring the growth of Table spaces to see the fragmentation and available space for growth.
  • Tasks involved extensive usage of SQL, Unix Shell Scripting and Oracle Server utilities like SQL*loader and Export/Import.
  • Setup Oracle standby - Stream replication, Oracle Materialized view replication.
  • Implemented and maintained Oracle 10gR2 RAC on Red Hat Linux.
  • Designed, developed and generated reports to provide up-to-date information for production planners.
  • Successfully provided 24x7 supports and monitoring of databases.
  • Worked with cross-functional teams of marketing team, engineers, and production planners to understand business process and develop functional specifications.
  • Implemented the data migration from the previous database.

Environment: Oracle 9i/10g, SQL*PLUS, SQL*Loader, Import/Export, OEM, RAC, RMAN, Erwin, Shell Scripting, Solaris, Linux, Windows 2000.

We'd love your feedback!