menu

close

close

Start your search

Oracle and SQL Server DBA

Cardiff

  1. Full time

Closing date

20/04/2021

About the job

 

Job Purpose

As a member of the DBA Service Teams you will be required to provide an ongoing wrap around service from Design, Build, Run, Maintain and Retire of a large enterprise Oracle and SQL Server database estate, and working across all IT departments, and key areas of the business.

The purpose is to support and manage database availability and ongoing maintenance by providing production support in and out of hours.  To play an active role in the creation of new Oracle and SQL Databases across the entire Admiral estate through integration with Delivery teams and an Agile Framework.

To assist in the design, delivery and ongoing maintenance of technology environments that meets and/or exceeds requirements as part of an exciting and critical programme of work, spanning across all Non-production and Production Environments.

 

Main Duties

The main duty of this role is to work across all areas of IT and Security to ensure new products and technologies are integrated/configured/optimised in line with IT architectural principles, policies and best practice relating to new and existing environments within the Admiral Technology estate. You will be working with all roles within IT to ensure this occurs in a controlled and timely manner.

In addition to this you will also proactively manage and address any risk issues relating to your assigned duties. You will be expected to complete your duties whilst conforming to any project timelines or service level agreements that are in place.

Other duties include:

  • Provide production support and apply CSI to the technology stack in order to maintain availability
  • Manage capacity and make recommendations for ensuring there is sufficient capacity available
  • Manage performance and make recommendations for improvements and optimisation
  • Undertake performance tuning tasks
  • Work to ensure all security recommendations are applied and in place across the Database estate
  • Configure and maintain enterprise technology environments
  • Support and manage Cloud based Databases/Instances
  • Respond in a timely manner to action tickets from both Service Desk and Jira queues
  • Recommending standards for best practise
  • Provide timely and accurate estimates for assigned tasks
  • Provide technical support to Application Development teams
  • Diligently share knowledge with others
  • As part of a team you will provide Technical Support to other teams, where appropriate
  • Maintain a good working relationship with customers and technical partners including Service and Delivery Teams
  • Produce or contribute to detailed documentation for existing or new configurations

This is not a full definition of the role but covers the main aspects and drivers for success.

 

Behavioural Competencies

Decision Making

  • Ensure decisions are objectively justified
  • Understanding of the impact of decisions for the team and the business
  • Confidence in making the right decision, and not necessarily the easy one

Communication

  • Ensure that all communication is clear and appropriate for its intended audience
  • Able to communicate with employee’s of all levels including management

Team Work

  • Readily be available to help support the team within a shift pattern covering 8am-6pm and be available for out of hours support as and when required

Dedication

  • Show passion for your work and a commitment to succeed
  • Proactively seeking to improve knowledge

Solutions Driven

  • Focus on providing solutions to problems
  • Focus on solving problems using a systematic and analytical approach.

Challenging

  • Be prepared to challenge the status quo and make suggestions for areas of quality improvement.
  • Be willing to voice an opinion on all matters whilst being receptive to feedback

 

Experience and Qualifications Required

Essential:

  • Professional experience working on a multi-terabyte, high volume enterprise database setup
  • Practical experience in the following DBA areas:
  • Oracle
    • Solid database design and SQL experience
    • Working with logical and physical data models
    • Maintaining and scheduling backup and archiving (BAR) processes
    • Designing and implementing indexing, archiving and partitioning strategies
    • Updating statistics and performance optimisation of long running queries
    • Operational maintenance e.g. patching and failovers
    • Implement policies and procedures for ensuring the security and integrity of the corporate data warehouse
    • Database Performance tuning (StatsPack & AWR)
    • Flashback Technologies
    • SQL/PLSQL scripting skills
    • UNIX shell scripting skill
    • Practical experience using Oracle 11g 12c 19c: -
    • RAC
    • Dataguard
    • RMAN
  • SQL Server
    • Strong experience in Database Administration for SQL Server
    • Experience with backups, restores and recovery models of large databases
    • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
    • Experience with Performance Tuning and Optimisation (PTO) using monitoring and troubleshooting tools
    • Experience in troubleshooting and resolving database problems
    • Strong knowledge of indexes, index management and statistics
    • Knowledge of T-SQL
    • Able to work with structured frameworks, methodologies and best practices
    • An ability to learn from, and adapt to, a changing technical environment.

Desirable:

  • Experience with OLE
  • OEM Grid 19c
  • Oracle Certification
  • Redhat / OLE Linux Admin
  • Experience of working in Agile (Kanban) and Waterfall projects
  • Experience of working in the Financial or Insurance sectors
  • Knowledge in scripting language
  • MCSA, MTA, MCSE certification
  • Experience using cloud technologies (Microsoft Azure, GCP, AWS)
  • Azure DevOps
  • A working knowledge of System Development Life Cycle (SDLC)
  • Agile ways of working
  • Kanban

Salary, Benefits and Work-Life Balance

We do not have a set salary for this position, as it will be dependent on the successful candidate’s experience. We are happy to see CVs from all candidates who meet the requirements and will be happy to discuss the remuneration package.

At Admiral, we are proud to be a diverse business where we put our people and customers first. We have great benefits to ensure employees have a great work-life balance; it's one of the reasons we're voted no. 1 in the 2019 Sunday Times Best Big Companies to Work For in the UK. We want you to have an element of freedom to define a working lifestyle that supports this, so accommodate flexible hours wherever possible.

You can also view some of our other key benefits here; https://admiraljobs.co.uk/employee-benefits/.

If you think this role is for you and would like to be considered for this opportunity, please click “apply now” to complete an online application form.

#LI-LP1

jobs

Related jobs

IT Asset Management Analyst

** DEFAULT listwidget.vacancypartial.salary - en-GB **

** DEFAULT listwidget.vacancypartial.locationfreetext - en-GB **

Cardiff

Job Type

Full time

Department

Admiral Tech

Location

Cardiff

Office address

Tŷ Admiral, David Street, Cardiff, CF10 2EH

Description

Purpose of role Admiral have several partners that we work with, who combine to create our IT Asset Management (ITAM) Ecosystem. These include several large account resellers, technology vendors

Reference

4785

Expiry Date

26/03/2021

Carter Campbell

Vacancy managed by

Carter Campbell
Carter Campbell

Vacancy managed by

Carter Campbell
View Shortlist
Cloud Engineer

** DEFAULT listwidget.vacancypartial.salary - en-GB **

** DEFAULT listwidget.vacancypartial.locationfreetext - en-GB **

Cardiff

Job Type

Full time

Department

Admiral Tech

Location

Cardiff

Office address

Tŷ Admiral, David Street, Cardiff, CF10 2EH

Description

  Cloud Engineer – Data and Analytics The Admiral Group is a multinational financial services provider, where data and technology are key to our success. We have an opportunity for an experience

Reference

4744

Expiry Date

19/03/2021

Valvanuz  Guerrero-Perez

Vacancy managed by

Valvanuz Guerrero-Perez
Valvanuz  Guerrero-Perez

Vacancy managed by

Valvanuz Guerrero-Perez
View Shortlist
Software Engineer

** DEFAULT listwidget.vacancypartial.salary - en-GB **

** DEFAULT listwidget.vacancypartial.locationfreetext - en-GB **

Cardiff

Job Type

Full time

Department

Admiral Tech

Location

Cardiff

Office address

Tŷ Admiral, David Street, Cardiff, CF10 2EH

Description

  Job Purpose This is an exciting opportunity to join a multi-skilled agile team in IT Delivery, in which you will be working on our core customer facing websites which allow customers to quote,

Reference

4718

Expiry Date

05/03/2021

Valvanuz  Guerrero-Perez

Vacancy managed by

Valvanuz Guerrero-Perez
Valvanuz  Guerrero-Perez

Vacancy managed by

Valvanuz Guerrero-Perez
View Shortlist
posts

Related posts

Meeting our Army Reserve employees - Daryl

Teaser

Contact Centre

Content Type

Blog

** DEFAULT postresults.publishdate - en-GB **

16/01/2020

