Note: The job is a remote job and is open to candidates in USA. CGS Business Solutions is committed to helping IT Professionals find the next right step in their career. They are currently seeking an Operations Support SSIS Analyst / SQL Data Analyst to analyze, troubleshoot, and document issues and processes for a Financial Services customer on a long-term contract engagement.
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
Skills
- 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
- 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
- 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
Company Overview