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.
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
Cloud • Information Technology • Productivity • Software • Automation
Provide advanced technical support for Boomi integrations: troubleshoot APIs, protocols, and logs; use tools like Postman, Wireshark, and Charles Proxy; work with Java/Groovy/JavaScript, Kubernetes, and enterprise systems (Salesforce, NetSuite, Hadoop); leverage AI for diagnostics and collaborate with customers and engineering teams to resolve complex integration issues.
Top Skills:
AIAi TechnologiesBoomi AtomsphereCharles ProxyEltETLGroovyHadoopHttp/HttpsJavaJavaScriptKubernetesLinuxNetSuiteOauth 2.0PostmanRancher DesktopReactRestSalesforceSftpSoapSsl/TlsTcp/IpWindowsWiresharkWsdl
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead clinical trial disclosure strategy and operations for Pfizer-sponsored interventional trials. Ensure timely, compliant posting of protocols, SAPs, CSRs, and clinical summaries per EMA Policy 70 and other regulations. Manage vendors, develop processes and technical solutions, represent Medical Writing on governance committees, and maintain regulatory knowledge and best practices to drive quality and consistency across disclosures.
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Lead product bring-up and sustain high-volume manufacturing for NAND/SSD products. Drive end-to-end yield improvement, failure analysis, and data-driven optimizations. Troubleshoot customer returns, define test flows and validation strategies, lead cross-functional task forces for qualification and ramp, and mentor junior engineers.
Top Skills:
Data AnalyticsFailure AnalysisNandPcieSASSataSsd
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
