Operations Support Engineer / SQL SSIS Developer (REMOTE)

CGS Business Solutions is committed to helping IT professionals find rewarding opportunities. They are seeking an Operations Support Engineer / SQL SSIS Developer to analyze, troubleshoot, and document issues while coordinating incident responses with support staff.

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

Requirements:

• 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
• 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
• 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
• Must be able to work Midnight to late morning shift
• Must be able to work overtime as needed, including occasional additional days if necessary
• Technical or associates degree or similar certification or working towards completion of such
• 3+ years' experience with IT departmental support or development
• 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
• 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