SQL Database Administrator (Azure).

As the DBA(Azure & SQL Server), you will work primarily with both on premise Microsoft SQL Server and Azure SQL Database. The role will Intel covering all areas of database administration, from server configuration, backups 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 backup strategy is implemented and maintained;
  • Ensuring that Availability Groups are healthy and performing;
• 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;
• Performance Tuning:
  • Provide advice and consultation to the development team to ensure production code is performing accordingly;
  • Review indexing strategy and ensure that these are maintained;
• Security:
  • Provide and monitor access to data based on a minimum rights best practise;

About The Candidate

Essential:

• T-SQL
• Backup and Restores;
• Security;
• Performance tuning and SQL Server internals;
• Azure

Desirable:

• Experience working with CI tools and source control (GIT);
• High Availability (Always On Groups);
• Powershell;
• VMWare & running SQL Server on virtual machines;
• Change Data Capture (CDC) experience

About The Company

• On-site Parking
• Free transport to and from Manchester Piccadilly station
• Excellent career progression
• Birthday off!
• On-site Gym

If this sounds like the role for you to apply for this opportunity please reply to this advert or email your CV