Database Administrator II

City of Lynchburg

Lynchburg, VA(remote)

JOB DETAILS
SALARY
$77,459.20–$110,000 Per Year
SKILLS
Access Control, Administrative Skills, Analysis Skills, Auditing, Business Continuity Planning (BCP), Calendar Management, Change Control, Computer Mouse Hardware, Computer Skills, Concrete, Cryptography, Data Mart, Data Modeling, Data Quality, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Desktop PC, Disaster Recovery, Documentation, Employee Retention, Enterprise Applications, File Server, HIPAA (Health Insurance Portability and Accountability Act), High Availability, Identify Issues, Import/Export, Incident Management, Information/Data Security (InfoSec), Interpersonal Skills, Keyboards, Leadership, Lift/Move 25 Pounds, Maintain Compliance, Mathematics, Microsoft Active Directory, Microsoft Hyper-V, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Server, Operations Planning, Operations Processes, PCI, Performance Analysis, Physical Demands, Plane Geometry, Power BI, Problem Solving Skills, Procurement Planning, Production Systems, Project Planning, Query Optimization, Regulatory Compliance, Replication and Remote Mirroring, Reporting Dashboards, Reporting Skills, Risk, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Server Support, Service Delivery, Software Administration, Software Patches, Software Upgrades, Solid Geometry, System Integration (SI), System Operations, Systems Administration/Management, Systems Analysis, Systems Maintenance, Technical Leadership, Technical Writing, Test Plan/Schedule, Testing, Trigonometry, User Documentation, User Groups, VMWare, Vendor/Supplier Evaluation, Windows PowerShell, Writing Skills
LOCATION
Lynchburg, VA
POSTED
2 days ago

Database Administrator II

Salary

$77,459.20 - $110,000.00 Annually

Location

Lynchburg, VA

Job Type

Full-time

Job Number

03631

Department

Information Technology

Division

Information Technology

Opening Date

07/07/2026

Closing Date

7/21/2026 11:59 PM Eastern

  • Description
  • Benefits

Description

The Database Administrator II (DBA II) is responsible for the design, security, performance, and reliability of the City of Lynchburgs 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.

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

Minimum Education and Experience Required

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

Bachelors 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 work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

REASONING ABILITY: Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram or schedule form.

INTERPERSONAL SKILLS: Tact and cooperation required. Communications involve both facts and opinions and coordination such as scheduling meetings or repairs with other City employees. May provide leadership and guidance as a work leader.

COMPUTER SKILLS: Thorough knowledge of the principles and practices related to database management systems and database management. Knowledge of SQL Server. Knowledge of a Windows Server-based infrastructure with both physical and virtual (VMware, Hyper-V) servers. Familiarity with data definition, modeling and logical design concepts; systems, including design, implementation and administration of file servers, software and desktops. Familiarity with modern techniques in system analysis and design.

OTHER REQUIREMENTS: Must successfully complete IS100 and IS700 National Incident Management (NIMS) training within 90 days of employment. May also be required to complete higher levels of NIMS training as determined appropriate for the position.

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands and fingers to operate a computer keyboard and mouse, and to install equipment. The employee is occasionally required to stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus.

WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate.

This position has flexibility for hybrid remote opportunities after 6 months and the completion of the department's non-virtual orientation and training.

The City offers an array of benefits combined with direct salary/wages in order to establish a total compensation package that supports the Citys goals of attracting, rewarding, and retaining employees who are both representatives of the community and are also able to deliver exceptional services.

  • Employees in full-time positions are eligible for the following benefits:
  • Medical, dental, and vision coverage
  • Retirement through the Virginia Retirement System (VRS);

the City's contribution is based on a rate determined bi-annually by the VRS Board and employees pay 5% of base pay (pre-tax) towards their VRS benefit

  • Life insurance at no cost to the employee

  • Optional benefits such as 457 deferred compensation, Roth IRA, flexible spending accounts, etc.

  • Eligibility for parental leave and tuition assistance

  • Paid Time Off

  • Employees in hourly and part-time positions may be eligible for benefits depending on the position

Employees of the City of Lynchburg may also be eligible for the Public Service Loan Forgiveness Program for federal student loans

Additional information about City benefits can be found on our website and in the Employment Policies & Procedures

Employer City of Lynchburg

Address 900 Church Street

Lynchburg, Virginia, 24504

Phone (434) 455-4200

Website https://www.lynchburgva.gov/human-resources

About the Company

C

City of Lynchburg