Senior Database Administrator
New
BrazilFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- PostgreSQLPythonSQLApache AirflowETLSnowflakedbt
Requirements
- 5+ years of experience in Database Administration, Database Engineering, or a data-focused engineering role with strong database ownership.
- Deep expertise in PostgreSQL, particularly in AWS environments such as RDS or Aurora, including performance tuning and optimization.
- Strong hands-on experience with Snowflake, including data ingestion, query optimization, and cost/performance management.
- Advanced SQL skills, including query profiling, execution plan analysis (EXPLAIN), indexing, and schema optimization techniques.
- Proven experience building and maintaining ETL/ELT pipelines using tools such as dbt, Airflow, AWS Glue, or Python-based solutions.
- Strong experience with AWS Database Migration Service (DMS) for data synchronization and migration workflows.
- Proficiency with Git and collaborative development workflows.
Responsibilities
- Design, build, and maintain robust ETL/ELT pipelines that transfer and consolidate data from multiple AWS PostgreSQL production databases into Snowflake for analytics and reporting.
- Continuously audit, analyze, and optimize SQL queries across production systems, identifying bottlenecks and improving performance through query rewrites, indexing strategies, and configuration tuning.
- Oversee the operational health, security, backup, and scalability of PostgreSQL (AWS RDS/Aurora) and Snowflake environments to ensure high availability and reliability.
- Act as a database performance escalation point, diagnosing and resolving critical production issues with minimal downtime.
- Collaborate closely with software engineers to review database schemas and SQL queries, enforcing best practices before production deployment.
- Contribute to data architecture decisions and ensure systems are designed for efficiency, scalability, and long-term maintainability.
View Full Description & ApplyYou'll be redirected to the employer's site
