JOB
The Database Administrator II (DBA II) is responsible for the design, security, performance, and reliability of the City of Lynchburg's enterprise SQL Server environment. This role supports mission-critical systems used by all City departments, and citizen-facing services. The DBA II ensures data integrity, regulatory compliance, and high availability across all departments.
EXAMPLE OF DUTIES
ESSENTIAL DUTIES AND RESPOSIBILITIES
Other duties to provide direct or indirect service to the citizens may be assigned.
-
Design, implement, and maintain SQL Server databases supporting enterprise applications;
-
Develop logical and physical data models;
-
Participate in application procurement and upgrade planning to ensure database compatibility and scalability;
-
Install, configure, patch, and upgrade SQL Server instances;
-
Maintain development, test, and production environments with proper change control;
-
Administer SQL Server Agent jobs, linked servers, and integration with Active Directory;
-
Monitor performance using native tools (Profiler, Extended Events, DMVs) and third party monitoring platforms;
-
Optimize queries, indexes, and execution plans to ensure responsive public-facing and internal systems;
-
Diagnose and resolve performance bottlenecks across storage, network, and application layers;
-
Implement and enforce database security policies, encryption, and least privilege access controls;
-
Ensure compliance with CJIS, HIPAA, PCI, and Virginia state data handling requirements;
-
Conduct regular audits of permissions, data access, and configuration baselines;
-
Develop and maintain backup strategies using native SQL Server tools and enterprise backup systems;
-
Perform routine recovery tests and maintain documentation for disaster recovery (DR) and continuity of operations (COOP);
-
Support high availability and off-site replication strategies for critical systems;
-
Build and maintain ETL workflows using SSIS to support data integration across departments;
-
Automate administrative tasks using T-SQL and PowerShell;
-
Support data imports/exports for reporting, public dashboards, and inter-agency data sharing;
-
Administer SSRS, Power BI gateways, and scheduled reporting processes;
-
Assist departments in developing dashboards, operational reports, and data extracts;
-
Administer SSAS, support data warehouse or data mart initiatives for analytics and transparency;
-
Provide technical guidance to developers, analysts, and vendors;
-
Participate in project planning, procurement reviews, and system integrations;
-
Participate in department and enterprise-level application support including, but not limited to, troubleshooting, upgrades, interfaces, and development;
ADDITIONAL DUTIES AND RESPONSIBILITIES
When unusual situations occur and/or the City Manager declares a State of Emergency, all City employees may be required to accept special assignments and perform as needed to ensure appropriate service delivery.
SUPERVISORY RESPONSIBILITIES
This position has no supervisor duties. May be required to perform occasional project leadership duties for relatively simple projects.
