Junior SQL Developer
dlrdmvDallas (TX)
About the role
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 Junior 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.
Seniority level:
Entry level Employment type: Full‐time Job function: Strategy/Planning and Information Technology Industries: Software Development Referrals increase your chances of interviewing at DLRdmv® by 2x Get notified about new SQL Developer jobs in Dallas, TX.
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.