Data Architect C2C requirements Alpharetta, GA

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

Role: Data Architect

Location: Alpharetta, GA

Job Description: Database Optimization, Data Modeling, Database Consolidation, Oracle to SQL Server Migration, Client Problem Statement

The organization has multiple databases with performance, scalability, and maintenance challenges. They need an expert who can optimize existing Microsoft SQL Server databases, redesign data models where required, merge databases from different applications, and support migration from Oracle to SQL Server while minimizing business disruption.

What They Are Looking For

Database Optimization

• Query tuning and execution plan analysis
• Index optimization (clustered, non-clustered, filtered indexes)
• Statistics maintenance
• Partitioning strategies
• Performance bottleneck identification
• Deadlock analysis
• TempDB optimization
• Storage optimization
• SQL profiling and monitoring

Data Modeling

• Logical data model design
• Physical data model design
• ER modeling
• Normalization and denormalization
• Master Data Management (MDM)
• Canonical data modeling
• Data governance
• Database Consolidation

Database Consolidation

• Schema comparison
• Data mapping
• Duplicate entity resolution
• Common data model creation
• Data standardization
• Data quality assessment
• Cross-application relationship management

Oracle to SQL Server Migration

• Oracle schema assessment
• SQL dialect conversion
• PL/SQL to T-SQL conversion
• Stored procedure migration
• Trigger migration
• Function conversion
• Performance benchmarking
• Data validation and reconciliation

Skills Required

Technical Skills

• MS SQL Server
• Oracle Database
• T-SQL
• PL/SQL
• SSIS
• SSMS
• Azure SQL
• Data Modeling Tools (ERWin, ER Studio)
• Query Store
• SQL Profiler

Architecture Skills

• Data Architecture
• Database Modernization
• Data Governance
• Data Migration Strategy
• Performance Engineering