Senior Microsoft SQL Developer
Asterism IT Solutions
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Development Testing
- Collaboration
- Communication
- Business Analytics
- Cloud Computing
- Backend Development
- Business Analysis
- Agile
- Auditing
- Authorization
- SQL
- SQL Azure
- SQL Tuning
- Regulatory Compliance
- Restructuring
- Project Implementation
- Quality Assurance
- Preventive Maintenance
- Project Management
- Payment Card Industry
- Performance Management
- Microsoft SQL Server
- Migration
- Microservices
- Microsoft Azure
- Scrum
- Extract, Transform, Load
- IT Management
- Data Retention
- Database
- DevOps
- API
- C#
- Data Migration
- GC
- Technical Writing
- Virtual Machines
- Technical Drafting
- IaaS
- Software Modernization
- ADF
- Stored Procedures
- .NET
Summary
Onsite Requirement: 1 day per week
Duration: 12 months, with possible extension
Interview: Phone and In-Person
Position Summary
VDOT is seeking a Senior Microsoft SQL Developer / Microservices Technical Lead to support a tolling modernization program. This role requires strong hands-on experience with SQL Server, .NET/C#, Azure SQL, Azure Data Factory, and database modernization, along with technical leadership experience.
The consultant will work closely with the PM/Scrum Master, SMEs, developers, QA, DevOps, Cloud, and other stakeholders to help decompose a monolithic database into microservice-aligned schemas and support application modernization.
Key Responsibilities
- Lead technical design discussions for microservices, database restructuring, and API integrations.
- Perform hands-on SQL development including:
- Schema modernization
- Stored procedures
- Views
- Indexing
- Query optimization
- Performance tuning
- Support .NET/C# backend and API development as needed.
- Guide engineering teams and provide technical leadership.
- Work closely with SMEs and project leadership on architecture and delivery decisions.
- Build migration logic and ETL pipelines using Azure Data Factory (ADF).
- Align SQL modernization efforts with microservice boundaries and migration timelines.
- Participate in code reviews and technical documentation reviews.
- Collaborate across SQL, .NET, BA, QA, DevOps, Cloud, and CAB teams.
- Support compliance requirements including PCI, data retention, audit, and secure data handling.
- Participate in Agile delivery activities and support project execution.
Required Qualifications
- 10+ years of overall IT experience.
- 7+ years of Microsoft SQL Server development experience.
- 5+ years of .NET / C# backend development experience.
- 3–5 years of technical lead experience.
- 3+ years of modernization or migration project experience.
- 3+ years of experience with Azure SQL in IaaS VM environments.
- 3+ years of experience building Azure Data Factory (ADF) pipelines and supporting ETL workloads.
- 3+ years of experience working with Agile delivery teams.
- Strong experience with SQL performance tuning, schema design, stored procedures, views, indexing, and data migration.
- Strong communication and cross-functional collaboration skills.
Preferred Qualifications
- 2+ years of state government or transportation industry experience.
- 2+ years working in regulated or audited environments.
- 2+ years of exposure to microservices architecture.
- Experience with PCI or other compliance-driven environments.
- Dice Id: 91173046
- Position Id: 9103981
- Posted 6 hours ago
Company Info
About Asterism IT Solutions
Asterism IT Solutions is a global IT services and consulting firm. Relationships. It’s what drives us. We believe in building strong, long-lasting partnerships with our clients and technology professionals. Our team connects top talent with leading organizations through a wide range of technology solutions, helping businesses grow—and careers thrive.
We find the right fit for our candidates across contract, contract-to-hire, and direct placement opportunities in software development, cloud, security, and more.
Tech professionals with strong technical skills and a vision for long-term career growth will feel right at home with Asterism.
For clients, Asterism offers flexible IT Staffing Services, helping you scale quickly with experienced professionals to support critical projects, address workload spikes, and meet specialized skill needs. Our Direct Hire services ensure permanent placements for key technical and leadership roles. We also deliver strategic IT Consulting—providing expert guidance on project planning, technology strategy, and execution across enterprise systems
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs