SQL Operations & Maintenance Support / Analyst - REMOTE

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 committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:

SUMMARY

CGS is hiring for a SQL Operations & Maintenance Support / Anlaystwith one of its Financial Services customers on a long-term contract possible contract to hire engagement. Ideal candidate will have 3-5 years’ experience and must be able to analyzes, troubleshoot and document issues and processes.Communicates and coordinates incident response with other support staff as required. Performs all duties in accordance with all company guidelines and applicable federal, state and local regulations wherein the company operates.

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.
• Perform other duties as assigned.

COMPETENCIES

• Strong analytical, problem solving, collaboration and technical skills
• 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
• Must be able to work Midnight to late morning shift.
• Must be able to work overtime as needed, including occasional additional days if necessary.

PREFERRED

• 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

EDUCATION

• Technical or associates degree or similar certification or working towards completion of such.
• 3+ years’ experience with IT departmental support or development
• 3+ years’ experience with SQL Server Integration Tools (SSIS) preferred.
• 3+ years’ experience with Microsoft SQL Server Database administration preferred.
• SQL Server and Windows Server certifications preferred

About CGS Business Solutions:

CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.