Sr Database Administrator job at The Walt Disney Company

Job Description

Job Summary:

At Disney, we‘re storytellers. We make the impossible, possible. We do this through utilizing and developing cutting-edge technology and pushing the envelope to bring stories to life through our movies, products, interactive games, parks and resorts, and media networks. Now is your chance to join our talented team that delivers unparalleled creative content to audiences around the world.

The Senior Database Administrator position works in a central team of Database Engineers and Administrators supporting DBMS for DTSS development teams and customers. Primary focus will be the support of RDBMS for customer internet sites and applications. Key responsibilities include Cloud (AWS) data migrations, upgrades, installations, optimization and tuning, scripting/programming, data loads, ETL, automation, security management(Encryption), backup and recovery, issue troubleshooting, advanced replication implementation, Disaster Recovery and High Availability designs. Additional tasks as assigned.

The ideal candidate will have excellent technical expertise in relevant state of the art relational database systems, technologies, and design; 4 or more years’ experience focused on MySQL/Galera, AWS RDS, Aurora, Postgres RDBMS; experience with MS SQLServer is a plus.

Responsibilities:

Leads and completes tasks independently, with attention to detail and while under pressure. Work with team in a collabrative environment
Excellent judgment, problem resolution, negotiation, and decision-making skills as well as the ability to work under continual deadline pressure.
Identifies, analyzes, and drives problems to resolution, handling complex issues simultaneously while effectively communicating across teams
Effectively communicates technical actions and expectations to the appropriate audience
Delivers customer service excellence by identifying appropriate technical solutions, and meeting/exceeding service expectations
Knowledge in 2 or more relavent areas including but not limited to: Cloud Computing, Internet Security, Hardware systems, Networking systems, Storage technolgies, Data Warehouse/Business Intelligence, Data Center Facilities, Ecommerce platforms are desired

Basic Qualifications:

Required strong experience with AWS RDS(MySql, Aurora, MariaDB), AWS EC2, MySQL, Galera, ProxySQL, Postgres
Solid shell(bash, powershell) scripting experience (Python and Ruby a plus)
Multiple years of experience with MySQL (familiarity with 5.6 and above required)
Experience with using AWS EC2, RDS, Aurora, AWS DMS a must.
Knowledge of different replication and clustering strategies and experience setting up replication between 2 or more hosts across Regions and DataCenters.
Architect and implement Security Compliance across all data platforms. PCI, PII
Experience setting up highly-available solutions for load balancing, connection pooling, and query partitioning.
Performance tuning skills; understanding of SQL Execution Plans
Ability to proactively identify, troubleshoot and resolve live database systems issues
Experience with automating tasks, deployments, and patching
Experience with monitoring database/system performance using Enterprise monitoring tools CloudWatch, Datadog, NewRelic
Strategies for performant and non-impactful backup/restore of high-volume live site DB's
SQL development experience for stored procedures/functions/extensions, ETL and OLAP data loads
Degree in computer science/information systems, engineering or related field preferred; or a corresponding number of years’ experience in technical operations or software engineering.
4 or more years of experience with relational database management systems with a focus on MS SQLServer Always On and AWS services.
2-4 years’ experience with configuration, troubleshooting, performance tuning, and security procedures; experience with Linux
2 or more years of IT operational experience supporting media, e-commerce, gaming or online businesses in a 24X7 production environment
Expertise in relational database administration including configuration, implementation, data modeling, maintenance, redundancy/HA, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL.
Expertise in configuring, implementing and supporting high availability redundancy strategies on systems including replication, clustering, log shipping, mirroring.
Expertise in relational database design and architectural principles and methodologies
Expertise with Disaster Recovery planning and implementation.
Demonstrated experience with troubleshooting systems issues and effectively diagnosing problems
Excellent knowledge of hardware, EBS Cloud storage, RAID, and disk subsystems technologies as they pertain to DBMS systems, familiarity with SAN technologies desired
Excellent systems documentation and diagraming skills
Experience with project management methologies and handling complex projects.
Experience with relevant scripting languages or programming frameworks desired (JavaScript, Python, perl, C; powershell, .Net a plus)
Knowledge of understanding of TCP/IP fundamentals (DNS, FTP, SSH), general networking technologies, AWS VPC stack, network architecture and connectivity troubleshooting

Preferred Education

Degree in computer science/information systems, engineering or related field preferred; or a corresponding number of years’ experience in technical operations or software engineering.

About The Walt Disney Company (Corporate):

At Disney Corporate you can see how the businesses behind the Company’s powerful brands come together to create the most innovative, far-reaching and admired entertainment company in the world. As a member of a corporate team, you’ll work with world-class leaders driving the strategies that keep The Walt Disney Company at the leading edge of entertainment. See and be seen by other innovative thinkers as you enable the greatest storytellers in the world to create memories for millions of families around the globe.

About The Walt Disney Company:

The Walt Disney Company, together with its subsidiaries and affiliates, is a leading diversified international family entertainment and media enterprise with the following business segments: media networks, parks and resorts, studio entertainment, consumer products and interactive media. From humble beginnings as a cartoon studio in the 1920s to its preeminent name in the entertainment industry today, Disney proudly continues its legacy of creating world-class stories and experiences for every member of the family. Disney’s stories, characters and experiences reach consumers and guests from every corner of the globe. With operations in more than 40 countries, our employees and cast members work together to create entertainment experiences that are both universally and locally cherished.

This position is with Disney Worldwide Services, Inc., which is part of a business segment we call The Walt Disney Company (Corporate).

Disney Worldwide Services, Inc. is an equal opportunity employer. Applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Disney fosters a business culture where ideas and decisions from all people help us grow, innovate, create the best stories and be relevant in a rapidly changing world.

Interested in this position?

Click here to learn how to get in touch