Senior Data Architect - Clearance Desired
Logistics Management Institute
- USA
- Permanent
- Full-time
- 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.
- 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.
- 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