Discovery DBA: SQL, Data Lakes & Cloud Migrations

CGS Federal

Boston (MA)

On-site

USD 110,000 - 150,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (FSA)
Paid Time Off

Job summary

CGS Federal is seeking a skilled Discovery Database Administrator (DBA) to support our legal accounts and government contracting portfolio in a fast-paced team. The DBA will manage SQL Server 2019/2022, implement security, create tables and reports, and maintain jobs across on-premises and cloud environments.

The role requires expertise in clustered environments, data modeling, data lakes/warehouses, and SSRS reporting.

Qualifications

  • Experience administering Microsoft SQL Server 2019 and 2022, with security setup and maintenance jobs.
  • Ability to design, implement, and maintain data models and databases in clustered/server environments.
  • Familiarity with data lakes, data warehouses, data marts, and metadata concepts.
  • Experience with data integration, data flow, and ER diagrams for legacy to cloud migrations.
  • Proficiency in backup/recovery strategies, log shipping, and high-availability configurations.
  • Experience upgrading SQL Server versions and developing reports with SSRS.

Responsibilities

  • Provide DBA support for Microsoft SQL Server environments (2019/2022) including security, schemas, indexes, and stored procedures.
  • Design, deploy, and maintain databases in clustered environments with best-practice optimization.
  • Develop SSRS reports and maintain a reporting server; create maintenance jobs and automation.
  • Support data lake, data warehouse, and data mart architectures and data modeling efforts.
  • Facilitate migration of systems to cloud infrastructure and ensure high availability.
  • Upgrade SQL Server versions and manage backups, disaster recovery, and log shipping.

Skills

SQL Server
SSRS
Data warehousing
Data modeling
Backup and recovery
Cloud migration
High availability
SQL performance tuning

Tools

SQL Server 2019
SQL Server 2022
SSRS
SQL Server Agent

Job description

CGS Federal is seeking a skilled Discovery Database Administrator (DBA) to support our legal accounts and government contracting portfolio in a fast-paced team. The DBA will manage SQL Server 2019/2022, implement security, create tables and reports, and maintain jobs across on-premises and cloud environments.

The role requires expertise in clustered environments, data modeling, data lakes/warehouses, and SSRS reporting.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Discovery DBA: SQL Server & Cloud Data Engineer
Discovery DBA: SQL Server & Cloud Data Engineer

CGS Federal • Washington

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+2
Executive Discovery DBA: SQL Server & Data Warehouse
Executive Discovery DBA: SQL Server & Data Warehouse

CGS Federal • Arlington (VA)

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+3
Senior Discovery DBA: SQL Server, Data Lakes & Cloud
Senior Discovery DBA: SQL Server, Data Lakes & Cloud

CGS Federal • City of Albany (NY)

On-site
USD 110,000 - 150,000
Health, Dental, and Vision
Life Insurance
401k
+3
Discovery SQL DBA: Cloud Migrations & Data Warehousing
Discovery SQL DBA: Cloud Migrations & Data Warehousing

CGS Federal • Baltimore (MD)

On-site
USD 110,000 - 170,000
Health Insurance
Dental Insurance
Vision Insurance
+4
Senior Discovery DBA – SQL Server & Cloud Migrations
Senior Discovery DBA – SQL Server & Cloud Migrations

CGS Federal • Chantilly (VA)

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+2
Senior Discovery DBA: SQL Server Mastery & Cloud Migrations
Senior Discovery DBA: SQL Server Mastery & Cloud Migrations

CGS Federal • New York (NY)

On-site
USD 90,000 - 130,000
Health, Dental & Vision
Life Insurance
401k
+2
Senior SQL Server DBA — Cloud Migrations & Data Warehousing
Senior SQL Server DBA — Cloud Migrations & Data Warehousing

CGS Federal • Austin (TX)

On-site
USD 110,000 - 150,000
Health, Dental, and Vision
Life Insurance
401k
+2
Senior Discovery DBA: SQL Server & Cloud Migrations
Senior Discovery DBA: SQL Server & Cloud Migrations

CGS Federal • Boston (MA)

On-site
USD 140,000 - 180,000
Health, Dental, and Vision
Life Insurance
401k
+2
Senior Discovery DBA: SQL Server, Cloud & HA
Senior Discovery DBA: SQL Server, Cloud & HA

CGS Federal • Los Angeles (CA)

On-site
USD 90,000 - 130,000
Health
Dental
Vision
+4
Senior Discovery DBA: Cloud Migrations & Data Modeling
Senior Discovery DBA: Cloud Migrations & Data Modeling

CGS Federal • Rockville (MD)

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+3