Contract role
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
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
To apply for this job email your details to yogesh@reveilletechnologies.com