SUMMARY:

Have over 18 years of progressive experience in database design, application development, and production deployment throughout the lifecycle. Technical strength includes logical/physical relational and dimensional database design and implementation, database configuration, backup and recovery, performance tuning, Shell and PL/SQL scripting, data warehouse construction for OLAP and ETL design.

TECHNICAL SKILLS:

DBMS: Oracle 8i/9i/10g/11g, Informix

Oracle: SQL*Loader, Data Pump, Import/Export, Partitioning, Replication, OEM, Backup/Recovery, RMAN, Upgrade/Patching

Software: Erwin, Oracle Discoverer, System Architect, Toad, SQL Developer

OS HP: UX, Sun/Solaris, AIX, Linux, DOS, VMS

Languages: PL/SQL, SQL, SQL*Plus, Pro*C, 4GL, UNIX Shell, C, HTML

Hardware Red Hat, Microsoft Windows, HP: UX PA - RISC, SUN-SPARC, IBM/RS6000, Confidential 6000/80, VAX (8820, 11/780)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Database Developer/DBA

Responsibilities:

• Manage the database design, administration, and development for the Confidential International Affairs projects.
• Review the VSPTS data model for compliance with the Confidential enterprise data model and develop the Data Management Plan which include specification of major subject areas, data dictionary and detailed physical database implementation.
• Involve SDLC process to develop the VSPTS 2.0 System by capturing requirements, providing database advice and solution to in corporate the business processes into database design using scrum framework.
• Design and implement the ETL process to import the data from external systems. Tasks include data analysis, data mapping, logical/physical database design using Erwin, data conversion, and programming in Shell, SQL scripts and PL/SQL.
• Configured and setup the database environment in Oracle 10g on MS Windows and Red Hat Linux server. Developed the installation scripts for DEV/FQT/UAT database releases and upgrades.
• Troubleshoot database related issues and provide after hour on-call support. Apply production release upgrades during non-peak hours.

Confidential, Alexandria, VA

Sr. Database Administrator/Developer

Responsibilities:

• Lead the database migration from Oracle 8i/9i to 10g on HP-UX and Window XP platforms.
• Performed Oracle 10gR2 installation and instance configuration.
• Determined migration methods for different applications based on the database nature.
• Provided DBMS expertise and guideline to the team and users.
• The daily tasks include: data loading, data copy and data transfer; production support in various database issues; backup and recovery; optimizing SQL scripts and database performance.
• Designed and developed data models using Erwin in support of application enhancement to in corporate with existing data model, and analytical reporting repository to develop various reports using Oracle Discoverer.
• Applied Oracle Critical Patches regularly; implemented government security requirements using 10g Network Data Encryption and Transparent data Encryption.

Confidential, McLean, VA

Database Administrator

Responsibilities:

• Lead the database design, development and implementation in a decision-support application to support Health Care business intelligence project. Duty included Data Modeling in Multi-dimensional Database Design (Star Schema), Oracle installation, database migration/upgrade, database creation, database maintenance, performance tuning, and backup/recovery implementation in a Data Warehousing environment under Oracle 8.1.7/Sun Solaris.

Confidential, Herndon, VA

Database Engineer

Responsibilities:

• Worked on the Confidential Wireless Web Product Reporting System and Confidential Billing Data Warehouse project that converts the old data repository to a new data warehouse, responsible for database design, data mapping, data transformation using Informatica 5.0 ETL tool and Erwin 3.5 in the Oracle 8.1.7/Sun Solaris 2.7 environment.

Confidential, Reston, VA

Oracle DBA/Developer

Responsibilities:

• Worked on the Concert Financial Billing Data Warehouse System (using MicroStrategy DSS Architect/Agent 5.5 in Oracle 8.0.5 on HP-9000/UX environment, responsibilities include gathering user requirements, coding enhancement (PL/SQL), monthly data loading, creating various financial reports in a large scale of Oracle 8.0.5 database on Sun Solaris/Unix Server.

Confidential, Reston, VA

Oracle DBA/Developer

Responsibilities:

• Designed and implemented the interface between the Global Customer Database System and CTTS (Common Trouble Ticket Systems) by setting up replication in Oracle.
• Converted and transformed the Relational Data Model into the Star Schema to enhance the reporting capabilities.

Confidential, Reston, VA

Oracle Application DBA

Responsibilities:

• As an application DBA lead in IMD Revenue System.
• Responsible for 2 HP 9000 K-series servers running HP-UX 10.20 and over 15 databases using Oracle 7.1.6/7.3.3/7.3.4 , managed 4-5 DBAs to support more than 10 development projects.
• Developed and implemented database naming standards, migration plan, and backup/recovery strategy for development group.

Confidential, Reston, VA

Programmer Analyst and Developer

Responsibilities:

• Be responsible for database design and implementation for the Jail Management System in a client-server environment.
• Developed the data model and Data Dictionary in System Architect, created Oracle instances and all database objects, set-up development/testing environment, support all the database changes, developed Oracle packages, store procedures and triggers.