SQL Developer at DLRdmv – Dallas, Texas

About DLRdmv

DLRdmv® provides streamlined software solutions for out-of-state title and registration processing. Our industry-leading solution DLR50™ features DMS integration, instant access to accurate fee quotes and forms, and full-service title processing. DLR50™ minimizes risks and keeps your loan processing on track. Trusted by dealerships nationwide, we now partner with financial institutions to simplify and accelerate the vehicle title and registration process - reducing errors, improving compliance, and enhancing the customer experience.

DLRdmv offers a competitive salary and a comprehensive benefits package including life, medical, dental, vision, and more.

DLRdmv is an EEO Employer. We sincerely appreciate your interest and will carefully evaluate your qualifications for employment. Be assured your opportunity for employment with our company will be based only on your merit without regard to race, color, religion, sex, age, national origin, mental or physical disability, or any other factor unrelated to job requirements.

About the role

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.

What you'll do

• 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.

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.