Database Administrator

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

Database Administrators maintain operational Oracle databases and supports the data transformation processes to enable storing and retrieval of customer data with a Data Warehouse. Database Administrators ingest data from internal and external sources and present that data for analytics and business intelligence. Database Administrators also main and administer application-specific databases. The Data Warehouse is currently implemented with the Data Vault 2.0 specification.

Duties include:
  • Design the 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
  • Design enterprise database strategies for functions such as backup, recovery and migration or to correct extremely complex operational and
  • 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
  • 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

Required:
  • Bachelors or equivalent experience in related field
  • Possess a minimum of seven (5) years of experience in Application Software and Extract Transform Load (ETL) and/or Data, Database and/or Data Warehouse implementations
  • Possess experience with SQL and SQL Plus
  • Possess experience building and scheduling data integration scripts that automat ingest of data from multiple sources (Oracle, SQL, Postgres).
  • Possess experience using data Extract Transform Load (ETL) applications
  • Must have intermediate level proficiency in MS office products. (Word, Excel, PowerPoint, Outlook)
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.

95908725