Sr. Data Base Engineer at Information Technology Services · Pune · 5 - 8 years · ₹10L - ₹20L / yr · Posted 12 Jan 2022

Preferred Education & Experience:
•Bachelor’s or master’s degree in Computer Engineering, Computer Science, Computer Applications, Mathematics, Statistics or related technical field or equivalent practical experience.
Well-versed in and 5+ years of hands-on demonstrable experience with:
▪Data Analysis & Data Modeling
Database Design & Implementation
Database Performance Tuning & Optimization
▪PL/pgSQL & SQL
•5+ years of hands-on development experience in Relational Database (PostgreSQL/SQL
Server/Oracle).
•5+ years of hands-on development experience in SQL, PL/PgSQL, including stored procedures,
functions, triggers, and views.
Hands-on experience with demonstrable working experience in Database Design Principles, SQL
Query Optimization Techniques, Index Management, Integrity Checks, Statistics, and Isolation
levels.
Hands-on experience with demonstrable working experience in Database Read & Write
Performance Tuning & Optimization.
•Knowledge and Experience working in Domain Driven Design (DDD) Concepts, Object Oriented
Programming System (OOPS) Concepts, Cloud Architecture Concepts, NoSQL Database Concepts
are added values
•Knowledge and working experience in Oil & Gas, Financial, & Automotive Domains is a plus
Hands-on development experience in one or more NoSQL datastores such as Cassandra, HBase,
MongoDB, DynamoDB, Elastic Search, Neo4J, etc. a plus
Job Location : Pune/Remote
Work Timings : 2.30 pm-11:30 pm
Joining Period : Immediate-20 day

Similar jobs (7)
Database Engineer (PostgreSQL) | 1-5 Years | Bangalore
We are looking for a Database Engineer (PostgreSQL) with 1-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:
- 1-5 years of PostgreSQL database experience.
- Strong SQL and performance tuning skills.
- Knowledge of database backup, recovery, and migration processes.
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.
Key Responsibilities
Administer, monitor, and support database platforms including Couchbase, PostgreSQL, and Oracle.
Perform database performance tuning, optimization, and troubleshooting.
Write and optimize complex SQL queries, stored procedures, and scripts.
Ensure database availability, reliability, backup, recovery, and security compliance.
Support production incidents, root cause analysis, and ongoing operational improvements.
Collaborate with application, infrastructure, and support teams to resolve database-related issues.
Required Skills
5 to 10 years of hands-on experience in Database Administration.
Strong experience with Couchbase, PostgreSQL, and/or Oracle databases.
Expertise in performance tuning, query optimization, indexing, and SQL development (Complex Queries, Stored Procedures, Scripts)
Experience with database monitoring, backup, recovery, and maintenance activities.
Production Support, Troubleshooting & RCA
Strong analytical and troubleshooting skills.
Nice to Have
Experience with cloud platforms such as AWS, Azure, or GCP.
Exposure to database automation and scripting
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.
Qualifications
● 3-8 years experience in Cloud Database Administration
● Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.
● Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.
● Proficient in PostgreSQL/MySQL database management, including installation, configuration, and performance tuning.
● Proven experience as a Database Administrator with a focus on
PostgreSQL/MySQL.
● In-depth knowledge of database design, implementation, and management for both PostgreSQL/MySQL environments.
● Familiarity with database security, backup procedures, and performance tuning for both systems.
● Strong analytical and problem-solving skills.
● Excellent communication and collaboration abilities.
● Relevant certifications (e.g., PostgreSQL Certified Professional, MySQLDatabase Administrator) are a plus.
Skills:
● Expertise in PostgreSQL/MySQL database management systems.
● SQL programming and query optimization for both databases.
● Data modeling and database design for PostgreSQL/MySQL.
● Backup and recovery procedures for both environments.
● Performance tuning and optimization for PostgreSQL/MySQL.
● Security protocols and measures for PostgreSQL/MySQL.
● Capacity planning and scalability for both systems.
We are looking for a Database Administrator to keep our databases fast, secure and highly available.
Responsibilities
- Install, configure and maintain Oracle, PostgreSQL and SQL Server databases
- Tune queries and database performance
- Manage backup, recovery and disaster-recovery plans
- Handle replication, high availability and security
Requirements
- 2+ years as a DBA on Oracle, PostgreSQL or SQL Server
- Strong backup, recovery and tuning experience
- Oracle or Microsoft DBA certification is a plus
Job Title: Senior Data Engineer
Position Summary
We are seeking a highly skilled Data Engineer with strong expertise in reporting infrastructure, data modeling, and analytics platforms. This role will focus on building scalable reporting solutions, optimizing data pipelines, and enabling data-driven decision-making across the organization. The ideal candidate will have deep experience with databases, data warehousing, and complex query development. While Ruby on Rails experience is beneficial, the primary emphasis is on data engineering and reporting systems.
Key Responsibilities
- Design, develop, and maintain reporting infrastructure and data platforms.
- Build and optimize complex SQL queries, data models, and reporting datasets.
- Develop scalable ETL/ELT pipelines and data integration processes.
- Design and maintain database schemas to support analytics and reporting requirements.
- Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions.
- Implement data quality, governance, and performance best practices.
- Support and enhance enterprise reporting solutions and dashboards.
- Work with large-scale datasets in cloud data warehouse environments.
- Troubleshoot reporting issues and optimize database performance.
- Partner with engineering and product teams to establish sustainable data architecture.
Must Have: Technical Skills
- PostgreSQL
- Snowflake
- Advanced SQL
- Data Modeling
- Data Warehousing
- Reporting & Analytics Infrastructure
- ETL/ELT Development
- Query Performance Tuning
Success Profile:
The ideal candidate is a data-focused engineer who enjoys working with complex datasets, designing scalable reporting solutions, and building foundational infrastructure that empowers analytics and business intelligence teams. They should be comfortable navigating databases, optimizing queries, and translating business reporting needs into robust technical implementations.
Experience Range: 5-10 years
Role Type: Individual Contributor / Senior Engineer
Primary Focus: Reporting Infrastructure, Data Engineering, Data Warehousing, and Analytics Enablement.







