Roles and Responsibilities
- Expert in SQL Server Database Administration, including SQL Server on VMWare (on premise), Azure SQL Database and Azure SQL Managed Instance, SQL Server Reporting Server (SSRS).
- Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
- Monitor database performance to ensure high levels of performance, availability, and security.
- Optimize and fine-tune databases for better query performance and scalability.
- Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
- Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
- Database and T-SQL optimization including performance tuning, query optimization, and supportability.
- DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure devops or Flyway tools.
- Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
- Create and maintain appropriate documentation about the database.
- Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
- Manage SQL server and Windows security audits and take corrective action to stay compliant.
- Provide support after hours through the on-call rotation and weekend support coverage.
- Perform scheduled maintenance and support release deployment activities after hours.
Experience and Qualifications
- 10+ years of strong SQL Server Database administration experience preferably in the asset management Industry.
- Knowledge of Azure cloud and 3+ years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
- 5+ years of experience with backups, restores and recovery models.
- 5+ years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
Experience and Qualifications
- 10+ years of strong SQL Server Database administration experience preferably in the asset management Industry.
- Knowledge of Azure cloud and 3+ years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
- 5+ years of experience with backups, restores and recovery models.
- 5+ years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
