Posted: Monday, July 3, 2017 1:37 AM
O*NET 15-1133.00, 15-1132.00, 15-1199.02 Position Summary: The SQL Developer is responsible for providing direct support to ConServe's application landscape in addition to developing and implementing Business and IT application improvement initiatives/projects. Under the direction of the Applications Development Manager, the Applications Analyst II actively supports all aspects of the projects from start to finish with a particular emphasis on program development, quality testing and end user enablement. Essential Duties & Responsibilities: Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner. Recommends technical solutions to reported problems, identifying pros and cons of each solution. Engages project sponsors to understand business concerns / objectives and collaboratively identify and implement solutions. Creates, enhances and maintains custom and COTS applications. Plan, develop, test and install systems solutions to enable new business lines and/or departments as well as special Client requests. Recognizes, raises awareness to and implements improvements in IT keep-it-running activities. Mentors and cross-trains team members on IT keep it running processes, ensuring supportability across the team. Train users on the new/modified applications. Quality control of application system functionality to ensure data integrity and system synergy with all peripheral devices. Confirms software solutions by conducting tests and modifying code and/or configuration. Provide guidance and support the end users in their efforts to become more proficient in the use of the applications. Generate Ad-hoc reports as needed. Provides reference documentation by writing and maintaining functional and technical specifications. Maintains system and programming guidelines by adhering to the software development lifecycle. Protects operations by keeping information confidential. Adherence to ConServe's Professional Practices Management System (PPMS), Code of Conduct, and Compliance Program. Education: High School Diploma or GED Bachelor's Degree in Information Technology or related field or equivalent combination of education and related experience. Skills/ Requirements: Three (3) years of experience in an applications development role. Three (3) years of experience in ETL development with the SSIS toolset preferred. Experience writing and troubleshooting SQL queries. Experience with MS SQL Server working with a relational database management system as a developer preferred. Knowledge of SSRS reporting preferred. Knowledge of C# preferred. Knowledge of Cisco TIDAL Workflow scheduler preferred. Ability to act independently to resolve problems. Good verbal communication skills and interpersonal skills. Must show a sense of urgency, being able to perform and multitask under pressure. Solid experience with Microsoft Office suite of products. Must be able to provide on-call support on a rotating basis. US Citizenship or Lawful Permanent Resident Alien with three or more years of US residency from date of legal entry into US Ability to obtain and maintain Government Security Clearance. No conflicts of interest with ConServe or our Clients.
• Location: Fairport, Rochester
• Post ID: 27786218 rochester