Senior SQL Server Developer(DevOps)

The Ceres Group, L.L.C. - Boston, MA

Full-time - Mid Level

Boston, MA

Performing Arts, Spectator Sports, and Related Industries

About the position

The Senior SQL Server Developer (DevOps) is responsible for ensuring the availability and optimization of production, development, and QA database environments. This role requires a solid understanding of SQL Server internals and the ability to analyze and resolve performance issues. The candidate will provide technical expertise to multiple delivery teams in a DevOps environment, ensuring that database code is optimized and scalable while maintaining high availability.

Responsibilities

• Ensure that the firm's databases are available to end users at all times, 24x7x365, including on-call rotation
• Provide guidance to delivery teams to ensure that database code is optimized, scalable, and meets standards
• Implement enhancements and updates to ensure database technology is current
• Efficiently and effectively troubleshoot problems in all environments as they arise
• Ensure that database and query performance are optimized
• Identify and remediate performance issues in the production environment before they impact the business

Requirements

• Bachelor's degree in computer science or a related technical field is preferred
• 5-8 years of closely related experience with Microsoft SQL Server 2012 and later
• Experience with additional Microsoft database related technologies such as SSIS, SSRS, and SSAS
• Exposure to Agile software methodology and CI/CD tools and practices
• Advanced T-SQL programming, performance, and optimization techniques
• Experience with backup/recovery tasks, user administration, and SQL Server installation and configuration
• Strong understanding of database replication technologies, configuration and performance in a clustered environment
• Software development or scripting experience (powershell, python, C#, etc.)
• Familiarity with Windows Server 2008/2012, Linux, Sybase ASE 15