Photon Logo

Photon

Database Lead | Technical Lead | India

Reposted 24 Days Ago
Be an Early Applicant
In-Office or Remote
Hiring Remotely in India
Senior level
In-Office or Remote
Hiring Remotely in India
Senior level
Lead database design, data modeling, schema evolution, migrations, and ETL/ELT pipelines across MySQL, PostgreSQL, and GCP databases. Enable CI/CD, support batch and streaming ingestion, monitor and troubleshoot pipelines, produce runbooks, and mentor offshore DB/ETL engineers while collaborating with onshore architects.
The summary above was generated by AI

Job Description: Database Lead

Experience

5–8 years

Location

Offshore 

Role Overview

We are looking for a Database Lead with strong GCP, database, and ETL experience to support a cloud-native data platform. The role involves database design, data modeling, schema evolution, data migrations, ETL pipelines, and data streaming across MySQL, PostgreSQL, and Google Cloud databases (Spanner, Cloud SQL, AlloyDB).

The candidate will act as a technical lead, collaborating with onshore architects and leading offshore DB/ETL resources as additional team members are onboarded.

Key Responsibilities

  • Lead data modeling, schema design, and database architecture across MySQL, PostgreSQL, Spanner, Cloud SQL, and AlloyDB.
  • Own data migrations (one-time migrations, incremental/delta loads, and ongoing data synchronization).
  • Design and manage config-driven ETL / ELT pipelines, with table-level configuration files and minimal transformations.
  • Support on-demand onboarding of new tables and manage schema changes / evolution.
  • Design and support data streams for batch and near-real-time ingestion.
  • Work across teams on event-driven architectures, ensuring reliable data publishing and downstream consumption.
  • Enable CI/CD deployments for database changes, ETL jobs, dataflows, and configurations.
  • Monitor and troubleshoot ETL pipelines, data syncs, and streaming jobs; support reprocessing and recovery.
  • Prepare and maintain playbooks, runbooks, and operational documentation.
  • Lead and mentor offshore DB/ETL engineers, review designs, guide implementation, and ensure delivery quality.

Mandatory Skills & Experience

  • 5–8 years of experience in database and data engineering roles.
  • Proven expertise in data modeling, schema design, and data migrations.
  • Strong hands-on experience with MySQL and PostgreSQL.
  • Experience with Google Cloud databases: Spanner, Cloud SQL, AlloyDB.
  • Experience with ETL / ELT pipelines, data integration, and data streaming.
  • Strong understanding of schema evolution, delta processing, and data synchronization.
  • Advanced SQL skills.
  • Experience working on GCP, including services like Pub/Sub, Dataflow, BigQuery, and Cloud Storage.
  • Experience with CI/CD pipelines for data and database deployments.
  • Ability to technically lead offshore teams and work with onshore stakeholders.

Nice to Have

  • Exposure to other databases / technologies such as AS/400, MongoDB, Cassandra, and GraphQL.
  • Experience in enterprise data modernization or legacy-to-cloud programs.
  • Professional Cloud Certifications (Google / Microsoft / AWS), including:
    • Google Professional Data Engineer
    • Google Cloud Architect
    • Google Cloud Engineer

Similar Jobs

2 Hours Ago
Remote or Hybrid
India
Senior level
Senior level
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Manage end-to-end fund accounting for Luxembourg real estate fund structures, including NAV calculations, capital accounts, management fees, and real estate transaction recording. Support month/quarter/year-end closes, investor reporting, capital calls, distributions, audits, and regulatory reporting (AIFMD/CSSF). Coordinate with AML/KYC, transfer agency, legal, administrators, auditors, and valuers. Drive process improvements and support system automation.
Top Skills: Accounting SystemsExcel
2 Hours Ago
Remote
Gujarat, IND
Expert/Leader
Expert/Leader
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Manage and supervise site services for a semiconductor plant including cafeteria, janitorial, landscaping, pest control, transport, dormitory, POS, and vendor contracts. Lead plant design, procurement support, testing/commissioning, asset integrity, budgeting, safety compliance, RBA audits, contractor oversight, and continuous improvement to ensure reliable, safe facility operations and customer satisfaction.
Top Skills: Agentic AiPos System
2 Hours Ago
Remote
Gujarat, IND
Senior level
Senior level
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Lead mechanical design reviews and coordination for large-scale semiconductor/pharma cleanroom facilities. Perform HVAC, exhaust, utility and piping analyses, CFD review, pipe stress and vibration checks, equipment specification and procurement support, clash detection, BIM coordination, and technical oversight during construction to ensure compliant, energy-efficient mechanical systems and on-time project delivery.
Top Skills: AutocadBimBim 360ClaudeComputational Fluid Dynamics (Cfd)CopilotGen-Ai (ChatgptLlms)NavisworksP&Ids

What you need to know about the Delhi Tech Scene

Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account