Work in Iowa Manufacturing Jobs

Job Information

VIVA USA Inc SQL Server DBA Lead in Des Moines, Iowa

Req Ref No: MKIAIS101 Location: Des Moines, IA Duration: 11.0 months

Description

Description:

Senior/Lead SQL Server DBA :

The client 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 supporting the client department. The ideal candidate will have experience implementing databases in the cloud and establishing operational procedures to maximize utilization. Project: SQL Server DBA Support Ongoing DBA support, SSIS development and technical leadership for the SQL Server DBA staff. Function as a Team Lead / Mentor to oversee and instruct less senior staff. Provide Data Warehouse Administration of source files and develops changes to Cubes and Dimensions. Business Case: Support the client SQL Server DBMS' and associated ETL (SSIS) and Reporting needs (SSRS). Also, Data Warehouse Administrator. Deliverables: Database installs, SSIS & SSRS development, performance tuning and troubleshooting. Data Warehouse maintenance changes.

MS SQL 2016+ SSRS 2015+ SSIS for ETL T SQL for stored procedures Microsoft Window Server 2019 Datacenter, Microsoft Window Server 2016 Datacenter and Microsoft Window Server 2012R2 AWS Always On Availability Group

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.

REQUIRED SKILLS:

Expert understanding of Database best practices 8 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 to the team - 6 YEARS Strong written and verbal communication skills 6 YEARS Data Warehousing concepts (Cubes and Dimensions) 3 YEARS SQL Server DBA experience with 2012 or newer 8 YEARS SQL Server Database Design 8 YEARS SQL Server Database Performance monitoring 8 YEARS SQL Server database troubleshooting and query optimization 8 YEARS SQL Server Stored Procedure Design and implementation (T-SQL) 8 YEARS SQL Server Integration Services (SSIS) 8 YEARS SQL Server Reporting Services (SSRS) 8 YEARS Experience in implementing operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). 2 YEARS Familiarity with Agile (Scrum and/or Kanban) methodology 2 YEARS AWS Always On Availability Groups 2 YEARS Experience migrating databases to the Cloud using Azure & AWS Highly Desired Architecture Planning experience Skills :

Skill Required / Desired Amount of Experience Expert understanding of Database best practices Required 8 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 le Required 6 Years Strong written and verbal communication skills Required 6 Years Data Warehousing concepts (Cubes and Dimensions) 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 (T-SQL) 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 AWS Always On Availability Groups Required

Experience migrating databases to the Cloud using Azure & AWS Highly desired

Architecture Planning experience Required

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

DirectEmployers