PostgresSQL DBA

Role overview:

·         Technology Expertise & DBA Skill Set

·         Cloud Platforms: AWS, Azure

·         Database IaaS: Oracle, Microsoft SQL Server, PostgreSQL

·         Database PaaS: CosmosDB, MySQL, SQL Managed Instance, RDS Aurora, MongoDB

·         Infrastructure as Code: Terraform, Ansible

·         CI/CD & Automation: GitHub Actions, GitLab, Azure DevOps

·         Programming & Scripting: Python, Bash/Shell, PowerShell

·         Operating Systems: Linux/Unix (RHEL, Ubuntu), Window

Database Team Overview

Our Database Team is the foundation of enterprise-grade databases delivering secure, compliant and high-performing database platforms across Azure and AWS. We provide managed services for Oracle and Microsoft SQL Server, operating in a system DBA role to ensure platform reliability, resilience, and operational excellence. In addition, we support PaaS and RDS database services by acting as the platform team defining policies, enforcing security standards, and managing networking configurations while enabling self-service capabilities for application teams to consume these services efficiently.

What would you do here:

·         Database Security & Compliance: Implement robust security controls, encryption, and auditing to safeguard sensitive data and meet regulatory requirements.

·         Lifecycle Management: Oversee patching, upgrades, and end-of-life transitions to maintain platform stability and minimize risk.

·   Performance Optimization: Monitor and tune databases for optimal performance across diverse workloads.

·         Automation & Operational Excellence: Design and deploy automation for provisioning, monitoring, and maintenance to achieve “brilliant basics” and reduce manual intervention.

·         Business-Critical Certification: Validate and certify database environments to support mission-critical applications with high availability and disaster recovery strategies.

·         Incident & Problem Management: Provide rapid response and  root-cause analysis for database-related incidents to ensure business continuity.

·         Capacity Planning & Scalability: Forecast growth and optimize resources to support evolving business needs.

Best Regards!

Data Platform Engineer

Design, automate, and scale our data platform — this is an engineering role, not a traditional "DBA job.

Must-have :

• Data modeling & schema design (from first principles, not just maintenance)
• PostgreSQL (deep, hands-on — partitioning, replication, tuning)
• Any distributed NoSQL store (Cassandra, ScyllaDB, or similar wide-column/distributed DB) (real production experience)
• Python (automation & tooling, not just scripting)
• DevOps & CI/CD (building pipelines, not just using them)
• Terraform (infrastructure-as-code)

You'll:

• Design schemas, partitioning strategies, and lead the Postgres → Cassandra migration end-to-end
• Own PostgreSQL performance, replication, and zero-downtime schema changes
• Build Python-based automation to eliminate repetitive DB work
• Own CI/CD pipelines and Terraform-based infra provisioning
• Drive uptime, DR, monitoring, and incident response
• Own multi-tenant security (RLS, least-privilege access) and data governance

Experience: 4–9 years, data/database/platform engineering in demanding production environments.

Bonus: Kafka/Debezium (CDC), Redis, Flyway/Liquibase, GDPR/DPDP exposure.

Senior Database Administrator (DBA)

Database Reliability & Performance  •  Senior Individual Contributor

• Experience: 6–9 years in production database administration / engineering
• Level: Senior Individual Contributor (hands-on)
• Function: Data Platform — reliability, performance, and governance across relational and distributed SQL & NoSQL DBs.

About the Role

We are hiring a Senior Database Administrator to own the health, performance, and reliability of the data layer behind a high-scale, multi-tenant platform. Our environment spans several independent PostgreSQL database instances, a cache-first read tier, change-data-capture pipeline, analytics and archival stores. Should be capable of implementing NoSQL stores (Cassandra / ScyllaDB) & MySQL  end to end as we scale.

This is a hands-on senior IC role for someone who has run demanding production databases and wants full ownership: partitioning and maintenance, performance tuning, monitoring, uptime, disaster recovery, and the security and data-governance documentation that keeps a regulated, multi-tenant platform audit-ready. You will work closely with, and take direction from, engineering leadership — translating priorities into a well-run, well-documented data platform.

What You'll Own

PostgreSQL Depth

