Do you want to make a difference in one of the fastest-growing counties in the United States? Can you work as part of a team, with inspiration, vision and creativity? Are you passionate about the role of technology in supporting the mission of local government?
Loudoun County’s Department of Information Technology is currently seeking an experienced SQL Server DBA to join our team. This is a technical administrator and support position supporting the County’s SQL Cluster environment and standalone SQL Server databases. As a SQL Server DBA, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems. Database design, security and operational support experience is required. A working knowledge of T-SQL, SQL Server Management Studio (SSMS), SQL Server 2008, 2012 and 2014 is required. Knowledge of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Visual Studio preferred. The position will be responsible for installing, upgrading and patching Microsoft SQL Servers, database backups (full and differential data backup, restore, and transaction logs), performance monitoring and tuning (index maintenance, profiling), capacity planning , setting and maintaining database security (logins, roles) and supporting developers (query design, data fixes, and troubleshooting) Experience with high availability solutions (database mirroring, log-shipping and clustering) is required. The following knowledge areas are a plus: SQL Server Integration Services - package design, creation, scheduling, and maintenance, using SSIS for ETL (extract, transform and load) between different DBMS platforms (Oracle, DB2, cloud), SQL Server Reporting Services – requirements gathering and design of reports for business and operational support (charts, graphs, business intelligence, self-service reports) and implementing Policy Based Management (creating rules and reports to enforce County standards and best practices)
Any combination of education and experience equivalent to a Bachelor’s degree with major coursework in computer science or related field and at least 2 years of professional experience in database administration and support, application and database development support.
Criminal background and credit check will be performed on the successful candidate. A valid automobile driver’s license and driving record are required.