We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume Profile

NJ

Professional Summary

Over ten years of experience as an applications developer, database developer and administrator, database performance tuner, architecture design, business intelligence developer, technical lead and consultant.

Work Experience

Oracle Database Administrator

Confidential

Primary role acted as the database administrator and performance tuner on the State of Maine's Eligibility system. Lead development activities during the implementation of the Affordable Care Act and Oracle database upgrade from version 10G to 11GR2. Designed and built database and operating system performance monitoring utilities using Unix shell and Oracle PL/SQL. Extensively wrote Oracle PL/SQL database procedures, Unix Shell scripts and CA Workload Automation jobs.

Data Warehouse Developer

Confidential

Designed, developed and maintained enterprise data warehouse. Extensively diagnosed load failures, monitored performance issues and conducted performance tuning. Implemented various Oracle scheduled jobs for database maintenance activities including gathering table and schema level statistics and overall database health. Designed and developed Informatica jobs for extracting source data into Oracle data store and data warehouse. Designed and developed utilities for handling nightly job execution, exception handling and recovery of failed jobs.

Oracle Database Administrator

Confidential

Position acted as the primary database administrator for the Department of Health and Human Services applications. Backup database administrator to the Enterprise Data Warehouse for DHHS. Duties included data modeling, analysis, design, creation and maintenance of complex Oracle databases in accordance to agency and data owner requirements while upholding agency standards and policies. Designed and implemented RMAN backup configurations and scripts. Maintained and developed UNIX shell scripts for data loading. Regularly performed system performance and query optimization, structural or procedural changes as needed. Ensure daily systems availability, performance and integrity while addressing production problems.

Systems Analyst/Web Developer

Confidential

Design, created and maintained international corporate expense management system powered by Concur technologies. Lead the application maintenance of internal corporate card request/issuing application using ASP.Net and C .Also, designed web based application to support internal audit staff activities of expense reports generated through expense management system. Extensively built new functionality to audit application using C and Oracle PL/SQL to quickly generate reports to executive members. Diagnosed database performance issues and managed nightly database jobs.

Systems Development Specialist

Confidential

Primary role acted as technical lead developer on the Department of Health and Human Services enterprise data warehouse. Administrator for the Congo's reporting servers. Developed and maintained complex Oracle packages and UNIX shell scripts for extraction, transformation and loading of data, creation and maintenance of ETL job scheduling using Oracle Job scheduler and UNIX Cron. Designed and implemented procedural code to log entries for all data mart processes in an effort to track performance, errors and recover failed jobs from point of failure. Used variety of tools to target inefficient code and resolve critical production failures. Ensured daily production database jobs ran to success and available for data warehouse users.

Systems Development Specialist

Confidential

Code, modified, maintained and integrated moderate to complex programs from detailed/general specifications. Developed Oracle PL/SQL packages and SQL scripts for various applications and reporting tools. Designed, created and maintained delivery method of client server applications to end-user desktops utilizing Microsoft's System Management Server SMS . Designed and executed user test plans against system changes. Conducted end-user training for release scheduled application changes. Supervised and coordinated other development staff application changes to ensure timeliness of release schedule.

Skills

Oracle 9i/10g/11g. SQL, PL/SQL, RMAN, UNIX, Database Administration, Data Warehousing, Power Builder versions 8/9/11, SQL Server T-SQL, Java Scripting, Congo's BI, CA Workload Automation, All Fusion Harvest, VB.NET,C , technical writing, project leadership and mentoring.

Hire Now