Junior SQL Developer

DLRdmv®; Dallas (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading automotive services provider in Dallas, TX is looking for a motivated Junior SQL Developer. In this full-time role, you will work on real-world data pipelines and cloud database infrastructure, focusing on T-SQL and AWS RDS. The ideal candidate will have a background in Computer Science and hands-on experience with SQL Server and SSIS. This entry-level position offers great career growth opportunities.

Qualifications

• 1-3 years of hands-on experience with T-SQL, SQL Server, and AWS RDS.
• Strong understanding of relational database design and indexing strategies.
• Experience with SSIS package development and deployment.

Responsibilities

• Write and performance-tune complex T-SQL queries and stored procedures.
• Provision and maintain Amazon RDS instances.
• Implement data validation and error logging in ETL workflows.

Skills

T-SQL (complex joins, CTEs, window functions, dynamic SQL)

AWS RDS

SSIS

SQL Server 2016+

Source control (Git)

Analytical and problem-solving skills

Excellent written and verbal communication

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Job description

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.