Senior Postgresql Database Engineer

We are CirrusLabs. Our vision is to become the world's most sought-after niche digital transformation company that helps customers realize value through innovation. Our mission is to co-create success with our customers, partners and community. Our goal is to enable employees to dream, grow and make things happen. We are committed to excellence. We are a dependable partner organization that delivers on commitments. We strive to maintain integrity with our employees and customers. Every action we take is driven by value. The core of who we are is through our well-knit teams and employees. You are the core of a values driven organization.You have an entrepreneurial spirit. You enjoy working as a part of well-knit teams. You value the team over the individual. You welcome diversity at work and within the greater community. You aren't afraid to take risks. You appreciate a growth path with your leadership team that journeys how you can grow inside and outside of the organization. You thrive upon continuing education programs that your company sponsors to strengthen your skills and for you to become a thought leader ahead of the industry curve.You are excited about creating change because your skills can help the greater good of every customer, industry and community. We are hiring a talented Senior Database Engineer>to join our team. If you're excited to be part of a winning team, CirrusLabs (is a great place to grow your career.Experience: 5+ yearsLocation: Bangalore/HyderabadShift Time: 3 PM - 12 AM ISTDuties and Responsibilities:1) Produce clear scaling options (e.g. /"replicas + routing”, /"move to Aurora + N readers”, /"proxy + tune”, /"partition hot tables”) with tradeoffs, cost modeling, and risk, not only tuning the current box.2) Performance: Profile workloads (pg_stat_statements, EXPLAIN ANALYZE, logs), tune queries and indexes, reduce lock contention and bloat, advise on connection pooling and transaction patterns.3) Schema & migrations: Own database migration scripts – review DDL changes, migration risk, and rollout strategy; help design partitioning, constraints, and data lifecycle (archival, retention).4) RDS / Aurora operations: Size instances, storage, and I/O; understand replication, failover, reader endpoints, RDS parameter groups, backups, PITR, major version upgrades, and maintenance windows.5) Observability: Define SLIs for DB latency and errors; work with metrics, slow query logs, and Performance Insights (or equivalent).6) Incidents: Own end-to-end performance investigations (metrics, logs, EXPLAIN, wait events) and produce actionable index/query/schema changes.7) Collaboration: Document playbooks, review high-risk SQL in PRs, and mentor engineers on PostgreSQL best practices.Required Qualifications :1) 5+ years of experience as a database engineer/administrator with at least 3 years of experience managing PostgreSQL on AWS RDS or Aurora.2) BS or higher in Computer Science or related field. Required Skills3) Deep PostgreSQL: Query planner behavior, indexing (B-tree, partial, covering), MVCC, vacuum/autovacuum, statistics, concurrency and isolation levels, extensions when appropriate.4) Amazon RDS for PostgreSQL: Parameter groups, version upgrades, backups, Multi-AZ, read replicas, RDS Proxy, monitoring, and security (IAM, encryption, networking). 5) Amazon Aurora PostgreSQL-Compatible: Cluster topology, reader/writer behavior, failover, storage and replication concepts, and operational tradeoffs vs. standard RDS.5) Cost optimization: Right-sizing, IOPS, storage.6) Hands-on production experience tuning PostgreSQL under real load (not only local/dev).7) Experience with high migration velocity (many schema changes, zero-downtime patterns, backfills).8) Strong communication: explain tradeoffs to non-DB specialists and write clear runbooks.

Apply Now