Database Administrator

Infinity Consulting Solutions
Washington, DC
20 Mar 2025

Vacancy expired!

Database Administrator

Onsite in DC office as needed

$95-105k base

Summary:

The Database Administrator (DBA) manages the Firm's Microsoft SQL Server databases in both development and mission-critical production environments. The DBA is responsible for the overall health of the Firm's databases, and duties include design, installation, provisioning hosts, backup/recovery, deployment, performance tuning, and maintenance. The DBA translates technical requirements into database solutions (logical and physical database design principles) and works closely with software developers to implement robust, scalable applications. In production environments, the DBA manages, monitors, analyzes performance (usage), database metrics (efficiency), and data security (access), while ensuring high levels of data availability.

Qualifications:
  • Bachelor's degree required, or equivalent combination of education and applicable experience.
  • 4-5 years progressive work experience as Microsoft SQLServer database administrator.
  • 3+ years managing all DB maintenance plan activities including backups, indexing, integrity, and consistent checks.
  • 3+ years with developing stored procedures and powershell scripts.
  • 3+ years monitoring and resolving database blocking, deadlocks, replication, and log shipping issues.
  • Experience supporting legal specific applications like iManage, 3E, vi, Intapp preferred, but not required.
  • Strong written, verbal, and interpersonal skills required.
  • Strong analytical ability and problem solving skills required.

Duties and Responsibilities:
  • Responsible for day-to-day support, such as validating backups, restoring backups, reviewing disk utilization, capacity planning, monitoring database health, troubleshooting performance issues.
  • Develop preventative maintenance procedures to ensure databases are performing optimally with the primary objective of minimizing down time.
  • Build an asset/configuration management system to track database usage and dependencies.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Assist developers with complex query tuning and schema refinement.
  • Perform scheduled maintenance and support release deployment activities.
  • Apply Critical Patch updates and Patch Set Upgrades.
  • Recommend long-range and annual technology plans and provide input into budgeting requests.
  • Develop and execute project management plans to achieve desired time lines as systems and programs are selected, purchased, installed, and/or further developed.
  • Assist with the design, testing, and implementation of disaster recovery and business continuity plans, procedures, audits, and enhancements.
  • Promote unparalleled customer service to our lawyers and clients.
  • Communicate complex system information and ideas effectively and efficiently to lawyers, managers, and staff.
  • ETL, Data Engineering and Reporting Solutions (Power BI, SSRS, SSIS, Tableau, etc.).
  • Work with Cloud data platform such as Snowflake.