Sr Manager - Cloud DBA [T500-29022]

About Us: McDonald’s is proud to be one of the most recognized brands in the world, with restaurants in over 100 countries that serve 70 million customers daily. We continue to operate from a position of strength. Our updated growth strategy is focused on staying ahead of what our customers want and realizing further growth potential. Our relentless ambition is why McDonald’s remains one of the world’s leading corporations after almost 70 years. Joining McDonald's means thinking big and preparing for a career that can have influence around the world. At McDonald’s, we see every day as a chance to create positive impact. We lead through our values centered on inclusivity, service, integrity, community and family. From support of Ronald McDonald House Charities to our Youth Opportunity project and sustainability initiatives, our values keep us dedicated to using our scale for good: good for our customers, people, industry and planet.

Work location: Hyderabad, India

Work hours: Regular

Work pattern: Full time role.

Work mode: Hybrid.

Position Summary: DBA Platform Lead: As a key member of the McDonald’s Global Data Platform & Operations team, this role focuses on the physical design, management, and optimization of cloud database platforms, with a strong emphasis on GCP BigQuery. The role supports the implementation and maintenance of database structures, metadata definitions, and source-to-target mappings, while ensuring database platforms are reliable, scalable, and cost-efficient in support of advanced analytics and AI use cases. The ideal candidate

should be passionate about databases and brings hands-on experience with cloud databases, strong SQL skills, and a practical understanding of batch, event-based, and streaming data ingestion into database layers, and partners closely with data engineers, analysts, and platform stakeholders to ensure physical data designs and platform operations meet performance, governance, and business needs.

Who we’re looking for: Primary Responsibilities:

• Meet with data analysts, business intelligence teams, and other key stakeholders to gather, understand, and address complex data requirements. Ensure that the data solutions designed are both technically sound and aligned with business needs.
• Hands-on design, development, deployment, and management of database architecture solutions. Ensure that the solutions are scalable, flexible, and tailored for advanced analytics and AI scenarios utilizing GCP BigQuery.
• Execute ongoing GCP BigQuery platform administration and health checks, including configuration management, slot and reservation allocation, capacity monitoring, and remediation of platform-level issues to ensure stable, scalable, and cost-efficient BigQuery services.

Implement database operations best practices, including:

• Alerts & Monitoring: Configure proactive alerts for query performance, slot utilization, storage consumption, and failed jobs; monitor cost and usage trends; automate health checks for schema integrity.
• SQL Tuning: Review execution plans, optimize joins and aggregations, leverage partitioning and clustering, avoid SELECT *, and recommend materialized views for frequent queries.
• User Recommendations: Provide query optimization guidelines, educate analysts on efficient SQL practices, encourage parameterized queries, and share dashboards for performance and cost transparency.
• Planning and coordinating database downtime for maintenance or any other activities*
• Work closely with the IT security team to ensure that all database platforms adhere to strict security protocols, ensuring data privacy and protection.
• Participate in data governance initiatives. Collaborate with cross-functional teams to help drive best practices, emphasizing data accuracy, security, and ensuring that all architectures are in line with regulatory compliance standards.
• Stay updated with the latest trends and best practices for database platform architecture. Continuously evaluate the existing design and processes, recommending and implementing improvements as necessary.
• Be skilled at conveying complex ideas in a clear and understandable manner, tailoring communication strategies based on the audience and the nature of the project.
• Engage in Deployment efforts through CI/CD or manual intervention. Skill:
• Bachelor’s or Master’s degree in information technology, or a related field.
• 2+ years of experience in data design for logical and physical models, including ER, dimensional, and canonical modeling approaches for analytics and data warehousing.
• 3+ years of experience with cloud services such as GCP and AWS (GCP preferred).
• 3+ years of hands-on experience managing and optimizing GCP BigQuery platforms, including workload management, capacity planning, and cost optimization through FinOps-based consumption budgeting and forecasting.
• 3+ years of experience developing advanced SQL for complex analytical and data warehousing use cases, including large-scale analytical queries and complex transformations.
• Experience supporting batch, event-based, and streaming data ingestion into cloud database platforms, including managing schemas, partitioning strategies, and ingestion patterns aligned with downstream analytics requirements.
• Working knowledge of medallion architecture concepts, including how raw data is refined through intermediate layers and optimized in the Gold layer for performant, governed analytical access.
• 1+ years of experience with Erwin Data Modeler, including logical, physical, and conceptual modeling and translating business requirements into technical designs.

Preferred Skills:

• Familiarity with cloud-managed data integration, transformation, and movement tools such as DBT, Talend, or Confluent (Kafka).
• Demonstrated expertise in data governance, data management, and data quality geared towards data analytics, data science, and GenAI contexts.
• Excellent written, verbal, and meeting facilitation skills.
• Strong analytical and critical thinking skills.
• Self-driven with the ability to set priorities and mentor others in a performance-driven environment

Why Join Us: Work with a mission-driven team building cutting-edge technology. Be part of a collaborative, inclusive, and growth-oriented culture.

Additional Information: McDonald’s is committed to providing qualified individuals with disabilities with reasonable accommodation perform the essential functions of their jobs. McDonald’s provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to sex, sex stereotyping, pregnancy (including pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), race, color, religion, ancestry or national origin, age, disability status, medical condition, marital status, sexual orientation, gender, gender identity, gender expression, transgender status, protected military or veteran status, citizenship status, genetic information, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.