Software Engineer II - Database Administrator, ITC

Who You’ll Work With

NIKE, Inc. does more than outfit the world's best athletes. It is a place to explore potential, obliterate boundaries and push out the edges of what can be. The company looks for people who can grow, think, dream and create. Its culture thrives by embracing diversity and rewarding imagination. The brand seeks achievers, leaders and visionaries. At Nike, it’s about each person bringing skills and passion to a challenging and constantly evolving game.

This role is part of the Foundational Platform Engineering (FPE) and with Relational Datastore Team which is part of Database Management Technology Foundation (DMTF) under FPE.

Who We Are Looking For

We are seeking a skilled and experienced Database Administrator with 2-5 years of hands-on expertise in managing PostgreSQL and MySQL databases in Cloud environments, with strong preference for AWS RDS & Aurora. The ideal candidate will have a deep understanding for Database Architecture, Migration strategies, Upgrades, Monitoring and Performance Tuning. Good to have additional experience with Oracle or SQL Server Databases.

Key Skills & Traits

• Masters’ or Bachelors' degree in Computer Science or a related field
• 2-5 years of experience as a Database administrator with expertise in PostgreSQL and MySQL in AWS RDS & Aurora
• Additional experience with Oracle or SQL Server is highly desirable
• In-depth knowledge of AWS RDS & Aurora architecture, including Multi-AZ setups, read replicas and failover mechanisms, Migration methods.
• Strong understanding of Database internals and proficiency in Performance Tuning
• Experience with monitoring tools like AWS CloudWatch, Database Insight etc.
• Knowledge of Infrastructure-as-a-code tools like Terraform, CloudFormation is a plus
• Proficient in SQL and scripting languages like Python, Bash for automation and monitoring
• Strong problem solving skills and ability to troubleshoot complex database issues
• Excellent communication skills to collaborate with cross-functional teams
• Ability to work independently and manage multiple priorities in a fast-paced environment
  
  

What You’ll Work On

You will play a critical role in ensuring the reliability, scalability and performance of our database systems to support business critical applications.

Platform Responsibilities

• Database Management & Administration: Design, deploy and manage PostgreSQL and MySQL database in AWS RDS & Aurora, On-prem
• Execute Major database upgrades with minimal downtime and ensure compatibility with application requirements
• Plan and execute Database migration with minimal downtime
• Implement & maintain database security best practices, including user access control, encryption and compliance.
• Performance Tuning & Optimization; Query Tuning, Index optimization and parameter optimization. Monitor and fine-tune resource utilization. Identify and resolve performance bottlenecks
• Document database configuration, processes and troubleshooting steps for knowledge sharing and compliance
• Collaborate with and consult other Nike development teams, architecture teams etc.
• Provide on-call support for critical database issues and participate in incident response and root cause analysis.