Database Engineer

Responsibilities:

Core Database Administration: Administer, support, and maintain enterprise database systems with a primary focus on PostgreSQL.

Database Migration: Plan and execute database migrations, schema conversions, and data transformations from legacy database systems (such as MariaDB/MySQL) to PostgreSQL with minimal downtime.

Deployment and High Availability: Lead the installation, configuration, and provisioning of database clusters across cloud and customer data centers (on-premises), ensuring high availability (HA) and automated failover.

Replication and DR: Design and implement robust strategies for physical/logical replication, backup, and point-in-time recovery (PITR) to ensure business continuity.

Performance Tuning: Proactively monitor database health and availability using Prometheus and Grafana. Perform query optimization, indexing, connection pooling (e. g., PgBouncer), and resource configuration for low latency and high throughput.

Analytical and Secondary Data Stores: Support and manage analytical/OLAP workloads (e. g., ClickHouse) and caching/NoSQL systems (e. g., Redis) as needed.

Automation: Automate routine database administration tasks, migration scripts, installation workflows, and configuration management using scripting (Bash/Python) and automation tools.

Security: Implement and maintain database security controls, including hardening, role-based access management (RBAC), auditing, and encryption standards.

Collaboration and Documentation: Work closely with development, infrastructure, and platform teams to improve reliability, scalability, and schema design while maintaining comprehensive technical documentation.

Requirements:

Experience: 5-8 years of hands-on experience in database administration. PostgreSQL.

Expertise: Expert-level knowledge of PostgreSQL architecture, internals, physical/logical replication, connection pooling (e. g., PgBouncer), and performance tuning is mandatory.

Database Migration: Proven experience migrating schemas, queries, and live data from other relational database engines (e. g., MariaDB/MySQL) to PostgreSQL.

High Availability and Replication: Deep understanding of HA architectures (e. g., Patroni, pg_auto_failover), backup strategies (pgBackRest, WAL archiving), point-in-time recovery (PITR), and replication topologies.

Infrastructure and Deployment: Proven experience installing and configuring databases in hybrid environments (customer DCs and cloud).

Observability: Proficiency with monitoring tools, specifically Prometheus and Grafana.

Nice To Have:

MariaDB / MySQL Expertise: Solid hands-on experience administering, replicating, and tuning MariaDB or MySQL databases.

Redis and NoSQL: Working knowledge of Redis (for caching and persistence) and general exposure to NoSQL databases.

Analytical Databases and Workloads (OLAP): Experience administering columnar or analytical databases (e. g., ClickHouse, Druid, Snowflake, Vertica). Hands-on ClickHouse experience (cluster operations, sharding) is a major bonus.

IaC Tools: Familiarity with Ansible, Terraform, or Chef for configuration management.

Automation: Strong scripting skills in Bash and/or Python for automating installation, migration, and maintenance tasks.