DBA PL - PostgreSQL

Jobgether

Brasil

Remote

BRL 120,000 - 180,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
Dental insurance
Life insurance
Meal or food allowance
Transportation allowance
Wellhub membership (formerly Gympass)
Fully remote work arrangement
Permanent employment contract

Job summary

Jobgether is seeking a Mid-Level PostgreSQL Database Administrator (DBA) based in Brazil. You will design, manage, and optimize analytical database environments, focusing on performance, scalability, and cost efficiency for reporting and data-driven decisions.

You will work with OLAP architectures, SQL tuning, ETL processes, and data security in a remote-first setup. Collaboration with developers and data analysts is essential to deliver robust, high-performing data infrastructure.

Qualifications

  • Bachelor's degree in a related field.
  • Approximately 4 years of experience in data-related roles with agile methodologies.
  • Solid PostgreSQL/SQL experience and knowledge of data warehouses.
  • Strong SQL skills incl. stored procedures, views, indexing, partitioning, and performance tuning.
  • Experience with modern data warehouses (BigQuery, Snowflake, Redshift, ClickHouse) and cloud providers (AWS/Azure/GCP).
  • Understanding analytical database architectures and dimensional modeling.
  • Ability to collaborate with developers and analysts to solve complex data challenges.

Responsibilities

  • Design, implement, and maintain analytical database structures (OLAP) using dimensional modeling like Star and Snowflake schemas.
  • Analyze execution plans and optimize complex queries and ETL routines for performance.
  • Manage database access and safeguard data, ensuring LGPD compliance.
  • Monitor and administer database instances for availability, scalability, and cost efficiency.
  • Collaborate with developers and data analysts to design indexing strategies, partitioning, and materialized views.
  • Identify performance issues and implement improvements for reliable data access and reporting.

Skills

SQL
Dimensional modeling
Cloud technologies
Agile methodologies
Analytical thinking
Collaboration

Education

Bachelor's degree

Tools

PostgreSQL
BigQuery
Snowflake
Redshift
ClickHouse
AWS
Azure
GCP

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Mid-Level PostgreSQL Database Administrator (DBA) based in Brazil.

We are looking for an experienced Database Administrator specializing in PostgreSQL to design, manage, and optimize analytical database environments. In this role, you will ensure database performance, scalability, availability, and cost efficiency while supporting reliable access to business-critical data. You will work with analytical database architectures, dimensional modeling, complex SQL queries, and ETL processes to enable efficient reporting and data-driven decisions. You will also contribute to data security and compliance with Brazil’s data protection regulations. Collaborating with developers and data analysts, you will help build robust, high-performing database solutions in a technology-focused environment. This is a fully remote opportunity for a professional who enjoys solving complex technical challenges and continuously improving data infrastructure.

Accountabilities:
  • Design, implement, and maintain analytical database structures (OLAP), using dimensional modeling approaches such as Star Schema and Snowflake Schema.

  • Analyze execution plans and optimize complex SQL queries, analytical queries, and ETL routines to improve performance and prevent bottlenecks.

  • Manage database access permissions and safeguard analytical data, ensuring compliance with applicable data protection regulations, including Brazil’s LGPD.

  • Monitor and administer database instances, managing availability, scalability, and operational costs.

  • Collaborate with developers and data analysts to design efficient indexing strategies, table partitioning, and materialized views.

  • Identify performance issues and implement improvements to ensure reliable, efficient data access and reporting.

Requirements:

The ideal candidate brings solid database administration experience, advanced SQL expertise, and practical knowledge of modern analytical data platforms. You should be comfortable working with cloud technologies, agile methodologies, and technical teams.

  • Bachelor's degree, preferably in Computer Science, Engineering, Data-related disciplines, or a related field.

  • Approximately 4 years of experience in data-related roles, working with agile methodologies.

  • Strong database administration experience with PostgreSQL, SQL Server, Oracle, or MySQL.

  • Advanced SQL skills, including stored procedures, views, indexing, partitioning, and query performance tuning.

  • Experience with modern data warehouses and columnar databases, such as BigQuery, Snowflake, Amazon Redshift, or ClickHouse.

  • Knowledge of cloud providers and services, particularly AWS, Microsoft Azure, or Google Cloud.

  • Understanding of analytical database architectures and dimensional modeling.

  • Strong analytical and problem-solving skills, with the ability to troubleshoot complex database performance challenges.

  • Ability to collaborate effectively with developers, data analysts, and other technical stakeholders.

  • No professional certification is required.

Benefits:
  • Health insurance.

  • Dental insurance.

  • Life insurance.

  • Meal or food allowance.

  • Transportation allowance.

  • Wellhub membership (formerly Gympass).

  • Fully remote work arrangement.

  • Permanent employment contract.

How Jobgether works:

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.

We appreciate your interest and wish you the best!

Why Apply Through Jobgether?

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

DBA | Administrador de Banco de Dados
DBA | Administrador de Banco de Dados

Jobgether • Brazil

Remote
BRL 163,000 - 204,000
Monthly salary
Remote work
Health insurance
+7
Analista de Dados Júnior, Pleno e Sênior | SQL | Power BI | Cloud
Analista de Dados Júnior, Pleno e Sênior | SQL | Power BI | Cloud

Jobgether • Brazil

On-site
BRL 90,000 - 150,000
Medical insurance
Dental insurance
Meal allowance
+10
DBA Sênior | Oracle, PostgreSQL e MongoDB
DBA Sênior | Oracle, PostgreSQL e MongoDB

Jobgether • Brazil

Remote
BRL 180,000 - 320,000
100% remote work
PJ contractor arrangement
Dba Sênior | Oracle, Postgresql E Mongodb
Dba Sênior | Oracle, Postgresql E Mongodb

Jobgether • Brasília

Remote
BRL 180,000 - 310,000
100% remote work
PJ contract
SQL Engineer Report Developer (SSRS & Power BI)
SQL Engineer Report Developer (SSRS & Power BI)

Jobgether • Brazil

Remote
BRL 180,000 - 280,000
Fully remote across Latin America
Professional development opportunities
English scholarships
Administrador de Dados
Administrador de Dados

Jobgether • Brazil

Remote
BRL 90,000 - 130,000
Fully remote Brazil
CLT contract
6-month initial term
Analytics Engineer III (Diretoria de Dados - FP&A)
Analytics Engineer III (Diretoria de Dados - FP&A)

Jobgether • Brazil

Remote
BRL 180,000 - 240,000
Analista Desenvolvedor de Sistemas
Analista Desenvolvedor de Sistemas

Jobgether • Brazil

Remote
BRL 60,000 - 100,000
Food and meal allowance
Education discounts
Stefanini Academy access
+9
Data & Platform Engineer
Data & Platform Engineer

Jobgether • Brazil

Remote
BRL 300,000 - 420,000
Fully remote position
Full-time opportunity
Modern technology environment
+4
Senior Solution Engineer, Partnerships
Senior Solution Engineer, Partnerships

Jobgether • Brazil

Remote
BRL 490,000 - 570,000
Remote work in Brazil
Base salary 490,000–570,000 BRL
Performance bonus 73,500–85,000 BRL
+5