• Administer multiple production PostgreSQL instances (v16+), including schema/DDL review, migrations, and release coordination.
• Design and maintain table partitioning strategies (range/hash/time-based) and automate partition lifecycle — creation, retention windows, and safe drops.
• Own query and instance performance tuning: EXPLAIN/ANALYZE, indexing strategy, autovacuum/bloat management, connection pooling (e.g. PgBouncer), and parameter-group tuning.
• Execute zero-downtime schema changes using expand–migrate–contract / blue-green patterns; assess lock impact and avoid long ACCESS EXCLUSIVE locks on hot tables.
• Manage replica topology (writer/reader endpoints), replication lag, and read-scaling as load grows.
• Partner with app teams on migration tooling (e.g. Flyway) and paired forward/rollback scripts; enforce idempotent, reviewed, tested DDL.

NoSQL & Scale

• Data-model, deploy, and operate distributed NoSQL clusters — Cassandra and/or ScyllaDB — including partition/clustering key design, compaction strategy, repair, and node operations (bootstrap, decommission, scale-out).
• Lead the planned migration of high-volume payload tables from partitioned PostgreSQL to Cassandra/ScyllaDB: capacity planning, dual-write/backfill design, cutover, and validation.
• Tune distributed-store read/write paths, consistency levels, and cluster sizing for predictable latency at scale.
• Support the cache-first architecture (Redis) and change-data-capture / streaming pipelines (e.g. Kafka) that move data to analytics and cold-archival stores.

Operations, Reliability & DR

• Own database uptime and SLOs; build and maintain monitoring, alerting, and dashboards for the key signals (latency, replication lag, CPU/IO, connections, vacuum lag, error rates).
• Define and regularly test backup and disaster-recovery strategy — RPO/RTO targets, point-in-time recovery, restore drills, and cross-AZ / future multi-region readiness.
• Drive incident response for database-related issues: triage, mitigation, root-cause analysis, and follow-up actions.
• Write and maintain runbooks (partition maintenance, failover, archival, DR, migration procedures) and participate in an on-call rotation for the data layer.
• Establish production-change discipline: pre-flight and post-deploy verification, rollback criteria, and backup verification before destructive operations.

Security, Governance & Documentation

• Implement and maintain database access control — least-privilege roles, schema-scoped permissions, and row-level security (RLS) for multi-tenant isolation.
• Own data-governance documentation: PII maps, per-table retention policies, audit-readiness, and the controls behind privacy-regulation compliance (e.g. GDPR / DPDP-style erasure and legal-hold workflows).
• Author and maintain architecture decision records (ADRs), schema documentation, and monitoring/runbook docs so the data platform is legible to the wider team.
• Uphold encryption-at-rest/in-transit posture and safe handling of sensitive columns; keep the data layer aligned with the platform's compliance requirements.

Coding & Automation Bar (Required)

This role is automation-first, not click-ops. The right candidate treats repetitive database work as something to script away and can drop into application code when a problem demands it.

• Strong scripting in Python and Bash for automation of maintenance, backups, partition management, backfills, and health checks.
• Comfortable with infrastructure-as-code (e.g. Terraform) and configuration management (e.g. Ansible) for reproducible database infrastructure.
• Solid SQL and PL/pgSQL; able to read and debug application-layer database code and, worst case, write or patch application code (e.g. Python/Node/Java) to unblock a fix.
• Fluent with Git-based workflows, code review, and CI for database migrations and tooling.

Required Qualifications

• 6–9 years operating relational databases in demanding production environments, with deep PostgreSQL expertise (internals, partitioning, replication, performance tuning).
• Hands-on experience running at least one distributed NoSQL store in production — Cassandra or ScyllaDB strongly preferred (other wide-column/distributed stores considered).
• Proven ownership of backup/DR, monitoring, and incident response for production databases.
• Strong scripting/automation background (Python, Bash) and experience with IaC.
• Experience with managed cloud databases (AWS RDS or equivalent) and understanding of instance/parameter-group tuning, replicas, and failover.
• Experience designing for multi-tenancy and data isolation at scale.
• Clear written communication — able to produce runbooks, ADRs, and governance docs a team can rely on.

Nice to Have

• Experience migrating workloads from PostgreSQL to Cassandra/ScyllaDB (or similar relational-to-distributed migrations).
• Familiarity with Redis as a cache tier and with CDC / streaming pipelines (e.g. Kafka, Debezium).
• Exposure to Flyway (or Liquibase), pgTAP or similar schema testing, and PgBouncer.
• Working knowledge of privacy regulations (GDPR, India DPDP) and audit/compliance processes.

