Here at CarFinance 247 an exciting opportunity has arisen and we are recruiting for a Database Administrator to join our Data Team.
As the Database Administrator, you will work primarily with both on premise Microsoft SQL Server and Azure SQL Database. You will cover all areas of database administration, from backups, server configuration and integrity checking, through performance monitoring, alerting and tuning, to code reviews, schema design and ownership of the database CI pipeline.
Responsibilities Include:
- Performance Monitoring and Alerting:
- Ensuring that performance thresholds are maintained;
- Creating and maintaining alerting channels for critical issues (slack);
- Backups, High Availability & Integrity checks:
- Ensuring that the Carfinance 247 backup strategy is implemented and maintained;
- Ensuring that Availability Groups are healthy and performant;
- Performance Tuning:
- Provide advice and consultation to the development team to ensure production code is performant;
- Review indexing strategy and ensure that these are maintained;
- Security:
- Provide and monitor access to data based on a minimum rights best practise;
- CI and Code Reviews:
- Own and monitor the CI pipeline for SSDT based deployments;
- Perform code reviews in GIT for database schema and code changes;
- Research and development:
- Taking regular R&D days to keep abreast of the latest developments;
- Prototyping alternative solutions and new products.