Data Engineer DBA
Job Description
The State of Utah is seeking a Data Engineer DBA to design, administer, and continuously improve data systems and cloud data infrastructure. This hybrid role combines Microsoft SQL Server database administration with hands-on work building and operating ETL and Azure and Microsoft Fabric data platform capabilities.
In this position, you will support production-grade databases across development, testing, and production environments while also contributing to modern data pipeline development and data platform integration. You will work with both technical and non-technical stakeholders to deliver solutions aligned to data needs, governance expectations, and organizational compliance requirements.
What you will do
- Administer, monitor, secure, and maintain Microsoft SQL Server databases across development, testing, and production.
- Monitor database performance, identify bottlenecks, and apply SQL Server tuning strategies.
- Manage database backups and restores, disaster recovery procedures, maintenance plans, and high-availability solutions.
- Build, maintain, and troubleshoot ETL processes integrating data from multiple systems.
- Develop and support data pipelines using SQL Server Integration Services, Azure Data Factory, Microsoft Fabric pipelines, notebooks, or similar technologies.
- Support Azure Cosmos DB, including NoSQL data storage, querying, indexing, partitioning, performance monitoring, and downstream integration.
- Support Microsoft Fabric OneLake, including lakehouses, warehouses, pipelines, notebooks, semantic models, and integration with Power BI.
- Ensure data integrity, quality, privacy, security, and compliance with organizational policies and applicable regulations.
- Collaborate with stakeholders to understand data requirements and deliver effective solutions.
- Assist with database migrations, upgrades, automation, modernization efforts, and cloud data platform initiatives.
- Promote data governance best practices for data access, metadata management, and secure data sharing.
Qualifications
- Associate degree or higher in Computer Science, Information Systems, Data Engineering, Data Analytics, or a related field (preferred); equivalent professional experience may be considered.
- Professional experience in database administration, data engineering, database development, or a related technical role.
- Strong experience with Microsoft SQL Server database administration.
- Strong proficiency in T-SQL, including complex queries, stored procedures, functions, views, indexing, and query optimization.
- Experience designing, maintaining, and troubleshooting relational database structures.
- Experience with database backup and recovery, performance tuning, monitoring, indexing, security, and access management.
- Experience developing and supporting ETL/ELT processes and data pipelines, with SSIS and Azure Data Factory experience a must.
- Experience working with Azure Cosmos DB, including NoSQL data models, partitioning concepts, indexing, querying, and integration.
- Experience with Azure Data Lake Storage, including storage organization, security, file formats, and data lifecycle management.
- Understanding of modern cloud data architecture patterns, including delta lakes, lakehouses, warehouses, and medallion-style data organization.
- Familiarity with data quality, data governance, data privacy, and secure data access practices (Informatica experience is a plus).
- Ability to troubleshoot complex database design, data integration, and cloud data platform issues.
- Strong analytical, problem-solving, documentation, and communication skills.
- Ability to work both independently and collaboratively with technical and non-technical teams.
Technologies
- Microsoft SQL Server, T-SQL
- SQL Server Integration Services (SSIS)
- Azure Data Factory
- Microsoft Fabric (pipelines, notebooks, semantic models, OneLake, lakehouses, warehouses)
- Azure Cosmos DB
- Azure Data Lake Storage
- Power BI
- ETL, ELT
- Informatica
- Azure notebooks and related platform components
Position details
- Location: Salt Lake City, UT (hybrid)
- Address: 250 East 500 South, Salt Lake City, UT 84111, United States
- Schedule: Full-Time
- Hourly pay: USD $40.00 - $50.00
- Benefits: Eligible for a full benefits package
- Background check required: Yes
- Drug test required: No
- Application deadline: 11/27/2026
- Posting note: This job posting may close at any time after the minimum advertising period of three (3) business days has passed, should a sufficient applicant pool be received. Applicants are encouraged to apply as early as possible.
How to apply
Applicants must complete a work analysis to be considered for the role. Please click here to view the requirements and submit your answer.
Additional posting information
- SCHEDULE CODE: AE - Employees of the State Board of Edu. This is a career service exempt at will position.
- Remote work / in-office: Hybrid