How You Work

• Ownership mindset — takes a directive and runs it to done, with sound judgment on trade-offs.
• Reliability-first and detail-oriented; disciplined about verification, rollback, and documentation.
• Collaborative in a high-performing engineering team; communicates clearly with developers and leadership.
• Pragmatic and scale-aware — designs for where the platform is going, not just where it is.

TECHJAYS

Position: Senior Database Engineer / DBA

Experience: 7+ Years

Location: Coimbatore / Hybrid (Remote option available)

Employment Type: Contract

Joining: Immediate or within 30 days preferred

Core Focus: Microsoft SQL Server Administration, Always On Availability Groups, Performance Tuning, Database Security, Disaster Recovery, Production Database Operations, High Availability, and Multi-Terabyte Database Management.

Tools & Platforms: Microsoft SQL Server (HA / Clustered), Always On Availability Groups (AGs), TDE & Auditing, T-SQL, Partitioning & Archiving, PowerShell, Snowflake / Redshift / AWS Aurora (Nice to Have).

About the Role

We are looking for a Senior Database Engineer / DBA to own a large, multi-terabyte Microsoft SQL Server environment running in a highly available, clustered configuration.This is a hands-on production database role supporting a live, customer-facing SaaS platform. The role focuses on maintaining database availability, performance, security, and reliability. This is not an analytics or reporting role.

The ideal candidate will have strong hands-on experience managing SQL Server databases in a 24x7 production environment, troubleshooting complex database issues, maintaining Always On Availability Groups, and ensuring business continuity through effective disaster recovery practices.

Key Responsibilities

1. Production Database Administration & High Availability

Own and maintain the production SQL Server environment in an Always On Availability Group configuration.Handle failover operations, synchronization delay troubleshooting, and read replica load management.Maintain database availability and ensure the stability of production database environments.Manage SQL Server alerts and provide on-call coverage for production database operations.

2. Performance Tuning & Incident Management

Lead incident response and root cause analysis for production database issues.Troubleshoot query plan regressions, TempDB contention, deadlocks, and blocking issues.Perform index and statistics maintenance to ensure optimal database performance.Review developers' T-SQL queries and schema changes before deployment. Advise developers on table design, indexing strategies, and database performance optimization.

3. Database Security & Compliance

Maintain database security through Transparent Data Encryption (TDE), auditing, and certificate and key rotation.Monitor anomalous database access patterns and ensure appropriate security controls.

Handle confidential or legally sensitive data requests following established processes.Maintain database security standards and support compliance requirements.

4. Database Maintenance & Capacity Planning

Perform quarterly cumulative update patching across database environments.Manage partitioning and archiving on multi-terabyte databases without impacting production performance.

Own capacity planning for storage, CPU, and memory.Manage recurring environment refreshes across staging, development, and QA environments.Ensure production maintenance activities are performed safely with minimal downtime.

5. Disaster Recovery & Database Migrations

Design, implement, and test disaster recovery strategies for SQL Server environments.Support customer instance migrations between regions, including database preparation and validation.

Perform regular DR testing and ensure database recovery readiness. Manage large-scale database migrations while maintaining availability and data integrity.

6. Production Operations & Support

Provide on-call, weekend maintenance, and after-hours support as required.Maintain clear documentation of database changes, incidents, and recovery procedures.Work closely with engineering teams to ensure reliable database operations.Ensure production database changes follow established change control and operational procedures.

Must-Have Requirements

• 7+ years of hands-on Microsoft SQL Server DBA experience in a 24x7 production environment. SQL development experience alone is not sufficient.
• 3+ years of direct experience with Always On Availability Groups, including failover handling and synchronization delay troubleshooting.
• Experience managing multi-terabyte production databases, including partitioning, archiving, and index and statistics maintenance without blocking production.
• Experience leading incident response and root cause analysis for production database issues.
• Strong experience with database security practices, including TDE, auditing, certificate rotation, and key management.
• Hands-on experience with SQL Server performance tuning, query optimization, and production troubleshooting.
• Experience designing and testing disaster recovery strategies.
• English fluency sufficient for real-time incident communication, with meaningful business-hours overlap with Pacific time.
• Nice-to-Have Skills
• Experience supporting a SaaS CRM or similarly high-transaction-volume application.
• Exposure to Snowflake, Redshift, or AWS Aurora alongside transactional SQL Server work.
• Experience with customer instance migrations or similar large-scale data movement projects.
• Experience in SOC 2, HIPAA, or PCI-regulated environments.
• Comfort handling legally sensitive or confidential data requests as part of a defined process.

