Short Description:
SQL DBA with XML & SSIS (for Schema changes)
This position requires experience in both database and application development. The State of Iowa is looking for someone who has a strong understanding of SQL Server, plus experience developing in SSIS and XML
Complete Description:
This position requires experience in both database and application development. The State of Iowa is looking for someone who has a strong understanding of SQL Server, plus experience developing in SSIS and XML. The work will initially focus on developing and updating schemas then will evolve into other project work related to SQL database and development, such as maintaining databases or writing scripts. The candidate will have experience working in a fast-paced environment, with aggressive timelines.
Responsibilities:
•Experience and knowledge in supporting application system development life cycle.
•Perform performance tuning.
•Monitor database performance and space requirements.
•Communicate accurate and useful status updates.
•Manage and report time spent on all work activities.
•Ability to work in a team environment
•Analyze the current transactional database designs to determine needed improvements
•Document and standardize data structures, procedures and processes
•Ability to comprehend complex technical and logical concepts and adapt quickly to changes
•Strong quantitative, analytics, problem solving, organizational, communication and interpersonal skills are required
•Attention to detail and maintaining high quality standards is a must
•Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision
•Strong written and verbal communication skills
•Mentor and coach peers
•Provide knowledge transfer to peers
Skills:
Skill
Required / Desired
Amount
of Experience
SQL programming experience with 2005/2008/2012
Required
7
Years
SSIS & SSAS Experience
Required
7
Years
SSRS
Required
4
Years
T-SQL & ANSI SQL
Required
4
Years
XML
Required
4
Years
Large scale data migration experience
Required
4
Years
Data Warehousing concepts
Required
3
Years
Architecture Planning experience
Highly desired
Experience with Sharepoint DB's
Desired
MySQL/PostgreSQL
Desired
SQL SERVER database troubleshooting and query optimization
Desired
SQL SERVER Database Design
Desired
SQL SERVER Stored Procedure Design and implementation
Desired
SQL SERVER Database Performance monitoring
Desired