Database Engineer

Grid; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Grid is seeking an experienced PostgreSQL Database Administrator to manage enterprise database systems, focusing on PostgreSQL, replication, backup strategies, and high availability. You will migrate legacy databases from MariaDB/MySQL, design scalable, highly available clusters, and optimize performance for low latency.

Responsibilities include monitoring with Prometheus and Grafana, supporting analytical workloads (ClickHouse) and caching layers, and automating routine tasks with Bash/Python.

Qualifications

• 5-8 years of hands-on experience in database administration with PostgreSQL.
• Expert-level knowledge of PostgreSQL architecture, internals, replication, and performance tuning.
• Experience migrating schemas and data from MariaDB/MySQL to PostgreSQL.
• Deep understanding of HA architectures and backup strategies.
• Proficiency in monitoring with Prometheus and Grafana.

Responsibilities

• Administer, support, and maintain PostgreSQL-based enterprise databases.
• Plan and execute migrations from legacy systems (MariaDB/MySQL) to PostgreSQL with minimal downtime.
• Lead deployment of database clusters across cloud and on-premise data centers ensuring HA and automated failover.
• Design replication strategies and PITR backups for business continuity.
• Tune queries, indexing, connections, and resource configurations for low latency and high throughput.
• Support analytical/OLAP workloads and caching/NoSQL stores as needed.
• Automate routine tasks and migrations using Bash/Python and IaC tools.
• Implement RBAC, auditing, encryption, and security hardening.
• Collaborate with development and platform teams and document configurations.

Skills

PostgreSQL

Replication

Performance tuning

Monitoring

Tools

PgBouncer

pgBackRest

Prometheus

Grafana

ClickHouse

Job description

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.