Database Lead | India

Photon; Chennai; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Photon is seeking a Senior Software Engineer with strong RDBMS, SQL, Python, and Google Cloud Platform expertise to design and build scalable data-intensive cloud solutions. The role emphasizes data modeling, CDC, and distributed processing across GCP services.

You will design data pipelines, implement production-grade code, and collaborate with architects and business teams to deliver robust data platforms leveraging Spanner, Datastream, and Dataflow.

Qualifications

• 7+ years of software/data engineering experience.
• Strong RDBMS and SQL skills, including query optimization and database design.
• Hands-on experience with Google Cloud Platform (GCP).
• Strong experience with Google Cloud Spanner, Datastream, and Dataflow.
• Experience with CDC and data synchronization.
• Proficiency with Git, CI/CD, release management, and engineering best practices.

Responsibilities

• Design and build scalable, data-intensive applications and cloud solutions.
• Design data models, schemas, transformations, and data integration workflows.
• Develop Python-based applications and data pipelines.
• Work with CDC, data synchronization, and distributed data processing.
• Develop, test, troubleshoot, and optimize production-quality code.
• Collaborate with architects, engineers, and business teams to translate requirements into scalable solutions.

Skills

RDBMS

SQL

Python

GCP

Data modeling

Distributed systems

Data synchronization

Software engineering

Tools

Google Cloud Spanner

Google Datastream

Google Dataflow

Pub/Sub

Job description

Senior Software Engineer - RDBMS & Google Cloud

Role Overview

We are looking for a Senior Software Engineer with strong expertise in RDBMS, SQL, Python, and Google Cloud Platform to design and build scalable, reliable data-intensive applications and cloud solutions.

Key Responsibilities

• Design and develop solutions using RDBMS, SQL, and data modeling best practices.
• Build cloud-native solutions using Google Cloud Spanner, Google Datastream, and Google Dataflow.
• Develop robust Python-based applications and data pipelines.
• Design data models, schemas, transformations, and data integration workflows.
• Work with change-data-capture (CDC), data synchronization, and distributed data processing.
• Develop, review, test, troubleshoot, and optimize production-quality code.
• Work with Git-based code repositories, branching strategies, pull requests, and code reviews.
• Manage and contribute to CI/CD and release pipelines, deployments, and production releases.
• Follow software engineering best practices around security, scalability, observability, testing, documentation, and maintainability.
• Collaborate with architects, engineers, and business teams to translate requirements into scalable technical solutions.

Required Skills

• 7+ years of software/data engineering experience.
• Strong RDBMS and SQL skills, including query optimization and database design.
• Strong Python programming skills.
• Hands‑on experience with Google Cloud Platform (GCP).
• Strong experience with Google Cloud Spanner.
• Experience with Google Datastream / CDC and Google Dataflow.
• Good understanding of distributed systems and data synchronization.
• Strong data modeling skills.
• Proficiency with Git/code repositories, CI/CD, release management, and engineering best practices.

Good to Have

• Experience with Pub/Sub, Cloud Storage, Cloud Functions/Cloud Run, or other GCP services.
• Experience with database migration, replication, or hybrid cloud architectures.
• Experience designing highly available and multi-region applications.
• Familiarity with Agile development and automated testing.

Ideal Candidate

A hands‑on senior engineer who combines strong database fundamentals with modern GCP engineering, can independently design and implement solutions, and follows disciplined software development and release practices.