Senior Database Administrator Resume
Bethesda, MD
PROFESSIONAL SUMMARY:
Devoted database administrator with seven years of extensive knowledge and proficiency in security implementation, backup & recovery, high availability and disaster recovery solutions, upgrades, patching, performance monitoring and tuning, migration, and database cloning. Proficient in various platforms such as Linux, Unix, Windows, and various database systems such as Oracle 10g, 11g, and 12c. Enthusiastic problem solver whose able to adapt quickly to a fast - paced environment.
TECHNICAL SKILLS:
RDBMS: Oracle RDBMS 10.2.0, 11.2.01, 11.2.0.4,12.1.0.2, 12.2.1.0.2 , SQL Server (2008/2012)
TOOLS: /UTILITIES: Backup & Recovery (RMAN), Oracle Enterprise Manager 10g & 11g, TDE (AES), Automatic Storage Management (ASM), TOAD, SQL Loader, Oracle Data Guard, Real Application Cluster (RAC), Oracle Apps R12, OBIEE/OBIA, Audit Vault, Oracle Grid Control 10g, 11g, and 12c, Oracle Statspack, SQL Tuning Advisor, SQL Access Advisor, SQL Segment Advisor, Oracle Single Sign-On, PeopleSoft, Workday, Oracle Application Express, Jira, Remedy, Java, AWS, Azure, MongoDB, IBM mainframes (VSAM and ADABAS)
LANGUAGES: SQL, PL/SQL, T-SQL, Shell Scripting, PERL, Bash
OPERATING SYSTEMS: Red Hat Enterprise Linux 5, 6, 7.5, Unix, MS Windows Server 2008/ 2012
PROFESSIONAL EXPERIENCE:
Confidential, Bethesda, MD
Senior Database Administrator
Responsibilities:
- Deploy, administer, patch and maintain all physical and virtual servers hosted by Confidential
- Manage Confidential security requirements for Confidential systems
- Research and implement open source solutions, both local and cloud-based
- Participate in tool and application development (e.g. the DIR repository webpage and several scripts for the import/export of patient data from/to sparse Excel files and clinical databases)
- Deploy, support and extend third-party software and applications for the DIR
- Partner with the Confidential IT organization to continually expand, share and improve support to our scientists.
- Manage shared license service (MATLAB)
- Manage Configuration Management System
Confidential, Washington, DC
Network Database Administrator
Responsibilities:
- Provided day-to-day support for Oracle 11.2.0.4 databases in 24/7 production environment on Red Hat Enterprise Linux servers, as well as Microsoft SQL Server 2012 databases on Windows Server 2012.
- Managed database authorization and database roles/privileges, and enabled database auditing for database security.
- Configured Oracle Transparent Data Encryption (TDE) to encrypt sensitive data.
- Monitored space utilization and optimized performance of Oracle 11g databases using Oracle Enterprise Manager.
- Provided and maintained high availability and disaster recovery using Oracle Data Guard.
- Performed backup and recovery of Oracle databases using Recovery Manager (RMAN).
- Created logical backups of Oracle databases using Data Pump utility.
- Cloned databases using RMAN.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
- Performed bulk load into databases SQL Loader.
- Assisted in system integration of servers (one way transfers and multi-level access solutions)
- Provided troubleshooting and support for user issues.
- Analyzed complex SQL queries, and provided data analysis and interpretation.
- Enforced business rules and maintained data integrity via the use of constraints using DDL statements.