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 (http://www.cirruslabs.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 (pg_stat_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 PostgreSQL best pract

ices.

Required Qualificat

ions :

1) 8+ 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 appro

priate.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. standa

rd RDS.5) Cost optimization: Right-sizing, IOPS, s

torage.6) Hands-on production experience tuning PostgreSQL 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.