SQL Server Database Administrator/SSIS & XML Developer (Job ID: 597502)

  • 1305 E Walnut St, Des Moines, IA 50319, USA
  • Full-time

Company Description

Computer Consultants International, Inc. (CCI) is an IT Consulting Firm with more than 18 years experience providing effective, expert-level services in industries such as Construction, Technology, Finance, Healthcare, and Government. CCI focuses on building long-term relationships while completing projects from design to delivery. People are CCI's key component for success. Recruiting utmost-quality individuals for our clients, CCI fields a workforce of individuals who are selected not only because of their technical qualifications but also for their achievements as substantial, contributing human beings. In government work and in the commercial market, high standards of ethics and accountability are critical. Therefore our people are chosen for their integrity and ability to maintain relationships, as well as expertise in their field. To learn more about CCI, visit us online at www.cci-worldwide.com.

Job Description

CCI is looking for someone who has a strong understanding of SQL Server database administration, with experience developing in SSIS and XML. This position will be an addition to our database support team of three 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.). 

•Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. 

•Refine and automate regular processes, track issues, and document changes. 

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

•Coordinate with other agency departments to update and integrate processes as necessary. 

•Demonstrate leadership skills (foster a spirit of teamwork, mentor peers, and take ownership of assigned project work). 

•Install and configure SQL Server, applying service packs and feature packs. 

•Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs. 

•Assist developers with complex query tuning and schema refinement. 

•Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps. 

 

SKILLS REQUIRED FOR THIS POSITION 

•SQL Server DBA experience with 2012 or newer. [REQUIRED] 8 years 

•SQL Server Integration Services (SSIS) [REQUIRED] 8 years 

•SQL Server Reporting Services (SSRS) [REQUIRED] 8 years 

•SQL Server Stored Procedure Design and implementation [REQUIRED] 8 years 

•SQL Server database troubleshooting and query optimization [REQUIRED] 8 years 

•SQL Server Database Performance monitoring [REQUIRED] 8 years 

•SQL Server Database Design [REQUIRED] 8 years 

•Expert understanding of Database best practices [REQUIRED] 8 years 

•Experience upgrading databases from lower to latest versions [REQUIRED] 6 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 - [REQUIRED] 6 years 

•Strong written and verbal communication skills [REQUIRED] 6 years 

•Data Warehousing concepts [REQUIRED] 3 years 

•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 

•Databases migration using Azure &/or AWS [Highly desired] 

•Experience in performing DR techniques - Always On, Clustering, Replication, Database mirroring, etc. [Highly desired] 

Qualifications

SQL Server DBA experience with 2012 or newer. Required. 8 Years 

SQL Server Integration Services (SSIS). Required. 8 Years 

SQL Server Reporting Services (SSRS). Required. 8 Years 

SQL Server Stored Procedure Design and implementation. Required. 8 Years 

SQL Server database troubleshooting and query optimization. Required. 8 Years 

SQL Server Database Performance monitoring. Required. 8 Years 

SQL Server Database Design. Required. 8 Years 

Expert understanding of Database best practices. Required. 8 Years 

Experience upgrading databases from lower to latest versions. Required. 6 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 lea. Required. 6 Years 

Strong written and verbal communication skills. Required. 6 Years 

Data Warehousing concepts. Required. 3 Years 

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 

Databases migration using Azure &/or AWS. Highly desired.   

Experience in performing DR techniques - Always On, Clustering, Replication, Database mirroring, etc. Highly desired.   

Interviews for this opening will be conducted on July 17th and 18th.  

Additional Information

For immediate consideration, please send your resume to hire(at)cci-worldwide.com with "597502-IA"- The subject line.