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