Senior SQL DBA in Des Moines, IA (in-person interview, preferred locals)

ROLE	Sr SQL DBA
LOCATION	Des Moines IA
DURATION	LONG TERM
RATE	DOE
DIRECT CLIENT	YES
INTERVIEW TYPE	In-Person Only
Local candidates strongly preferred ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
State Experience Highly Preferred U.S. Citizens and those authorized to work in the U.S. are encouraged to apply Note: For H1 While submitting I need consultant I 797 OR ID Proof.
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. 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. Responsibilities ·      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.

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