SQL Developer

Job Description:

Job Overview

The SQL Database Developer is responsible for supporting projects in a dynamic, fast paced, scalable, and agile environment. Tasks include the design and development of backend database solutions in support of meeting the goals of the company. The Database Developer will interface with business users to ensure the database is satisfying business requirements.

Responsibilities & Duties*

Back-End Database Infrastructure

• Create and maintain database stored procedures, functions, batch services, Windows Services, and WCF components
• Implement and test database design and functionality, and tune for performance
• Locate and define new process improvement opportunities

Data Conversion and Data Migration

• Create and maintain integrations to both internal and external applications through data feeds
• Acquire, understand, manipulate, and organize data from various sources
• Create and maintain existing SQL Server Integration Packages

Provide Systems Support

• Ensure business process integrity is maintained
• Provide coverage of automated back-end processes, especially during off-production hours; this coverage will be on a rotating basis amongst team members
• Maintain and develop documentation of IT processes

System Design and Technical Leadership

• Participate in the evaluation of business requirements and processes, preparation of application system specifications and the development, testing and implementation of efficient, cost effective applications solutions
• Provide design input and direction for new database development
• Follow procedures for change control and product migration

System Development

• Review documented business requirements and test plans and provide technical feedback to Business Analysts

Testing/Troubleshooting

• Ensure quality with thorough unit testing of all code and participating in systems integrated testing
• Assist Business Analysts and End Users with any technical issues during systems integrated testing, parallel testing, training sessions and demonstrations

System Support

• Provide on-call support for the production systems on a rotating basis
• Maintain existing applications adhering to the established architecture and standards for that application

Documentation

• Write technical documentation in support of assigned projects
• Document all code using format established by the project

Communication

Develop and maintain effective relationships and communication with the team, other co-workers, management, clients and vendors

Experience & Education*

• Bachelor’s degree in Computer Science or related field
• Three to five years’ software development experience

• SQL Server SSRS, WPF, Web Service Development , MVC are a plus
• Experience with data sourced from mainframe systems is a plus (COBOL, VSAM, and MVS) 
• Insurance industry experience preferred

Knowledge, Skill, ability

• Excellent written and oral communication skills
• Ability to mentor and coach
• Ability to work in a fast-paced environment
• Ability to work individually and as a team player
• Ability to adapt to changes in the work environment
• Ability to work remotely with limited interaction with fellow team members 
• Ability to learn and work with third party software vendors and/or systems

Essential requirement (non-negotiable) *

• Experience in developing systems using C#, Visual Basic, .NET and SQL Server
• Experience with SQL-ANSI-standard, SQL Server SSIS
• Experience in working with Microsoft Word and Excel