DirectJobHub
Jobs · Information Technology · Massachusetts

Discovery Database Administrator (DBA) (Top Secret Clearance Required)

CGS Federal (Contact Government Services) · Massachusetts, United States · 3 wk ago
Information Technology$142k–$193k/yrFull-time

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.
  • Optimize databases using best practices.
  • Manage Microsoft SQL Server 2019 and 2022 in a Clustered Server environment.
  • Apply expert knowledge of data models, data lake, data warehouse, data mart architectures, metadata, data modeling, data flow, entity relationship diagrams, schema architectures, and query languages.
  • Create and maintain databases in a Clustered Server environment.
  • Mirror database servers, implement log shipping, and ensure database redundancy and high availability.
  • Create full backup and recovery capabilities for the Microsoft SQL Server 2019 and 2022 platform.
  • Facilitate the migration of systems into cloud infrastructure.
  • Upgrade SQL Servers from lower versions to the latest version (version 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.

About the role

Support various aspects of the company's portfolio, assisting with legal accounts. Play a key role in supporting the company's mission to solve government problems with cutting-edge technology.

Responsibilities

  • Provide database administration support including setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
  • Optimize databases using best practices.
  • Manage Microsoft SQL Server 2019 and 2022 in a Clustered Server environment.
  • Apply expert knowledge of data models, data lake, data warehouse, data mart architectures, metadata, data modeling, data flow, entity relationship diagrams, schema architectures, and query languages.
  • Create and maintain databases in a Clustered Server environment.
  • Mirror database servers, implement log shipping, and ensure database redundancy and high availability.
  • Create full backup and recovery capabilities for the Microsoft SQL Server 2019 and 2022 platform.
  • Facilitate the migration of systems into cloud infrastructure.
  • Upgrade SQL Servers from lower versions to the latest version (version 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.

Requirements

Must have expertise in database administration, including Microsoft SQL Server 2019 and 2022, and experience with data models, data lake, data warehouse, data mart architectures, metadata, data modeling, data flow, entity relationship diagrams, schema architectures, and query languages.

Qualifications

Must have a bachelor's degree in Computer Science, Information Technology, or a related field. Relevant experience in database administration and management is preferred.

Benefits

Comprehensive benefits package including health, dental, and vision insurance, life insurance, 401(k), flexible spending account (health, dependent care, and commuter), paid time off, and observance of state/federal holidays.

Pay

$142,100 - $192,850 annually

Schedule

Full-time, executive-level position

Similar jobs