SUMMARY:

• For the past 30 years Confidential has worked in every phase of the Software Development Life Cycle. In a number of cases he has done everything: Designed the database, loaded the tables, wrote the programs, setup the website, installed the software and tuned the system.
• He has worked as an Oracle & SQL Server DBA (Production, Development and Conversion)
• He has completed over 25 Oracle contracts. Five for Oracle Corporation
• He has performed 12 Database Conversions All Involving ETL, Extraction, Transformation & Loading
• He has 20+ years of PL/SQL experience.
• He has written hundreds of packages and procedures

TECHNICAL SKILLS:

DATABASES: ORACLE, Microsoft's SQL*SERVER, INFORMIX, DATACOM DB/DC, SQL/DS, DBASE, RBASE, XDB, FOXBASE, ACCESS, CLIPPER, CTREE, SUPERBASE, NOMAD 2, MODEL 204

LANGUAGES: JAVA, C/C++/C#, PERL, COLDFUSION, PHP, AJAX, JAVASCRIPTOPERATING SYSTEMS WINDOWS, SOLARIS, LINUX, MS DOS

OTHER SOFTWARE: ORACLE S Jdeveloper & Warehousebuilder, SoapUi, TOAD, Erwin Eclipse, Mapitude s GISDK, Visual Studio, Toad

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Senior SOA, Java & PL/SQL Developer

Responsibilities:

• Fixed bugs in numerous PL/SQL packages running in a large Data Warehousing environment.
• Fixed a SOA/BPEL bug in a large application using JDeveloper and Weblogic Admin Console.
• Fixed a DBA bug caused by a bad DB Link between 11g and 12c Oracle databases.
• Wrote half of a jQuery UI frontend, Java Spring API backend application using eclipse and Tomcat
• Developed a small Data Warehouse application for Confidential .

Confidential, Washington, DC

Senior Oracle DBA/ Java Spring, jQuery Developer

Responsibilities:

• Served on a small Agile team converting an archaic Oracle Forms system to a modern website..
• Created an Oracle Database instance on a Linux server in AWS using silent install.
• Created numerous database views based upon the code of the Oracle Forms 6.0 Application.
• Created various parts of the backend Java Spring API using eclipse and Tomcat 7.0
• Created various parts of the jQuery UI using JSON to communicate with the API

Confidential, Arlington, VA

Java, PL/SQL Developer

Responsibilities:

• Participate in a major Oracle database migration. As such moved about two dozen schemas and their objects on about two dozen servers from 11G to 12C. This involved using TOAD to unload the objects and sql - loader to load the objects.
• Developed multiple Java Web Services in support of the CA-NLETS effort to do background checks on Drivers Licenses for the Dept. of State. Developed numerous interfaces to these sites in Java (jax-ws), SOA/BPEL and PL/SQL
• Developed a Java application that imported XML data, (images and test) from the National Center for Missing and Exploited Children website and stored them in Oracle 12C database.

Confidential

Oracle DBA/Developer

Responsibilities:

• Designed and Created the 11g Oracle Database.
• Developed a PL/SQL Simulation Model to represent the flow of 100,000 customers using 50,000 vehicles traveling between 5,000 urban locations on a minute-by-minute basis.

Confidential

Oracle DBA/ Fusion Middleware Developer

Responsibilities:

• User Oracle’s Fusion Middleware PL/SQL Web Toolkit to convert about 150 web screens and reports originally written in Oracle Reports and Oracle Designer.
• This project employed PL/SQL and Javascript.

Confidential, Fairfax, VA

Oracle DBA/Developer, and Sql Server DBA/Developer

Responsibilities:

• Created multiple databases and wrote various PL/SQL and T-SQL procedures
• Created a SQL server database and used SSIS to extract millions of records from an Oracle DB.
• Created a local replica of the ALTHA Database by importing over twenty different schemas .
• This involved debugging about a hundred PL/SQL procedures and triggers
• Created a procedure to generate millions of Oracle patient records in PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed and debugged PL/SQL procedures on a case by case basis
• Created logical and physical data models using Erwin
• Wrote stored procedures, functions, triggers and packages using PL/SQL

Confidential

Oracle DBA/Website Developer

Responsibilities:

• Designed and Created the database using Oracle 10g, and wrote all of the software.
• Wrote a Point-of Sale Unit in C and a Vehicle Control Unit, also written in C, which was in radio in contact with the Point-of Sale-Unit, and a Central Control System.
• The Central Control system, consisting of a Serial Communications Program was written in PRO*C operating under Solaris.
• Built a website which was written in ColdFusion MX/Java script residing on a Linux Computer. The purpose of the website was to allow customers to make vehicle reservations online.

Confidential

Oracle DBA / Website Developer

Responsibilities:

• While Serving as the Senior Oracle DBA, Confidential also designed and built an Internet Site using Coldfusion, Java Scripts, and Oracle Database Triggers. The website involved over 450 web pages and 200,000 lines of code.
• Trained over 250 users and in one year's time increased the transaction rate from one per month to over twelve hundred.
• Maintained the help desk and fielded questions from attorneys and judges throughout the day.
• Built a user feedback mechanism to encourage continuous improvement. Rewrote the system four times.
• Converted the data from an IBM mainframe environment to an Oracle Database and kept the machines in sync throughout the day.

Confidential, Fairfax, VA

Oracle DBA /Developer

Responsibilities:

• Built an Internet Site using Oracle's Application Interface 9i, Oracle Forms 6i and an Oracle 8i database. This was done in a Windows NT environment.

Confidential, Fairfax, VA

Oracle DBA

Responsibilities:

• Kept databases running, developed backup procedures, developed an Oracle WebDB interface to the system as well as an Oracle Forms 6.0 interface.
• Installed Oracle Replication on the system and used Erwin for database configuration.

Confidential

Oracle DBA (Production DBA)

Responsibilities:

• Performed day-to-day production DBA functions. (HP)

Confidential, Fairfax, VA

Oracle DBA and Conversion Specialist

Responsibilities:

• Took records from a hierarchical structure and reinserting them with new keys, while maintaining data structure integrity.

Confidential, Charlotte, NC

Oracle DBA (Development DBA)

Responsibilities:

• Kept fifteen different databases running for five different development teams and at the proper configuration using Erwin on a SUN platform

Confidential, Fairfax, VA

Oracle DBA and Conversion Specialist

Responsibilities:

• Converted two UNISYS DMS1100 databases to ORACLE 7.3.4 databases operating under UNIX on an HP T700.
• Created all of the database structures and loaded the tables
• Wrote Perl and DOS Shell scripts.
• Tuned the databases resulting in performance that was six times faster.

Confidential, Fairfax, VA

Oracle DBA and Conversion Specialist

Responsibilities:

• Converted a SQL*Server database on Windows/NT and its C++/ODBC application to a C++/ODBC application using an ORACLE 8.0 database.