SUMMARY:

• 30 years’ experience managing Oracle databases with at least the past 3 years working with Oracle 11g
• The largest Oracle database that I have worked with was 20 Terabytes (20 TB).
• The DHS IIDS (Integrated Immigration Data System) took 24 hours to refresh.
• I have migrated 5 Terabytes from Oracle 12 to a Confidential Postgres instance during my last contract with the College Board on a weekly basis.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Senior Oracle DBA

Responsibilities:

• I worked as a consultant development DBA at the College Board. I developed the EVENTS schema for the new SAT and PSAT using ER Studio.
• Generated the DDL and triggers. Wrote PL/SQL to migrate old PSAT and SAT records to new system.
• I worked with the Analytics group developing new schemata in Oracle 12g and Amazon Confidential .
• I translated Oracle DDL to Postgres, developed the grants and permissions for the Confidential databases, and developed the Confidential (distribution key) strategy for the Confidential nodes.
• I also worked with the AP Teacher Scoring and Access To Opportunity programs.
• The contract was for one year.

Confidential, Arlington, VA

Senior Oracle DBA

Responsibilities:

• I transitioned to Confidential while continuing to support the United States Postal Service Office of the Inspector General (USPS Confidential ).
• I continued to support Confidential ’s development, quality assurance, and production databases while also implementing a new development, quality assurance, production environment for a data warehouse project.
• I added an integration database to the existing application environment to assure better quality on new software development.
• I assisted in transitioning the Inventory COTS package from an Oracle database to a SQL Server database and facilitated the inter - action of that database with the existing Oracle database using Oracle Gateway I migrated all Oracle databases from 10.2.0.4 to 11.2.0.3 on new hardware using Oracle's Datapump via a database link.
• I implemented data feeds to Confidential ’s Cornerstone and Agilquest vendors.

Confidential, Arlington, VA

Senior Oracle DBA

Responsibilities:

• I worked as a consultant for Confidential at USPS Confidential as a production and development DBA with the Application Development group of the CTO.
• I ensured the availability and performance of their development, quality assurance and production databases containing over 1 terabyte of data.
• I supported the developers in implementing bug fixes, implemented an automated backup methodology, and supported monthly releases of new software and features to existing applications.

Confidential, Washington, DC

Senior Oracle DBA

Responsibilities:

• I worked as a development DBA for the Confidential Secure Communities Dashboard.
• I developed and implemented the database schemata, set up the data replication via materialized views, did a small amount of data transformation, and set up automated jobs to refresh and backup the database.
• I created all the database scripts and documented their implementation.
• I worked as a development DBA supporting Confidential ’s IIDS ( Confidential Integrated Decision Support) data warehouse.
• This consisted of two databases containing nearly 250 Gigabytes of data; a staging database where the Extraction, Testing and Loading (ETL) of the data occurred and the target database where the users queried the processed data using Oracle’s Hyperion BI tool. Data was replicated from the source to the staging database using Oracle’s materialized views and from the staging to the target database using a combination of Oracle’s materialized views and Infomatica ETL processes.
• I also supported the development and testing environments of the IIDS.
• I developed and implemented the physical databases, wrote over 1,400 SQL and PL/SQL scripts, and several procedures including an extensive package to manage the data workflow. I interacted extensively with the ETL and BI tool teams, the production DBA task members, and the end customer.
• I documented the IIDS in the VDD and used Version Manager (VM) to maintain configuration control.
• I prepared and maintained the traceability matrix and prepared the test and acceptance plans for each release.
• I was an Oracle development DBA supporting the Enforcement Arrest and Release Management ( Confidential ) development team.
• We developed a Java based application for Confidential using a Sprint Agile Development methodology.
• I was able to document a 300% increase in application through-put by use of bind variables and Sql tuning in the Oracle database.
• I designed, implemented, and maintained the development database on a Dell blade server using Windows Server 2003 and Oracle 9i.
• We implemented the web-based version of Ident for use with Confidential .
• I was an Confidential development DBA for the INS (now Confidential ) under the Confidential Security. I supported developers in enhancing and adding new functionality to the Confidential application and the Confidential (Enforcement & Identification Database) RAC database.
• I analyzed SQL and PL/SQL to optimize response time using Explain Plan, Statspack, Oracle Enterprise Manager (OEM), SQL Impact and SQL Lab. created and maintain 22 related development, test, migration and training Oracle databases, including the Confidential development, testing, training and migration databases, that were either full copies or extracts of the production database.
• Each database contained over 7,000 database objects and over 20,000 grants and privileges that needed to be maintained.
• I created PL/SQL scripts to add new objects, tables, views, synonyms, grants, and triggers.
• I supported the developers, testers and trainers and established and administered their Oracle userids.
• I assisted in setting up a training/lab center for Ident biometrics. This consisted of tying the new version of the application to an image database of photographs and fingerprints.
• I was responsible for migrating the CAIS application and database from the IHP database to the Confidential and integrating the CAIS data and database objects with the existing database. This involved remapping the primary and foreign keys of over 2,000,000 rows of data without loosing the data integrity of the CAIS data or disrupting the integrity or availability of the existing Confidential data.
• I was the primary support for the Confidential Snapshot/Datamart database. This used Oracle Advanced Replication to maintain a "snapshot" of approximately 60 of the most interesting tables in the Confidential database. Database triggers populated 4 datamarts that present the data to end users in an aggregated format. I ensured that the replication worked and that new users were added with the appropriate privileges I upgraded the operating system of the server from Windows 2000 Service Pack 1 to Windows 2000 Service Pack 4, upgraded the Oracle RDBMS from 7.3.4 to 8.1.6 to 9.1.0 to 9.2.0.3.0, and researched and recommended specifications for new database and application servers.
• I used Confidential Tracker and Version Manager (VM) for configuration management and used Symantec pcAnywhere and Cicso VPN for remote server management.
• I was responsible for upgrading the anti-virus software on our Intel based servers.

Confidential, Herndon, VA

Senior Oracle DBA

Responsibilities:

• I was a contractor with Oracle's Confidential Group. was responsible for 6 terabytes of e-mail data in an Oracle 8.1.6 High Availability Parallel configuration (Dataguard) on two HP-9000s.
• I provided second level support for e-mail clients.
• I monitored and tuned database and Confidential

Confidential, Vienna, VA

Senior Oracle DBA/Task Lead

Responsibilities:

• I was responsible for a database migration task that moved 25 years of Confidential Civilian Employee Personnel records off IBM mainframe to an Oracle 7.3.4 database on HP 9000.
• I coordinated with Java developers to optimize SQL and PL/SQL code using Explain Plan and my own suite of tuning scripts.
• I designed, developed and implemented the database of 500,000,000 records in 700 tables comprising over 60 Gigabytes of on-line data and 600 Gigabytes of archived raw data.
• I managed and coordinated junior DBAs and interfaced with Java developers and UNIX system administrators.
• I implemented Phase III of SEI methodology. I created a data warehouse for the Confidential Budget with Oracle 8.1.5 on a Sun Solaris platform.

Confidential, Alexandria, VA

Oracle DBA

Responsibilities:

• I maintained and tuned 11 Oracle 7.1.4 and 7.3.2.3 instances running on three IBM RISC 6000's and a HP 9000 at the Confidential (PERSCOM). I debuged and tuned PL/SQL.
• I developed a suite of SQL and AIX scripts to monitor the database and predict future problems.
• The data consisted of the personnel records of active, retired, reserve, Confidential, and civilian employees. Support junior DBAs and application developers.
• I maintained user access and privileges. The databases comprised over 100 Gigabytes of tablespaces on RAID and SAA devices.
• I was a member of a team that investigated the feasibility of implementing Oracle's High Availability Parallel Server.