Night Shift Production Support Technician (ETL/SQL)

Carrington; Salem (OR); 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 in Oregon to analyze, troubleshoot, and document issues in nightly ETL and server processes. You will coordinate incident response with support staff and document procedures to build a knowledge base for the team.

The role requires experience with SQL Server/SSIS, Windows Server, and related enterprise tools, plus flexibility for off-hours shifts and overtime. Training and growth opportunities are offered.

Qualifications

• Must be able to work Midnight to late morning shift.
• Overtime availability including occasional extra days 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
• Ability to understand, remember, and apply oral and/or written instructions or other information
• Ability to understand, remember, and communicate routine, factual information
• Ability to understand complex problems and to collaborate and explore alternative solutions
• Ability to apply common sense in performing job
• Ability to make decisions that have moderate impact on the immediate work unit
• Ability to organize thoughts and ideas into understandable terminology
• Ability to add, subtract, multiply, divide and to record, balance, and check results for accuracy
• Ability to understand and follow basic instructions and guidelines
• Ability to compose letters, outlines, memoranda, and basic reports and/or to orally communicate technical information
• Ability to express or exchange ideas by means of the spoken word, communicating orally with others accurately, audibly, and quickly

Skills

Analytical thinking

Troubleshooting

SQL Queries

Communication

Attention to detail

Education

Technical or associate degree or certification

Tools

SSIS

SQL Server

Windows Server

SFTP

Microsoft Exchange

Job description

Carrington Mortgage Holdings is seeking a Production Support Technician in Oregon to analyze, troubleshoot, and document issues in nightly ETL and server processes. You will coordinate incident response with support staff and document procedures to build a knowledge base for the team.

The role requires experience with SQL Server/SSIS, Windows Server, and related enterprise tools, plus flexibility for off-hours shifts and overtime. Training and growth opportunities are offered.