Database Developer

$125,000 - $125,000/Yr

People's Trust Insurance Company - Deerfield Beach, FL

Full-time - Mid Level

Deerfield Beach, FL

Insurance Carriers and Related Activities

About the position

This position is for a Microsoft SQL Server database developer responsible for providing database design services to the organization's software projects. The role involves analyzing requirements, documenting designs, and building out proposed solutions. Additionally, the developer will handle operational tasks such as tracking and resolving database incidents, responding to escalations, and collaborating with QA and development teams to address recurring issues.

Responsibilities

• Analyze requirements and document database designs.
• Build out proposed database designs for software projects.
• Track and resolve database-related incidents to meet SLAs.
• Respond to data-related escalations.
• Collaborate with QA and development teams to find solutions to recurring problems.

Requirements

• Ability to analyze requirements and documentation to design well-normalized databases.
• Ability to write clean and concise stored procedures and functions for web applications.
• Ability to produce ad-hoc queries and develop reports (SSRS) to support business needs.
• Proficiency with configuration tuning, optimizing queries and stored procedures, and managing triggers.
• Aptitude for troubleshooting and resolving database integrity, performance, blocking, deadlocking, replication, connectivity, and security issues.
• Successful 3-5 year track record of designing and administering SQL Server databases.
• Ability to work in an agile environment.
• Strong oral and written communication skills.

Nice-to-haves

• Experience with SQL Server High Availability (2012/2014 Always-On Feature).
• Experience with real-time data replication and conversion.
• Experience with TFS and Visual Studio 2015.
• Knowledge of performance monitoring tools such as Dell/Quest Spotlight.

Benefits

• Competitive salary starting from $125,000 per year.