Database Engineer

TTN Fleet Solutions

Farmers Branch (TX)

Hybride

USD 110 000 - 170 000

Plein temps

Il y a 4 jours
Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

TTN Fleet Solutions in United States, Texas is seeking a Database Engineer with deep MySQL expertise to design, build, and maintain our core data infrastructure. You will develop robust ETL/ELT pipelines, optimize relational schemas, and ensure high-availability data delivery for analytics and engineering teams.

The role bridges database administration with modern data pipeline development, focusing on performance tuning, data integrity, and cross-functional collaboration with software

Qualifications

  • Bachelor’s degree in a relevant field.
  • Deep MySQL expertise and data engineering experience.
  • Experience building ETL/ELT pipelines from MySQL sources.
  • Experience with modern data pipeline tools (Airflow/Prefect) and ingestion frameworks.

Responsabilités

  • Design, build, and automate scalable ETL/ELT pipelines sourcing from MySQL databases.
  • Model efficient relational schemas and OLTP tables with proper normalization.
  • Tune performance with indexing, partitioning, and EXPLAIN analysis.

Connaissances

Advanced SQL mastery
Python programming
Data pipeline orchestration
Relational database design
Analytical problem solving

Formation

Bachelor's degree in Computer Science / Information Systems

Outils

Apache Airflow
Prefect
Fivetran
Airbyte
dbt
AWS RDS
GCP Cloud SQL
Azure Database for MySQL
Snowflake
BigQuery
Redshift

Description du poste

Job Summary:

The Database Engineer has deep expertise in MySQL to design, build, and maintain our core data infrastructure. This role is responsible for developing robust ETL/ELT pipelines, optimizing complex relational database schemas, and ensuring high-availability data delivery for our analytics and engineering teams. The ideal candidate bridges the gap between traditional database administration and modern data pipeline development, maximizing the performance and reliability of our MySQL ecosystems.

Duties/Responsibilities:

  • Pipeline Development: Design, implement, and automate scalable data ingestion, transformation, and loading (ETL/ELT) pipelines sourcing from operational MySQL databases.
  • Database & Schema Design: Model efficient relational schemas, build transactional (OLTP) tables, manage primary/foreign keys, and establish clean normalization patterns.
  • Performance Tuning: Optimize complex SQL queries, manage table partitioning, structure indexes efficiently, and utilize execution plans (EXPLAIN) to eliminate system bottlenecks.
  • Data Integration & Warehousing: Replicate and sync data between MySQL production environments, staging areas, and downstream cloud data warehouses or analytics tools.
  • Data Integrity & Governance: Implement rigorous automated data validation checks, monitoring alerts, and lineage tracking to maintain high data quality and security.
  • Cross-Functional Collaboration: Partner with Software Engineers, Data Scientists, and BI Analysts to translate raw application data into reliable, optimized views for downstream consumption.

Required Skills and Qualifications:

  • Professional experience working heavily as a Data Engineer, Database Engineer, or Back-End Engineer with a relational focus.
  • Advanced SQL mastery, including deep experience troubleshooting, optimizing, and rewriting complex queries specifically within MySQL.
  • Hands-on experience with modern data pipeline orchestration tools (e.g., Apache Airflow, Prefect) and ingestion frameworks (e.g., Fivetran, Airbyte).
  • Strong proficiency in a programming language used for data manipulation, preferably Python.
  • Proven experience with database optimization techniques, such as indexing strategies, partitioning, and connection pooling.
  • Exceptional analytical problem-solving skills and the ability to articulate technical data structures to non-technical stakeholders.

Preferred Qualifications:

  • Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for MySQL) and cloud data warehouses (Snowflake, BigQuery, or Redshift).
  • Experience with dbt (data build tool) for managing transformations within the data stack.
  • Understanding of database administration tasks, including backup/restore verification, replication strategies, and high-availability/disaster-recovery (HA/DR) design.
  • Bachelor’s degree in Computer Science, Information Systems, or a related quantitative field.

Physical and Work Location Requirements:

  • Prolonged periods sitting at a desk and working on a computer.
  • Must be able to lift up to 20 pounds at times.
  • A hybrid work location is authorized for this position. Schedule is set by manager.
  • Company specifications must be met for internet connectivity when working from home.
Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Sr. Database Administrator
Sr. Database Administrator

Radiant Info Systems Ltd. • Kansas City (KS)

Sur place
USD 80 000 - 100 000
Confidentiality according to EEO guidelines
Sr. Database Engineer
Sr. Database Engineer

NextGen Invent Corporation • États-Unis

À distance
USD 120 000 - 180 000
Hybrid MySQL Data Engineer — ETL & Performance Expert
Hybrid MySQL Data Engineer — ETL & Performance Expert

TTN Fleet Solutions • Farmers Branch (TX)

Hybride
USD 110 000 - 170 000
MySQL DBA
MySQL DBA

Volto Consulting • Englewood Cliffs (NJ)

Sur place
USD 100 000 - 150 000
MySQL Database Administrator
MySQL Database Administrator

Photon • Sunnyvale (CA)

Sur place
USD 120 000 - 180 000
Database Engineer
Database Engineer

Changeis, Inc. • États-Unis

Sur place
USD 110 000 - 150 000
MYSQL Database Administrator
MYSQL Database Administrator

SRM Digital LLC • Framingham (MA)

Sur place
USD 90 000 - 120 000
MySQL DBA
MySQL DBA

TechDigital Group • Austin (TX)

Sur place
USD 80 000 - 120 000
Senior Data Engineer - 1018994
Senior Data Engineer - 1018994

Dexian • Covington (KY)

Sur place
USD 120 000 - 160 000
Data Engineer
Data Engineer

ReturnPro LLP • Florida

Sur place
USD 110 000 - 150 000