Database Developer / DBA (PostgreSQL)

Descrição da Vaga

Requisitos

• We need someone who has strong technical opinions and knows how to build resilient, high-performance database systems
• This role is perfect for someone who prefers working with a focused, high-impact data environment rather than managing a massive amount of data sprawl
• PostgreSQL Expertise: You have 4+ years of hands‑on experience managing production environments at a terabyte scale, such as a fleet of up to 100 instances
• Technical Conviction: You have a proven ability to recommend and advocate for the best database setups and high‑availability systems
• Cloud Proficiency: You have experience managing databases in major cloud environments (like AWS, Azure, or GCP) or private/VPS setups
• Automation Mindset: You have a strong background in scripting and automation to manage production environments efficiently
• AI: having the skill to use AI tools to assist with coding or monitoring is a great advantage

Responsabilidades

• You will be responsible for making our data infrastructure reliable and helping it grow
• Collaborative Infrastructure Design: You will work closely with the DevOps team to suggest and design solutions for our infrastructure
• Your role is to provide the architectural vision while working together on implementation
• High Availability: You will design and maintain replication, failover, and clustering to make sure our systems are always running and fault‑tolerant
• Backups & Disaster Recovery: You will design and test backup strategies to ensure we can restore data quickly with almost no downtime
• Observability & Monitoring: You will use tools like Prometheus and Grafana to watch our systems, check their health, and set up alerts for any issues
• Zero‑Downtime Maintenance: You will handle routine tasks like patching and vacuuming using blue‑green update techniques to avoid service interruptions
• Automation: You will use Ansible and Terraform to make infrastructure and deployment processes more efficient
• Architecture & Design: You will lead the planning of our database systems and provide a clear point of view on how to design schemas for better performance
• Performance Engineering: You will find performance problems and tune queries and indexes based on how the system is being used
• Development Support: You will work closely with engineering teams to help them optimize queries and plan safe database migrations
• Security & Access Management: You will manage database security, encryption, and rules for data access
• Incident Response: You will help find the root cause of database problems and write clear documentation for our systems and recovery steps

Benefícios