SeniorDatabaseConsultant,PostgreSQL

## Accountabilities Design, implement, and manage PostgreSQL database solutions, including configuration, upgrades, and ongoing administration across cloud and on-prem environments. Ensure high availability, disaster recovery, and data integrity through replication, failover mechanisms, backup strategies, and restoration processes. Analyze client database infrastructures and recommend performance, scalability, and reliability improvements aligned with best practices. Lead troubleshooting and problem management efforts, identifying root causes, resolving complex incidents, and preventing recurrence. Develop and maintain database architectures, including schema design, data modeling, and migration strategies across different database systems. Collaborate with clients and internal teams to deliver technical solutions, manage expectations, and ensure service quality and alignment with operational standards. Participate in on-call rotations and support continuous service availability for mission-critical environments. Requirements: Strong hands-on experience administering PostgreSQL databases in production environments, including installation, configuration, upgrades, and performance tuning. Solid experience with cloud platforms such as AWS, Azure, or GCP, including database monitoring and operational management. Expertise in high availability and replication solutions (e.g., Patroni, repmgr) and disaster recovery strategies. Experience with database backup and recovery tools such as pgBackRest, Barman, and pg_basebackup, including PITR and WAL archiving. Strong scripting and automation skills (Bash, Python) with familiarity in infrastructure automation tools (Ansible, Terraform, Chef, Puppet, or Salt). Experience with database monitoring and observability tools such as Prometheus, Grafana, Datadog, Zabbix, or similar platforms. Experience with database migrations across heterogeneous systems (Oracle, MySQL, MSSQL to PostgreSQL) using tools like ora2pg or cloud migration