Senior SQL DBA

My client are Tech Disruptors in their space, working with a team of over 80 engineers in NI, my client run a Remote First business here. This innovative and forward thinking company are proving to be a real Tech Disruptor globally. A novel and interesting option for retailers globally.

As a Senior Database Administrator, you'll work closely with the Database Administration Manager to help strengthen the DBA team as a centre of excellence. You will help build upon the existing foundations by maintaining the databases' performance, integrity, and security. It is an exciting opportunity to get involved in the early stages of team development and contribute towards its success. My client are seeking an experienced, self-motivated SQL Server DBA to focus on database design, development, and administration.
The individual will work closely with Engineering and Technical Operations teams to build/deploy scalable and highly efficient implementations in our 24x7 environment.

Deploying to a real-time transaction processing environment, the ideal candidate will apply a solid understanding of database design principles, indexing design strategies, and strong SQL development skills.

Also, that candidate is expected to be a self-starter who can operate well under various situations and types of projects, ranging from a team of one to a team of many.

Duties and Responsibilities

• Work with engineering teams on logical/physical database design to support new and existing application development. Maintain data models and keep them current.
• Design and develop schema, indexes, SQL queries, and stored procedures.
• Maintain database specifications, data dictionary, design/coding standards, and complementary documentation.
• Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques.
• Analyse SQL query plans and leverage diagnostic tools to identify performance bottlenecks and take appropriate corrective actions to remediate.
• Evaluate the merits/ benefits of available system upgrades and enhancements - implement as necessary.
• Build HA and DR systems using Failover Clustered instances, Availability Groups, Multi-site clusters, and Replication across geo-diverse data centre's.
• Commit to achieving 5 9's up-time of all OLTP production databases.
• Work with Engineering teams and Technical Operations in reviewing and preparing database deployments.
• Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO).
• Develop in-depth knowledge of business processes facilitated by our software products.
• Keep abreast of industry best practices, services, and supporting tooling.
• Provide hands-on design, development, and code reviews.
• In-depth knowledge of SQL Server architecture - engine, query processing, query optimisation, locking etc.
• Work as part of a team and provide after-hours support when required.

Qualifications

• Bachelor's Degree or equivalent work experience.
• 5+ years of SQL Engineering / Administration, in-depth experience with SQL Server 2012+.
• Strong knowledge of SQL Server architecture - engine, query processing, query optimisation, locking etc.
• Experience automating the execution and notification of database-related processes and alerts.
• Experience configuring MS SQL for high availability and Disaster Recovery using SQL Clustering and Always On Availability Groups.
• Knowledge of scripting languages, e.g. PowerShell and T-SQL.
• Possess some experience with security and encryption.
• Attentive to detail with a relentless focus on accuracy.
• Team player who works hard and plays hard.
• Excellent oral and written communication skills.

For further information on this vacancy, or any other job in Belfast or wider Northern Ireland, please apply via the link below or contact Ryan Quinn in the strictest confidence.
Follow VANRATH on LinkedIn for:
Expert Career Advice. The Latest Top Jobs. Industry News. And much more…