What are the responsibilities and job description for the Database Developer position at People's Trust Insurance?
Job Description
This is a Microsoft SQL Server database developer role largely responsible for providing database design services to the organization’s software projects in development. Some of the primary responsibilities of this role include analyzing requirements, documenting, and building out the proposed designs. The position also calls for some operationally oriented services, like tracking and resolving database related incidents and resolving them to meet SLAs, responding to data related escalations, and working with QA and development teams to come up with solutions to recurring problems.
Requirements:
Technical
• Ability to analyze requirements and documentation to design well normalized databases
• Ability to write clean and concise stored procedures and functions for our web apps
• Ability to produce ad-hoc queries and develop reports to support business needs
• Proficiency with configuration tuning, optimizing queries and stored procedures, and managing triggers
• An aptitude for troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues
Professional
• 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, including proactively escalating any issues that cannot be resolved within established timeframes
Bonus points for:
• 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
• Familiarity with new features available in SQL Server 2016
• Knowledge of performance monitoring tools such as Dell/Quest Spotlight