Lead SQL Server Database Engineer

Date Opened: Nov 21, 2020

Location: Belfast, GB Derry/ Londonderry, GB

Company: Allstate Insurance Company

 

About Us

 

At Allstate Northern Ireland, we believe it’s more than just a job.  We believe in allowing our people to choose the direction of their careers.  It’s about you, your future and where you want to get to.

 

Opportunity is the hallmark of the Allstate career experience.  We invest heavily in our employees, offering long term career development, personal growth and investment in new technologies.  Every day is different, with new ideas, challenges, and rewards — no matter which team you join.

 

We believe that inclusive diversity is crucial to creating a culture of mutual respect where the strengths and talents of each individual are recognised.  We like to leave things better than we found them and deliver results.  We do all of this while having fun and exploring personal passions.

 

Join our team and you’ll find challenge and reward in a culture of innovation, support and balance.

 

 

Your role in the team

 

As our Lead SQL Server Database Engineer, you’ll help us on delivering project management, strategic direction, performance, reliability, and scalability of the organization’s current MS SQL Server database environments as well as the design, construction, and population of our new technology database schemas/environments.

 

From a day-to-day perspective the DBA is responsible to drive efforts to implement and/or refine operational and business continuity processes such as replication, availability groups, mirroring, backups and high availability.  Project assignments as assigned by Manager. Additionally, will be tasked with supporting our production and development MS SQL Server databases and ensuring their performance, availability, recovery security and utilization.

 

We are focused on developing our platform, so this is where you come in. Participating proactively in daily stand-up meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements, collaborate with vendors and internal team in the assessment of new technologies and their operationalization. We want you to be innovative in researching emerging trends and new technologies to identify potential improvements; develop business case justifications and cost/benefit analyses for IT database related spending and initiatives. You will partner with others in their organization to set and manage expectations; continually seeks opportunities to be a thought partner and increase internal business partner satisfaction and deepen relationships.

 

Here at Allstate, we’re passionate about letting you develop your career and ss our lead expert, you will be responsible for leading a team of SQL Server DBA professionals, providing leadership in design, architecting, maintaining, securing and providing on-call support for HA database systems (On-Prem and Cloud), as well as provide leadership in creating roadmaps and future state architecture of SQL Server platform collaborating with stake holders and business partners.

 

 

So, what are the essential criteria to apply?

 

  • All candidates must be able to demonstrate their right to work in the UK
  • 5+ years of experience in MSSQL Server in an enterprise level environment managing large-scale, complex database environments supporting complex/critical applications
  • Proven experience in MS HA and DR solutions such as WSFC, Always on Availability groups, Mirroring, Log shipping
  • Strong TSQL and PowerShell or Python/Shell scripting knowledge with ability to diagnose, develop and troubleshoot scripts.
  • Lead level expertise in MSSQL database platform
  • Knowledge of virtualized infrastructure (for example VMWare, AWS, Azure) 
  • Knowledge of database administration tasks such as backups, database recovery, security, high availability and Disaster Recovery architecture working with SQL 2012-2017 environments 
  • Proven ability to lead a technical team

 

 

 

We also have some desirable criteria

 

  • MS Certification
  • Certified in Cloud technology (AWS/AZURE)
  • Knowledge of Oracle, MySQL or MongoDB
  • Knowledge of ITIL framework processes such as Incident, Change, Problem, Service Request Management
  • Knowledge of cloud computing architecture/design/best practices

 

 

 

What we offer

 

As Digital DNA’s Workplace of the Year 2020 winners, we offer a generous benefits package that includes flexible annual leave entitlement, dental and healthcare insurance, an attractive pension package and discounts on gym memberships, public transport and parking.

 

Allstate invests heavily in your development, as an employee you will have access to multiple world-class learning platforms and courses from our award-winning in-house Learning & Development team.

 

We pride ourselves in providing clear career paths and opportunities for internal mobility allowing you to further develop within the organisation.

 

We encourage a better work life balance and you’ll have the opportunity to apply for various flexible working arrangements.

 

 

 

Statement on Fair Employment and Equal Opportunities

 

Allstate NI wishes to ensure equal opportunity is given to all job applicants.  This company will not discriminate on the grounds of race, gender (including gender reassignment status), sexual orientation, religious belief, political opinion, marital status, age or disability.

 

We are an equal opportunities employer. We welcome applications from all suitably qualified persons. However, as women are currently under-represented in our workforce, we would particularly welcome applications from women. All appointments will be made on merit.

 

Applicants should note Allstate NI complete AccessNI background checks on all candidates offered a position.

 

 

The closing date for receipt of applications is Friday 4th December 2020