
Database Administrator – PostgreSQL
Stefanini Brasil
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇧🇷 Brazil
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
AnsibleAWSAzureCloudDockerGoogle Cloud PlatformGrafanaKubernetesLinuxNoSQLPostgresPrometheusRDBMSTerraform
About the role
- Administer PostgreSQL environments in production, staging and development.
- Monitor database performance, availability and capacity.
- Perform backups, restores and disaster recovery strategies.
- Implement and maintain maintenance routines (VACUUM, ANALYZE, REINDEX).
- Analyze and optimize queries, indexes and execution plans.
- Manage security, users, permissions and access control.
- Support development teams with data modeling and best practices.
- Participate in incident resolution and root cause analysis.
- Document procedures and environments.
- Work collaboratively with Infrastructure, Cloud and DevOps teams.
Requirements
- Experience as a PostgreSQL DBA in a production environment.
- Proficiency in PL/pgSQL.
- Knowledge of replication, high availability and failover.
- Experience with logical and physical backups (pg_dump, pg_basebackup).
- Familiarity with Linux.
- Experience with monitoring tools (e.g., pgAdmin, Prometheus, Grafana, or similar).
- Knowledge of performance tuning and log analysis.
- Preferred — experience with PostgreSQL in cloud environments (AWS RDS, GCP, Azure).
- Preferred — knowledge of Docker/Kubernetes.
- Preferred — experience with automation tools (Ansible, Terraform).
- Preferred — PostgreSQL certifications.
- Preferred — experience with NoSQL databases or other RDBMS.
Benefits
- Remote work
- Culture of innovation
- Opportunities for professional growth
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQLPL/pgSQLdatabase performance tuningquery optimizationdata modelingbackup and restoredisaster recoveryreplicationhigh availabilityfailover
Soft skills
collaborationincident resolutionroot cause analysisdocumentation
Certifications
PostgreSQL certifications