Job No 15258
Microsoft SQL Administrator / MySQL Administrator
Contract: 6 month rolling contract
Start Date: ASAP
Location: Remote – Work from home and / or office based with occasional international travel
We are looking for well-rounded Technologist with good MSSQL and MySQL DBA Experience. Other additional technical areas a bonus
This is an exciting opportunity to join our growing organization to face off to our client(s) based in Switzerland.
The chosen candidate will be responsible for the day-to-day administration and support of the clients Microsoft SQL and MySQL Database Farms.
The ideal candidate needs to be a self-starter and able to work from home or an office environment, with the acute discipline to be focused and available to support our clients during core business hours and where required, after hours. After hours’ support for Incident resolution and implementation of changes is also required.
To be considered for the role, you will need to demonstrate a good understanding of the following skills and / or attributes: (in short, be a well-rounded Technologist with Microsoft SQL Database Administrator and MySQL)
· Good English (spoken / written
· French a plus (but not required)
· Good ability to work on your own or as a team
· 3+ year’s experience working as a SQL Server 2012/2014 DBA.
· Certification in either Microsoft SQL DBA 2012 and / or 2014
· MySQL Setup and Administration
· Database design concepts
· Technologies that make up the ecosystem that a Database would reside – i.e. networks, storage, o/s, backups and monitoring systems
· Installation and configuration of new SQL instances in 2012 and 2014
· Installation and configuration of Active, Active MariaDB instances
· Integration of MariaDB with WordPress – optional.
· Database migration methods from legacy SQL instances to newer SQL instances
· Database migration methods from Microsoft SQL to MySQL and visa-versa.
· Troubleshooting experience pertaining to Database Performance and / or Database Stability
· Non Functional Requirements – RTO and RPO (Recovery Time Objective and Recovery Point Objectives)
· Database Clustering (HA and DR)
· Data warehousing
· Writing TSQL proficiently
· BI Workloads
· Managing Database Backups
· Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
· Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
· Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
· Configure SQL Server monitoring utilities to minimize false alarms
· As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
· Deploy database change scripts provided by third party vendors
· When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
· Document the company’s database environment