Analyst IT Operations(MySQL & SQL DBA (Database Administrator))

Company Description

CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

Job Description

Key Roles and Responsibilities

      I.         Database Administration & Maintenance
 a. Installation & Configuration: Install, configure, and maintain database software across multiple environments (development, staging, production) for both MS SQL Server and MySQL.
 b. Monitoring & Optimization: Proactively monitor database system performance, identify bottlenecks, and implement solutions for performance tuning, including query optimization, index management, and server configuration adjustments.
c.  High Availability & Disaster Recovery: Implement and manage High Availability (HA) and Disaster Recovery (DR) solutions, such as SQL Server's Always On Availability Groups, Log Shipping, Mirroring, and MySQL Replication/Clustering, to ensure business continuity.
d. Backup & Recovery: Define, implement, and test robust backup and recovery strategies for all databases to ensure data integrity and minimal data loss in case of failures.
e. Patching & Upgrades: Plan, schedule, and execute database software patching, upgrades, and migrations with minimal downtime.
f. Storage Management: Manage disk space allocation, capacity planning, and resource utilization for both database platforms.
     II.         Security & Compliance
a. Access Control: Implement and manage database security, including user accounts, roles, permissions, and auditing to protect sensitive data.
b. Security Audits: Conduct regular security reviews and implement security best practices and compliance requirements.
   III.         Development & Support
a. Troubleshooting: Diagnose and resolve complex database-related issues, including connection problems, data corruption, and application errors, providing on-call support as needed.
b. Scripting & Automation: Write, modify, and optimize T-SQL (for SQL Server) and standard SQL/Stored Procedures/Functions (for both), and use scripting languages (e.g., PowerShell, Python, Bash) to automate routine DBA tasks.
   IV.         Collaboration: Work closely with developers, system administrators, and application teams to assist with database design, data modeling, query optimization, and deployment processes.
    V.         Documentation: Create and maintain comprehensive documentation for database procedures, configurations, standards, and troubleshooting guides.

Qualifications and Skills

        I.         Technical Expertise:
   Should be able to support: Microsoft SQL Server (T-SQL, SSMS, SSRS, SSIS, Always On, Clustering), MySQL (InnoDB/MyISAM, Replication, Clustering, Query Optimization)
   In-depth knowledge of SQL and T-SQL scripting.
   Proven expertise in Performance Tuning and Query Optimization for both environments.
   Strong understanding of database Backup and Recovery concepts and tools.
   Experience with High Availability and Disaster Recovery setups.
   Familiarity with Windows Server (for SQL Server) and Linux/Unix operating systems (for MySQL).
   Proficiency in at least one scripting language (e.g., PowerShell, Python).
   Knowledge of Data Modeling and database design principles.
      II.         Problem-Solving: Excellent analytical and troubleshooting skills to quickly diagnose and resolve complex technical issues in a mission-critical production environment.
     III.         Complete knowledge of ITIL.
    IV.          Soft Skills: Strong communication, documentation, and ability to work in a team or provide 24/7 on-call support.
      V.         Minimum Requirements
 Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
 4-6+ years of experience as a Database Administrator supporting production environments.
 Demonstrable experience administering both Microsoft SQL Server and MySQL databases.
 Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional - MySQL, etc.) are a plus.

Qualifications

What We’re Looking For: 

• Demonstrated a growth mindset by staying curious and continuously learning, embracing challenges, and improving themselves.
   

Additional Information

Don’t meet every single requirement? At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles.

How We Work:
We are a purpose driven company aiming to empower generations to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:

• We collaborate: Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
• We innovate: At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
• We execute: We are a performance-driven company. We strive for excellence and are focused on pursuing best-in-class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.

Our Approach to Flexible Work:
We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.

Who We Are:
Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our offerings include toys, content, consumer products, digital and live experiences. Our products are sold in collaboration with the world’s leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering generations to explore the wonder of childhood and reach their full potential.

Mattel’s award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.

Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment.

Videos to watch:
The Culture at Mattel
Corporate Philanthropy