Database Architect

Minimum Clearance Required to Start:
Top Secret SCI
Job Description:

Database Architect

The Database Architect leads the development of the data warehouse to enable storing and retrieval of mission data consolidated from many sources. They manage the ingest of data from internal and external sources and present that data for analytics and business intelligence. Database Architects also maintain and administer application-specific databases. The Data Warehouse is currently implemented with the Data Vault 2.0 specification. The Data Warehouse and most databases are currently implemented on an Oracle DBaaS platform that is managed separately.

Duties include:
  • Lead development and sustainment of data warehouse architecture
  • Lead the design of logical data relationships and query structures of new databases considering factors such as access methods, access frequency, storage media, data volatility, query requirements, and operating environments to support insider threat detection application software and data analysis
  • Develop logical data models translated into workable physical database schema and structures in the database development process to support insider threat detection application software and data analysis
  • Design enterprise database strategies for functions such as backup, recovery and migration or to correct extremely complex operational and performance
  • Implement new database designs using DataVault 2.0 methodology
  • Evaluate data sets and engineer solutions for integrating into the Data Warehouse
  • Sustain existing Data Warehouse and application databases
  • Perform daily database administration functions such as developing queries and reports based on customer requirements, modifying or developing database views, and managing backup and recovery operations
  • Use database management tools and utilities in monitoring, optimizing, and managing assigned databases during business hours
  • Modify systems and database configurations to correct problems that affect the confidentiality, integrity, and availability of data
  • Develop, sustain and preserve user manuals and instructions that guide customers in executing data access functions such as running queries and reports
  • Participate in multi-functional teams and manage work through JIRA
  • Team lead responsible for oversight of all Data Engineering duties

Required Skills and Experience:
  • Possess a minimum of eleven (11) years of experience in Application Software and/or Data, Database and/or Data Warehouse implementations
  • Possess a minimum of five (5) years of experience in implementing, managing, and maintaining data warehouses
  • Possess a minimum of two (2) years of experience in implementing, managing, and maintaining Oracle databases
  • Possess a minimum of one (1) years of experience in defining and managing work in an Agile process
  • Possess a Bachelor's Degree in a related or technical field

  • Certified in Data Vault 2.0
Must be able to obtain, maintain and/or currently possess a security clearance.
The position requires a COVID vaccination or an approved accommodation/exemption for a disability/medical condition or religious belief.