Database Administrator Job at TechNix LLC, Utah

VDNwVzRYUW1hM2tKaks4Zy95Vno4U2NHbXc9PQ==
  • TechNix LLC
  • Utah

Job Description

Position: Sr. Database Administrator

Duration: 1 year

Remote Work

Job ID: 3762

Agency: MNIT/DOC

Interview Mode: Teams

Project Schedule

  • Anticipated Project Start Date: September 1, 2026 or when a Work Order Contract is fully executed.
  • Anticipated End Date: August 31, 2027

Description of Project

The Minnesota Department of Information Technology Services (MNIT) partnering with the Department of Corrections, is seeking a Database Developer to assist in the design and maintenance of various databases, develop and optimize ETL pipelines and workflows, develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs. The Database Developer will develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems. The Database Developer will also execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems, build data ingestion and transformation workflows across raw, staging, curated, and analytics layers, maintain various reporting solutions using SSRS and Power BI, and Design and implement logical and physical data models (ERDs) for various applications. The Database Developer will also provide production support, including troubleshooting performance issues and on-call support and collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles.

At a high level, the resource will develop, maintain, and optimize enterprise database solutions and will support data integration, conversion, migration, reporting, and database performance while ensuring the accuracy, reliability, and integrity of enterprise data. The resource will also provide production support and collaborate with cross-functional project teams throughout the system development lifecycle using Agile methodologies.

Mode of Interview

The State will conduct interviews. The State reserves the right to remove a resource from consideration if the resource is unavailable for interview as requested by the State. Interviews will be conducted via Microsoft Teams.

Task:

  • Design and maintain various databases, including stored procedures, indexing, and data models.
  • Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server.
  • Execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems.
  • Develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs.
  • Build data ingestion and transformation workflows across raw, staging, curated, and analytics layers.
  • Build and maintain various reporting solutions using SSRS and PowerBI.
  • Design and implement logical and physical data models (ERDs) for various applications.
  • Develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems.
  • Provide production support, including troubleshooting performance issues and on-call support when needed.
  • Collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles.
  • Provide knowledge transfer.

Desired Skills

  • 10+ years of experience in database development or data engineering.
  • Expertise in SQL Server, T-SQL and performance tuning.
  • Experience with ETL tools (SSIS), Python, or PySpark.
  • Strong background in data modeling and data integration.
  • Experience with reporting tools (SSRS, PowerBI).
  • Working knowledge of DevOps tools such as Azure DevOps, GitHub, or Jenkins.
  • Experience supporting critical applications in financial, government, or legal industries.

Job Tags

Contract work, Remote work

Similar Jobs

Ann Logistics, LLC

Sprinter Owner Operators Needed - Great Pay and Bonuses Job at Ann Logistics, LLC

Job Overview:Ann Logistics LLC is seeking an experienced Owner Operator Driver to join our team. In this role, you will be responsible...  ...Operate vehicles such as box trucks, sprinters, and cargo vans.Ensure timely deliveries, adhering to all traffic laws and... 

Ochsner Health

Sr Medical Laboratory Scientist - Blood Bank (Nights) Job at Ochsner Health

 ...Ability to and experience working in controlled environment, following safety measures to minimize exposure to chemicals, body fluids, blood borne pathogens, etc. Advanced analytical skills to collect data, perform calculations, maintains system logs and operates... 

Dropoff, Inc.

Cargo Van Driver Needed - Daily Philadelphia Route (TWIC Preferred, Not Required) Job at Dropoff, Inc.

 ...We are looking for a reliable Cargo Van Owner Operator for a daily pickup route in Lancaster, PA , with deliveries to Philadelphia (airport, storage, or both). Route Details: Pickup Location: Lancaster, PA Pickup Time: Between 3:30 - 4:00 PM daily... 

Dropoff, Inc.

DFW Cargo Van Owner Operator Home Deliveries Job at Dropoff, Inc.

 ...1 years of age or older~ Solid knowledge of the city ~ Available Sunday - Wednesday ~ A registered, insured, and inspectedCargo van less than 10 years old (Full Size or Hi-Rise preferred, no minivans)~ A current driving license and a clean driving record ~ Tech... 

Service Tire Truck Center

Trailer Mechanic Job at Service Tire Truck Center

 ...Job description: Trailer Mechanic Tire Business names Service Tire Truck Centers as one of the best Tire Companies to work for in the United States in 2019. STTC offers an excellent benefit package, very competitive pay, and a path for employees to grow within the...