What We're Looking For

Strong Ownership: Takes responsibility for maintaining large, multi-terabyte production databases and ensuring their availability and reliability.

Technical Expertise: Demonstrates deep hands-on knowledge of SQL Server administration, Always On Availability Groups, performance tuning, and disaster recovery.

Incident Management: Maintains a calm, structured approach during production incidents and takes ownership of root cause analysis and preventive actions.

Attention to Detail: Follows disciplined change control, documentation, database security, and maintenance practices.

Clear Communication: Communicates effectively with developers, engineering teams, and stakeholders during live production incidents.

Operational Excellence: Understands the importance of maintaining production databases with minimal downtime and without impacting customer-facing applications.

Execution-Focused Mindset: Comfortable managing day-to-day database administration, on-call support, and hands-on production operations.

What We Offer

• Flexible work environment with Coimbatore office, hybrid, and remote options.
• Paid holidays and flexible time off.
• Medical insurance coverage of up to ₹4 lakh per person for self and family.
• Opportunities to support production infrastructure for global clients.
• A culture that values clarity, integrity, accountability, and continuous growth.

Database Engineer (PostgreSQL) | 5+ Years | Bangalore

We are looking for a Database Engineer (PostgreSQL) with 5+ years of experience to manage, optimize, and maintain PostgreSQL databases. The ideal candidate will have expertise in PostgreSQL, SQL Optimization, Database Design, Performance Tuning, Data Migration, and Backup & Recovery.

Responsibilities:

• Design, develop, and maintain PostgreSQL databases.
• Optimize SQL queries and improve database performance.
• Perform database design, indexing, and schema management.
• Execute data migration, backup, recovery, and disaster recovery activities.
• Monitor database health and troubleshoot performance issues.
• Collaborate with development teams to ensure scalable database solutions.

Requirements:

• 5-9 years of PostgreSQL database experience.
• Strong SQL and performance tuning skills.
• Knowledge of database backup, recovery, and migration processes.

1. Company Description:

Tatvic, is a marketing analytics company focusing on generating insights from data using long association with Google & its infrastructure. We breed,recognize and reward performance. As a company we are growing very fast & we are under transformation. To enable this transformation we need future leaders with eyesight which balances execution & strategic understanding.

Website: www.tatvic.com

2. Role Details

• Role: Lead Data Engineer
• Band: L4
• Department: Data Engineering
• Reporting to: L5 / Head of Delivery
• Location: Ahmedabad
• Job Type: Full Time
• Experience: 6-8 years of relevant experience
• Education: Bachelor’s or Master’s degree in Computer Science, Data Science, or a related technical field.

3. Mission & Role Overview

• Mission: To create high-level organizational impact by leading a team to design and deliver scalable, high-performance cloud-native data solutions. The Lead Data Engineer (L4) is responsible for ensuring technical excellence—specifically in BigQuery optimization and secure GCP/AWS architectures—while driving the transition to Agentic AI workflows and creating value through the development of L1-L3 engineers.
• Role Overview: This is a pivotal leadership role on the Management Track, responsible for end-to-end data outcomes for the function. The Lead Engineer ensures the quality of engineering execution, manages team utilization and resource allocation, and serves as the primary technical representative in cross-functional forums with Marketing, Strategy, and Product teams.

4. Key Responsibilities

• Lead the design, development, and deployment of scalable and efficient cloud-based data pipelines and architectures.
• Build reusable data solutions and software components that serve multiple customers and use cases.
• Architect cloud environments using GCP, ensuring best practices in IAM, Security, and Networking.
• Conduct Exploratory Data Analysis (EDA) on clickstream and behavioral datasets to derive insights.
• Manage end-to-end ETL processes, including data extraction, transformation, and loading using Python, SQL, and Airflow.
• Design and build production-grade software (APIs, services, internal tools) with sound engineering practices — version control, testing, CI/CD, and code review.
• Extend data platforms with AI capabilities — integrating LLMs, RAG pipelines, and agentic workflows where they add clear business value.
• Perform Root Cause Analysis (RCA) and resolve data quality, pipeline, or application issues.
• Collaborate cross-functionally with Marketing, Insights, Product, and Engineering teams to align data initiatives with business goals.
• Document architectures, design decisions, and operations clearly and consistently.
• Coach and mentor team members, ensuring technical excellence and continuous learning.
• Participate in recruitment and knowledge-sharing through interviews, blogs, and webinars.

