Administrador de banco de dados PostgreSQL

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for an Administrador de banco de dados PostgreSQL based in Brazil . 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.