Candidates must live in one of the following states: PA, NJ, NH, DE, CO, SD, TX, WY, AK, FL.

The Senior Database Developer is an expert in SQL Server database systems, configuration best practices, normalization strategies and coding standards. They are responsible for collaborating with the development team on future enhancements and improving existing systems through normalization and SQL optimizations. They coordinate database development tasks with product owners and work closely with the development team to translate business requirements to database design and implementation. They serve as an authority on database best practices and inform proper database design and performant SQL implementations

Responsibilities: 

• Serve as a database authority, collaborate with and mentor team members on database best practices to inform proper database design and performant SQL implementations
• Design and redesign databases to follow 3rd Normal Form (3NF), ensuring proper use of indexes, keys, and statistics for efficient data retrieval and integrity
• Manage and maintain database schemas using tools like SSDT (SQL Server Data Tools) to enable version control, validation, and automated deployments
• Write, review and optimize T-SQL queries, stored procedures, and functions to ensure they adhere to coding standards, performance recommendations and security best practices
• Diagnose and resolve performance issues caused by inefficient SQL queries, improper indexing, or suboptimal database design
• Participate in regular sprint planning, retrospectives, daily scrum and other group functions as part of agile development teams
• Support the operations teams on production issues, deployments, server maintenance, Disaster Recovery (DR) strategies, backups and other production service requests 
• Position requires occasional after-hours work during releases or other critical initiatives

Requirements: 

• Deep knowledge of SQL Server internals, including indexing strategies, statistics, execution plans, and performance tuning
• Expert developing Microsoft SQL Server databases in a large scale multi-tenant enterprise environment
• Expert in writing and reviewing performance optimized T-SQL including stored procedures and functions in a multi-tenant high-volume enterprise database environment 
• Expert in translating business requirements into normalized, performant database schema
• Expert in database normalization and denormalization
• Expert in analyzing and optimizing query performance through schema changes, SQL enhancements and indexing strategies
• Experience maintaining database schemes using data tools, version control and automated deployments
• Experience diagnosing and resolving slow queries, deadlocks, and performance bottlenecks
• Experience unit testing stored procedures and implementing sql testing frameworks is a plus
• The ideal candidate:
  • Will be able to work independently as well as in a group
  • Will suggest improvements to both the technology and business functionality of the product
  • Will estimate work activity, will deliver high-quality, low-defect engineering work product within established timelines and will ensure effective information flow throughout 
  • Will have excellent communication skills, a strong work ethic, good time management and decision making capabilities

Education and Experience: 

• 10+ years of experience developing SQL in an enterprise environment
• 10+ years of experience designing and implementing databases in an enterprise environment
• Bachelor’s degree in Computer Science or equivalent in a related field