Client is looking for someone who has a strong understanding of SQL Server database administration, with experience developing in SSIS and XML. This position will be an addition to our database support team of three SQL Server DBAs. This person will help shape the department’s future SQL Server vision from database standards and policies to automation efforts for deployment. The ideal candidate will have experience implementing databases in the cloud and will have experience with continuous integration and automation concepts.

Responsibilities:

Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes.

Effectively prioritize and manage concurrent projects, demonstrate initiative, and work independently with minimal supervision.

Drive results and leverage past experiences to improve the environment and related processes.

Coordinate with other agency departments to update and integrate processes as necessary.

Demonstrate leadership skills (foster a spirit of teamwork, mentor peers, and take ownership of assigned project work).

Install and configure SQL Server, applying service packs and feature packs.

Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs.

Assist developers with complex query tuning and schema refinement.

Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps

Skills Needed

SQL Server DBA experience with 2012 or newer Required 8 Years

SQL Server Integration Services (SSIS) Required 8 Years

SQL Server Reporting Services (SSRS) Required 8 Years

SQL Server Stored Procedure Design and implementation Required 8 Years

SQL Server database troubleshooting and query optimization Required 8 Years

SQL Server Database Performance monitoring Required 8 Years

SQL Server Database Design Required 8 Years

Expert understanding of Database best practices Required 8 Years

Experience upgrading databases from lower to latest versions Required 6 Years

Strong technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and le Required 6 Years

Strong written and verbal communication skills Required 6 Years

Data Warehousing concepts Required 3 Years

Operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). Required 2 Years

Familiarity with Agile (Scrum and/or Kanban) methodology Required 2 Years

Databases migration using Azure &/or AWS Highly desired Years

Experience in performing DR techniques - Always On, Clustering, Replication, Database mirroring, etc. Highly desired

Question 1 REMOTE WORK PERMITTED: Due to COVID-19, the client has agreed to allow the selected candidate to work remotely for the time being. However, the chosen candidate must be available to report in person as directed by the client to pick up equipment on the first day. This position REQUIRES the selected candidate to work ONSITE for the duration of the assignment once clear to return to the building. Do you accept this requirement?

Question 2 Provide three (3) professional (REQUIRED) references on the candidate resume with Contact Name, Title, Contact, and Relation to the candidate. NOTE: Candidates without professional references WILL NOT BE CONSIDERED

Question 3 Candidate writeup

Thanks
Ashish

Contract length: 12 months

Job Types: Full-time, Contract

Pay: $60.00 - $65.00 per hour

Work Remotely:

Temporarily due to COVID-19

Other SQL contracts

What

Where

Remote

SQL Server database administrator (Remote)

Other SQL contracts

0 outside IR35 SQL contracts