Oracle Database Administrator Resume

SUMMARY

Enterprise DBA support utilising around 8+ years of Experience in Oracle Database Administrator, providing 24X7 production and development support 11g/10g/9i/8i databases on different platforms like HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
Best practices for Oracle Database Infrastructure, Standards and Implementation.
Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure
Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise
Implement enterprise wide Database Development standards to eliminate time on Database tuning.
Database Installation and maintenance.
Installation of Oracle Databases 8i/9i/10g RAC/11g RAC.
Data Guard setup with Primary and Standby Databases.
Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
Implementation of Grid Control.
Monitoring extract process, replicat, manager processes.
Knowledge in OID, OVD, LDAP.
Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
Configuration of RMAN Backup using VERITAS Net backup.
Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
Physical database design, Logical database desin, normalization, de-normalization
Capacity planning and bench marking
Database security and auditing
Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
Collections of performance data for specific time range using STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL Trace.
Analysis of Database Wait Events.
Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.
Plan optimization applying corrective measures including code restructuring, identifying potential index issues and effective implementation of uniform coding structure to avoid optimizer re-parsing.
Managed extract, replicat, manager processes.
Setup tnsnames in OVD,OID.
Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.
Database trigger, stored procedure & packages PL/SQL coding.
Multiple upgrades of Sun Solaris and Linux servers from 8i,9i to Oracle 10g, Oracle 10g to Oracle 11g.
Excellent problem solving skills.
Excellent written and verbal communication skills.
Result oriented, self motivated, Team Player, Ability to work independently.

TECHNICAL SKILLS

Databases: Oracle 11g RAC, 10g RAC, 9i, 8i, 7.x, MS SQL Server 2005/2008

DBA: Oracle 11g, 10g, Oracle Enterprise Manager, TOAD

System Administration: Red Hat Linux, HP-UX, Sun-Solaris, IBM-AIX Windows 95/98/ME/NT/2003/XP

Backend Scripting: SQL*Plus, PL/Sql, UNIX Shell Script, Perl Scripting.

Network and Connectivity: Windows TCP/IP, VPN Connectivity, Oracle TNS Listener

Development Tool: Visual Studio, Visual C++, Windows/SDK, Visual Basic

Oracle Tools: RMAN, OEM/Grid Control, SQL*Loader, SQL ServerOracle Warehouse Builder, SQL*Plus, DBCA, Import/ExportData Pump, Streams, Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWRADDM

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship