Oracle DBA Resume

SUMMARY

Around 7 years of experience as Database Administrator, providing 24/7 support of both development and production Oracle 9.x, Oracle 10g and Oracle 11g on Various Platforms.
Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.
Over 2 years of experience working with Oracle Streams with complete end - to-end support for Oracle Streams Configure, Setup, Install, & support.
Over 4 years of experience working with Oracle Data Guard - Implement & support.
Planned, installed, configured and performed upgrades of Oracle DBMS software on various platforms.
Working Experience of setup and configuration, implementation of ASM/Grid Control/Automation/RMAN.
Extensive Knowledge of Automatic Workload Repository (AWR), Oracle Data Pump,ASM,DataGaurd
Generating statistics of database using ADDM and tuning the database accordingly.
Experience working on SQL Trace, TKPROF, Explain Plan.
Experience in creating different kinds of partitions on tables and indexes for managing large tables.
Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics (performance tuning) using Dbms Stats.
Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN and Verities Netback up.
Hands on experience in using dbms packages like DBMS JOB, DBMS SCHEDULAR, DBMS SQL.
Analyzed Tables, Indexes periodically to optimize the SQL queries and assigning proper indexes such as BIT map or B-Tree Index according to requirements.
Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
Experience in using OEM, TOAD, Data Migrations using export/import
Performed complete multi-master replication with updateable materialized views.
Strong knowledge in SQL,PL/SQL
Expert experience in Hot and Cold Backup of databases
Experience in Extracting, Transforming and Loading (ETL) data using SQLloader utility.
Managed Undo Segments in order to avoid "Snapshot too old".
Experience in Tablespace management both local and dictionary.
Experience in ORACLE11g installations
Created roles, profiles and privileges and assigned roles to users.
Automated many common tasks with Scripts by scheduling jobs (crontab) including: Backups, exports and imports, archiving old records and verification of such processes.
Have applied oracle patches for DST, Upgradation and migration of databases.
Experience in working high transacted OLTP systems.
Experience in working with Reporting tools such as Crystal Reports.
Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Raise Application Error, Parameterized Cursors.
Experience in working with different FTP clients like Smart FTP, cute FTP, SFTP and SCP.
Performed 24x7 production system problem analysis and recommend corrective measures in a timely manner.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP

RDBMS: Oracle (8i - 10G,11g), 10g RAC, SQL Server 2005

Languages: SQL, PL/SQL, C, C++, PERL, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDM

Database Modeling: Erwin 4.0, Rational rose

Other: EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship