Data Architect C2C requirements Alpharetta, GA

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