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

3-5 years of experience The MySQL & SQL DBA is responsible for the installation, configuration, maintenance, security, and performance tuning of both Microsoft SQL Server and MySQL database environments. This role ensures the company's data assets are stable, reliable, secure, and performant to support business operations and application needs.   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.