• 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

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 Datacenter, Microsoft Window Server 2016

•             Datacenter 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                          

 

Question 8

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 9

IS YOUR CANDIDATE AWARE that he/she would need to RELOCATE to Des Moines for this position?

Question 10

IF OFFERED THE POSITION – How much notice does your candidate require before he/she is able to start working?

Question 11

REMINDER: a) *** SKILL MATRIX is entered on the CANDIDATE SKILLS TAB of VectorVMS ONLY***. b) Candidates submitted who have the skills matrix included on the resume get REJECTED FROM CONSIDERATION. c) Candidates that have the skills matrix uploaded on a separate document included WILL GET REJECTED FROM CONSIDERATION.

Question 12

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 INCLUDED WILL NOT BE CONSIDERED.

Question 13

SHOW YOUR WORK in the SUMMARY of QUALIFICATIONS under the DETAILS tab of CANDIDATE PROFILE] Candidates are REJECTED when an agency cuts/pastes bullets from the resume rather than using the space to explain why your candidate is the right fit for these requirements. Agree?

Question 14

CANDIDATES LEGAL NAME (FIRST and LAST) - the legal name MUST get entered into the detail tab's correct fields before submitting the candidate profile. Please know the candidate's name.

Question 15

OCIO contractor personnel are now required to undergo additional background check investigations (run by OCIO) before starting, requiring completion of several waiver forms & fingerprint processes. The selected candidate will be responsible for completing all the necessary waiver forms (CAI provide), scheduling and completing the fingerprinting process, and returning all completed items to OCIO for processing. Please confirm you have discussed this with your candidate, and he/she will comply if selected.