Our Dublin based client are looking for a
SQL Server Specialist
to join their team in a new daily rate contract position
Looking for a person who has strong skills on upgrading and migration of data with a high level of SQL knowledge
This position is an initial 6 month contract with views to extend beyond that
This role involves the upgrade of existing SQL Server infrastructure along with designing and implementing high availability architectures for both SQL servers and data gateways in a complex and significant production environment
Responsibilities
* Leading on end-to-end SQL Server upgrade projects
* Leading on assessment all the way to production cutover
* Assessment of the current SQL Server environment and document all dependencies
* Designing of high level architecture for SQL Server environments based on business requirements
* Design excellent and high level solutions for data gateway infrastructure
* Develop migration plans with risk strategies and rollback procedures
* Configure new SQL Server environments with Always On Availability Groups
* Configure SSISDB within AG to include for encryption key management
* Migration of large databases with minimal downtime using appropriate synchronization methods
* Migrate and test SSIS packages, including those with PowerShell scripts and SFTP integrations
* Upgrade and configure data gateway servers for high availability
* Coordinate connection updates across Logic Apps, applications, and data feeds
Experience required
* SQL Server Major Version Upgrades
* Lead on production upgrades across major SQL Server versions (2012/2014/2016 to 2019/2022 or similar)
* Designed and implement high availability solutions for SQL Server from the ground up
* Be capable of being part of Architecture decisions
* Configuring SSISDB for use in Availability Groups
* Complex Migration Planning
* Create migration strategies that minimize downtime
* SQL Agent Job Management - Synchronized and managed Agent jobs across AG replicas
* SSIS Package Migration across SQL Server versions
* Experience working with mission-critical databases supporting multiple applications and integrations
HOW TO APPLY:
To apply for this role, please submit your updated CV. If your skills and experience match job requirements, you will be contacted to discuss your application in detail.
SIMILAR ROLES OPEN:
As a specialized recruitment agency, we also have several other permanent and contract IT roles available. Visit our website for more information or explore additional opportunities