Senior Database Administrator – Software

This is a fully remote position, open to applicants in Latin America.

📋 Description

• Data Pipeline Execution (ETL): Design, oversee, and monitor effective ETL/ELT pipelines to integrate data from various production AWS PostgreSQL instances into Snowflake for analytics and reporting.

• Advanced Query Auditing & Performance Tuning: Regularly review SQL queries in our production environments. Identify complex bottlenecks, rewrite inefficient queries, enhance indexes, and fine-tune database settings to guarantee optimal platform performance.

• Database Operations & Maintenance: Manage the daily health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake systems.

• Query Best Practices & Collaboration: Collaborate with Software Engineers to evaluate database schemas and queries prior to production deployment, serving as a trusted advisor on SQL best practices.

• Troubleshooting & Optimization: Act as the senior escalation point for database performance challenges, ensuring minimal downtime and high availability for our essential SMS services.

⛳️ Requirements

• 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role.

• PostgreSQL Expertise: Extensive hands-on experience managing and tuning PostgreSQL databases, particularly within the AWS ecosystem (RDS or Aurora).

• Snowflake Proficiency: Strong background in working with Snowflake, encompassing data loading, performance tuning, and warehouse cost management.

• Advanced SQL Profiling: Outstanding capabilities in query profiling, execution plan analysis (EXPLAIN), partition strategies, and index optimization.

• Hands-on ETL/ELT: Proven track record in building and maintaining data pipelines using tools such as dbt, Airflow, AWS Glue, or custom Python scripting.

• Data Migration & Synchronization: Fundamental experience using AWS Data Migration Service (DMS) to transfer and continuously synchronize data between relational databases and data warehouses.

• Version Control: Complete proficiency with Git.

🏝️ Benefits

• 100% Remote Work: Enjoy the flexibility to work from any location that fosters your productivity. All you need is a laptop and a reliable internet connection.

• Highly Competitive USD Pay: Receive an excellent, industry-leading salary in USD that surpasses standard market offerings.

• Paid Time Off: We prioritize your well-being. Our paid time off policies allow you to relax and recharge when necessary.

• Work with Autonomy: Benefit from the freedom to manage your time effectively, as long as the work is accomplished. Focus on results rather than the clock.

• Work with Top American Companies: Expand your expertise by engaging in innovative, high-impact projects with industry-leading U.S. companies.