Database Administrator I

City of Lynchburg

Lynchburg (VA)

Hybrid

USD 65,000 - 90,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

The City of Lynchburg is seeking a Database Administrator I to join our Information Technology team. This role supports design, security, performance, and reliability of the City's enterprise SQL Server environment, ensuring data integrity, regulatory compliance, and high availability.

The DBA I will work with mission-critical systems and may be eligible for hybrid remote work after six months, subject to orientation and department approval.

Qualifications

  • Associate's degree in Information Technology, Computer Science, Information Systems, or a related field; or equivalent education/experience.
  • At least one year of experience in database administration, SQL Server support, or a related technical field.
  • Working knowledge of relational database management systems, particularly Microsoft SQL Server.
  • Knowledge of SQL and T-SQL, database design, performance optimization, and backup/recovery procedures.
  • Familiarity with database security, access controls, and data integrity practices.
  • Ability to diagnose technical problems, analyze system performance, and implement effective solutions.
  • Ability to maintain technical documentation and communicate effectively.
  • Must successfully complete background check and possess a valid Virginia driver’s license; IS-100 and IS-700 NIMS training within 90 days.

Responsibilities

  • Assist in design, development, implementation, maintenance, and support of City databases and related applications.
  • Install, configure, patch, and upgrade Microsoft SQL Server databases and related software per procedures.
  • Create and maintain database objects; assist in developing data models.
  • Monitor database performance, identify issues, and assist with query optimization and troubleshooting.
  • Maintain development, testing, and production environments per change management procedures.
  • Assist in implementing database security measures, including user access controls and encryption.
  • Perform backups, recovery testing, and routine maintenance to ensure data integrity and availability.
  • Support ETL, data imports/exports, and integrations between systems.
  • Collaborate with departments to identify needs and support system improvements.

Education

Associate's degree in Information Technology, Computer Science, Information Systems, or a related field

Tools

Microsoft SQL Server
PowerShell

Job description

The City of Lynchburg is an Equal Opportunity Employer.

The City of Lynchburg is seeking a Database Administrator I to join our Information Technology team! This position is responsible for supporting the design, security, performance, and reliability of the City's enterprise SQL Server environment. The Database Administrator I (DBA I) supports mission-critical systems used by City departments and citizen-facing services, helping ensure data integrity, regulatory compliance, and high availability.

This position may be eligible for hybrid remote work after six months of employment and successful completion of the department's in-person orientation and training, subject to departmental approval and operational needs.

Other duties to provide direct or indirect service to the citizens may be assigned.

ESSENTIAL DUTIES AND RESPONSIBILITIES
  • Assists in the design, development, implementation, maintenance, and support of the City's databases and related application systems.
  • Installs, configures, patches, and upgrades Microsoft SQL Server databases and related software in accordance with established procedures.
  • Creates and maintains database tables, queries, reports, and other database objects; assists in developing logical and physical data models.
  • Monitors database performance, identifies potential issues, and assists with query optimization, indexing, and system troubleshooting.
  • Maintains development, testing, and production database environments in accordance with established change management procedures.
  • Assists in implementing and maintaining database security measures, including user access controls, permissions, encryption, and data protection.
  • Performs database backups, recovery testing, and routine maintenance to support data integrity, system availability, and disaster recovery.
  • Assists in implementing and maintaining database high-availability solutions.
  • Develops and maintains scripts and automated processes to support database administration, monitoring, and routine maintenance.
  • Supports data imports, exports, and integrations between databases, applications, and other systems, including ETL processes.
  • Assists with the installation, configuration, implementation, and ongoing support of purchased software applications and related database systems.
  • Troubleshoots database and application issues, coordinating with internal technical staff and software vendors to resolve problems.
  • Collaborates with City departments to identify business needs, evaluate technical solutions, and support system improvements and integrations.
  • Maintains technical documentation related to database configurations, procedures, security, backup and recovery, and system changes.
  • Participates in technology projects, system upgrades, and procurement evaluations as assigned.
  • Provides technical support for scheduled maintenance and database-related emergencies outside normal business hours, as needed.
ADDITIONAL DUTIES AND RESPONSIBILITIES

Whenunusual 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 supervisory responsibilities but may provide occasional project leadership for smaller-scale projects.

Associate's degree in Information Technology, Computer Science, Information Systems, or a related field and at least one year of experience in database administration, SQL Server support, or a related technical field; or an equivalent combination of education, training, and experience sufficient to demonstrate the required knowledge, skills, and abilities.

KNOWLEDGE, SKILLS, AND ABILITIES
  • Working knowledge of relational database management systems, particularly Microsoft SQL Server.
  • Knowledge of SQL and T-SQL, database design, performance optimization, and backup and recovery procedures.
  • Familiarity with database security, access controls, and data integrity practices.
  • Ability to diagnose technical problems, analyze system performance, and implement effective solutions.
  • Ability to maintain technical documentation and communicate effectively ;
  • Ability in t wa A etc.?? Full text? maybe incomplete.
  • Must successfully complete any required background check consistent with City policy and applicable law.
  • Possession of valid driver's license issued by the Commonwealth of Virginia and acceptable driving record according to the City’s Driving Criteria.
  • Must successfully complete IS100 and IS700 National Incident Management System (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 AND WORK ENVIRONMENT

Work is primarily performed in an office environment and involves prolonged periods of computer use, including sitting, typing, and viewing electronic screens. The position may require occasional movement between workstations, offices, and equipment areas, as well as handling or moving computer equipment. Work may occasionally be performed outside normal business hours to support system maintenance or emergency operations.

Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions of the position.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator I
Database Administrator I

The City of Lynchburg • Lynchburg (VA)

Hybrid
USD 60,000 - 90,000
Application Development Analyst I
Application Development Analyst I

City of Lynchburg • Lynchburg (VA)

Hybrid
USD 52,000 - 76,000
Hybrid remote work after six months
Application Development Analyst I
Application Development Analyst I

The City of Lynchburg • Lynchburg (VA)

Hybrid
USD 55,000 - 85,000
Database Administrator
Database Administrator

York County, VA • Yorktown (VA)

On-site
USD 60,000 - 80,000
Database Administrator
Database Administrator

York County • Yorktown (VA)

On-site
USD 60,000 - 85,000
CONSTRUCTION COORDINATOR I
CONSTRUCTION COORDINATOR I

City of Lynchburg • Lynchburg (VA)

On-site
USD 55,000 - 75,000
Database Administrator*
Database Administrator*

Orange County Government • Hillsborough (NC)

Hybrid
USD 95,000 - 120,000
SQL DBA I - Hybrid Remote, Data Integrity & HA
SQL DBA I - Hybrid Remote, Data Integrity & HA

The City of Lynchburg • Lynchburg (VA)

Hybrid
USD 60,000 - 90,000
Database Administrator*
Database Administrator*

Orange County, NC • North Carolina

Hybrid
USD 85,000 - 120,000
Training & LMS Administrator
Training & LMS Administrator

City of Charlottesville • Charlottesville (VA)

On-site
USD 75,000 - 94,000
Health insurance
Retirement plan
Gym membership reimbursement
+2