Administrador de banco de dados PostgreSQL

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).