Senior PostgreSQL & DBT Performance Architect

Motion Recruitment Partners LLC; Charlotte, Northern (NC, KY); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Motion Recruitment Partners LLC seeks a Senior SQL Support Engineer in Charlotte, NC to lead PostgreSQL architecture, optimize high-volume queries, and drive DBT transformation integrity. The role focuses on performance tuning, indexing, and capacity planning within a large financial services environment.

The candidate will design complex SQL solutions, develop runbooks, and contribute to enterprise data operations, reporting directly to infrastructure teams.

Qualifications

• 8+ years enterprise SQL engineering experience.
• Deep PostgreSQL expertise.
• DBT transformation experience.
• Advanced query tuning and performance diagnostics.
• Experience in financial or regulated environments.
• Prior Level 2/3 SQL Support in large environments desired.

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

Skills

SQL engineering

PostgreSQL

DBT models

Query tuning

Regulated environments

L2/L3 support

Job description

Motion Recruitment Partners LLC seeks a Senior SQL Support Engineer in Charlotte, NC to lead PostgreSQL architecture, optimize high-volume queries, and drive DBT transformation integrity. The role focuses on performance tuning, indexing, and capacity planning within a large financial services environment.

The candidate will design complex SQL solutions, develop runbooks, and contribute to enterprise data operations, reporting directly to infrastructure teams.