Discovery Database Administrator (DBA) (Top Secret Clearance Req with Security Clearance

Skills and attributes for success

• Provide database administration support including setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
• Aid in managing Microsoft SQL Server 2019 and 2022, applying best practices for optimizing databases.
• Create and maintain databases in a Clustered Server environment, applying expert knowledge of data models and their components.
• Apply working knowledge of data lake, data warehouse, and data mart architectures, metadata, data modeling, data flow, entity relationship diagrams, schema architectures, and query languages.
• Mirror database servers, implement log shipping, and ensure database redundancy and high availability.
• Create full backups and recovery capabilities for Microsoft SQL Server 2019 and 2022.
• Facilitate the migration of systems into cloud infrastructure.
• Upgrade SQL Servers from lower versions to the latest version (SQL Server 2019 and up).
• Create reports using Microsoft SQL Server Reporting Services (SSRS).
• Set up a reporting server and manage all DBA functions and report development using Software Systems development Architecture and Design.

Pay

$142,100 - $192,850 annually

Schedule

Full-time, Executive-Level