Sr. Database Engineer, SQL Server

Sr. Database Engineer, SQL ServerDisney Entertainment and ESPN Product & Technology is a global organization of engineers, product developers, designers, technologists, data scientists, and more – all working to build and advance the technological backbone for Disney's media business globally.The team marries technology with creativity to build world-class products, enhance storytelling, and drive velocity, innovation, and scalability for our businesses. We are Storytellers and Innovators. Creators and Builders. Entertainers and Engineers. We work with every part of The Walt Disney Company's media portfolio to advance the technological foundation and consumer media touch points serving millions of people around the world.The individual in this position will join the Data Stores team in an exciting and fast-paced environment where they will help build and maintain highly available relational database systems operating across multiple cloud and on-premise environments. These databases support many of the systems powering DEEP&T's digital media supply chain and consumer facing products.Responsibilities and Duties of the Role: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.Builds relationships with engineering teams and leads.Required Education, Experience/Skills/Training: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.The hiring 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.