Senior Data Architect – Clearance Desired

Overview

Seeking a senior data architect to oversee data architecture for large scale API and web application back end data store and implement ETL processes to supply application data for usage in the web application.

Responsibilities

• Oversees data architecture for large scale API and web application back end data store. Implements ETL processes to supply application data for usage in the web application.
• Manages critical low latency application databases on platforms.
• Develop packages and scripts for system enhancements and interfaces.
• Develops scripts to validate the various data on systems. Involve in writing queries to improve the database performance and availability.
• Must use process through the ETL and refresh to identify, troubleshoot, and correct code problems.
• Develop, implement, and execute a quality assurance program and quality control standards for all activities. Executes statement to create and update various tables and views utilize for testing of code on an database.
• Establish database backup/recovery strategy using user-manage backup.  Engineer extensive database solutions and interfaces enabling performance of data requests. Develop reusable components for deployment in a traditional data warehouse environment.
• Standardize database maintenance activities by standardizing directory structure, documentation of DBA activities.
• Establish backup and recovery options and implement automation of many DBA utility functions. Document database design, data definition language, define data migration strategy between different products/versions and develop data migration procedures.

Qualifications

Qualifications:

• Minimum of 10 years’ experience designing, developing, and maintaining enterprise database systems.
• Experience with cloud database development and implementation (AWS preferred).
• Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings. 
• Demonstrated experience with ETL pipeline design and implementation. 
• Overseeing aspects of data governance and maintenance, modeling, and secure access.
• Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle). 
• Demonstrated experience implementing ETL pipelines within and without the use of 3rd party vendor solutions (NNCompass, Pentaho).
• Demonstrated experience documenting database architecture and diagrams.
• Secret clearance or ability to obtain and maintain a government security clearance, for which one must be a US citizen.

Preferred:

• Experience with storage on cloud for containerized applications
• Experience with NoSQL (Cassandra, HBase, MongoDB, etc…)
• Experience with index based datastores (ElasticSearch, Solr)
• Experience running ETL pipelines over Apache NiFi