Job Description: PostgreSQL Database Administrator Key Responsibilities: Database Administration: Manage and optimize EDB and open-source PostgreSQL databases. Collaborate with teams to improve database performance and ensure high availability. Design and implement scalable, highly available database platforms for on-premises and cloud environments. Security, Backup, and Recovery: Apply security best practices, including encryption and role-based access control. Perform backups and restorations using tools like Pgbackrest, Pg_basebackup, Pg_dump, and Pg_dumpall. Conduct regular restoration testing to validate data integrity. Maintenance and Monitoring: Develop and implement standardized database maintenance plans. Monitor database health using Grafana, Prometheus, Telegraf, Loki, InfluxDB, and Pg_metrics. Proactively identify and resolve database issues. Performance Optimization: Analyze and resolve performance bottlenecks with query and index tuning. Utilize PGbouncer for effective connection pooling. Upgrades and Migrations: Manage PostgreSQL version upgrades and migrations with minimal downtime. Basic Oracle Knowledge: Possess foundational knowledge of Oracle database concepts and management. Skills and Tools: Databases: PostgreSQL, TimescaleDB, EDB Advanced Server, Oracle (basic). Backup/Recovery: Pgbackrest, Pg_basebackup, Pg_dump, Pg_dumpall, Barman. Monitoring: Prometheus, Grafana, InfluxDB, Telegraf, Zabbix, PgWatch2. High Availability: RepMgr, Patroni, HAProxy, PgPool. Containerization: Docker, Kubernetes, Docker Swarm. Performance: Query tuning, caching, PGbouncer. Platforms: RHEL, Ubuntu, Azure VMs. Notable Achievements: Developed custom database container images for Docker and Kubernetes. Implemented high availability solutions using RepMgr and Patroni. Enhanced performance through query optimization and bottleneck resolution. Designed and deployed scalable database architectures for on-premises and cloud environments. Successfully managed PostgreSQL migrations and upgrades with minimal disruption. Seamlessly integrated database systems into application architectures. ,
Employement Category:
Employement Type: Full time Industry: IT Services & Consulting Role Category: Not Specified Functional Area: Not Specified Role/Responsibilies: PostgreSQL Database Administrator Job in