• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 12th Nov 2020

REQ ID: 638786

Role- IA-IDPH-TS2-SQL Server DBA Lead

Customer- State of Iowa, OCIO: Office of the Chief Information Officer

Location- 200 E Grand, Des Moines, IA 50319

Duration- 11/30/2020 to 10/24/2021

NOTE: Consultant must have 8plus years of experience, not less than 8 years

 

Skill Martrix

Skill

Required / Desired

Minimum

Experience

Expert understanding of Database best practices

Required

8 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 leadership to the team

Required

6 Years

Strong written and verbal communication skills

Required

6 Years

Data Warehousing concepts (Cubes and Dimensions)

Required

3 Years

SQL Server DBA experience with 2012 or newer

Required

8 Years

SQL Server Database Design

Required

8 Years

SQL Server Database Performance monitoring

Required

8 Years

SQL Server database troubleshooting and query optimization

Required

8 Years

SQL Server Stored Procedure Design and implementation (T-SQL)

Required

8 Years

SQL Server Integration Services (SSIS)

Required

8 Years

SQL Server Reporting Services (SSRS)

Required

8 Years

Experience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred).

Required

8 Years

Familiarity with Agile (Scrum and/or Kanban) methodology

Required

2 Years

AWS Always On Availability Groups

Required

2 Years

Experience migrating databases to the Cloud using Azure & AWS

Highly Desired

Architecture Planning experienceRequired

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.

Short Description:

The State of Iowa is looking a Senior/Lead SQL Server DBA, with experience developing in SSIS and XML. This position will be supporting the Iowa Department of Public Health, joining a team of three.

 

Complete Description:

The State of Iowa 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 supporting the Iowa Department of Public Health, joining a team of three.  The ideal candidate will have experience implementing databases in the cloud and establishing operational procedures to maximize utilization.

 

Project: SQL Server DBA Support for IDPH.  Description:  Ongoing DBA support, SSIS development and technical leadership for the SQL Server DBA staff.  Function as a Team Lead / Mentor to oversee and instruct less senior staff.  Provide Data Warehouse Administration of source files and develops changes to Cubes and Dimensions.  Business Case: Support Iowa Department of Public Health SQL Server DBMS' and associated ETL (SSIS) and Reporting needs (SSRS).  Also, Data Warehouse Administrator. Deliverables: Database installs, SSIS & SSRS development, performance tuning and troubleshooting.  Data Warehouse maintenance changes.

• MS SQL 2016+
• SSRS 2015+
• SSIS for ETL
• T SQL for stored procedures
• Microsoft Window Server 2019 Datacentre, Microsoft Window Server 2016
• Datacentre and Microsoft Window Server 2012R2
• AWS Always On Availability Group

 

Responsibilities:

• Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).
• 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.
• Demonstrated leadership skills (foster a spirit of teamwork, mentor peers and take ownership of assigned project work).
• Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps.
• Coordinate with other agency departments to update and integrate processes as necessary.

 

Required Skills:

• Expert understanding of Database best practices – 8 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 leadership to the team – 6 YEARS
• Strong written and verbal communication skills – 6 YEARS
• Data Warehousing concepts (Cubes and Dimensions) – 3 YEARS
• SQL Server DBA experience with 2012 or newer – 8 YEARS
• SQL Server Database Design – 8 YEARS
• SQL Server Database Performance monitoring – 8 YEARS
• SQL Server database troubleshooting and query optimization – 8 YEARS
• SQL Server Stored Procedure Design and implementation (T-SQL) – 8 YEARS
• SQL Server Integration Services (SSIS) – 8 YEARS
• SQL Server Reporting Services (SSRS) – 8 YEARS
• Experience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). – 2 YEARS
• Familiarity with Agile (Scrum and/or Kanban) methodology – 2 YEARS
• AWS Always On Availability Groups – 2 YEARS
• Experience migrating databases to the Cloud using Azure & AWS – Highly Desired
• Architecture Planning experience