Advanced American Technologies, Inc

SQL Server DBA / SSIS Developer (Min 8yrs exp) (Remote during COVID) (Webcam Interviews ONLY)

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Des Moines
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: Agile SSRS SSIS Scripting
  • Secondary Skills: SQL Server DBA Database Design Data Warehousing Concepts
  • Job Location: Des Moines, Iowa
  • Posted Date: Posted today
Job Description

Please note that this position is with our direct client

Client is looking for a SQL Server DBA / SSIS Developer (Min 8yrs exp) (Remote during COVID) (Webcam Interviews ONLY)

POSITION DESCRIPTION

DIRECT CLIENT Position

Number of positions: 1

Length: 12 Months +

Location: Des Moines, IA 50319

Immediate interviews Web Cam interviews

 

Senior SQL Server DBA/SSIS Developer is needed to support Client's Modernization Project

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 an addition to our database support team of three SQL Server DBAs. This person will help shape the Client'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.


Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required.

Skill Matrix

Experience with Business workflow processes

Required / Desired

Amount

of Experience

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 le

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

0

Years

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

Highly desired

0

 

 

Relevant Job Openings
.NET Application Developer
System Analyst and System Administrator