Job Title: Infrastructure Architect
Location: Ireland
Employment Type: Contract
Duration: 6 months
Start Date: January 2026
Role Overview
The Infrastructure Architect will be responsible for designing and documenting a highly available Microsoft SQL Server 2022 environment, including clustered database infrastructure and disaster recovery capabilities. The role will also include providing technical leadership and planning support for the migration of existing SQL Server 2014 databases to the new platform, ensuring effective execution with minimal downtime and maximum performance.
Key Responsibilities
Architecture & Design
1. Design and document a robust SQL Server 2022 Highly Available (HA) clustered architecture, incorporating technologies such as Always On Availability Groups and Failover Clustering.
2. Define infrastructure requirements across compute, storage, and networking to ensure performance, scalability, and resilience.
3. Establish security, compliance, maintenance, and backup standards in alignment with organisational policies.
Migration Planning & Execution
4. Assess the existing SQL Server 2014 environment, including application dependencies and operational constraints.
5. Create detailed migration plans including testing phases, risk assessments, and rollback strategies.
6. Execute database migrations ensuring data accuracy, integrity, and minimal service disruption.
Technical Consulting
7. Act as a subject matter expert, advising stakeholders on SQL Server technologies, performance optimisation, and high availability/disaster recovery best practices.
8. Work closely with application teams to validate compatibility and support post-migration performance and query optimisation.
Documentation
9. Produce clear architecture diagrams, installation/configuration guides, and operational documentation.
10. Maintain detailed technical documents throughout the project lifecycle including migration learnings and runbooks.
Required Skills & Experience
Technical Expertise
11. Demonstrated experience architecting and implementing SQL Server HA solutions, ideally with SQL Server 2019/2022.
12. Strong understanding of Always On Availability Groups, Windows Server Failover Clustering, and associated replication technologies.
13. Experience planning and executing database migrations using recognised tools ( Data Migration Assistant, SSIS).
14. Skilled in performance tuning, indexing strategies, troubleshooting, and query optimisation.
Infrastructure Knowledge
15. Familiarity with enterprise virtualisation platforms ( VMware, Hyper-V).
16. Understanding of cloud environments such as Azure or AWS.
17. Strong appreciation of networking, storage, and security within enterprise infrastructure environments.
Soft Skills
18. Excellent communication and documentation skills.
19. Strong analytical, troubleshooting, and problem-solving capabilities.
20. Ability to work collaboratively with cross-functional teams and stakeholders.
Preferred Qualifications
21. Microsoft Certified: Azure Database Administrator Associate or equivalent.
22. Experience with hybrid cloud SQL deployments.
23. Knowledge of PowerShell for automation and scripting.
About Korn Ferry