Discovery Database Administrator (DBA)

Summary

Join our team as a Discovery Database Administrator and contribute to government innovation by supporting various aspects of our company's portfolio. You will play a key role in managing and maintaining Microsoft SQL Server databases, ensuring optimal performance and security. Responsibilities include setting up security, creating tables and indexes, designing SQL reports, and creating maintenance jobs. You will also assist in creating and maintaining databases in a clustered server environment and facilitate the migration of systems into cloud infrastructure. This executive-level position requires expert knowledge of database design, development, and maintenance, as well as experience with data lakes, data warehouses, and data marts. We offer a comprehensive benefits package.

Requirements

• Apply expert knowledge of the design, development and maintenance of various data models and their components
• Apply working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages to integrate a seamless solution within legacy infrastructure

Responsibilities

• Provide database administration support to include, but not limited to the following activities
• Assist in managing Microsoft SQL Server 2019 and 2022 to include setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs etc. Must apply best practices for optimizing databases
• Assist in creating and maintaining databases in a Clustered Server environment. Must apply expert knowledge of the design, development and maintenance of various data models and their components
• Apply working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages to integrate a seamless solution within legacy infrastructure
• Mirror database servers, log shipping, latest techniques for Database redundancy and high Availability, and full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform
• Facilitate the migration of system into cloud infrastructure
• Upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS)
• Setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design

Benefits

• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays