TELECOMMUTE Data Architect

Prismagic Solutions Inc
United States
14 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

.NET Framework Microsoft Windows User Authentication Cyber Security Databases Data Validation Data Governance Data Integration Database Connection Internet Information Services (IIS) Microsoft SQL Server Oracle (Applications)
+8 more
Performance Tuning Server Administration SQL Databases SQL Server Reporting Services Technical Debt Database Migration Data Management Network Server

Job description

Provides senior hands-on technical expertise supporting the assessment, planning, design, migration, validation, and stabilization of MHS’s SQL Server environment. Responsible for target-state architecture, database migration strategy and execution, data validation, performance considerations, security architecture, reporting migration, integration dependencies, and technical troubleshooting.

Supports migration of databases and associated dependencies, including SSRS reporting, Linked Servers, IIS-hosted application connectivity, authentication configurations, and external integrations. Participates in testing, cutover, rollback readiness, production validation, and post-migration stabilization.

Assesses technical debt and contributes recommendations for database organization, standardization, maintainability, documentation, and future-state architecture during roadmap development.

Requirements

  • SQL Server architecture, administration, upgrade, and migration
  • Hands-on database migration and modernization
  • SQL Server Reporting Services (SSRS) migration and validation
  • Linked Server configuration and migration
  • Application/database connectivity and dependency analysis
  • Performance tuning and optimization
  • Data integration architecture
  • Windows and SQL authentication and security configuration
  • Backup, recovery, rollback, and migration validation
  • Production cutover and post-migration troubleshooting
  • Technical documentation and knowledge transfer

Preferred Skills

  • SQL Server 2025 migration experience
  • IIS-hosted and custom .NET application environments
  • Oracle and interface-engine integrations
  • Master Data Management (MDM)
  • Data governance initiatives
  • Healthcare, education, or other regulated environments
  • Experience modernizing legacy SQL Server environments

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · World Congress 2024

3:50 min

Queues in TCP stacks and continuous network connections

Clemens Vasters Clemens Vasters · World Congress 2022

4:45 min

Building careers inside distributed technology consulting environments

Oliver Zimmert · LIVE

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all