DBA PL - PostgreSQL
Core
Design, manage, and optimize analytical PostgreSQL database environments to ensure performance, scalability, and cost efficiency while supporting reliable access to business-critical data.
Role type
Mid-level IC PostgreSQL Database Administrator
Builds
Robust, high-performing analytical database solutions (OLAP)
Domain
Data Engineering / Cloud Data Warehousing
Deliverable
production ML models
Required skills
PostgreSQL, dimensional modeling (Star/Snowflake), complex SQL optimization, ETL management, cloud data warehouses (BigQuery, Snowflake, Redshift, ClickHouse), cloud platforms (AWS, Azure, GCP), database security & compliance (LGPD)
Preferred skills
Agile methodologies, troubleshooting complex performance issues
Technologies
PostgreSQL, BigQuery, Snowflake, Amazon Redshift, ClickHouse, AWS, Microsoft Azure, Google Cloud
Responsibilities
Design and maintain analytical database structures using dimensional modeling; Analyze execution plans and optimize complex SQL queries and ETL routines; Manage database access permissions and ensure compliance with data protection regulations; Monitor and administer database instances for availability and cost efficiency; Collaborate on indexing strategies, table partitioning, and materialized views; Identify and resolve performance issues to ensure efficient data access.
Seniority
Mid-level, hands-on IC