Oracle Database Administrator (hybrid or remote)

• About Us

   

  The world isn’t standing still, and neither is Allstate. We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs. That’s why now is an exciting time to join our team. You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.

   

  You’ll do all this in an environment of excellence and the highest ethical standards – a place where values such as integrity, inclusive diversity and accountability are paramount. We empower every employee to lead, drive change and give back where they work and live. Our people are our greatest strength, and we work as one team in service of our customers and communities.

   

  Allstate operate a very flexible hybrid working policy that will allow you to design your working week in collaboration with your manager with a blend of remote and office working for NI based employees as well as condensed working patterns (4 day week/9 day fortnight). Employees based in GB will be employed on a permanent remote working contract.

   

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

   

  Your role in the team

   

  This is a Database Administrator (DBA) role within the Data & Intelligent Systems (D&IS) area. 

  The DBA designs, documents, provides guidance, and supports database infrastructure solutions to fulfill business or technology requirements.

  They perform activities aimed at improving database performance and efficiency. They also provide trending data on and makes recommendations for performance issues for application and database environments, ensuring stability, and providing evaluation of new or changed products.

    

  • Reviews and approves data modeling processes and DBMS specific requirements for basic and intermediate application database requirements
  • Leads logical data modeling processes for complex applications database requirements and converts logical data models into physical data models for complex application databases
  • Directs root cause analysis on complex incidents and leads the problem management discussions related to incidents
  • Coordinates the use of DMBS vendors and others to assist in the analysis and resolution of database problems/issues
  • Supervises database creation activities of the DBA team
  • Installs/configures complex databases for applications. CRS/ASM
  • Leads peer reviews and identify infrastructure-wide impact/exposure of patching and configuration changes.
  • Create and document installation procedures and provides guidance for, and defines database configuration standards
  • Provides complex database maintenance services to application development teams
  • Develops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to management
  • Directs and define backup and recovery requirements and resumption strategies based on characteristics of the data, operational environment, and Recovery Time Objectives/Recovery Point Objectives
  • Acts as client advocate, ensuring smooth implementation into application architecture and database standards
  • Analyzes trending data and provide performance recommendations addressing specific application/system performance issues
  • Facilitates database testing efforts and work with subject matter experts to create implementation/migration plan with executable documentation
  • Authors complex scripts and tutors other DBA’s in scripting skill and usage and designs, codes and implements local facilities to support the DBMS environment 
  • Maintains understanding of the database software industry and provides future solutions, manage research activities; design and document standards and understands new technology and communications with applications along applicability to the environment 
  • Review product test results and recommend database/technology solutions to improve overall database environment
  • Mentor more junior Database Administrators on complex topics
  • Tunes intermediate sequel, makes performance recommendations on subsystem parameters and leads discussions on tuning efforts with applications and infrastructure groups.  Ensures these solutions are in alignment with enterprise strategy  

   

   

  So, what are the essential criteria to apply?

   

  • All candidates must evidence an existing right to work in the UK
  • Experience with Oracle
  • Experience with Linux
  • 5+ years in database management, testing, scripting, or configuration

   

  We also have some desirable criteria

   

  • Experience with Exadata
  • Experience with data warehouse design

    

   

  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.

   

  Apply here: https://bit.ly/3Km2jsv 

   

  The closing date for receipt of applications is Monday 31^st January 2022