Database Administrator II

Posting number: 03631

Department: Information Technology

Division: Information Technology

Job classification: DATABASE ADMIN II

Posting type: Open & Promotional

Categories: IT and Computers

Summary

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.

Examples 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.

Qualifications

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION AND EXPERIENCE

Bachelor's degree from an accredited college or university; one to two years related experience and/or training; or equivalent combination of education and experience.

OTHER QUALIFICATIONS

LANGUAGE SKILLS: Ability to read, analyze and interpret documents such as technical procedures and system operating and maintenance manuals. Ability to write reports and correspondence. Ability to speak effectively before groups of users and customers to obtain requirements, explain procedures, and resolve problems.

MATHEMATICAL SKILLS: Ability to wor