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