~44m ago

Administrador de banco de dados PostgreSQL

BrazilRemoteFull-timemid

Other

0 views0 saves0 applied

Apply Now

Quick Summary

Requirements Summary

Manage database roles and access permissions, maintain audit trails and logs, support encryption practices,

Technical Tools

Other

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.

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

~2 min read

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.