Summary

Daryl chats to us about juggling his career and being in the Royal Monmouthshire Royal Engineers Militia We were extremely proud to publicise our promise of support to all those who serve, by signing the Army Covenant back in July last year. We recognise that our Army Reservists are a crucial part of the Defence family, and by implementing protective and flexible workplace policies, we’re able to empower our employees to make a real difference to their personal and professional development.We caught up with Daryl to hear his story…What is your Admiral background?‘’I’ve worked for Admiral for ten and a half years; I began in Claims taking customer calls and joined Claims Audit four years ago and have been there ever since.’’Why did you join the Army Reservists and what Regiment are you part of?“Joining the Army had always been at the back of my mind and it came to a moment in time where it was now or never. My fitness levels weren’t great, so I focused on my training, lost a load of weight and signed up!I’d joined for a little extra challenge in my life, to do something different and to push myself out of my comfort zone. The opportunity presented itself and I grabbed it.I didn’t want to leave Admiral and go into the Army full time but I was craving a new challenge. It’s great that I’m able to enjoy my job here, whilst thriving in a new environment as an Army Reservist.I’m in the Royal Monmouthshire Royal Engineers Militia and have been for the past year now.”How are you finding balancing your two roles as well as family life?“A Royal Engineer is one of the most diverse roles offered in the Army; it’s not just soldiering, but also Combat Engineering – essentially, you have to have a broad spectrum of skills, from front-line Soldier to construction and logistics. The training has been intense; a lot of it you do at the start when joining, but as there is so much, the training carries on as your career progresses.The Claims department has been really good with flexible working; I’m able to finish work earlier at times to get to the Regiment and development courses on time – my managers have been incredibly supportive and have given me all the time I’ve needed.I needed five weeks off this year for training which was all signed off by the Admiral management team. The training then changed due to unforeseen circumstances, but work was so flexible, I took a mixture of paid holiday and unpaid leave for this (I’m still paid by the Army during such training).The flexible working at Admiral is important to me; I know how lucky I am to get this support from my employer.  I’m doing a good job of balancing my job at Admiral, the Reserves and my family life.”Do you find that your Army career has complimented your role here at Admiral?“The training has been fantastic in the Army, it teaches you about responsibility, drive, how to take control of situations, as well as confidence building.The training opportunities are endless, from leadership courses to learning how to work as a team – the training is second to none and continuous.These are all transferable skills that I bring to my role here at Admiral, so ultimately, my Reservist career benefits both parties!”

Teaser

Read on
Laura  Pengilly

by

Laura Pengilly

Laura  Pengilly

by

Laura Pengilly

Meeting our Army Reserve employee - Chris

Teaser

Contact Centre

Content Type

Blog

** DEFAULT postresults.publishdate - en-GB **

17/12/2019

Summary

