Associate - SQL Developer

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

• 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
• 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

Requirements

• 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

Preferred

• Experience with data sourced from mainframe systems is a plus (COBOL, VSAM, and MVS)
• Insurance industry experience preferred