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
Data Architect C2C requirements Alpharetta, GA in alpharetta at Unknown Company
This position is listed as full time and onsite.