Oracel DBA Resume

Title
Oracel DBA

Primary Skills
Oracle DBA,Oracle 10g/9i/8i and 10g RAC.UNIX (Solaris, AIX, HPUX), Windows 2000 AS, 2003, Linux Redhat AS4

Location
US-CA-SFO (will consider relocating)

Posted
Mar-03-09


Executive Summary:
• More than 6 years of extensive experience as Oracle 10g/9i/8i Database Administrator
• Experience as a Production support/Operations DBA with Multi-Terabyte 24x7/large databases and as a Development/Engineering/Data Warehouse DBA
• Hands on experience in RAC (Real Application Clusters), Dataguard/StandBy and Grid Control on various Platforms including RedHat Linux, AIX,Solaris and Windows Servers
• Expert level knowledge in PL/SQL Programming (Writing stored procedures for Packages Implementing functions, triggers, collections)
• Excellent knowledge in working with physical & relational models of the database, Data Modeling using ERWIN in a development environment/multiple environments.
• Hands on experience in setting up & administering Oracle Streams. Configured replication based on Oracle Streams.
• Supported Oracle Data Warehouse databases, complex queries, de-normalized schemas, Performance related issues related to Data warehouses.
• Experience in Installations, Configuration, Maintenance, Support and Patches
• Good hands on experience in Database backups, user-managed backup/RMAN-managed backup with or without catalog, operating system backup, cold and hot backup
• Performance tuning, optimization, troubleshooting using AWR & Statspack, Stats gathering, CBO,QEP, TRACE and Events setting
• Experience in latest features like Data Pump, Flash-Back Recovery, ASM, ADDM, ASSM and Recycle Bin.
• Experience in data management tools like SQL*Loader, EXP & IMP
• Extensive working Knowledge of Enterprise Manager/ Grid Control.
• Configure & manage standby database for disaster recovery & business continuity (Data Guard).
• Experience in handling tools such as Toad.
• Experience in Database Security frame work and SOX procedures, Users, Roles, Profiles and resource Management
• Experience in capacity planning, space management, Rollback segments and Undo segments.
• Experience in shell scripting and scheduling jobs using cron, DBMS_JOBS, DBMS_SCHEDULER
• Monitoring and managing the space usage and table partitioning.
• Very good team player and self-starter with the ability to multitask.
• Excellent communication and interpersonal skills.
• Strong conceptual, business, analytical skills and innovative problem solving abilities.
• Very good at Unix and Linux.

SKILL SET:

Hardware Systems:
Sun, IBM RS/6000, pSeries, x86, x86_64, I64, SAN(IBM DS8300) NETAPPS,EMC
Storage: DS8300, EMC, NetApps, Sun StoreEdge T3+
Operating Systems: UNIX (Solaris, AIX, HPUX), Windows 2000 AS, 2003, Linux Redhat AS4

System Management Tools: Oracle Grid control, TOAD, Oracle Enterprise Manager, Oracle RMAN, Quest Software (toad), ASM

Programming & Scripting Languages: JAVA, C, PL/SQL, SQL, Shell, HTML

Development Tools: SQL*LOADER, datapump, EXPORT/IMPORT, PL/SQL, SQL*PLUS

Database: Oracle 10g/9i/8i and 10g RAC.

Tools/Utilities: Data-pump, Data Guard, SQL*Loader, DBCA, OEM, TOAD, RAC, ASM, RMAN, TKPROF, AWR, STATSPACK

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in SFO, CA | Resumes in California

View other Oracel DBA resumes, Database Administrator resumes