Senior Database Administrator / Data Engineer (Snowflake) - Software Industry

ABOUT TRUELOGIC At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals. Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference. By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future. OUR CLIENT Our client is a technology company specializing in large-scale customer engagement and communication solutions. Their platform processes high volumes of real-time transactional and customer interaction data, helping organizations deliver personalized experiences at scale. JOB SUMMARY We are seeking a Senior Database Administrator / Data Engineer with strong Snowflake expertise to take ownership of our production data platform, database performance, and data movement processes. In this role, you will be responsible for optimizing and maintaining our Snowflake and AWS PostgreSQL environments, building and managing ETL/ELT pipelines, auditing and tuning SQL queries, and ensuring reliable, scalable, and cost-efficient data operations across a high-volume production platform. RESPONSIBILITIES - Snowflake Administration & Optimization: Own the performance, administration, monitoring, and cost optimization of our Snowflake environment. Ensure efficient data loading, warehouse utilization, and platform scalability. - Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. - Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. - Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. - Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. - Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services. QUALIFICATIONS AND JOB REQUIREMENTS - 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role. - Snowflake Expertise: Hands-on experience working with Snowflake in production environments, including data loading, query performance tuning, warehouse management, and supporting data integration workflows. - PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora). - Advanced SQL Profiling: Exceptional skills in query profiling, execution plan analysis (EXPLAIN), partition strategies, and index optimization. - Hands-on ETL/ELT: Proven experience building and maintaining data pipelines using tools like dbt, Airflow, AWS Glue, or custom Python scripting. - Data Migration & Synchronization: Experience using AWS Data Migration Service (DMS) to move and continuously synchronize data between relational databases and data warehouses. - Version Control: Absolute proficiency with Git. NICE TO HAVE SKIL