Job Description
SQL Developer Dallas, TX Job Details Full-time $100,000 - $110,000 a year 1 day ago Qualifications Data encryption Version control Cloud identity and access management (IAM) Computer science Data replication Data Integration (Data management) Computer Science Data migration Database backup and recovery Visual Studio IT system monitoring Data reporting Git Information Systems Mid-level Scalable systems Technology security practices Data Architecture Design (Architecture design skills) Analysis skills Bachelor's degree Cloud infrastructure implementation Scripting Scalability Amazon CloudWatch Data validation 1 year SSIS Cloud monitoring RDS database Bachelor's degree in computer science Communication skills Virtual Private Clouds Database replication implementation T-SQL System performance monitoring
Full Job Description 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.
