About the role

  • Provide database administration support for legal discovery accounts
  • Manage and optimize Microsoft SQL Server 2019/2022 including security, tables, indexes, stored procedures, and maintenance jobs
  • Design and create SQL reports and setup reporting servers using SSRS
  • Create and maintain databases in clustered server environments and apply data modeling best practices
  • Implement redundancy and high-availability solutions (mirroring, log shipping) and full backup/recovery
  • Facilitate migration of systems into cloud infrastructure and upgrade SQL Server versions
  • 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)
  • Design SQL reports and create 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
  • Knowledge of data flow, entity relationship diagrams, schema architectures and query languages
  • Implement database redundancy and high availability (mirroring, log shipping)
  • 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 server and perform DBA functions and report development

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