Oracle Database Administrator Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Certified (OCA) Database administrator (DBA) with extensive experience designing, coding, testing tuning, and supporting next - generation database solutions in Oracle enterprise environments.
- Proficient in an assortment of technologies, including Oracle 9i/10g/11g, Java, C++, UNIX, Linux and Windows.
- Languages: English, Spanish, and Portuguese
TECHNICAL SKILLS
Languages (proficient): SQL, PL/SQL, Unix Shell scripting
Languages (familiar): Java, C++
Database: VLDB Oracle 9i, 10g, 11g Enterprise Server
Platforms: Windows, HPUX, Linux Unbreakable
Oracle: RMAN, ASM, RAC, AWR, ASH, ADDM, SQL Advisor’s, SQL Developer, DBCA, SQL*NET, Wallet, SCAN, OEM/Grid Control, dbv, opatch, csscan
PROFESSIONAL EXPERIENCE
Confidential
Oracle Database Administrator
Responsibilities:
- Manage and maintain Oracle DBA (24X7) Development, Test and Production Oracle 9i, 10g, 11g Real Application Cluster (RAC) Databases, physically and logically.
- Performed Unicode Conversions, SQL PL/SQL Tuning, Unix Shell scripting and Oracle installations.
- Created and improved Unix Shell Scripts to monitor database health, utilization, alerts and performance.
- Implemented compression, partitioning, data masking, cloning, and user and space management and planning.
- Assist development and application teams with analyzing less TEMPthan optimal process/system performance.
- Worked with Oracle Support troubleshooting bugs and ORA errors, and applied patches as recommended/required.
- Analyzed AWR, ASH, ADDM, and traces to resolve performance issues, hatches, locks, and waits to meet performance and availability requirements.
- Gather statistics, histograms, and database metrics for system performance.
- Prioritized and resolved high volume of client and internal user requests, in addition to performing fast-paced installation and qualification procedures with deadlines.
- Performed backups, restores, and refreshes of databases and applications, ensuring uninterrupted availability of client’s production systems.
- Monitored and optimized performance, resources, availability, and operation of all systems.
- Added, modified or removed users, roles and privileges, profiles, and other data accesses.