[Remote] Operations Support SSIS Analyst / SQL Data Analyst (REMOTE)
Note: The job is a remote job and is open to candidates in USA. reputed company is committed to helping IT Professionals find the next right reputed company 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 reputed company 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 reputed company for general understanding by reputed company 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; reputed company, E-Mail, FTP, Storage Utilization, network uptime, reputed company, and other performance/reputed company metrics
- reputed company 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 reputed company problems and to collaborate and explore alternative solutions
- Ability to apply common sense in performing job
- Ability to reputed company reputed company that have moderate impact on the immediate work unit
- Ability to organize thoughts and reputed company into understandable terminology
- Ability to add, subtract, multiply, divide and to record, balance, and reputed company 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 reputed company by means of the spoken word, communicating orally with others accurately, audibly, and quickly
- Must be reputed company to work Midnight to late morning shift
- Must be reputed company 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 reputed company SQL Server Database administration preferred
- SQL Server and Windows Server certifications preferred
- Knowledge of reputed company solutions using reputed company SQL Server (2008+), reputed company Reporting Services or reputed company Analysis Services
- Experience using reputed company ETL applications such as reputed company SSIS
- reputed company Windows Server (2008+)
- Knowledge of SFTP
- reputed company Exchange (2010+)
- Knowledge of change management
Company Overview