Truelogic

Truelogic

Senior Database Administrator (DBA) – Software

LATAMRemotePosted Today
Full TimeSeniorRemote

See how this job matches your profile

Sign in for an AI-powered fit score, breakdown, and a tailored resume.

Sign in

Job Description

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 c

Key Highlights

  • 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

Required Qualifications

  • 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role.
  • PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora).
  • Snowflake Proficiency: Strong experience working with Snowflake, including data loading, performance tuning, and warehouse cost management.
  • 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: Core 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.
  • 5+ years of experience in Database Administration, Database Engineering, or a heavily database-focused Data Engineering role.
  • PostgreSQL Expertise: Deep hands-on experience managing and tuning PostgreSQL databases, specifically within the AWS ecosystem (RDS or Aurora).
  • Snowflake Proficiency: Strong experience working with Snowflake, including data loading, performance tuning, and warehouse cost management.
  • 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: Core 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.

Preferred Qualifications

  • Python scripting and automation experience.
  • Experience with CDC technologies (Debezium, AWS DMS, Fivetran, etc.).
  • Experience with real-time streaming platforms (Kafka, Kinesis, etc.).
  • Knowledge of compliance frameworks such as TCPA, CTIA, and SOC 2.
  • Bash/Shell scripting experience.
  • Familiarity with monitoring and observability tools (Datadog, CloudWatch, Grafana, etc.).
  • Python scripting and automation experience.
  • Experience with CDC technologies (Debezium, AWS DMS, Fivetran, etc.).
  • Experience with real-time streaming platforms (Kafka, Kinesis, etc.).
  • Knowledge of compliance frameworks such as TCPA, CTIA, and SOC 2.
  • Bash/Shell scripting experience.
  • Familiarity with monitoring and observability tools (Datadog, CloudWatch, Grafana, etc.).

Skills & Technologies

GoAWSPostgreSQLSQLPythonGitKafkaBash

About the Company

Truelogic

Truelogic

View company profile →

Interested in this role?

Sign in or create a free account to see how this job matches your skills, apply with one click, and let our AI tailor your resume.

Sign in to apply
AI-powered resume optimization
Save and track your applications
Sign in to apply

Job Details

Employment Type

Full Time

Experience Level

Senior

Location

LATAM

Work Mode

Remote

Posted

Today