Administrador de banco de dados PostgreSQL
J
JobgetherDatabase administration
Based in BrazilFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- At least five years of documented experience in database administration, specifically in the required specialty
- Required Skills
- PostgreSQLLinux
Requirements
- Bachelor's degree or completed higher education qualification in Information Technology or a related field.
- At least five years of documented database administration experience in the required specialty, including critical enterprise environments requiring high availability.
- Strong PostgreSQL administration expertise, including performance tuning, VACUUM/autovacuum, execution-plan analysis, replication, backup and recovery, and troubleshooting.
- Practical experience with PgBouncer, connection pooling, database connection monitoring, and resolving saturation issues.
- Linux administration experience, particularly with RHEL, Debian, or Ubuntu, including storage and file-system optimization.
- Knowledge of physical and logical replication, disaster recovery planning, monitoring, alerting, and business continuity.
- Ability to develop, analyze, and maintain PL/pgSQL scripts and automate database administration activities.
- Understanding of access controls, auditing, encryption, data governance, database modeling, and LGPD compliance.
- Completion of ITIL 4 training with a minimum workload of 12 hours, and official ITIL 4 Foundation certification or higher.
- At least one required cloud database certification: Microsoft Certified: Azure Database Administrator Associate (DP-300), AWS Certified Database – Specialty, or Google Professional Data Engineer.
- PostgreSQL Professional certification, or LPIC-1 certification accompanied by at least 40 hours of PostgreSQL training.
- Ability to investigate complex technical issues, identify root causes, and implement reliable, performance-oriented solutions.
- Strong documentation and communication skills, and ability to collaborate across technical teams and coordinate with external technology providers.
Responsibilities
- Manage enterprise PostgreSQL environments, including configuration, maintenance, monitoring, troubleshooting, and operational support.
- Tune database performance, manage VACUUM and autovacuum routines, analyze execution plans with EXPLAIN and ANALYZE, and improve query performance and resource utilization.
- Install, configure, and administer PgBouncer, optimize connection pooling, monitor connection activity, and diagnose connection saturation.
- Develop, review, and maintain PL/pgSQL scripts to automate database operations and recurring tasks.
- Support and optimize Linux environments, including RHEL, Debian, and Ubuntu, with attention to storage performance and database file systems.
- Implement and maintain physical and logical replication, monitoring, alerting, and disaster recovery strategies.
- Configure and improve backup and restoration policies to protect data and support recovery objectives.
- Apply patches, manage version upgrades, and resolve incidents across development, testing, homologation, and production environments.
- Manage database roles, permissions, audit trails, logs, encryption practices, and compliance with LGPD and applicable security standards.
- Collaborate with technical teams and produce documentation, technical specifications, and best-practice guidance.
View Full Description & ApplyYou'll be redirected to the employer's site