5. Must-Have & Good-to-Have Skills

Must-Have Skills:

• Strong understanding of clickstream data and data pipeline architecture
• Hands-on experience with cloud platforms (GCP)
• Expertise in SQL, Python, and Airflow
• Solid software engineering foundation — API design, testing, version control, and deployment practices
• Proven ability to perform exploratory data analysis and data validation
• Knowledge of cloud security, IAM, and networking best practices
• Working knowledge of building or integrating AI/LLM-based components into existing systems
• Excellent problem-solving, stakeholder management, and communication skills

Good-to-Have Skills:

• Certifications such as: Google Cloud Professional Data Engineer / Cloud Architect
• AWS Certified Data Analytics or Azure Data Engineer Associate
• Google Analytics 4 (GAIQ)
• Experience in marketing attribution, commerce data, or analytics ecosystems
• Exposure to cost optimization and cloud resource management
• Experience with agent frameworks (LangChain, ADK, MCP) or LLM APIs
• Experience building automation frameworks or internal data tools

6. Not-a-Fit Criteria

• Individual Contributor Focus: Operates as the team's best individual contributor instead of building team capability or empowering L3s.
• Information Hoarding: Keeps architectural patterns or tribal knowledge trapped in their head rather than creating reusable playbooks and documentation.
• Avoidance of Conflict: Avoids difficult performance conversations with underperforming team members, allowing capability gaps to persist.
• Activity Over Outcomes: Measures success by "tasks completed" rather than pipeline stability, data accuracy, or business impact.
• Functional Siloing: Fails to build partnerships with Marketing or Product teams, leading to misaligned data delivery.

Our Culture & Perks - Where Passion Meets Purpose:

• Competitive CTC: Based on experience and skillset
• Medical Insurance for you and your family
• Return-to-Work Program for New Moms — because career breaks shouldn’t break momentum
• 1 Work From Home Day/Month — flexibility when life calls
• 2 Birthday Leaves/Year — one for you, one for someone you love
• Monthly Engagement Activities — from game nights to learning sessions
• Inclusive Culture & Equal Opportunity Employer — diversity drives our innovation
• We Think Like Engineers & Athletes: we build, we iterate, we scale, we win — together
• 5-day workweek — because balance drives brilliance

Job Overview:

We are seeking an experienced Cloud Data Engineer to the architecture, development, Data migration, ETL pipeline in cloud and optimization of a next-generation data platform. This is a development role for an individual with over 4 years of deep data engineering and data migration, data pipeline in AWS expertise, capable of driving technical direction, and delivering high-impact solutions in a fast-paced

4+ Years of hands-on, progressive experience in Cloud Data Engineering, cloud ecosystems AWS, Data Architecture

• Deep conceptual understanding of core data engineering principles, ETL/ELT patterns, and metadata management

•  Ability to translate complex business needs into actionable technical requirements.

•  Strong troubleshooting and problem-solving skills in distributed systems.

•  Agile/Scrum teamwork capabilities and version control practices

• Insurance industry experience preferred but not mandatory

• Tools:

o Cloud Environment: AWS (S3, IAM, VPC, Glue, Lambda etc.)

o Experience with dbt Core, Iceberg, AWS Glue Catalog, AWS lambda, Redshift, Athena, Splunk, AmazonQ, AWS streaming services, Git

o Strong SQL, Pyspark and Python

Key Skills:

Python & System Design: Strong expertise in Python and system design, with proven experience architecting scalable, production-grade systems.

LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.

Cloud & Data Architecture: Deep understanding of data and cloud architecture across AWS and Azure, including multi-store data design, distributed systems, streaming, security, and cost optimization.

Azure Databricks: Hands-on production experience with Azure Databricks architecture, including Unity Catalog, Delta Lake, cluster policy design, job orchestration, and Terraform provisioning.

Supply Chain & Inventory Management: Strong domain knowledge of supply chain and inventory operations, including demand planning, MRP logic, inventory parameters, and translating business planning decisions into data requirements.

