About the role

  • Provide database administration support for legal accounts
  • Manage Microsoft SQL Server 2019 and 2022: security, tables, indexes, stored procedures, reports, maintenance jobs
  • Create and maintain databases in Clustered Server environments
  • Apply data modeling and architecture knowledge to integrate with legacy infrastructure
  • Implement mirroring, log shipping, redundancy, high-availability, and backup/recovery strategies
  • Facilitate migration of systems into cloud infrastructure
  • Upgrade SQL Server versions and set up reporting servers using SSRS
  • Responsible for all DBA functions and report development utilizing software systems architecture and design

Requirements

  • Top Secret Clearance Required
  • Experience managing Microsoft SQL Server 2019 and 2022 (security, tables, indexes, stored procedures)
  • Experience designing SQL reports and creating maintenance jobs
  • Best practices for optimizing databases
  • Experience creating and maintaining 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
  • Experience with mirroring, log shipping, database redundancy, high availability, full backup and recovery for MSSQL
  • Experience facilitating migration of systems into cloud infrastructure
  • Experience upgrading SQL Server versions to 2019+ and using Microsoft SQL Server Reporting Services (SSRS)
  • Experience setting up reporting servers and performing 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