Mid-Level PostgreSQL Database Administrator (DBA)

New
J
JobgetherAnalytical databases
Based in BrazilFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Experience
Approximately 4 years of experience in data-related roles
Required Skills
AWSPostgreSQLSQLMicrosoft SQL ServerMySQLOracleSnowflakeClickhouseBigQuery

Requirements

  • Hold a bachelor's degree, preferably in Computer Science, Engineering, a data-related discipline, or a related field.
  • Have approximately 4 years of experience in data-related roles.
  • Have experience working with agile methodologies.
  • Bring strong database administration experience with PostgreSQL, SQL Server, Oracle, or MySQL.
  • Demonstrate advanced SQL skills, including stored procedures, views, indexing, partitioning, and query performance tuning.
  • Have experience with modern data warehouses and columnar databases such as BigQuery, Snowflake, Amazon Redshift, or ClickHouse.
  • Know cloud providers and services, particularly AWS, Microsoft Azure, or Google Cloud.
  • Understand analytical database architectures and dimensional modeling.
  • Be able to troubleshoot complex database performance challenges.
  • Be able to collaborate with developers, data analysts, and other technical stakeholders.

Responsibilities

  • Design, implement, maintain, and optimize analytical database structures using OLAP and dimensional modeling.
  • Analyze execution plans and optimize complex SQL queries, analytical queries, and ETL routines.
  • Manage database access permissions and safeguard analytical data in line 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 on indexing strategies, table partitioning, and materialized views.
  • Identify database performance issues and implement improvements for reliable data access and reporting.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now