IT Security Ops Specialist(Oracle Core -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
Database Installation and Configuration: Installing, configuring, upgrading, and patching Oracle Database software, including major version upgrades and applying security patches (PSUs/CMPs).
Backup and Recovery (B&R): Designing, implementing, and managing robust backup and disaster recovery strategies using tools like Recovery Manager (RMAN) and Data Pump to ensure data protection and minimal downtime. Performing database restores and point-in-time recoveries as needed.
Performance Tuning: Monitoring, diagnosing, and resolving database performance issues. This involves using tools like AWR (Automatic Workload Repository), ASH (Active Session History), and SQL Tuning Advisor to optimize SQL queries, database parameters, and indexing strategies.
Security Management: Implementing and maintaining database security, including managing users, roles, privileges, profiles, and ensuring compliance with security policies. This often includes implementing Transparent Data Encryption (TDE).
Storage and Capacity Planning: Allocating, managing, and optimizing database storage structures (tablespaces, data files) and planning for future storage and resource needs based on business growth.
High Availability (HA) and Disaster Recovery (DR): Implementing and administering HA solutions such as Oracle Real Application Clusters (RAC) and Data Guard (Physical/Logical Standby) for maximum uptime and failover capability.
Routine Maintenance: Performing essential maintenance activities like indexing, space management, statistics gathering, and general database housekeeping.
Troubleshooting: Identifying and resolving complex technical problems within the database environment, often in collaboration with application, operating system, and network teams.
Qualifications and Skills
Oracle Database Technologies
a. RMAN (Recovery Manager) for backup and recovery.
b. RAC (Real Application Clusters) and ASM (Automatic Storage Management).
c. Data Guard (Physical and Snapshot Standby).
d. Performance Tuning Tools (AWR, ASH, Explain Plans, SQL Trace).
e. Data Pump (Import/Export utility).
f. Oracle Database Architecture (memory structures, processes, storage components).
g. Knowledge of Oracle Multitenant Architecture (CDB/PDB) is increasingly critical.
Programming and Operating Systems
a. SQL (Structured Query Language) and PL/SQL for data manipulation and procedural programming.
b. Proficiency in Linux/UNIX operating systems and Shell Scripting for automation and administrative tasks.
Complete knowledge of ITIL.
Other Skills
a. Strong problem-solving and analytical skills.
b. Excellent communication skills for interacting with developers, management, and other technical teams.
c. Experience with cloud database services (e.g., Oracle Cloud Infrastructure, AWS RDS) is a growing asset.
Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
8+ years of experience as a Database Administrator supporting production environments.
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.
Want more jobs like this?
Get Computer and IT jobs in Hyderabad, India delivered to your inbox every week.
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
Perks and Benefits
Health and Wellness
Parental Benefits
Work Flexibility
Office Life and Perks
Vacation and Time Off
Financial and Retirement
Professional Development
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Mattel.