Sr. Database Engineer, SQL Server

About the role

This is an on-site role requiring 4 days in-person at designated office location.

Responsibilities

• Responsible for building, deploying, and ensuring all DEEP&T database infrastructure is available 24/7/365.
• Leverage software development and automation to design, modernize, and deliver database infrastructure.
• Participates in setting the architectural direction for database platforms and projects.
• Manage multiple competing priorities in a fast-paced, deadline-oriented environment.
• Analyze, design, and deploy fault-tolerant, distributed, and highly available database infrastructure.
• Proactively plan and implement infrastructure changes through capacity forecasting, software release cycles, and right sizing.
• Provide database expertise through performance tuning, troubleshooting and administration.
• Develop, enhance, and adhere to engineering and administration standards.
• Develop automation and tooling to increase operational efficiency while ensuring system reliability and security.
• Build infrastructure and systems for scalability, resiliency, availability, and recovery though infrastructure as code and configuration management.
• Provide relevant insights of data store infrastructure through metrics, monitoring, and alerting.
• Maintain thorough and well-written documentation.
• Participate in live event support and on-call rotation.
• May provide oversight and direction to junior team members.

Requirements

• Basic Experience:
• Bachelor's degree, preferably in computer science, Engineering, or related field (or equivalent experience).
• 5+ years of related work experience with Microsoft SQL Server, Amazon RDS for SQL Server, Azure SQL, and Azure SQL MI.
• Fundamental understanding of Microsoft SQL Server database internals.
• Experience working in Agile software development.
• Experience with source control management tools (Git, GitLab, GitHub).
• Intermediate to advanced level of expertise in one or more programming languages such as Python, Java, or Go.
• General understanding and experience with Windows operating system, network, and containers.
• Excellent verbal and written communication skills.
• Experience designing and deploying fault-tolerant, distributed, and highly available database infrastructure.
• Experience in database availability monitoring and status reporting using native monitoring tools.
• Well-versed in SQL Server backup, restore, and recovery strategies.
• Experience keeping a large environment compliant by deploying SQL Server patches and upgrades.
• Experience with disaster recovery planning and implementation.
• Carries out assignments with little coaching or guidance from others.
• Preferred Experience:
• Experience operating within a database reliability engineering (DRE) and/or systems reliability engineering (SRE) role.
• Experience running, deploying, and maintaining production systems in Azure and Amazon Web Services.
• Experience with infrastructure as code (Terraform, CloudFormation).
• Experience building a proper path to production leveraging multiple lifecycles, testing, integration, and CI/CD pipelines.
• Experience with the configuration and implementation of SQL Server Always On availability groups.
• Experience with configuration management (Ansible, Chef).
• Comfortable collaborating with cross-functional teams providing guidance in SQL Server best practices.
• Experience with proactively identifying problems/areas of improvement and designing creative solutions to successfully remediate issues.

Qualifications

• Basic Qualifications:
• Bachelor's degree, preferably in computer science, Engineering, or related field (or equivalent experience).
• 5+ years of related work experience with Microsoft SQL Server, Amazon RDS for SQL Server, Azure SQL, and Azure SQL MI.
• Intermediate to advanced level of expertise in one or more programming languages such as Python, Java, or Go.
• General understanding and experience with Windows operating system, network, and containers.
• Excellent verbal and written communication skills.
• Experience designing and deploying fault-tolerant, distributed, and highly available database infrastructure.
• Experience in database availability monitoring and status reporting using native monitoring tools.
• Well-versed in SQL Server backup, restore, and recovery strategies.
• Experience keeping a large environment compliant by deploying SQL Server patches and upgrades.
• Experience with disaster recovery planning and implementation.
• Carries out assignments with little coaching or guidance from others.

Skills

• Software engineering principles to database engineering and administration.
• Writing code, completing programming tasks, and performing testing and debugging of applications.
• Conceiving and implementing software components, fixes, enhancements, and new systems.
• Providing database expertise through performance tuning, troubleshooting and administration.
• Developing, enhancing, and adhering to engineering and administration standards.
• Developing automation and tooling to increase operational efficiency while ensuring system reliability and security.
• Building infrastructure and systems for scalability, resiliency, availability, and recovery though infrastructure as code and configuration management.
• Providing relevant insights of data store infrastructure through metrics, monitoring, and alerting.
• Maintaining thorough and well-written documentation.
• Participating in live event support and on-call rotation.
• Collaborating with cross-functional teams providing guidance in SQL Server best practices.

Benefits

Base pay range for this position in Bristol, CT is $141,900 to $190,300 and in New York is $148,700 to $199,400 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.

Pay

The base pay range for this position in Bristol, CT is $141,900 to $190,300 and in New York is $148,700 to $199,400 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.

Schedule

The base pay range for this position in Bristol, CT is $141,900 to $190,300 and in New York is $148,700 to $199,400 per year. The base pay actually offered will take into account internal equity and also may vary depending on the candidate’s geographic region, job-related knowledge, skills, and experience among other factors. A bonus and/or long-term incentive units may be provided as part of the compensation package, in addition to the full range of medical, financial, and/or other benefits, dependent on the level and position offered.