Simple Logic - Database Administrator

The ideal candidate will be responsible for ensuring database availability, security, performance, and scalability.

You will work closely with application developers, system engineers, and DevOps teams to provide high-quality data solutions and troubleshoot complex issues in a mission-critical environment.

Responsibilities :

- Install, configure, and upgrade PostgreSQL databases in high-availability environments

- Design and implement database architecture, including replication, partitioning, and sharding

- Perform daily database administration tasks including backups, restores, monitoring, and tuning

- Optimize queries, indexes, and overall performance of PostgreSQL systems

- Ensure high availability and disaster recovery by configuring replication (Streaming, Logical) and backup solutions (pgBackRest, Barman, WAL archiving)

- Implement and maintain security policies, user access control, and encryption

- Monitor database health using tools such as pgAdmin, Nagios, Zabbix, or other monitoring tools

- Troubleshoot database-related issues in development, test, and production environments

- Automate routine tasks using shell scripting, Python, or Ansible

- Work with DevOps/SRE teams to integrate PostgreSQL into CI/CD pipelines and cloud platforms

Technical Skills

PostgreSQL Expertise :

- Proven experience with PostgreSQL 11+ (latest version experience preferred)

- Experience with PostgreSQL replication: streaming, logical, and hot standby

- Deep understanding of VACUUM, ANALYZE, autovacuum configuration and tuning

Tuning & Monitoring :

- Query optimization and slow query analysis using EXPLAIN and ANALYZE

- Experience with database performance monitoring tools (e.g., pg_stat_activity, pgBadger)

- Strong debugging and troubleshooting of locking, deadlocks, and resource contention issues

DevOps Integration :

- PostgreSQL experience on AWS RDS, Azure Database for PostgreSQL, or GCP Cloud SQL

- Familiarity with IaC tools like Terraform or CloudFormation is a plus

- Experience with CI/CD integration and containerization tools (Docker, Kubernetes) for DB deployment

Compliance :

- Implement role-based access control, data masking, and audit logging

- Ensure compliance with standards like GDPR, ISO 27001, or SOC 2 where applicable

Education :

- Bachelors or Masters degree in Computer Science, Information Technology, or a related field

Experience :

- Minimum 4+ years of experience in PostgreSQL database administration

- PostgreSQL certification (e.g., EDB Certified Associate/Professional) is a plus

- Experience in 24x7 production environments supporting high-volume transactions

Desirable Skills :

- Exposure to multi-tenant architectures

- Experience migrating from Oracle/MySQL to PostgreSQL

- Knowledge of NoSQL systems (MongoDB, Redis) is a plus

- Understanding of data warehousing and ETL processes