System Architecture & Technical Decision-Making: Ability to make sound architectural decisions based on first principles, evaluate technical trade-offs, and avoid unnecessary complexity and abstraction.

LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.

Technical Leadership: Ability to influence teams without direct authority, establish technical standards, prepare technical specifications and documentation, and mentor team members.

Experience in pharmaceutical or regulated industries is highly valued.

Navtech is a premier IT software and services provider. Our mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future.

We have been recognized as the Best Cloud Service Provider by GoodFirms for delivering quality services and results. We strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients globally.

We are a fast-growing company serving clients across the United States, UK and Europe. You will work with a team of talented developers, quality engineers and product managers who are passionate about building impactful technology solutions.

About the Role

We are looking for an experienced Senior SQL Server / SSIS Engineer to design, develop, maintain and optimise database solutions and ETL workflows.

The ideal candidate should have strong hands-on experience with Microsoft SQL Server, SSIS package development, T-SQL programming, database performance tuning and data migration.

You should be comfortable working with existing database systems, troubleshooting complex issues, improving performance and ensuring data integrity, security and availability.

Key Responsibilities

• Design, develop and maintain SQL Server databases, database objects and logical data models.
• Develop, deploy and maintain SSIS packages for ETL processes and data integration.
• Build and optimise complex SQL queries, stored procedures, functions, views and triggers.
• Design and implement data extraction, transformation and loading workflows across multiple systems.
• Perform database migrations, data transformations and validation activities.
• Monitor and troubleshoot SQL Server databases, SSIS packages and SQL Server Agent jobs.
• Identify and resolve performance bottlenecks through query optimisation, indexing and execution plan analysis.
• Handle database administration activities, including upgrades, backups, recovery and maintenance.
• Ensure database performance, security, availability and data integrity.
• Troubleshoot database locking, blocking and resource utilisation issues.
• Collaborate with developers, QA engineers and other stakeholders to understand database requirements.
• Maintain technical documentation for database structures, ETL workflows and processes.
• Provide production support and proactively identify opportunities to improve database performance and reliability.

Who Are We Looking For?

• 6–10 years of experience in SQL Server development and database engineering.
• Strong hands-on experience with Microsoft SQL Server, preferably SQL Server 2016/2017 or above.
• Hands-on experience in developing, deploying and maintaining SSIS packages.
• Strong understanding of ETL processes, data integration and data migration.
• Advanced knowledge of T-SQL, stored procedures, functions, views and triggers.
• Experience in database performance tuning, query optimisation, indexing and execution plans.
• Experience in SQL Server monitoring, troubleshooting and resolving database performance issues.
• Good understanding of SQL Server Agent jobs, database backups, recovery and maintenance.
• Experience resolving database locking conflicts, blocking and resource utilisation issues.
• Knowledge of SQL Server system tables and Dynamic Management Views (DMVs).
• Experience with PowerShell scripting and automation is preferred.
• Exposure to AWS RDS, Azure SQL or other cloud database environments is an advantage.
• Knowledge of PostgreSQL or NoSQL databases is a plus.
• Experience leading or mentoring junior developers is preferred.
• Bachelor's or Master's degree in Computer Science, Software Engineering, IT or a related field.
• Excellent analytical, logical, troubleshooting and communication skills.

Good to Have

• Experience with SSRS or SSAS.
• Knowledge of AWS RDS or Azure SQL.
• Experience with PowerShell scripting.
• Exposure to PostgreSQL or NoSQL databases.
• Relevant Microsoft SQL Server certifications.

Why Navtech?

• Performance reviews and appraisals twice a year.
• Competitive compensation package with additional bonuses and benefits.
• Opportunities to work with renowned clients across the US, UK and Europe.
• Medical insurance coverage for self and immediate family.
• Opportunity to work with a culturally diverse and collaborative team.
• Opportunities for continuous learning and technical growth.

About Solutionara

Solutionara is an AI-led IT Consulting and Technology Services organization delivering enterprise transformation through Cloud, Integration, Data Engineering, Digital Experience, AI, and Enterprise Applications.

Headquartered in the United States with a Global Delivery Center (GDC) in Noida, India, Solutionara partners with enterprise organizations across retail, manufacturing, distribution, consumer goods, and other industries to design, implement, and support scalable technology solutions.

