Database Administrator II

About the role

The Database Administrator II (DBA II) supports mission-critical systems used by all City departments and citizen-facing services. This role ensures data integrity, regulatory compliance, and high availability across all departments.

Responsibilities

• 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;

Qualifications

• 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.
• Reasoning Ability: Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Mathematical Skills: Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry.
• 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.