Database Administrator (MSSQL DBA)

Digital Business Automation function within CTO Infrastructure are seeking an experienced and dynamic individual to join our team as an MSSQL Database Administrator (DBA). In this role, you will be responsible for project delivery related to Database and Operating System migration for one of the Banks middleware application. The ideal candidate should possess strong database skills, in-depth knowledge of database migrations, and a proven track record of successful project delivery.

What you’ll do

• Build new MSSQL infrastructure and test and migrate the data from old infrastructure to new
• Prepare the pre-implementation plan for both non-production and production migration, including a plan of implementation, post-implementation verification and backout
• Help to optimize the database performance before the production go-live
• Help to ensure end-to-end testing of the underlying middleware (in collaboration with application SME) to ensure no data loss and good application performance
• Maintain documentation on migration strategies, rollback plans, and best practices
• Ensure compliance with security and regulatory requirements
• Automate migration tasks using PowerShell, SQL scripts, and third-party tools where applicable

What you need to have to succeed in this role

• Strong expertise with Microsoft SQL Server 2016 and 2019
• Experience migrating between MSSQL database versions
• Ability to create testing, implementation, verification and rollback plans and writing documentation and procedures
• Proven ability to provision, configure, manage and troubleshoot on-prem instances of MS SQL in High-Availability setup
• Proficiency in PowerShell, SQL and Windows Server 2016 and Windows Server 2019
• Solid understanding of monitoring and optimizing database performance
• Willingness to work with closed-source 3rd party product
• Familiarity with middleware technology (IBM Liberty or WAS) is a plus