What are the responsibilities and job description for the SQL Database Consultant position at Ket Software?
Title: SQL Database Consultant
Location : Brooklyn, NY
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.