Senior Postgresql Database Engineer

We are  Cirrus Labs . 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 Engine er>to join our team. If you're excited to be part of a winning team, Cirrus Labs   (http://(Use the "Apply for this Job" box below).  io) is a great place to grow your caree

Experience:

8+ years
Shift Time: 3 PM - 12 AM IST

Duties 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 (_statements, EXPLAIN ANALYZE, logs), tune queries and indexes, reduce lock contention and bloat, advise on connection pooling and transaction patt
erns.
3) Schema & migrations:
Own database migration scripts – review DDL changes, migration risk, and rollout strategy; help design partitioning, constraints, and data lifecycle (archival, retent
ion).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 win
dows.
5) Observability:
Define SLIs for DB latency and errors; work with metrics, slow query logs, and Performance Insights (or equival
ent).6) Incidents:
Own end-to-end performance investigations (metrics, logs, EXPLAIN, wait events) and produce actionable index/query/schema cha
nges.
7)

Collaboration:

Document playbooks, review high-risk SQL in PRs, and mentor engineers on Postgre

SQL best pract

ices.
Required Qualific at

ions :
1) 8+ years of experience as a database engineer/administrator with at least 3 years of experience managing Postgre

SQL on AWS RDS or
Aurora.
2) BS or higher in Computer Science or related field. Required
Skills3) Deep Postgre

SQL:
Query planner behavior, indexing (B-tree, partial, covering), MVCC, vacuum/autovacuum, statistics, concurrency and isolation levels, extensions when appro
priate.
4) Amazon RDS for Postgre

SQL:
Parameter groups, version upgrades, backups, Multi-AZ, read replicas, RDS Proxy, monitoring, and security (IAM, encryption, networking).
5) Amazon Aurora Postgre

SQL-Compatible:
Cluster topology, reader/writer behavior, failover, storage and replication concepts, and operational tradeoffs vs. standa
rd RDS.
5) Cost optimization: Right-sizing, IOPS, s
torage.
6) Hands-on production experience tuning Postgre

SQL under real load (not only loca
l/dev).7)

Experience with high migration velocity (many schema changes, zero-downtime patterns, back
fills).8) Strong communication: explain tradeoffs to non-DB specialists and write clear ru

nbooks.