SQL Developer / SQL Database Engineer / Application DBA

ConsultNet Technology Services and Solutions; Salt Lake City (UT); On-site; USD 83,000 - 103,000; Full time

Job summary

ConsultNet Technology Services and Solutions seeks an experienced SQL Developer to join a Fortune 500 client in Salt Lake City. You will design, optimize, and maintain advanced SQL Server solutions supporting pipeline operations and enterprise systems.

This role expands into SQL Server Application DBA responsibilities, including data modeling, indexing, query tuning, and maintaining stored procedures, with a focus on data integrity and security.

Qualifications

• 5+ years of Microsoft SQL Server development experience.

Responsibilities

• Design, develop, and optimize complex SQL Server stored procedures, views, functions, and triggers.

Skills

SQL Server

T-SQL

Stored Procedures

Views

Functions

Triggers

CTEs

Windowing Functions

Query Tuning

ETL

Data Modeling

Tools

SSIS

SSRS

Azure Data Factory

Power BI

Job description

SQL Developer / SQL Database Engineer

Location: Salt Lake City, UT

Start date: ASAP

Type: Contract (12+ Months with Extension Potential)

Compensation: $60-$75/hr DOE

Overview

We are seeking an experienced SQL Developer to join a Fortune 500 company responsible for supporting critical pipeline operations and enterprise business systems. This role is ideal for someone with advanced SQL Server development skills who also has an interest or background in database administration. You will design, optimize, and maintain complex SQL solutions supporting pipeline operations, regulatory reporting, scheduling, accounting, asset management, and enterprise applications. This position will expand into SQL Server Application DBA responsibilities including data modeling, designing and maintaining tables and indexes, query tuning, refactoring, and maintaining complex stored procedures.

Key Responsibilities

• Design, develop, and optimize complex SQL Server stored procedures, views, functions, and triggers.
• Write efficient T-SQL queries for large, highly transactional databases.
• Troubleshoot and improve SQL performance using execution plans, indexing strategies, and query optimization.
• Develop ETL processes and automate data movement between enterprise systems.
• Support business reporting and analytics by building reliable database objects.
• Collaborate with application developers, business analysts, and infrastructure teams to deliver scalable database solutions.
• Participate in database design, schema modifications, and data modeling.
• Coordinate with System DBA's to request database maintenance, backups, restores, security, and disaster recovery planning.
• Monitor database health and recommend improvements for performance and reliability.
• Support production deployments and troubleshoot database-related production issues.
• Ensure data integrity, compliance, and security across critical business systems.

Required Qualifications

5+ years of Microsoft SQL Server development experience.

Expert-level T-SQL programming skills.

Strong experience developing:

• Stored Procedures
• Views
• Functions
• Triggers
• Complex joins
• CTEs
• Windowing functions

Experience with SQL Server performance tuning and optimization.

Strong understanding of indexing strategies and execution plans.

Experience working with large enterprise databases.

Knowledge of database normalization and relational database design.

Experience supporting production environments.

Strong troubleshooting and analytical skills.

Excellent communication and collaboration abilities.

Preferred Qualifications

Experience with SSIS, SSRS, or Azure Data Factory.

Experience with Power BI or enterprise reporting platforms.

Familiarity with C#, .NET, or API integrations.

Experience with source control (Git or Azure DevOps).

Exposure to cloud database technologies.

Industry Experience Preferred

• Natural Gas Transportation
• Oil & Gas
• Utilities
• Energy
• Pipeline Operations
• Manufacturing
• Industrial Operations

Nice to Have

When working with System DBA's as the Application DBA, having SQL Server Administration experience would be a plus.

Knowledge such as:

• Backup & Recovery
• Database Security
• Maintenance Plans
• SQL Server Agent
• High Availability concepts
• Performance Monitoring
• Experience supporting SCADA or operational technology (OT) systems.
• Familiarity with pipeline scheduling, nominations, gas accounting, or asset management systems.
• Knowledge of regulatory reporting and compliance data.

What You'll Bring

• Passion for solving complex data challenges.
• Ability to work independently while collaborating across technical and business teams.
• Strong attention to detail and commitment to data quality.
• Desire to expand into database administration and enterprise data architecture.

Welcome to ConsultNet, a premier national provider of technology talent and solutions. Our expertise spans across project services, contract-to-hire, direct search, and managed services onshore, nearshore, and hybrid. For over 25 years, we have connected thousands of consultants with meaningful roles through a personal, communication-driven approach, partnering with a diverse client base to build high-performing teams and create lasting impact. Our comprehensive service offerings cover a wide range of technology and engineering positions across key markets nationwide. Learn more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.