Senior SQL Server DBA

Job Description: Senior Database Administrator (SQL Server)

Role Overview: My Client are a financial services and technology company that specializes in providing solutions to empower businesses and merchants. They offer a range of services and products tailored to enhance payment processing, financial management, and business operations. Their focus is on enabling businesses to thrive in the rapidly evolving digital landscape, offering innovative tools and solutions to drive growth and success.

Key Responsibilities:

1. Collaborate on logical/physical database design with engineering teams, ensuring current data models.
2. Design and develop schema, indexes, SQL queries, and stored procedures.
3. Maintain database specifications, data dictionary, and coding standards.
4. Perform problem resolution, root cause analysis, and preventive measures.
5. Analyze SQL query plans, diagnose performance bottlenecks, and take corrective actions.
6. Evaluate and implement system upgrades and enhancements as necessary.
7. Build HA and DR systems using advanced clustering and replication techniques.
8. Ensure 99.999% uptime for all OLTP production databases.
9. Assist in reviewing and preparing database deployments with Engineering teams.
10. Manage backups to meet business Recovery Point Objectives (RPO).
11. Conduct backup tests to ensure compliance with Recovery Time Objectives (RTO).
12. Gain deep insights into business processes facilitated by our software products.
13. Stay updated on industry best practices, services, and supporting tools.
14. Provide hands-on design, development, and code reviews.
15. Demonstrate expertise in SQL Server architecture, including engine, query processing, optimization, and locking.
16. Collaborate effectively within the team and provide after-hours support when required.

Qualifications:

• Bachelor's Degree or equivalent work experience.
• 7+ years of SQL Engineering/Administration experience, with a strong focus on SQL Server 2012+.
• Extensive experience supporting 24x7 OLTP and data warehouse/BI environments.
• Profound knowledge of SQL Server architecture, including engine, query processing, optimization, and locking.
• Experience automating database-related processes and alerts.
• Proficiency in configuring MS SQL for high availability and Disaster Recovery using SQL Clustering and Always On Availability Groups.
• Familiarity with scripting languages (e.g., PowerShell, VBScript, T-SQL).
• Knowledge of storage systems.
• Understanding of SQL replication technologies is desirable.
• Some experience with security and encryption is preferred.
• MCSA/MCSE certification is a plus.
• Excellent oral and written communication skills.

Offered Benefits:

• Flexible paid holiday policy.
• Company bonus.
• Private Medical Insurance for the employee.
• Life Assurance (4x salary).
• Income Protection (75% of salary until state retirement age).
• Work From Home allowance (£60/month with £26 tax-free per HMRC rules).
• One-time Home Office setup allowance (£500).
• Pension Contributions (5% employer contributions).
• Co-working space day or month passes if you prefer working with others.

If you are interested in hearing about this Data role or any other oppourtnity please do reach out to Rachel Boyle on 028 90330250