Senior SQL Developer & DBA: Cloud DW & Legacy Migrations

Insight Global; Chicago (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

Insight Global in Chicago is seeking a seasoned SQL Developer/DBA for an on-site contract. The role blends database development and administration across two strategic initiatives: migrating legacy data to a modern SQL Server environment and designing a cloud-based data warehouse to enable scalable reporting and analytics.

The candidate will manage ETL, data modeling, and performance tuning while handling maintenance, security, and backup/recovery in both on-prem and cloud platforms.

Qualifications

• 5+ years of experience as SQL Developer/DBA
• Strong SQL Server development and admin skills
• Experience with legacy migrations to modern SQL Server environments
• Experience with on-prem and cloud data platforms
• Experience with ETL, data warehousing, and data modeling

Responsibilities

• Develop and maintain SQL Server objects (procedures, views, functions)
• Perform performance tuning, monitoring, backup/recovery, and security tasks
• Lead/participate in legacy migrations to modern SQL Server
• Design and implement cloud-based data warehouse to enable reporting and analytics
• Balance development and DBA duties with environment optimization

Skills

SQL Developer/DBA

SQL Server

T-SQL & Stored Procedures

ETL/Data Warehousing

Data Modeling

Performance Tuning

Backup & Recovery

Security

Migrations / Legacy Modernization

On-Prem SQL Server

Cloud Platforms (Azure/AWS/GCP)

Tools

Power BI

SSRS

DevOps / CI/CD

Deployment Automation

Always On / HA / Clustering

Job description

Insight Global in Chicago is seeking a seasoned SQL Developer/DBA for an on-site contract. The role blends database development and administration across two strategic initiatives: migrating legacy data to a modern SQL Server environment and designing a cloud-based data warehouse to enable scalable reporting and analytics.

The candidate will manage ETL, data modeling, and performance tuning while handling maintenance, security, and backup/recovery in both on-prem and cloud platforms.