Previous Job
IA OCIO DBA5 - SQL Database Admin
Ref No.: 18-03702
Location: Des Moines, Iowa
Start Date / End Date: 05/28/2018 to 05/26/2019
Requisition Description
Engagement Type:

Short Description:
Senior level Database Administrator may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities.

Complete Description:
The State of Iowa is seeking an individual with extensive experience with Microsoft SQL Server.
The ideal candidate will have the ability to troubleshoot and problem-solve with a strong sense
of urgency. In this position, you will be the face of all things data. You will need to be able to
see the big picture while also able to work though the details to implement the big picture. This
will involve data migration from other systems, script development and execution, creating DB
backups, database design and verification, data integrity validation, and interactions with
external stakeholders and customers. The candidate will have experience working in a
fast-paced environment, with aggressive timelines. This person should be a self-starter, able to
work both independently and cooperatively as required. State government experience is a
definite plus.
-Refine business requirements into technical requirements and specifications
-Design and develop SSIS packages, database objects, tables, stored procedures and views
-Performance tuning the stored procedures and T-SQL.
-Communicate accurate and useful status updates
-Manage and report time spent on all work activities

Strong written, technical documentation and oral communication skills
Enjoy working in a team environment.

Required / Desired Skills
Skill Required / Desired Amount of Experience
Solid experience with Microsoft SQL Server 2008 R2 and above Required 8 Years
SQL Server Integration Services (SSIS) Required 8 Years
Strong knowledge of XML and XPath Required 8 Years
T-SQL language (queries, views, procedures) Required 8 Years
SQL Server Reporting Services (SSRS) Required 8 Years
Proficient translation of business requirements and functional specifications into technical data requirements Required 8 Years
Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision Required 8 Years
Large-scale data Extract, Transform and Load (ETL) migrations Required 8 Years
Data warehousing concepts Desired
Experience with iterative and/or Agile Scrum development methodologies Desired
SQL Server database troubleshooting and query optimization Desired
SQL Server Database Design Desired
SQL Server Stored Procedure Design and implementation Desired
Knowledge of Microsoft BizTalk Server Desired
Exposure to cloud technologies (Azure, AWS, etc) Desired