SQL Operations & Maintenance Analyst - Night Shift

CGS Business Solutions; California (MO); On-site; USD 70,000 - 95,000; Full time

Job summary

CGS Business Solutions is seeking a SQL Operations & Maintenance Support Analyst to monitor and troubleshoot ETL processes for a financial services client on a long-term contract with potential hire. The ideal candidate has 3–5 years’ experience in SQL Server, ETL, and production support.

Responsibilities include incident management, cross-team communications, and documenting procedures to improve efficiency. The role requires night shift availability and a strong analytical mindset.

Qualifications

• Technical or associate degree or relevant certification.
• 3+ years IT departmental support or development.
• 3+ years’ experience with SSIS (SQL Server Integration Services).
• 3+ years’ experience with Microsoft SQL Server Database administration.
• SQL Server and Windows Server certifications preferred.

Responsibilities

• Monitors nightly data load processes using server tools and email.
• Analyzes and troubleshoots nightly process errors and failure notices.
• Logs and assigns incidents in the Service Desk and records fixes.
• Coordinates with internal and outside support staff to address production issues.
• Documents processes and production jobs to build a knowledge base.
• Performs process development work and enhancements.
• Analyzes performance and tunes ETL processes for better throughput.
• Monitors server health and capacity metrics, including security and storage.
• Performs other duties as assigned.

Skills

Analytical skills

Problem solving

Collaboration

Technical skills

Incident coordination

Night shift

Education

Technical degree or relevant certification

3+ years IT support experience

SSIS experience

SQL Server DBA certification preferred

Tools

Microsoft SQL Server

SSIS

SSRS/SSAS

Windows Server

SFTP

Exchange Server

Job description

CGS Business Solutions is seeking a SQL Operations & Maintenance Support Analyst to monitor and troubleshoot ETL processes for a financial services client on a long-term contract with potential hire. The ideal candidate has 3–5 years’ experience in SQL Server, ETL, and production support.

Responsibilities include incident management, cross-team communications, and documenting procedures to improve efficiency. The role requires night shift availability and a strong analytical mindset.