Job Description
Job Description
Responsibilities
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.
Required Qualifications
- 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
Numbers & Facts
| Location | NULL, PA (Remote) |
| Industry | Staffing/Employment Agencies |
| Salary | $106,000–$124,000 |
| Company Size | 50 to 99 employees |
| Year Founded | 2017 |
| Website | http://www.prismagicinc.com |
About Company
Prismagic started with an idea of connecting people with 'people', connecting the 'need' to 'accomplishments' and connecting the 'jobs' to 'lifestyle'. At Prismagic, we would like to partner with talent, we call consultants to understand their expertise and how we can best fit that in the growth engine of any corporate, we call client to create a win-win ecosystem for everyone.
With over 30 years of combined expeirence of the key stakeholders in Staffing, Services and Information Technology, Prismagic is a platform built to complement the need of its clients with the potential of its consultants.
We bring an energized team, a fresh perspective and the zeal to exceed the expectations of our partners every time we are entrusted to perform. Our rewards and recognitions today is only the delight that we can bring for our stakeholders through a committed workforce and an honest, transparent, value driven system.
PRISMAGIC (Not just a name, but a philosophy)
We always believed that businesses need to create magic for its stakeholders – the magic of solutions, the magic of trust and the magic of value – and whatever problem we could think of, the final solution is always People. Every problem always starts at design but invariably ends at People and each solution brought us to the fact, “People Relations IS MAGIC” – Process Reinforcement IS MAGIC – “PR-IS-MAGIC” - and We got our name. It is not just a name but a philosophy that every employee believes, trusts and run on.
For more details, please visit http://www.prismagicinc.com/
Skills
- Application Hostingunmatched
- Authenticationunmatched
- Data Qualityunmatched
- Data Recoveryunmatched
- DataArchitect Data Modeling Toolunmatched
- Documentationunmatched
- Healthcareunmatched
- Identify Issuesunmatched
- Knowledge Transferunmatched
- Master Data Management (MDM)unmatched
- Microsoft .NETunmatched
- Microsoft IIS Web Server (Internet Information Services)unmatched
- Microsoft SQL Serverunmatched
- Microsoft SQL Server DBA (Database Administration)unmatched
- Microsoft Windows Operating Systemunmatched
- Migration Strategyunmatched
- Oracleunmatched
- Performance Tuning/Optimizationunmatched
- SQL (Structured Query Language)unmatched
- SQL Server Reporting Services (SSRS)unmatched
- Security Architectureunmatched
- Server Architectureunmatched
- Systems Administration/Managementunmatched
- Technical Analysisunmatched
- Technical Supportunmatched
- Technical Writingunmatched
- Testingunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder