DBA PL - PostgreSQL
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.
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