Remote Production Support Technician - SQL/ETL

Carrington; Salt Lake City (UT); Remote; USD 85,000 - 95,000; Full time

Benefits offered by this job

Healthcare plans

401(k) match

Employee discounts

Training programs

Referral bonuses

Educational reimbursement

Job summary

Carrington Mortgage Holdings is seeking a Production Support Technician to monitor nightly ETL processes, troubleshoot issues, and coordinate incident response. The role emphasizes SQL/SSIS, Windows Server, SharePoint documentation, and knowledge-base development to support enterprise data operations.

The position requires off-hours availability (midnight to late morning) and the ability to work overtime as needed. It offers a competitive pay range and comprehensive benefits.

Qualifications

• Must be able to work the Midnight to late morning shift.
• Must be able to work overtime as needed.
• Knowledge of enterprise solutions using Microsoft SQL Server (2008+), Microsoft Reporting Services or Microsoft Analysis Services
• Experience using enterprise ETL applications such as Microsoft SSIS
• Microsoft Windows Server (2008+)
• Knowledge of SFTP
• Microsoft Exchange (2010+)
• Knowledge of change management
• Technical or associate degree or similar certification or working towards completion of such.
• 1 - 2 years’ experience with IT departmental support or development
• 1 – 2 years’ experience with SSIS preferred.
• 1 – 2 years’ experience with Microsoft SQL Server Database administration preferred.
• SQL Server and Windows Server certifications preferred

Responsibilities

• Monitors nightly software data load processes using server management tools and email.
• Analyzes and troubleshoots nightly process errors and failure notices using server management and software development tools and other software utilities.
• Logs and assigns incidents in the Service Desk product, and records incident fixes and other incident analysis.
• Communicates with internal tier 2 support staff and outside vendor support staff as necessary to address production issues and coordinate efforts.
• Documents processes and production jobs in Service Desk, Sharepoint and elsewhere with a goal toward establishing a knowledge base for general understanding by all support staff.
• Performs process development work and process enhancements.
• Analyzes process performance, identifies process improvement opportunities and performs performance tuning on systems and processes to improve overall ETL performance.
• Monitors server health and performance during off hour periods including, but not limit to; Citrix, E-Mail, FTP, Storage Utilization, network uptime, security, and other performance/capacity metrics.
• Strong analytical, problem solving, collaboration and technical skills
• SQL Queries

Skills

SQL Queries

Analytical skills

Problem solving

Team collaboration

IT support

Education

Technical or associate degree or similar certification

Tools

SSIS

SQL Server

Windows Server

SFTP

SharePoint

Service Desk

Job description

Carrington Mortgage Holdings is seeking a Production Support Technician to monitor nightly ETL processes, troubleshoot issues, and coordinate incident response. The role emphasizes SQL/SSIS, Windows Server, SharePoint documentation, and knowledge-base development to support enterprise data operations.

The position requires off-hours availability (midnight to late morning) and the ability to work overtime as needed. It offers a competitive pay range and comprehensive benefits.