Oracle DBA Resume

SUMMARY

Over Seven Years of extensive experience in the IT industry involving Oracle Database Administration, Oracle Applications Administration. Worked extensively on Oracle 11g, 10g, 9i, and 8i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security
Excellent experience in installation, configuration and administration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX and Windows environment.
Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script Development, and documentation.
Installation, administration and maintenance of Oracle 10g RAC,11g RAC
Worked extensively on Oracle Installation, Oracle Version Upgradation, Migrations (from 8i to 11g) and patching
Involved in performance tuning and database reorganizations. Worked on Disaster Recovery and Implementation
Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planningand efficient usage of the disk space. Performed SAN analysis and provided recommendations
Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life - Cycle (SILC).
Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data
Supported Streams Database where Database, Schema, Table level Replication is done. Worked on Partitioning and Materialized views
Extensively usedDatabase Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD
Monitoring VLDB (Very Large Databases) using Grid Control and also working off-shore while monitoring
Wrote several Purging shell scripts on Linux which have been using as standard script at the workplaces
Designed complex ER diagrams, Data Flow Diagrams/Process Diagrams to detail the specifications
Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, datamigration, dataclean-up, data archiving, etc

TECHNICAL SKILLS

RDBMS: Oracle 11g RAC/10g RAC/9i/8i

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1 Red Hat Linux RHEL 4.x, 5.x and Windows 98/NT/2000/2003/XP

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

TOOLS: RMAN, ASM, SQL*Loader, DataPump, TOAD, DBCA, DBUA, OEM/GridControl, Oracle Data Guard, ERWIN, TOAD

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

ETL: Informatica, External Tables

OTHER: EMC, NetApp, VeritasNetBackup, TSM

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Developed RMAN scripts for database back up and recovery including- hot and cold backup
Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
Good at Data Dictionary views, User Security and Auditing.
Team player with excellent interpersonal, analytical and communications skills
Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
Participated in planning and implementation of off-site Disaster-Recovery planning and testing
Worked with development and operations staff in resolving problems quickly and efficiently
Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments
Monitored and managed various database components (logical & physical) like table- spaces, segments
Worked extensively on Shell scripting for backup, recovery and maintenance for databases

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship