Database Administrator Resume
Bowie, MD
OBJECTIVE:
To obtain database administration/analyst position with my expertise and experience in performance tuning, crisis management plus efficient and reliable utilization of my hands - on skillset and training to improve productivity that can support next generation database solutions in oracle enterprise.
SUMMARY:
Over 4 years’ experience as an Oracle Database Administrator using Oracle 10g, 11g and 12c.Operated as a member of the systems administration team managing multiple Linux systems for over 2 years implementing steady maintenance of configuration settings and controls in the test and development network. Highly diligent, supportive, also a terrific team player with a great attitude that thrives on challenge. Exceptional listening and creative problem solving skills with excellent communication, also interpersonal skills and training to end-users on specific applications.
TECHNICAL SKILLS:
Languages: SQL (Data Definition Language, Data Manipulation Language)
Relational Databases: SQL Server, Oracle 10g, 11g and 12c
Software: Microsoft Windows XP/Vista/7/8, EMR, and Outlook, Virtual Box, MobaXterm, VMWAREMS Office 2010, Red Hat Linux (RHEL 6.5) operating system, Active directory
Software Applications/Tools and Utilities: OEM, RMAN, RMAN DATABASE DUPLICATION,DATA MIGRATION - EXPORT-IMPORT, PROCEDURES, PACKAGES & FUNCTIONS-BACKUP &RECOVERY PERFORMANCE TUNING,CRONTAB,SHELL SCRIPTING,AWR,SCHEDULER.
EMPLOYMENT:
Confidential, Bowie, MD
DATABASE ADMINISTRATORResponsibilities:
- Provide Oracle database administrative support to various user groups (application developers, data managers etc.) create and maintain Oracle database objects (schemas, tables, indexes etc.).
- Analyze and tune voluminous SQL code.
- Tune databases to improve performances to make objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
- Excellent capacity planning knowledge in terms of memory and disk usage, establishing benchmarks for business and technical performance.
- Created and managed custom Oracle databases on Linux and windows platforms
- Scheduling backups using the crontab utility.
- Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
- Excellent skills using secure copy for files between databases on different servers.
- 24 hour on call rotation.
- Performed data migration from a database in one server to a database housed on another server using database link.
- Migrated data using the data pump export (expdp) and import (impdp) utility.
- Excellent skillset in cloning using cold backup, hot backup and RMAN.
- Registering databases and listeners to OEM Cloud Control 12C.
- Monitoring Alert logs for any errors, problems or processes running.
- Create and Assign Roles, Privileges and Profiles to various Users.
- Created and configured listeners for databases using NETCA or TNS/LISTENER.ora files.
- Expertise on backup and recovery tasks on Oracle database using RMAN and cold back - ups using shell scripts.
- Effective experience using RMAN to restore and recover control and data files respectively.
- Efficient performance of flashback and point in time recovery.
