Lead Software Engineer
Under Armour India
- Bangalore, Karnataka
- Permanent
- Full-time
- Define, own, and continuously evolve the enterprise database architecture strategy and multi-year roadmap across on-premises VMware-hosted environments, AWS cloud-native services, and hybrid configurations
- Assess the current database estate and develop a structured rationalization and modernization plan, including migration pathways from VMware on-premises systems to AWS managed services where appropriate
- Establish and enforce database architecture standards, design patterns, backups, and governance frameworks across all platforms and teams
- Lead database architecture reviews for new applications and significant platform initiatives, ensuring decisions are sound, scalable, and aligned with the broader technology strategy
- Evaluate emerging database technologies and provide well-reasoned recommendations for adoption, consolidation, or retirement
- Own the operational health of the full database portfolio including Oracle, Microsoft SQL Server, Amazon RDS, Aurora, DynamoDB, Snowflake, and PostgreSQL across both VMware and AWS environments
- Define and oversee patching schedules, upgrade plans, and lifecycle management processes across all platforms, balancing operational risk with the need to maintain current and supported versions
- Design, implement, and regularly validate backup and recovery strategies across all environments, leveraging RMAN for Oracle on VMware, AWS Backup and RDS snapshots for cloud-hosted databases, and native Snowflake and DynamoDB capabilities
- Lead capacity planning across the full database estate, incorporating both VMware resource constraints and AWS cost and scaling considerations
- Define and maintain disaster recovery and business continuity plans for all critical database systems, including cross-environment recovery scenarios spanning VMware and AWS
- Manage licensing, cost optimization, and vendor relationships for Oracle and Microsoft SQL Server, including licensing implications across VMware and AWS environments
- Partner with application engineering teams to review data models, schema designs, stored procedures, and SQL code, providing expert guidance on performance, maintainability, and best practices
- Lead query performance analysis and optimization across both on-premises and cloud-hosted databases, resolving slow queries, inefficient indexing, and poorly structured data access patterns
- Define and enforce SQL development standards and code review practices for all database changes across VMware-hosted and AWS-managed environments
- Serve as the primary database subject matter expert in discussions with the VMware infrastructure team regarding host sizing, storage, vSphere maintenance, and the impact of infrastructure changes on database workloads
- Lead the technical planning and execution of database migrations from VMware to AWS, utilizing AWS DMS, AWS Schema Conversion Tool, and platform-native migration capabilities
- Serve as the primary technical authority and day-to-day point of contact for the MSP, defining scope, quality standards, and prioritization of work across both VMware and AWS database environments
- Develop and maintain a clear operational runbook and task catalog governing what work is delegated to the MSP versus retained internally
- Conduct regular operational reviews with the MSP, evaluating SLA performance, reviewing incident trends, and identifying opportunities to improve service quality
- Review and approve MSP deliverables including patching plans, change requests, and incident post-mortems before implementation
- Bachelor's degree with typically 8 years of relevant experience or Master's degree with typically 6 years of relevant experience or typically 12 years of relevant work experience without degree.
- 8+ years of experience in database engineering or database administration, with demonstrated experience across both application and infrastructure dimensions of the role
- Strong hands-on experience with Microsoft SQL Server including clustering with always On Availability Groups, performance tuning, and operational management in both VMware-hosted and AWS RDS configurations
- Hands-on experience with Amazon RDS and Aurora including multi-AZ deployment, read replicas, automated backups, and Performance Insights
- Proficiency with PostgreSQL including configuration tuning, replication, and operational best practices across VMware and AWS environments
- Experience managing or providing technical oversight of a Managed Service Provider or external DBA support partner
- Strong SQL development skills across multiple dialects with the ability to review, optimize, and govern SQL developed by application engineering teams
- Solid understanding of database security, compliance requirements (PCI-DSS, SOC 2), and backup and recovery design across VMware and AWS environments
- On call duties as needed
- Solid experience with Amazon DynamoDB including NoSQL data modeling, capacity management, global tables, and DynamoDB Streams
- Hands-on experience with Snowflake including warehouse architecture, data sharing, RBAC, and performance optimization
- Expertise in Oracle Database including architecture, performance tuning, Data Guard, RMAN
- Location: This individual must reside within commuting distance from ouroffice.
- Work Schedule:This role follows a hybrid work schedule, requiring 4 days in-office per week