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