Job Details

Remote, part-time Database Engineer (PostgreSQL DBA) position at Kikidler. Salary from $2000. Responsibilities include PostgreSQL administration, data schema design, performance optimization, and working with JSONB structures.

Administration and development of PostgreSQL (14+) in the employee activity monitoring system project. Designing data schemas and optimizing complex SQL queries. Performance analysis (EXPLAIN ANALYZE, pg_stat_statements). Working with JSONB structures, department hierarchy, and time series. Designing and implementing a multi-tenant architecture. Performing migrations without downtime (online DDL, zero-downtime). Configuring backup and recovery (PITR, WAL archiving). Interaction with the backend team (Go, pgx/pgxpool).

Solid knowledge of PostgreSQL 14+ (schemas, optimization, execution plans). Understanding of MVCC, locks, autovacuum, and their impact on performance. Experience with zero-downtime production migrations. Deep understanding of multi-tenancy (schema-per-tenant, RLS, shared tables). Experience with indexes (B-tree, GIN, partial, composite). Partitioning skills (range/list partitioning). Experience with pg_stat_statements. Ability to build backup and recovery strategies (pg_dump, pg_basebackup, WAL). Nice to have: Experience with high-load systems. Experience designing architecture for large data volumes. Understanding of backend development in Go.

Remote work format. Part-time employment. Work on an actively developing product. Participation in the transition to a multi-tenant architecture.