On Premise Data Architect / Database Migration Engineer

Data Architect / Database Migration Engineer – Data Center Migration 

About the Role 

As a Data Architect / Database Migration Engineer, you will be a hands-on technical contributor responsible for database architecture, migration execution, data integrity, performance, security, and operational readiness as business-critical applications move from a legacy on-premises data center to a new on-premises data center. 

This project is primarily a data center relocation and infrastructure migration with minimal application refactoring. However, the move creates an opportunity to improve database documentation, performance, backup and recovery practices, monitoring, operational processes, and selected areas of technical debt without creating unnecessary modernization scope. 

What You'll Do 

• Assess current-state SQL Server databases, schemas, stored procedures, indexes, jobs, integrations, dependencies, data movement patterns, backup/recovery procedures, and operational runbooks. 

• Design target-state database architecture for the new data center, including configuration, connectivity, security, high availability, replication, monitoring, and supportability requirements. 

• Plan and execute database migration activities including discovery, dependency mapping, migration sequencing, backup/restore, replication, validation, reconciliation, cutover, rollback, and stabilization. 

• Develop SQL scripts, stored procedure updates, validation routines, reconciliation queries, automation scripts, and migration documentation. 

• Partner with application developers, QA, infrastructure, security, monitoring, and operations teams to ensure database readiness and application compatibility. 

• Use Jira for migration tasks, defects, documentation, traceability, and status reporting; use ServiceNow for change and operational workflows. 

Required Qualifications 

• 8+ years of hands-on database engineering, data architecture, or database migration experience. 

• Deep expertise with Microsoft SQL Server, SQL Server databases, SQL stored procedures, T-SQL, query tuning, indexing, schema design, and SQL programming. 

• Demonstrated experience migrating databases as part of data center relocation, infrastructure transition, or enterprise application migration projects. 

• Experience with data validation, reconciliation, backup/recovery, rollback planning, performance tuning, and production support. 

• Experience with database dependencies across applications, batch jobs, reporting, APIs, integrations, and operational processes. 

• Experience using Jira and ServiceNow in structured delivery and change management environments. 

Preferred Qualifications 

• Experience in fintech, payments, banking, accounting, or regulated environments. 

• Experience with VMware-hosted SQL Server environments and Microsoft Windows Server platforms. 

• Experience with Splunk, Dynatrace, or Moogsoft for database and application observability. 

• Experience with PowerBuilder, VB6, .NET, Java, VBS macros, and database-heavy legacy applications. 

Core Technology Environment 

• Microsoft Windows Server / Microsoft OS environments 

• Microsoft SQL Server and SQL Server databases 

• VMware vCenter and enterprise virtualization 

• Jira for Agile delivery, backlog, defects, traceability, and reporting 

• ServiceNow for change, incident, problem, and operational workflows 

• Splunk, Dynatrace, and Moogsoft for observability, monitoring, alerting, and event correlation 

• .NET, C#, VB.NET, Java, PowerBuilder, VB6, VBS macros 

• SQL stored procedures, T-SQL, and deep SQL programming practices 

Success in the First 12 Months 

• Deliver reliable database migration plans and execution patterns for core application workloads. 

• Establish repeatable validation, reconciliation, rollback, and stabilization processes. 

• Improve SQL Server performance, reliability, documentation, monitoring, and operational supportability. 

• Reduce migration risk through strong dependency analysis and data integrity controls. 

• Become the trusted authority for database readiness and migration execution. 

Ideal Candidate 

A hands-on data architect and database migration engineer with deep SQL Server and SQL programming expertise who can safely move complex enterprise databases between on-premises data centers while improving performance, integrity, documentation, and operational resilience. 

Work Authorization 

• Applicants must currently possess valid and unrestricted authorization to work in the United States without current or future sponsorship requirements.