Senior Data Architect - Clearance Desired

Overview

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