Administrador de banco de dados PostgreSQL

Jobgether; Brasil; On-site; BRL 180,000 - 320,000; Full time

Benefits offered by this job

Healthcare: Medical insurance

Dental coverage

Meal support

Life insurance

Transportation allowance

Well-being programs

Pharmacy discounts

Education benefits

Family support

Mental health support

Inclusive workplace

PwD friendly

Job summary

Jobgether is seeking an experienced PostgreSQL Database Administrator to manage and optimize enterprise database environments across development, testing, and production. You will ensure performance, security, availability, and resilience while supporting data governance and LGPD compliance.

You will lead backup, recovery, replication, automation, and documentation, collaborating with IT, development, QA, and governance teams to deliver reliable data platforms and continuous improvement of

Qualifications

• Bachelor's degree in IT or related field is required.
• 5+ years of enterprise DB experience with high availability.
• Strong PostgreSQL administration and performance tuning skills.
• Practical experience with connection pooling, replication, backup, and recovery.

Responsibilities

• Manage enterprise PostgreSQL environments including configuration, monitoring, and operational support.
• Perform advanced database tuning and analyze execution plans to improve query performance.
• Install, configure, and optimize PgBouncer and monitor connections.
• Develop PL/pgSQL scripts to automate recurring tasks.
• Support Linux environments (RHEL, Debian, Ubuntu) and optimize storage performance.
• Implement and maintain physical and logical replication; manage backup and DR strategies.
• Handle patches, version upgrades, and incident management across environments.
• Maintain data governance standards and LGPD compliance; ensure audit trails.

Skills

PostgreSQL

Performance tuning

PL/pgSQL

PgBouncer

Linux

LGPD security

ITIL 4 awareness

Cloud certifications

Education

Bachelor's degree in IT or related field

Tools

PgBouncer

PL/pgSQL

Job description

We are seeking an experienced PostgreSQL Database Administrator to manage and optimize critical enterprise database environments. In this role, you will ensure database performance, security, availability, and resilience across development, testing, and production environments. You will lead advanced database tuning, replication, backup, recovery, and disaster recovery initiatives to support business continuity. Working closely with infrastructure, development, quality assurance, and IT governance teams, you will help maintain reliable and compliant data platforms. You will also contribute to automation, technical documentation, and the continuous improvement of database administration practices. This is an opportunity to apply deep PostgreSQL expertise in a technically demanding environment where operational excellence, data protection, and high availability are essential.

Accountabilities

• PostgreSQL database administration: Manage enterprise PostgreSQL environments, overseeing configuration, maintenance, monitoring, troubleshooting, and ongoing operational support.
• Performance optimization: Perform advanced database tuning, manage VACUUM and autovacuum routines, analyze execution plans using EXPLAIN and ANALYZE, and identify opportunities to improve query performance and resource utilization.
• Connection management: Install, configure, and administer PgBouncer, optimize connection pooling modes, monitor connection activity, and diagnose connection saturation and related performance issues.
• Automation and scripting: Develop, review, and maintain complex PL/pgSQL scripts to automate database operations and improve the reliability and efficiency of recurring tasks.
• Linux infrastructure management: Support and optimize Linux environments, including RHEL, Debian, and Ubuntu, with particular attention to storage performance and file systems used by database workloads.
• High availability and disaster recovery: Implement and maintain physical and logical replication, establish proactive monitoring and alerting, and support disaster recovery strategies to ensure service continuity.
• Backup and recovery management: Configure, administer, monitor, and continuously improve backup and restoration policies to protect data and support recovery objectives.
• Database lifecycle and incident management: Apply patches, manage version upgrades, and resolve incidents and problems across development, testing, homologation, and production environments.
• Data governance and modeling: Maintain corporate naming conventions, data object libraries, integration maps, and database administration standards in accordance with established data governance policies.
• Model validation: Review and validate logical and physical data models, ensuring technical consistency and alignment with institutional requirements.
• Security and regulatory compliance: Manage database roles and access permissions, maintain audit trails and logs, support encryption practices, and ensure compliance with Brazil's General Data Protection Law (LGPD) and applicable security standards.
• Cross-functional technical support: Collaborate with IT planning, change management, software quality, testing, and infrastructure teams to address database-related needs and improve service delivery.
• Documentation and technical research: Produce technical documentation and best-practice guidance, evaluate emerging infrastructure solutions, prepare technical specifications, and coordinate support requests with vendors and technology providers.

Requirements

• Education: Bachelor's degree or completed higher education qualification in Information Technology (IT) or a related field.
• Professional experience: At least five years of documented experience in database administration, specifically in the required specialty, working with critical enterprise environments that demand high availability.
• Advanced PostgreSQL expertise: Strong knowledge of PostgreSQL administration, performance tuning, VACUUM/autovacuum, execution-plan analysis, replication, backup and recovery, and operational troubleshooting.
• PgBouncer and connection management: Practical experience configuring connection pooling, monitoring database connections, and resolving saturation issues.
• Linux administration: Experience supporting Linux environments, particularly RHEL, Debian, or Ubuntu, including storage and file-system optimization.
• High availability and resilience: Knowledge of physical and logical replication, disaster recovery planning, monitoring, alerting, and business continuity practices.
• Scripting and automation: Ability to develop, analyze, and maintain PL/pgSQL scripts and automate database administration activities.
• Security and governance: Understanding of access controls, auditing, encryption, data governance, database modeling, and LGPD compliance.
• IT service management: Completion of ITIL 4 training with a minimum workload of 12 hours, along with an official ITIL 4 Foundation certification or higher.
• Cloud database certification: At least one of the following certifications is required:
  • Microsoft Certified: Azure Database Administrator Associate (DP-300).
  • AWS Certified Database - Specialty.
  • Google Professional Data Engineer.
• PostgreSQL or Linux certification: PostgreSQL Professional certification, or LPIC-1 certification accompanied by at least 40 hours of PostgreSQL training.
• Analytical and problem-solving skills: Ability to investigate complex technical issues, identify root causes, and implement reliable, performance-oriented solutions.
• Communication and collaboration: Strong documentation and communication skills, with the ability to work effectively across technical teams and coordinate with external technology providers.

Benefits

• Healthcare: Medical insurance through Hapvida, Bradesco, or Unimed, depending on the region.
• Dental coverage: Dental insurance through Hapvida Odonto or Bradesco Dental.
• Meal support: Food or meal allowance.
• Life insurance: Fully employer-funded life insurance.
• Transportation assistance: Transportation allowance.
• Well-being: TotalPass fitness benefits and access to Auster well-being services.
• Pharmacy discounts: Access to a pharmacy benefits program.
• Education benefits: Partnerships with educational institutions and access to a corporate learning platform.
• Family support: Welcome kit for new babies.
• Mental health support: Access to the Moodar platform.
• Inclusive workplace: An environment that values collaboration, professional development, diversity, and inclusion.
• Accessibility: The original posting indicates a preference for applications from people with disabilities (PwD).