We caught up with Chris, who began his Admiral career almost nine years ago, after spending six years as a Lance Corporal, having served two tours in Iraq We were extremely proud to publicise our promise of support to all those who serve, by signing the Army Covenant back in July this year. We recognise that our Army Reservists are a crucial part of the Defence family, and by implementing protective and flexible workplace policies, we’re able to empower our employees to make a real difference to their personal and professional development.We caught up with Chris to hear his story…Can you tell us a bit about your Army career and career at Admiral?‘I left school with no GCSE’s and decided the Army was the best option for me. I passed my basic training and chose to become a driver by trade and completed all possible licences, including; 17.55-ft, 55-ton, motorbike, off-road, etc, all by the time I hit 17.When I reached my 18th birthday, I volunteered to be deployed to Iraq and that’s when I picked up my Lance Corporal title.In the space of two years, I’d spent a year in Iraq on two separate deployments and I’d experienced a lot, including seeing roadside bombs and losing three friends. After two tours, I was ready for something else and thought to myself, what can I do now?I’m so grateful to Admiral for taking me on during a recession, as I was struggling to find a job for a while. The role was a call centre position, so very different from my background, but I saw it as a great opportunity and a foot in the door. It was a massive change for me, going from what I’d experienced in the Army, to an office-based job, and not forgetting to mention, a pay cut too. After six months I adapted well, got used to the different environment and started to enjoy it.I began in Motor Claims and have since explored various areas of the business, including becoming Admiral’s very own chauffer (which sadly isn’t a position anymore!), before ending up where I am today, which is on the Superior Car team. That’s part of the beauty of Admiral, there are so many internal opportunities to move about the business and broaden your horizons.The Chauffer role sounds interesting, how did that come about?In Admiral, there are many opportunities to develop and experience other areas of the business, so when a job came up for an internal chauffeur, I applied and was successful. I had already completed relevant qualifications for this role whilst in the Army, so it felt like the perfect opportunity for me! Importantly, how was the transition from a career in the Army to a career at Admiral?After being out of the Army for a while, I re-joined as a reservist; I was working full-time at Admiral and part-time in the Reserves. This was a great, but gruelling two years.Admiral supported me during this time and paid me during my training days, as well as the required time away.After my time in the regular Army and Reserves, I adjusted to life at Admiral fine. The decompression training provided by the Army helps bring you back to normality, but also, I love working at Admiral; the simple fact that you don’t have to wear a uniform, or shave; it’s a different world. Coming to Admiral was easy for me, you’re able to leave work on time, and do whatever you want after work, and during the weekends.Whilst I enjoyed my time in the Army, which taught me so much, I now appreciate working in a relaxed environment – and knowing exactly what my day will entail.It’s all the little things about working here that made it such an easy transition for me.What are you doing now and are you enjoying it?I’m now a part of Claims’ Superior Car team – managing a small team that I helped set up from scratch. It involves helping customers who’ve unfortunately been involved in an accident in a “supercar” (Ferrari McLaren , Rolls Royce, etc.). My skills and experiences developed during my Army career, along with my passion for cars and driving, has allowed me to flourish in this role.I feel very lucky that Admiral took that chance on me nine years ago, I’m able to work with my passion and I really do enjoy coming to work every day – how many people can say that?

Teaser

Read on
Laura  Pengilly

by

Laura Pengilly

Laura  Pengilly

by

Laura Pengilly

Celebrating our 5th Annual Learning & Development Conference

Teaser

Contact Centre

Content Type

Blog

** DEFAULT postresults.publishdate - en-GB **

20/11/2019

Summary

On the 8th of November, our very own Admiral Academy hosted their 5th International Learning and Development (L&D) Conference. Over 150 training professionals came together from all corners of the business to collaborate, share best practise, network and most importantly celebrate success. The day kicked off with the amazing Admiral Inspire Choir and an opening speech from Head of People Services and Head of Learning and Development. David Stevens (CEO) also recorded a personal thank you message to attendees for their efforts in winning the L&D Award at the Best Big Companies to Work for Awards this year!The day included a whole host of talks from managers around the business, with keynote speaker Garan Pieniazek who gave an inspiring talk. The day also incuded talks from our ILM 7 Graduates and Working Groups who have worked incredibly hard throughout the year to deliver current content at this year’s conference.The second part of the day was recognising staff in the business who made a real impact within the learning and development community over the last year.Award Winners from this year’s conference are;Getting To Know Your Learners – Holly: Admiral AcademyDriving Performance – Deepshika: Customer ServiceGuardian of The Culture – Daniel: Admiral AcademyHighly Commended - Excellence in Learning and Development – New BusinessWinner - Excellence in Learning and Development - RenewalsThe L&D Conference and Awards highlights the incredible work of training professionals throughout the business and truly make a difference to the business and staff. Thank you to all and a huge well done!

Teaser

Read on
Laura  Pengilly

by

Laura Pengilly

Laura  Pengilly

by

Laura Pengilly

Our Benefits

As one of our four pillars to our culture, Reward and Recognition is extremely important. We believe that happy staff make happy customers, so we have a huge range of great benefits to make sure everybody has something to smile about! Here are a few of our more popular ones.

Share
Schemes

Flexible
Working

Local
Discounts  

Travel Season
Ticket loans

Groups
& Societies 

Development 
Opportunities

View more benefits