As a rapidly growing consulting organization, we foster a culture of ownership, innovation, collaboration, and continuous improvement, empowering our teams to contribute beyond their immediate responsibilities while delivering exceptional value to our global clients.

Every team member is expected to think like a consultant and business problem solver—understanding client objectives, challenging assumptions when appropriate, leveraging AI responsibly, and continuously identifying opportunities to improve quality, productivity, and customer outcomes.

AI is embedded into how we work, but it is an enabler—not a replacement for expertise, critical thinking, or accountability.

Role Overview

Solutionara is seeking a Senior Data Engineer with strong data engineering and database expertise to design, build, optimize, and support enterprise-scale data solutions.

This is a hands-on engineering position requiring strong SQL, Python, ETL/ELT, database, cloud, and troubleshooting capabilities. The engineer will work closely with technical leads and client stakeholders while taking ownership of major engineering components.

Location: Noida, India – Onsite | Employment Type: Full-Time | Experience: 6–9 Years

Key Responsibilities

Data Engineering

• Design, develop, test, deploy, and support scalable ETL/ELT pipelines.
• Build ingestion and transformation solutions across databases, APIs, files, and enterprise applications.
• Develop high-quality SQL and Python-based data processing solutions.
• Implement batch and incremental data-processing patterns.
• Develop reusable engineering components and frameworks.
• Support complex data migration and transformation activities.
• Perform source-to-target mapping and technical data analysis.
• Implement pipeline logging, monitoring, exception handling, and recovery mechanisms.

Database & Platform Engineering

• Design and optimize relational database schemas and data structures.
• Analyze and improve SQL/query performance.
• Support indexing, partitioning, storage optimization, and database performance.
• Implement appropriate database security and access controls.
• Support database monitoring, availability, backup/recovery, and operational requirements in collaboration with infrastructure/platform teams.
• Troubleshoot database and pipeline performance issues.
• Contribute to cloud data-platform configuration and optimization.

Data Quality

• Implement automated validation and data-quality controls.
• Develop reconciliation processes between source and target systems.
• Identify duplicate, incomplete, inconsistent, and invalid data.
• Implement cleansing, standardization, validation, and exception-management logic.
• Work with technical and business stakeholders to understand and implement business data rules.

Technical Delivery

• Convert technical designs into reliable production solutions.
• Participate in technical design and code reviews.
• Mentor junior/mid-level engineers.
• Support estimation and technical planning.
• Troubleshoot complex production and integration issues.
• Collaborate with technical leads, application teams, DevOps, QA, BI, and client teams.
• Document technical designs, mappings, configurations, operational procedures, and engineering decisions.

Consulting & AI-Led Working

• Understand the business purpose behind assigned engineering requirements.
• Raise risks, assumptions, dependencies, and potential improvements proactively.
• Communicate effectively with client and internal stakeholders.
• Use AI-assisted tools to improve coding, testing, analysis, documentation, and troubleshooting productivity.
• Independently verify AI-generated code and recommendations before implementation.
• Identify opportunities for engineering automation and process improvement.

Required Qualifications

• 6–9 years of experience in data engineering, database engineering, data integration, or related areas.
• Advanced SQL skills.
• Strong hands-on Python experience.
• Strong ETL/ELT development experience.
• Strong relational database knowledge, such as SQL Server, PostgreSQL, Oracle, or equivalent.
• Experience with data modeling and database design.
• Experience with AWS, Azure, or another major cloud platform.
• Experience with modern data technologies such as Databricks, Snowflake, Redshift, Synapse, Glue, ADF, Airflow, dbt, or equivalent.
• Experience with performance tuning and optimization.
• Experience with data validation and reconciliation.
• Strong troubleshooting and analytical skills.
• Ability to take ownership of engineering deliverables with limited supervision.

Preferred Qualifications

• Experience working with enterprise ERP, CRM, PIM, PLM, MES, or related systems.
• Experience with manufacturing, retail, distribution, or consumer-goods data.
• Experience with CI/CD and infrastructure/platform engineering practices.
• Experience with API and event-driven integrations.
• Previous consulting or technology-services experience.

What Success Looks Like

• Pipelines and databases perform reliably at enterprise scale.
• Engineering solutions are maintainable, reusable, and well documented.
• Data issues are detected and addressed systematically.
• Junior engineers receive effective technical guidance.
• Problems are owned through resolution rather than simply escalated.
• Engineering decisions reflect both technical requirements and client business objectives.