Job Title: SQL Server Professional
We are seeking an experienced and skilled SQL Server developer to lead a critical infrastructure upgrade project.
The role requires proven expertise in SQL Server upgrades, high availability (HA) architecture design, and managing complex migrations with minimal downtime.
* Lead end-to-end SQL Server upgrade project from assessment through to production cutover
* Assess the current SQL Server environment and document all dependencies (applications, integrations, data feeds)
* Design HA architecture for SQL Server based on business requirements (RPO/RTO, complexity)
* Develop detailed migration plans with risk mitigation and rollback strategies
* Migrate databases with minimal downtime using appropriate synchronization methods
* Configure SSISDB within Always On Availability Groups (AGs), including encryption key management across replicas
* Upgrade and configure data gateway servers for high availability
* Coordinate connection string updates across dependent applications and integrations
* Conduct comprehensive failover testing and validation
Key Responsibilities:
* Provide technical leadership and communicate progress to key stakeholders
* Produce operational documentation, including architecture diagrams, runbooks, and troubleshooting guides
* Provide post-migration support and knowledge transfer