Motion Recruitment
Senior Database Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Database Engineer with 8+ years of SQL engineering experience, specializing in PostgreSQL and DBT transformation. Contract length is unspecified, with a competitive pay rate. Location is remote, requiring experience in financial or regulated environments.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 3, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Charlotte Metro
-
🧠 - Skills detailed
#"ETL (Extract #Transform #Load)" #PostgreSQL #SQL (Structured Query Language) #dbt (data build tool) #SQL Queries #Documentation #Scala #Schema Design #Alation #Database Monitoring #Monitoring #Indexing
Role description
Role Summary
The Senior Database Engineer is responsible for enterprise SQL engineering, DBT transformation integrity, and PostgreSQL performance optimization. This role serves as the primary authority on schema design, indexing strategies, and large-scale data operations.
Key Responsibilities
• Lead PostgreSQL architecture and performance optimization
• Design and optimize complex SQL queries supporting APIs and DBT models
• Analyze execution plans and tune high-volume workloads
• Implement indexing and partitioning strategies
• Conduct database health assessments and capacity planning
• Develop SQL investigation playbooks for L2 escalations
Deliverables & Outcomes
• Reduced DBT runtime and transformation failures
• Improved database query performance
• Structured database monitoring and maintenance procedures
• SQL diagnostics documentation and runbooks
Required Experience / Skills
• 8+ years enterprise SQL engineering experience
• Deep PostgreSQL expertise
• DBT transformation experience
• Advanced query tuning and performance diagnostics
• Experience in financial or regulated environments
Role Summary
The Senior Database Engineer is responsible for enterprise SQL engineering, DBT transformation integrity, and PostgreSQL performance optimization. This role serves as the primary authority on schema design, indexing strategies, and large-scale data operations.
Key Responsibilities
• Lead PostgreSQL architecture and performance optimization
• Design and optimize complex SQL queries supporting APIs and DBT models
• Analyze execution plans and tune high-volume workloads
• Implement indexing and partitioning strategies
• Conduct database health assessments and capacity planning
• Develop SQL investigation playbooks for L2 escalations
Deliverables & Outcomes
• Reduced DBT runtime and transformation failures
• Improved database query performance
• Structured database monitoring and maintenance procedures
• SQL diagnostics documentation and runbooks
Required Experience / Skills
• 8+ years enterprise SQL engineering experience
• Deep PostgreSQL expertise
• DBT transformation experience
• Advanced query tuning and performance diagnostics
• Experience in financial or regulated environments
