Cloud / Data Architect Consultant Resume

SUMMARY

Strong math and analytical aptitude
15 - year program management and technical leadership experience
Eager to learn new things, vision oriented
20+ years database ( Oracle, PostgreSQL, MySQL ), 5 years Python, AWS service solutions

PROFESSIONAL EXPERIENCE

Confidential

Cloud / Data Architect Consultant

Responsibilities:

Provided data and cloud architect consulting service for a federal contract involving a cloud service lift and shift process for an Oracle DoD application to Amazon Web Service (AWS) GovCloud
Set-up EC2 instance and configuration set-up for RDS and Aurora

Confidential

Data Architect / Research Associate

Responsibilities:

Using Big Data analytic alrogithms, created ETL Python and shell scripts to ingest GB’s of near real time NWS and FAA data, de-duping, filtering, thresholding and normalizing to one common format before persisting to six PostgreSQL and MySQL databases
Worked side-by-side with data analysts to develop tool requirements making the code more operationally robust to be handed off to a third party
Created backend database stored procedures queryable by the front end ( java, Django )
Tuned systems from data ingest to SQL tuning to database optimization
NoSQL, Hadoop, AWS Cloud research and testing

Confidential

Oracle Database Administrator, Developer

Responsibilities:

Extensive SQL and database tuning: Statspack, explain plan, tkprof, trace, utlbstat/utlestat, OEM Grid Control’s AWR, ADDR packages
Database upgrades and quarterly patching with CPUs and occasional one-off Oracle bug fix patches (opatch)
Developed and tuned Oracle PL/SQL procedures, packages and functions
Designed the database architecture, database physical design (SQL*Plus and shell scripts), database logical design (Toad, PowerDesigner)
Migrated the QA databases and then production (with standby) from Oracle 9i to 10g to 11 complete with rollback procedures
Implemented Oracle Data Guard (both physical and logical configurations) between two different vendor data centers with periodic fail-over tests
Set-up Oracle Streams and Change Data Capture (CDC) for data replication

Confidential

Research Associate

Responsibilities:

Technical lead and software engineer for a K-12 science and education program called GLOBE ( globe.gov ).
Oracle DBA supporting multi-master Oracle symmetric replication. Oversaw the physical and logical design of the databases (using PowerDesigner and Toad), and tuning of the applications and databases.
Involved with all aspects of the software lifecycle for the website.
Code was written in Perl and Oracle SQL / PL/SQL.
Later performed some contract work in support of the project