Title: PostgreSQL DBA- L2
Budget: 12 LPA
Location: Mumbai
Only male candidates.
Job Title:
L2 PostgreSQL Database Administrator
Job Summary:
The L2 PostgreSQL Database Administrator handles advanced database tasks, including performance tuning, replication, and disaster recovery planning. This role involves in-depth troubleshooting and optimizing database systems to ensure efficient operations and high availability.
Technical Responsibilities:
Advanced Performance Tuning:
Perform in-depth query optimization using EXPLAIN, EXPLAIN ANALYZE, auto_explain, and pg_stat_statements.
Optimize PostgreSQL configuration parameters (shared_buffers, work_mem, maintenance_work_mem, effective_cache_size) for performance improvements.
Implement partitioning strategies and fine-tune indexing (including BRIN, GIN, and GiST indexes).
Replication & High Availability:
Set up and manage replication configurations (e.g., streaming replication, logical replication).
Implement and monitor high-availability solutions using tools like Patroni, pg_auto_failover, or PgBouncer for connection pooling.
Backup & Disaster Recovery:
Design and implement comprehensive backup strategies using pgBackRest, Barman, or custom scripts.
Develop and regularly test disaster recovery plans, including Point-In-Time Recovery (PITR) scenarios.
Security Hardening:
Enforce advanced security measures, including database encryption (e.g., TLS, data-at-rest encryption), role-based access control (RBAC), and auditing with tools like pgAudit.
Conduct regular security audits and vulnerability assessments.
Data Migration & Upgrades:
Plan and execute major version upgrades using techniques like pg_upgrade, and handle data migrations with minimal downtime.
Perform cross-platform migrations (e.g., from Oracle to PostgreSQL) using tools like Ora2Pg.
Troubleshooting & Root Cause Analysis:
Perform deep-dive troubleshooting of complex issues (e.g., deadlocks, replication lag, high latency queries) using PostgreSQL logs, pg_stat_activity, pg_locks, pg_stat_user_tables.
Lead incident response and root cause analysis for critical production issues.
Automation & Scripting:
Develop automation scripts for routine database tasks (e.g., backups, monitoring) using Bash, Python, or Ansible.
Implement Infrastructure as Code (IaC) for PostgreSQL environments using tools like Terraform.
Documentation & Mentoring:
Maintain detailed technical documentation on database architectures, processes, and best practices.
Mentor L1 DBAs, providing guidance and knowledge sharing on complex tasks.
Technical Skills:
PostgreSQL Tools: Advanced use of pgAdmin, psql, pgBackRest, pg_repack, pg_stat_statements, Patroni.
Operating Systems: Advanced proficiency in Linux/Unix, with strong scripting skills (Bash, Python).
SQL & PL/pgSQL: Advanced SQL skills, including stored procedures and trigger functions.
Monitoring & Automation: Prometheus, Grafana, Ansible, Terraform.
Security: pgAudit, TLS configuration, role-based security.