Software Engineer II - Database Administrator, ITC

Who You’ll Work With

Who We Are Looking For

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

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.