Infrastructure Engineer - Oracle DBA

Devopsroles; Bengaluru; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Warner Music Group is seeking an Infrastructure Engineer to safeguard global database environments, focusing on PostgreSQL and legacy Oracle. You will monitor health and security, support migrations, and ensure performance across a multi-cloud setup.

You will implement automation, assist with on-call rotations, and collaborate with Senior DBAs to optimize data infrastructure in a large-scale enterprise.

Qualifications

• Foundational Oracle DBA knowledge to support legacy systems pending migration.
• Proficiency in PostgreSQL administration, installation, configuration, and troubleshooting.
• Familiarity with multi-cloud platforms, mainly AWS and GCP; Azure a plus.
• Develop and maintain automation scripts (Python, Shell) for DB tasks and cloud automation.
• Strong SQL skills, query analysis, and schema management.

Responsibilities

• Perform daily database maintenance and monitoring for PostgreSQL and Oracle environments.
• Assist senior DBAs in migrating legacy Oracle workloads to PostgreSQL cloud environments.
• Manage backup and recovery strategies; test restores and archive pipelines.
• Handle user access, roles, schemas, and SOX compliance documentation.
• Monitor and troubleshoot automated batch jobs, schedules, and job chains.
• Troubleshoot connectivity, performance issues, and invalid objects in DBs.
• Support multi-cloud database instances across AWS, GCP, and Azure.

Skills

Oracle DBA

PostgreSQL Admin

Cloud Platforms

Automation Scripting

SQL & Tuning

Linux/Windows

Tools

Oracle Database

PostgreSQL

AWS

GCP

Azure

Job description

At Warner Music Group, we're a global collective of music makers and music lovers, tech innovators and inspired entrepreneurs, game-changing creatives and passionate team members. Here, we turn dreams into stardom and audiences into fans. We are guided by three core values that underpin everything we do across all our diverse businesses: Curiosity: We do our best work when we're immersing ourselves in culture and breaking through barriers. Curiosity is the driving force behind creativity and ingenuity. It fuels innovation, and innovation is the key to our future. Collaboration: Making music and bringing it to the world is all about the power of originality amplified by teamwork. A great idea, like a great song, travels globally. We ignite passions and build connections across our diverse community of artists, songwriters, partners, and fans. Commitment: We pursue excellence for our team and our talent. Everything in music starts with a leap into the unknown, and we're committed to keeping the faith, acting with integrity, and delivering on our promises. Technology is one of the most important parts of our business. Whether it's signing up new artists; ensuring we provide the right data to Spotify, YouTube, and other digital service providers; or helping artists use the latest AI tools and make thoughtful decisions with data-driven insights - technology plays an invaluable role in our success. The engineering team at Warner Music Group makes all of it a reality. Check out first-hand accounts from the WMG engineering, product, design, infrastructure and data teams in our blog! WMG is home to a wide range of artists, musicians, and songwriters that fuel our success. That is why we are committed to creating a work environment that actively values, appreciates, and respects everyone. We encourage applications from people with a wide variety of backgrounds and experiences. Consider a career at WMG and get the best of both worlds - an innovative global music company that retains the creative spirit of a nimble independent.

Your role: We are seeking an Infrastructure Engineer to support our global database operations during an exciting period of technological transformation. You will be the frontline defender of our database environments, ensuring daily health, security, and performance. This is an excellent opportunity to utilize your PostgreSQL skills while gaining hands-on experience managing legacy Oracle databases, modern multi-cloud infrastructure, and executing cross-platform database migrations in a large-scale enterprise environment.

Here you'll get to:

• Daily Operations & Monitoring: Perform routine database maintenance, monitor automated jobs, and investigate Level 1 and Level 2 alerts for capacity and performance issues across both PostgreSQL and Oracle environments.
• Migration Support: Actively assist Senior DBAs in the technical execution of migrating legacy Oracle workloads into PostgreSQL cloud environments.
• Backup & Recovery: Manage comprehensive backup and recovery strategies across relational database systems. Execute native Oracle and PostgreSQL backup methods, conduct routine restore testing, and manage archive pipelines to safeguard against data loss.
• User & Security Management: Manage database users, roles, and schemas. Perform routine user access audits and assist with SOX compliance documentation.
• Enterprise Job Scheduling: Monitor automated batch jobs and agents, troubleshoot aborted jobs, schedule chains, and assist developers in configuring automated tasks.
• Incident Resolution: Troubleshoot database connectivity, performance issues, and invalid objects. Escalate complex P1/P2 incidents to Senior DBAs when necessary.
• Multi-Cloud Support: Assist in maintaining and monitoring cloud database instances across our multi-cloud footprint.

About you:

• Foundational knowledge of Oracle Database Administration to support legacy systems pending migration.
• Proficiency in PostgreSQL administration, including installation, configuration, basic tuning, and troubleshooting.
• Familiarity with multi-cloud platforms, primarily AWS (EC2, RDS) and GCP. Basic knowledge of or exposure to Azure is a plus.
• Develop and maintain automation scripts (Python, Shell, etc.) to streamline database administration, monitoring, and backup processes, with cloud automation experience being a strong plus.
• Knowledge of Microsoft SQL Server (MSSQL) administration is a plus.
• Experience working with current server operating systems, including Linux and Windows.
• Solid understanding of SQL, query analysis, and database schema management.
• Willingness to participate in on-call rotations to support our 24/7 global operations.