1 w2 integration architect data integration ssid ssis odbc jdbc sql server onsite Job in saint paul, mn

SORT BY

W2 - Database Administrator - DBA (Migration, SQL server apps, SSIS, SSRS, ETL, AlwaysOn) - Hybrid

Tanson Corp

Saint Paul, MN | Full Time

$107k-133k (estimate)

1 Week Ago

W2 - Database Administrator - DBA (Migration, SQL server apps, SSIS, SSRS, ETL, AlwaysOn) - Hybrid

Tanson Corp Saint Paul, MN

$107k-133k (estimate)

Full Time | IT Outsourcing & Consulting 1 Week Ago

Save

Tanson Corp is Hiring a W2 - Database Administrator - DBA (Migration, SQL server apps, SSIS, SSRS, ETL, AlwaysOn) - Hybrid Near Saint Paul, MN

Job Details

Description:

Seeking a Database Administrator (DBA) who will be a member to the Infrastructure Team, will need to work closely with the Server System Engineers, and collaborate with other MNIT DOC and Enterprise teams.

The resource will help migrate to new versions of SQL and ensure the availability and optimization of the current MSSQL 2008 2022 databases. The resource may occasionally work with other database platforms such as Oracle. This position will need to have experience in ETL processes and have knowledge of Azure SQL Database and Managed Instances.

The work is expected to be done in a hybrid manner. The on-site work location is at St. Paul, MN 55108.

Interviews will be conducted via Microsoft Teams.

Project Schedule

Anticipated Project Start Date: July 8, 2024
Anticipated End Date: July 7, 2025

Sample Tasks

Support SQL server applications
Supporting SQL Server components, including SSIS and SSRS
Maintaining and troubleshooting ETL (Extract, Transform and Load) processes
Performing SQL backups and Disaster Recovery
Performing database migrations & upgrades
Working with Azure SQL technologies
Documenting work and processes
Provide mentorship to other DBAs on the team
Provide knowledge transfer

Desired Skills

Experience with SQL server applications and supporting components, including SSIS and SSRS.
Experience maintaining and troubleshooting ETL (Extract, Transform and Load) processes.
Experience in mentor IT staff and database design
Experience in assessing and introducing new technologies to improve operation of database infrastructure.
Experience as a lead worker in a team of subject matter experts of varying capacities
Experience in Microsoft Azure SQL technologies.
Experience with AlwaysOn and other High Availability SQL technologies