Data Architect: SQL Server Optimization & Migration

Tech Mirrors; Alpharetta (GA); On-site; USD 110,000 - 165,000; Full time

Job summary

Tech Mirrors in Alpharetta, GA is seeking a Data Architect to optimize SQL Server databases, redesign data models, and consolidate databases across applications.

You will lead Oracle to SQL Server migration efforts, implement robust data governance, and define migration strategies that minimize business disruption while maintaining data integrity.

The role requires deep experience with T-SQL, PL/SQL, SSIS, SSMS, Azure SQL, and data modeling tools such as ERWin or ER Studio.

Qualifications

• Must have deep experience with SQL Server and Oracle databases, strong data modeling and migration expertise.
• Proven ability to consolidate databases across applications and migrate from Oracle to SQL Server with minimal disruption.
• Experience with performance tuning, governance, and data quality in large enterprise environments.

Responsibilities

• Optimize existing Microsoft SQL Server databases for performance, scalability, and maintenance.
• Redesign data models and implement canonical data models where appropriate.
• Consolidate databases from multiple applications and standardize schemas.
• Lead Oracle to SQL Server migration efforts, including schema and code conversion, testing and validation.
• Establish data governance and quality practices across platforms.

Skills

MS SQL Server

Oracle Database

T-SQL

PL/SQL

SSIS

Azure SQL

Data Modeling

Data Governance

Performance Engineering

Migration Planning

Tools

ERWin

ER Studio

SQL Profiler

SSMS

Job description

Tech Mirrors in Alpharetta, GA is seeking a Data Architect to optimize SQL Server databases, redesign data models, and consolidate databases across applications.

You will lead Oracle to SQL Server migration efforts, implement robust data governance, and define migration strategies that minimize business disruption while maintaining data integrity.

The role requires deep experience with T-SQL, PL/SQL, SSIS, SSMS, Azure SQL, and data modeling tools such as ERWin or ER Studio.