Middle/Senior DBA (PostgreSQL)

We are seeking an experienced and driven Middle/Senior DBA specializing in PostgreSQL to join our team. This role is pivotal in ensuring the availability, performance and security of our database systems in a dynamic production environment.Administer PostgreSQL databases, focusing on configuration, tuning and optimizationDesign and implement high-availability architectures with replication and failover setupsConfigure load balancing mechanisms to ensure cluster fault toleranceOptimize database connection pooling performance for application servicesMonitor SQL query performance and system resource utilization to identify bottlenecksAnalyze and enhance database structures, indexes, queries and transactions for efficiencyEnsure data integrity, consistency and proper management of transactions and locksDevelop backup, archiving and recovery policies while conducting routine recovery testsSupport transaction log archiving and implement reliable recovery mechanismsManage Linux-based servers in production database environmentsDocument database configurations, operational activities and procedures