Senior Database Engineer - SQL

Posted:
10/28/2024, 5:00:00 PM

Location(s):
Bristol, Connecticut, United States ⋅ Connecticut, United States

Experience Level(s):
Senior

Field(s):
Data & Analytics ⋅ Software Engineering

Job Posting Title:

Senior Database Engineer - SQL

Req ID:

10104561

Job Description:

Disney Entertainment & ESPN Technology

On any given day at Disney Entertainment & ESPN Technology, we’re reimagining ways to create magical viewing experiences for the world’s most beloved stories while also transforming Disney’s media business for the future. Whether that’s evolving our streaming and digital products in new and immersive ways, powering worldwide advertising and distribution to maximize flexibility and efficiency, or delivering Disney’s unmatched entertainment and sports content, every day is a moment to make a difference to partners and to hundreds of millions of people around the world.

A few reasons why we think you’d love working for Disney Entertainment & ESPN Technology

  • Building the future of Disney’s media business: DE&E Technologists are designing and building the infrastructure that will power Disney’s media, advertising, and distribution businesses for years to come.
  • Reach & Scale: The products and platforms this group builds and operates delight millions of consumers every minute of every day – from Disney+ and Hulu, to ABC News and Entertainment, to ESPN and ESPN+, and much more.
  • Innovation: We develop and execute groundbreaking products and techniques that shape industry norms and enhance how audiences experience sports, entertainment & news.

Engineering Services designs, builds, and sustains technology that powers DE&E Technology’s worldwide content production and distribution platforms. In doing so, they contribute to a series of cross-functional services and technologies, including Quality Assurance, Data Analytics, Software Development, Broadcast Infrastructure, and Networking & Security. 

Job Summary:

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 DE&ET’s digital media supply chain and consumer facing products.

We’re looking for an individual who can apply software engineering principles to database engineering and administration to build processes and automation to help deliver infrastructure faster, safer, more consistently, and with the right level of observability required to operate at scale.

Responsibilities and Duties of the Role:

  • Responsible for building, deploying, and ensuring all DE&ET 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:

Basic Qualifications 

  • 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 Qualifications 

  • 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.

Required Education  

  • Bachelor’s in computer science or related field and 5 + years relevant experience

Job Posting Segment:

Engineering Services

Job Posting Primary Business:

ES - Production Platforms

Primary Job Posting Category:

Software Engineer

Employment Type:

Full time

Primary City, State, Region, Postal Code:

Bristol, CT, USA

Alternate City, State, Region, Postal Code:

Date Posted:

2024-10-29