Senior SQL Server DBA — Cloud Migrations & Data Warehousing

CGS Federal

Austin (TX)

On-site

USD 110,000 - 150,000

Full time

20 hours ago
Be an early applicant

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
Paid Time Off and Holidays

Job summary

CGS Federal is seeking a Senior Discovery Database Administrator to support our legal accounts and government-focused portfolio. You will manage Microsoft SQL Server 2019 and 2022, implement security, design schemas, and develop reports using SSRS in a clustered, high-availability environment.

The role requires experience with data lakes and data warehouse architectures, plus cloud migration tasks. It offers full-time employment in a dynamic team with opportunities for growth and professional

Qualifications

  • Experience managing Microsoft SQL Server 2019 and 2022.
  • Ability to set up security, create tables, indexes, and stored procedures.
  • Experience with clustering, maintenance jobs, and reporting with SSRS.
  • Knowledge of data lakes, data warehouse architectures and data modeling.
  • Experience with data migration to cloud infrastructure.

Responsibilities

  • Provide DBA support including security, tables, indexes, stored procedures, reporting.
  • Create and maintain databases in a clustered server environment.
  • Apply data lake/warehouse concepts to integrate with legacy infrastructure.
  • Mirror databases, implement log shipping, backups, and high availability.
  • Facilitate migration of systems to cloud infrastructure.
  • Upgrade SQL Server versions (2019+) and develop SSRS reports.
  • Set up a reporting server and perform DBA functions and report development.

Skills

SQL Server administration
Database design
SSRS reporting
Data migration to cloud
Data warehousing basics

Tools

SQL Server 2019/2022
Clustered server environment

Job description

CGS Federal is seeking a Senior Discovery Database Administrator to support our legal accounts and government-focused portfolio. You will manage Microsoft SQL Server 2019 and 2022, implement security, design schemas, and develop reports using SSRS in a clustered, high-availability environment.

The role requires experience with data lakes and data warehouse architectures, plus cloud migration tasks. It offers full-time employment in a dynamic team with opportunities for growth and professional

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
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
Discovery DBA: SQL, Data Lakes & Cloud Migrations
Discovery DBA: SQL, Data Lakes & Cloud Migrations

CGS Federal • Boston (MA)

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 • 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 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
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
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
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
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