SQL Database Consultant
Ariel Partners · New York City, New York, US
Project Name: The Data Center Colocation and Migration Project TASKS & DUTIES: - Configure existing databases on SQL Server 2016/2019 to read-only mode to en...
Job description
Project Name: The Data Center Colocation and Migration Project TASKS & DUTIES: - Configure existing databases on SQL Server 2016/2019 to read-only mode to ensure data integrity during transition. - Perform full database backups on SQL Server 2016/2019. - Restore databases to the new SQL Server 2022 environment. - Bring SQL Server 2022 databases online and decommission legacy instances by setting prior versions offline. - Establish user accounts, permissions, jobs, and SSIS packages within SQL Server 2022. - Migrate reports and subscriptions from SSRS 2016 to SSRS 2022. - Engage report owners to reconfigure data source connections to align with the upgraded platform. - Coordinate with database owners to update existing jobs and packages to SQL Server 2022 compatibility. - Create and validate linked servers to ensure cross-platform functionality. - Facilitate comprehensive testing and verification by database owners to confirm operational readiness. REQUIRED SKILLS: If you are interested in getting more information about this opportunity, please contact Irina Rozenberg Recruiting@arielpartners.com at your earliest convenience. At Ariel Partners, we solve the most difficult problems t...