Oracle Development DBA Resume , Alexandria, VA - Hire IT People

SUMMARY:

TECHNICAL SKILLS:

DATABASES: Oracle 12C, 11g R2, R3, R4; 10gR3; 9iR2; 8i.MS SQL*Server 2000, 7.0, 6.5, 7.0 and 2000.

LANGUAGES: SQL, PL/SQL, VB.NET.

Software tools: Toad Oracle Suite, Embarcadero ER/Studio data architect, ERWIN, PLSQL Developer, DBArtisan, RAPID*SQL, SPOTLLIGHT.

HARDWARE: Intel - X86, SUN (E1000, 6500, 4500, SPARC, ULTRA), DEC - ALPHA 8400, 8200 and 4100.

OPERATING SYSTEMS: RedHat Linux, MS-WINDOWS (2013; 2007; 2000; NT), SOLARIS.

WORK EXPERIENCE:

Oracle Development DBA

Confidential, Alexandria, VA

Responsibilities:

Model OLTP and DSS databases (both at LDM and PDM levels) to meet the application requirements for COMPASS projects. Used ER/Studio data architect.
Lead a team of three DBAs to manage our dev, test and Prod environments.
Develop, test and deploy DB changes scripts based on requirements for the project enterprise ELDM.
Tune database performance to enhance response time through various mechanisms: SQL tuning, memory (SGA) tuning, I/O tuning and partitioning of large tables based on certain keys.
Develop, test and deploy PL/SQL modules: Functions, Procedures, Packages, Triggers to meet business requirements.
Manage Dev, Test and Training DB environments.
Install and configure Oracle 12c and 11g as needed by the development teams.
Participate in DB design and modeling using Embarcadero ER/Studio.
Support Production deployments and releases through SDLC agile methodology.
Lead a team of three DBAs to manage our dev, test and Prod environments.
Assign and track tasks for each team member.
Review tasks accomplished to make sure we meet the requirements and SLA expectations.
Report back to management regarding tasks accomplished, tasks in progress, risks, obstacles and possible resolutions to each issue.

Oracle Development DBA

Confidential, Washington, DC

Responsibilities:

Develop, test and deploy DB changes scripts based on requirements for the project enterprise DB.
Develop, test and deploy PL/SQL modules: Functions, Procedures, Packages, Triggers to meet business requirements.
Manage Dev, Test, Training and Prod DB environments.
Tune database performance to enhance response time through various mechanisms: SQL tuning, memory (SGA) tuning, I/O tuning and partitioning of large tables based on certain keys.
Install and configure Oracle 10g, and 9i as needed by the development teams.
Participate in DB modeling using ERWIN.

Oracle Development DBA

Confidential, Rockville, MD

Responsibilities:

Design an enterprise - wide database repository to store the Grants awarded by the department to various research and educational facilities allover the USA.
Model the databases in Erwin for large transactional and warehouse systems.
Design an Oracle-based replication mechanism to replicate large amounts of data from the NIH central database down to the NIMH data mart.
Implement and develop PL/SQL modules (functions, procedures, packages, triggers) for maintaining and enhancing the functionality of the databases.
Install, tune and maintain 10 Oracle databases for GID/GMIS to support around 2000 users nation-wide.
Gather requirements to Develop, design and implement a unified database system for DHHS.
Analyze various database modules for possible integration and centralization.
Tune database performance to enhance response time through various mechanisms: SQL tuning, memory (SGA) tuning, I/O tuning and partitioning of large tables based on certain keys.

Oracle DBA / DATABASE & SYSTEMS ANALYST

Confidential, Fairfax, VA

Responsibilities:

Design a Corporate wide database repository to store the Organizational Hierarchy of all the facilities owned and managed by WM.
Model databases in Erwin V4.0 for large transactional and warehouse systems.
Implement and develop PL/SQL modules for maintaining and enhancing the functionality of the databases.
Install, tune and maintain 5 oracle databases for Corporate and facilities database on IBM AIX and NT/2000.
Gather requirements to Develop, design and implement a unified database system for Corporate and organizational hierarchy for WM.
Analyze DB modules for possible integration.

ORACLE Development DBA / SYSTEMS ANALYST Consultant

Confidential, VA

Responsibilities:

Design, model and implement the GeneExpression Data Warehouse (GXDW).
Design a pattern recognition module for identifying features in a chip of DNA patterns.

ORACLE Development DBA / ORACLE ARCHITECT / DBA

Confidential, RESTON, VA

Responsibilities:

Serve as a Senior Systems Analyst / Database Architect / Database Administrator in the area of systems development for the EPA community on the Standard Reference Tables (SRT), Facility Registry System (FRS), and Data Registry (DR) projects.

SOFTWARE ENGINEER

Confidential, College Park, MD

Responsibilities:

Designed and implemented programs in C language for IBM 370, UNIX, UNIVAC 1100/92, IBM?PS/2 systems to monitor and improve their performance when running Data Bases in a multi-user environment.