SQL Database AdministratorLocation: Chesterfield, VA 23832Duration: 3 Months*local candidates strongly preferred*this is a short term contract*interviews will be conducted via webcam*candidates will telework now (after coming to office to pick up laptop). Once restrictions are lifted, candidates will be required to work onsite daily M-F 8-5pm, NO exceptionsDesire a detail-oriented person to document our SQL Jobs, Stored Procedures and find file path names that need to be changed to DFS.To assist in moving databases/jobs/procedures from older servers to new VM serversAid in updating SQL Jobs and Stored Procedures from Nighttime billing to Daytime billing.Analyze the Department of Utilities' information needs and make recommendations for improvements. Develop, interpret and support relational database solutions in a Microsoft SQL Server environment that addresses critical business functions or needs for the department.Identify and troubleshoot code-related issues.
Extract data, present data, and put data into spreadsheets; create, modify and test various SQL queries, stored procedures, and views for obtaining data. Create consistent and accurate technical documentation of implemented applications, databases, and systems. Create and modify existing SSRS reports.
Assist other analysts and the Automation Coordinator in the research and implementation of best practices for the department's database environment including maintenance issues, operation requirements, disaster recovery, and security. Evaluate and propose the effectiveness of alternative approaches to user needs; assist in the training of newly hired Automation Systems Staff.Preemployment drug testing, FBI criminal background check and education/degree verification required. Must maintain personal mobile technology as a condition of employmentSkill - Required / Desired - Amount of Experience - HaveSQL Server - Required - 7T-SQL - Required - 7SSRS - Required - 7SQL Views & Stored Procedures - Required - 7Technical Documentation - Required - 7Bachelor's degree in information systems, computer science, or similar field; or equivalent combination of training and experience - Highly desired - 7Strong communication skills - Required