DBA PL - PostgreSQL
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:
You will be responsible for designing, implementing, maintaining, and optimizing analytical database structures, ensuring they meet performance, security, and scalability requirements. Your responsibilities will include:
-
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.
Skills
As published by lever
Resume/CV, Full name, Email, Phone, Current location, Current company
Sign in to read and join the discussion.