SQL Server Upgrade Specialist
We are seeking an experienced SQL Server professional to lead a critical infrastructure upgrade project.
* Key Responsibilities:
* Lead end-to-end SQL Server upgrade project from assessment through to production cutover, ensuring seamless migration of databases and applications.
* Assess the current SQL Server environment, documenting dependencies, including integrations, data feeds, and applications.
* Design high availability architecture for SQL Server based on business requirements, balancing RPO/RTO with complexity.
* Develop detailed migration plans, incorporating risk mitigation and rollback strategies to minimize downtime.
* Provision and configure new SQL Server environment with Always On Availability Groups, ensuring synchronized replication across replicas.
* Migrate databases using synchronization methods that meet minimal downtime requirements.
* Configure and synchronize SQL Agent jobs across AG replicas, utilizing role-based execution logic.
* Upgrade and configure data gateway servers for high availability, ensuring continuous data flow.
* Coordinate connection string updates across dependent applications and integrations, ensuring uninterrupted service.
* Conduct comprehensive failover testing and validation, ensuring system resilience.
* Provide technical leadership and communicate progress to key stakeholders, fostering transparency and collaboration.
* Produce operational documentation, including architecture diagrams, runbooks, and troubleshooting guides, facilitating knowledge sharing.