DBA/SQL Programmer

Location: Desmoines, IA
Date Posted: 07-26-2018
DBA/SQL Programmer (569719)
Desmoines, IA
F2F
60-65/hr CTC
 
Short Description:
Senior SQL Server DBA/SSIS Dev
 
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.
 
Estimated work efforts:
SQL Server database administration  70%
experience developing in SSIS and XML  30% - (The 30% would be more design with project ETL work)
 
This TS2 position will be joining our database support team of 3 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.).
-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.
 
Skill       
 
Expert understanding of Database best practices
Required
8
Years
Strong technical and project management skills, engage in a hands-on way, and provide specific technical guidance and leadership for development team
Required
6
Years
Data Warehousing concepts
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
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
2
Years
Familiarity with Agile (Scrum and/or Kanban) methodology
Required
2
Years
Experience migrating databases to the Cloud using Azure & AWS
Highly desired
 
 
Architecture Planning experience
Required

Regards,
 
Srinivas Rao
 
Key Business Solutions, Inc.
 
|Email: recruiter4@keybusinessglobal.com|
|Office: 916 646 2080 Ext 217|| Fax: 916 646 2081|
|Website: keybusinessglobal.com ||
 
or
this job portal is powered by CATS