About the role

  • Provide database administration support for legal discovery accounts
  • Manage Microsoft SQL Server 2019 and 2022 including security, schema, stored procedures, reports, and maintenance jobs
  • Create and maintain clustered server databases and data models
  • Integrate solutions across legacy infrastructure using data lakes, warehouses, and marts
  • Implement replication and high-availability strategies (mirroring, log shipping, backups, recovery)
  • Facilitate cloud migrations and upgrade SQL Server instances to supported versions
  • Setup reporting servers and develop reports using Microsoft SQL Server Reporting Services (SSRS)
  • Responsible for all DBA functions and report development utilizing software systems architecture and design

Requirements

  • Top Secret Clearance required
  • Manage Microsoft SQL Server 2019 and 2022: security, tables, indexes, stored procedures, maintenance jobs
  • Apply best practices for optimizing databases
  • Create and maintain databases in a Clustered Server environment
  • Expert knowledge of design, development, and maintenance of various data models
  • Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, ER diagrams, schema architectures, and query languages
  • Implement database replication techniques: mirroring, log shipping, redundancy, high availability
  • Full backup and recovery capabilities for Microsoft SQL Server 2019 and 2022
  • Facilitate migration of systems into cloud infrastructure
  • Upgrade SQL Servers from lower versions to 2019+ and create reports using SSRS
  • Setup reporting servers and perform report development and all DBA functions

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

Job title

Discovery Database Administrator, DBA

Job type

Experience level

Mid levelSenior

Salary

$142,100 - $192,850 per year

Degree requirement

No Education Requirement

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job