Data Engineer

i2b Technologies Pvt Ltd; Hyderabad; On-site; INR 1,000,000 - 2,000,000; Full time

Job summary

i2b technologies pvt ltd is a fast-growing technology startup looking for a hands-on Database Platform Engineer to own PostgreSQL databases on AWS end-to-end, ensuring speed, reliability and security at high concurrency. You will build data pipelines that feed them and automate deployments as the platform scales.

You will work closely with the principal engineer and backend team on design decisions, performance tuning, and zero-downtime schema changes as the product evolves.

Qualifications

• 5+ years of PostgreSQL production administration for large databases.
• Strong AWS RDS/Aurora PostgreSQL experience with Multi-AZ and upgrades.
• Expert in backup, PITR, restore, and performance tuning under high concurrency.
• Experience delivering zero-downtime schema changes and data migrations.
• Infrastructure as code with Terraform or CloudFormation.
• CI/CD for database changes using Flyway or Liquibase and GitHub Actions.

Responsibilities

• Database administration: manage PostgreSQL on AWS RDS/Aurora in production with high availability.
• Data engineering: build ETL/ELT data pipelines and move data between stores.
• DevOps and automation: implement IaC, automate deployments, monitor with CloudWatch and Grafana, ensure security.

Skills

PostgreSQL administration

AWS RDS/Aurora PostgreSQL

Backup and PITR

Performance tuning

Zero-downtime schema changes

CI/CD for DB changes

SQL scripting (Python Bash)

Linux proficiency

Education

Bachelor's degree in Computer Science / IT or related field

Tools

Terraform

CloudFormation

Flyway

Liquibase

GitHub Actions

Jenkins

AWS CodePipeline

PgBouncer

Grafana

CloudWatch

Job description

Job Description:

Company: i2b technologies pvt ltd

Website: Visit Website

LinkedIn: Visit LinkedIn

Business Type: Startup

Company Type: Product

Business Model: B2B2C

Funding Stage: Bootstrapped

Industry: Technology

Salary Range: ₹ 10-20 Lacs PA

Job Description

We are a fast-growing technology startup preparing new products for production. We're looking for a hands-on Database Platform Engineer to own our PostgreSQL databases on AWS end to end: keeping them fast, reliable and secure at high concurrency, building the data pipelines that feed them, and automating how they are deployed and changed. You'll work closely with our principal engineer and backend team, and your decisions will shape the platform as it scales.

Key responsibilities

Database administration

• Own PostgreSQL on AWS RDS / Aurora in production, including high availability, replication and failover.
• Design and test backup and point-in-time recovery to meet defined RPO and RTO targets.
• Tune performance using execution plans, pg_stat_statements and Performance Insights; manage indexes, partitions, vacuum and bloat.
• Configure RDS parameter groups and connection pooling (PgBouncer / RDS Proxy) for high-concurrency workloads.
• Plan and run zero-downtime schema changes, data migrations and major version upgrades.
• Review database designs from developers for performance, integrity and security.

Data engineering

• Build and maintain data pipelines (ETL/ELT, CDC) using Python, SQL and AWS services.
• Move data reliably between transactional databases, event streams and analytics stores.

DevOps and automation

• Provision and manage database infrastructure as code with Terraform or CloudFormation.
• Automate database deployments through CI/CD pipelines using Flyway or Liquibase.
• Set up monitoring, alerting and dashboards with CloudWatch and Grafana; lead incident response and root-cause analysis.
• Enforce database security: access control, encryption, auditing and secrets management.
• Automate routine operations with Bash and Python scripts.

Must-have Skills

• 5+ years of hands-on PostgreSQL administration in production, including databases of 1 TB or more.
• Strong experience with AWS RDS or Aurora PostgreSQL: parameter groups, Multi-AZ, read replicas, snapshots and upgrades.
• Proven experience with backup, PITR and restore, plus performance tuning and lock troubleshooting under high concurrency.
• Experience delivering zero-downtime schema changes and data migrations.
• Infrastructure as code with Terraform or CloudFormation.
• CI/CD for database changes (Flyway, Liquibase, GitHub Actions, Jenkins or AWS CodePipeline).
• Strong SQL plus scripting in Python and Bash; comfortable on Linux.
• Bachelor's degree in Computer Science, IT or a related field, or equivalent experience.

Requirements: