Virohan - Database Administrator - PostgreSQL

• 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 Expertise

• Proven experience with PostgreSQL 11+ (latest version experience preferred)
• Strong knowledge of SQL, PL/pgSQL, database objects, and data types
• Experience with PostgreSQL replication: streaming, logical, and hot standby
• Deep understanding of VACUUM, ANALYZE, autovacuum configuration and tuning
• Knowledge of PostGIS, pgBouncer, and pg_stat_statements is a plus
  

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