SQL Operations & Maintenance Support / Analyst - REMOTE

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 / Anlayst with 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.