Visitors Government Business Loudoun County Services About Loudoun Loudoun County Virginia Where Tradition Meets Innovation

SYSTEMS ANALYST

Recruitment #19-S4B-1379

Date Opened:11/16/2018 8:00:00 AM
Closing Date:Open until filled
Hiring Range:Depending on Qualifications
Department:INFORMATION TECHNOLOGY
Job Type: Open and Competitive
Full/Part-Time: Full-Time
Eligible For:Full Benefits
Reg/Temp: Regular

 Go Back  Apply   View Benefits

INTRODUCTION

This position may be under filled as a Systems Analyst at either the Specialist III or Specialist II level.

JOB DESCRIPTION

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)

JOB REQUIREMENTS

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.

POST CONDITIONAL OFFER CONTINGENCIES

Criminal background and credit check will be performed on the successful candidate. A valid automobile driver’s license and driving record are required.
Click on a link below to apply for this position:

Fill out the Application NOW using the Internet.
If you have questions about how to apply online, you may contact us by phone at (703) 777-0213 or e-mail us at HR@loudoun.gov. EOE.

 



 
Home | Contact Us | Sitemap | Accessibility

Loudoun County Government: P.O. Box 7000, Leesburg, VA 20177 | Ph: 703-777-0100