SQL Developer

Location: Dallas, TX

DLRdmv is driving innovation in the automotive services industry – streamlining title, registration, and compliance processes for our clients nationwide. We operate with the efficiency of a seasoned corporation and the energy of a start-up: collaborative, fast-moving, and always evolving.

Job Description

We are seeking a motivated SQL Developer with hands-on experience in AWS RDS, SQL performance tuning, and SSIS ETL development to join our growing data engineering team. This is an excellent opportunity for a technically curious developer early in their career to work on real-world data pipelines, cloud database infrastructure, and mission-critical reporting systems.

You will play a key role in designing, building, and optimizing data solutions that power business insights, ensure data accuracy, and support scalable applications.

Job Responsibilities

• Write, refactor, and performance-tune complex T-SQL queries, stored procedures, functions, and views.
• Analyze execution plans, add appropriate indexing, and resolve bottlenecks in high-volume environments.
• Implement best practices for error handling, transactions, and query reusability.
• Provision, configure, and maintain Amazon RDS instances (SQL Server, PostgreSQL, MySQL).
• Manage backups, restores, replication, Multi-AZ deployments, and automated snapshots.
• Monitor performance using CloudWatch, Performance Insights, and RDS Enhanced Monitoring.
• Apply security best practices: IAM roles, VPC security groups, encryption at rest/transit, and parameter groups.
• Design, develop, and deploy SSIS packages for ETL/ELT workflows using Visual Studio and SQL Server Data Tools.
• Implement data validation, error logging, restartability, and package configurations.
• Migrate legacy DTS/SSIS packages and optimize for performance and reliability.
• Schedule and monitor SSIS jobs via SQL Server Agent or AWS SSM/Airflow.
• Collaborate with analysts and developers to design normalized/denormalized schemas and data marts.
• Participate in code reviews, data architecture discussions, and sprint planning.
• Assist in large-scale data migrations (on-prem ? cloud, cross-database).
• Build reusable ETL frameworks for recurring data loads.
• Support BI teams by creating staging tables, views, and report-ready datasets.
  
  

Experience & Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent practical experience).
• 1–3 years of hands-on experience with:
• T-SQL (complex joins, CTEs, window functions, dynamic SQL)
• SQL Server 2016+ (on-prem or RDS)
• AWS RDS (instance setup, scaling, backups, monitoring)
• SSIS (control flow, data flow, scripting tasks, deployments)
• Solid understanding of relational database design, normalization, and indexing strategies.
• Experience with source control (Git preferred).
• Strong analytical and problem-solving skills with attention to detail.
• Excellent written and verbal communication — able to explain technical concepts clearly.