Senior Database Administrator

About TruelogicAt 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 ClientThe company operates in the mobile messaging and marketing technology space, helping brands connect with their audiences in a more direct and impactful way.Their mission is centered on bridging communication gaps through innovation, reliability, and measurable results.With a cutting-edge messaging platform, they simplify how businesses launch campaigns, enabling personalized engagement at scale and supporting brands in strengthening their customer communication strategies.Job SummaryWe are seeking a Senior Database Administrator to play a key role in managing, optimizing, and evolving our data infrastructure.This role requires deep expertise in PostgreSQL internals, Snowflake performance tuning, and SQL optimization.The ideal candidate has hands-on experience with ETL from AWS Postgres to Snowflake, as well as strong skills in data modeling, monitoring, automation (Python), and orchestration tools such as Airflow and dbt.This project has a 3-month duration.ResponsibilitiesDesign and maintain ETL pipelines from AWS Postgres databases to the Snowflake data warehouse.Audit and optimize SQL queries, PostgreSQL internals, and Snowflake performance for scalability and efficiency.Implement monitoring, alerting, and automation using tools like Datadog, CloudWatch, and Python scripting.Support data modeling, schema design, and orchestration with platforms such as Airflow and dbt.Qualifications and Job RequirementsHands-on experience with ETL processes from AWS Postgres to Snowflake.Strong ability to audit and optimize SQL queries for performance and scalability.Deep understanding of PostgreSQL internals (indexes, query planner, VACUUM, etc.).Expertise in Snowflake performance tuning and warehouse management.Experience with monitoring and alerting tools (e.g., Datadog, CloudWatch).Skills in data modeling and schema design.Proficiency in Python or scripting for workflow automation.Familiarity with orchestration tools such as Airflow and dbt.What We Offer100% Remote Work: Enjoy the freedom to work from the location that helps you thrive.All it takes is a laptop and a reliable internet connection.Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.Paid Time Off: We value your well-being.Our paid time off policies ensure you have the chance to unwind and recharge when needed.Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done.Focus on results, not the clock.Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.Why You'll Like Working HereA Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.Team Up with Skilled Professionals: Join forces with senior talent.All of our team members are seasoned experts, ensuring you're working with the best in your field.Apply now#J-*****-Ljbffr