In order to cultivate relationships and promote team spirit, we require your presence in the office for a minimum of 8 days per month.
Responsibilities :
- Installing, tuning and upgrading RDBMS infrastructures
- Proactively and regularly making recommendations for database improvements (policies, procedures & standards)
- Monitoring system performance and identifying problems that arise
- Responding in a timely manner to user-reported errors
- Protecting the database against threats or unauthorized access by establishing and maintaining security and integrity controls
- Ensuring that the database is adequately backed up and able to be recovered in the event of disaster
- Reporting on metrics regarding usage and performance
- Suggesting changes and improvements for database maintenance, performance, reliability and protection
- Regularly liaising with IT project teams including database programmers
Requirements :
5+ years of experience with Database Administration for MSSQL Server (2016-)Analytical mindset in troubleshooting and resolving database problemsGood understanding of Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting toolsExperience with backups, restores and recovery modelsKnowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL ServerExpertise in SQL languageExperience in implementing operational automation using scripts such as : PowerShell, Ansible playbooksExperience with Windows servers, including Active Directory and disk configurationsCritical thinking and problem-solving skillsGood communication skillsBeing a team playerBeing highly organized with a sense of ownershipNice to have :
Experience with MS SQL Server Always ONExperience with MS Azure SQL databasesExperience with Desired State Configuration and DBAtoolsExperience with ServiceNow & Azure DevOpsExperience with Ansible playbooksExperience with other database systems like Oracle, PostgreSQL & MongoDB will be considered as an assetMicrosoft SQL Server certificationsLI-DL1