Summary
Has over 12 years of overall IT experience. The past 10 years focused on Database Administration specifically Oracle. As a database administrator, performed tasks such as database monitoring and tuning, data warehouse modeling, star query tuning, RMAN backup and recovery, RAC implementation, Data Guard, Grid Control and data encryption using both dbms_crypto and TDE. Also experienced in designing/deploying both OLTP and OLAP database systems and making critical decisions in regards to database application implementation. Share expertise and experience with team members and others.

Core Competencies

• SQL Tuning and Oracle Database Tuning
• Database Installation, Migration, & Replication
• Software Development Life Cycle (SDLC)
• Extract, transform and load (ETL)
• Data Integrity, Backup & Recovery
• Ability to convert Perl to PL/SQL

Technical Proficiencies
Databases: Oracle 8i/9i/10g/11g, SQL Server 2000, MySQL
Programming Languages: PL/SQL, Perl, CGI, PHP, BASH Shell Scripting, XSLT
Other Languages: CSS, XHTML, XML
Platforms: Linux (Oracle, Red Hat, Suse), Solaris 9, Windows 2000/2003
Tools: Oracle Enterprise Manager, SQL Developer, SQL*Plus, SQL*Loader, Toad, CVS, Microsoft Visio, Case Studio

PROFESSIONAL EXPERIENCE

Confidential,Bethesda, MD09/05 to Present
Sr. Database Administrator
Work on-site at Metropolitan Washington Airport Authority (MWAA) to install, upgrade and maintain applications running on Oracle Databases and Oracle Application Server. Provide database support for applications requiring Oracle, SQL Server and MySQL database on both Windows and Linux platforms. Work with other vendors and outside contractors to integrate law enforcement systems with other agencies. Update all Oracle servers by applying the most recent patches from Oracle.
Key Contributions:

• Assist manager in most of the project decision making and ensures that every project is completed successfully on time or ahead of schedule.
• Install, configure and support Oracle E-Business Suite running on RAC environment for the ERP team.
• Led team of Oracle DBA to standardize RMAN database cloning when refreshing data from production servers to pre-production.
• Provides 24/7 database and application support, maintenance and upgrade for COTS applications such as: AirIT PROPworks, inPursuit Records Management System, Intergraph Computer Aided Dispatch system, Ross Financial system and RoamSecure.
• Initiate FM1 Oracle Application Server migration from Windows to Linux to stabilize the system.
• Test and document the use of Oracle Data Guard and Grid Control for future applications.
• Upgrade from Oracle 9i DB, Oracle 9i App Server to Oracle 10g DB and App Server.
• Migrate Oracle databases running on Windows OS to Solaris and Red Hat platforms using RMAN.
• Provide Linux assistance to Security and Server Admin group.
• Create audit script in PL/SQL that alerts DBA team of any unauthorized logins.
• Create maintenance script in PL/SQL that alerts DBA team of backup status and low tablespace alerts.
• Provides database expertise and guidance to Orizon when company bids for a new contract.

Confidential,Fairfax, Virginia 04/00 to 09/05
Database Administrator -
Work mainly as an Applications and Maintenance Oracle database administrator running Oracle 9i RAC on Red Hat Servers. Design and update OLTP/OLAP data models for software developers using Microsoft Visio and Case Studio. Participate in design and code reviews to ensure high performance on ETL programs. Deploy production-ready tables on production Oracle databases running Oracle Multi-master Replication and/or Oracle Advanced Replication. Update all Oracle servers by applying the most recent patches from Oracle. Use Perl scripts, PL/SQL procedure and packages to accomplish daily tasks such as populating backup databases, reporting error logs, client setups and generating both company quarterly reports and client custom reports. Documents program pseudo code prior to writing using a standardized template system.
Key Contributions:

• Create and maintains Oracle Data Warehouse.
• Influence company to schedule table analysis using DBMS_STATS.
• Manage company’s 150-200 GB of data on 5 database instances (Linux environment).
• Migrate all Oracle 8i databases to Oracle 9i.
• Co-create an Oracle 9i database running Real Application Clusters using Oracle Cluster File System.
• Turn a 28 million records OLTP heap table into a partition table to ease administration burdens using DBMS_REDEFINITION.
• Implement PL/SQL package to archive, aggregate data and execute without using SQL aggregate functions for tracking customer traffic.
• Successfully recover a 100GB production database that crashed due to disks failures.
• Tunes SQL queries using AutoTrace, Tkprof, SQL Hints written by other programmers to ensure optimum performance.
• Convert Perl dbi scripts running on cron to PL/SQL procedures or packages running on DBMS_JOB.
• Reduce by 70%, time to migrate html to multiple servers by creating a program utilizing Perl scripts to export data to a XML file, transform the XML file to html using XSLT and migrate the html file using Unix SCP.
• Build secured CGI-driven software Usage Reporting tools for CEO to allow user to download results in Microsoft Excel. Reduced reporting task by a minimum of 4 hours.
• Create publishing ready files using Perl scripts to produce the book “Congress at Your Fingertips” appeared on the top 5 of the Washington Post Bestsellers Non-Fiction list.

Confidential,Arlington, Virginia 11/01 to 06/02
Contract Web Developer
Create a database driven template system using MySQL and PHP running on Apache to create html pages for new chapters website. Maintain and update pages based on client requirements.

Confidential,Arlington, Virginia 4/01 to 6/01
Contract Web Developer
Develop a multi-page apartment website. Supervise the design of site by working with graphic designer. Create CGI scripts that allow user/client interactivity.

Confidential,Chicago, Illinois 10/99 to2/00
Contract Web Developer
Develop an E-commerce web site to allow users to customize an order on-line. Supervise the design of the site by working with graphic designers. Configure secure server for secure transaction and merchant accounts.

EDUCATION AND CREDENTIALS

Bachelor of Science in Biology