Senior Database Administrator

3 months ago

Edinburgh, United Kingdom Scottish Government Full time

Overview:
Do you have excellent attention to detail along with the confidence and experience to influence colleagues and stakeholders at all levels? Can you demonstrate a strong working knowledge of Oracle Application Server and Oracle database (10g and above) including installation, performance tuning and RMAN recovery skills? Are you interested in learning new cloud technologies and skills ? If the answers to the above are yes, then this exciting opportunity could be for you.

The Agriculture and Rural Economy (ARE) Directorate works to support Scotland's sustainable economic growth, especially in the rural economy, making the most of Scotland’s environment, natural assets and advantages - its people, landscapes, biodiversity, agriculture, food & drink and animal welfare.

Digital and Information Services Division (DISD) supports the ARE Directorate by setting and delivering its digital strategy, as well as running, maintaining, developing and adapting its many critical IT/digital systems - the main ones of which are used by external customers. Staff in the Division have a very broad range of digital, governance and commercial skills, reflecting the complexity and variety of solutions in use, and the services they provide include: Digital Strategy and Governance; Digital Delivery and Customer Engagement; Digital Operations and Technical Management and Procurement and Contract Management. ISD does this through a blend of in-house and externally delivered approaches.

Overview of the role

The post is that of Senior Database Administrator within the Technical Management team. The Technical Management team is responsible for the build, design, maintenance and enhancement of ARE’s infrastructure and it’s services. Ensuring that all infrastructure components, including internal user services and services to the public, are running as required both efficiently and to the agreed service levels across the ARE customer base.

Whilst tasks within the current role will naturally be centred around the Oracle database there will be ample opportunity, and expectation, to learn new database technology (Postgres etc). As a Senior DBA with a wealth of experience you will often be asked to contribute in wider conversations with regards to:

- the entire IT estate, assist in the journey to digital transformation, continuing establishment of cloud technologies, DevOps adoption and you will be well placed to shape direction and make the most of opportunities that arise from these conversations.

**DDaT Pay Supplement**

**Responsibilities**:

- Monitor database activity to ensure databases are available, secure, recoverable, error free, and performant
- Ensure databases availability
- Perform regular database backups to ensure data can be recovered or recreated in the case of corruption
- Identify and resolve issues that impact functionality, data integrity or data access
- Identify, escalate, and resolve blocks that negatively impact database performance
- Develop tools to aid with event and capacity monitoring
- Plan and implement new database installations to best practice
- Plan and implement major release databases upgrades and periodic patching schedules
- Utilise standard corporate tools to manage incidents, problems, and changes midentifying the root cause for DB related major incidents
- Participating and delivering tasks in Disaster Recovery tests
- Providing technical expertise to the development teams
- Provide regular updates to management and colleagues on progress, and work with Business colleagues to ensure critical deliverables are provided and schedules met.
- Ensure knowledge and skills transfer by providing coaching and training to colleagues.
- Line management responsibility can be expected

**Competencies**:
Analysis and Use of Evidence

Communication and Engagement

Improving Performance

Self-Awareness

ICT Specialism

Essential Criteria & Qualifications:
**Essential Criteria**:
1. A highly skilled and experienced database administrator (5+ yrs) with proven hands-on experience of administration within an enterprise level IT infrastructure. A strong working knowledge of Oracle Application Server and Oracle database (10g to 19c) with demonstratable skills in installation, performance tuning, Spatial, RMAN recovery, solid experience of OEM 13c and Data Guard along with the ability to shell script.

2. Experience of database container (CDB), and pluggable (PDB), database administration, snapshot, clone management, ASM storage, Grid Infrastructure 12c and 19c along with the ability to manage the performance and availability of mission-critical OracleAS and database environments.

3. Motivated team player with excellent organisational skills, triage, task prioritisation and excellent problem solving and troubleshooting skills.

4. Proven track record of designing, participating and delivering tasks in Disaster Recovery tests

**Location**:Saughton House, Edinburgh, EH11 3XD

This post is based in Edin

  • Senior Database Administrator

    3 months ago

    Edinburgh, United Kingdom Lorien Full time

    **SENIOR DATABASE ADMINISTRATOR - 6 MONTH INITIAL CONTRACT - OUTSIDE IR35** **Our leading Public Sector Client are looking for a highly experienced Senior Database Administrator to join on a current project.** - At least 5 years' experience of as working as Oracle Database Administrator, ideally on Unix platforms. - Experience of Oracle 10g/11g/19c RAC GRID...

  • Principal Database Administrator

    3 months ago

    Edinburgh, United Kingdom Wood Mackenzie Limited Full time

    In the middle of the energy transition, businesses and governments are faced with significant challenges. But the pace and scale of change mean every decision is made under mounting pressure. Now, more than ever, companies need reliable data, analytics and actionable insight. Wood Mackenzie is the leading global provider of data and analytics solutions for...

  • Lead Database Administrator

    3 months ago

    Edinburgh, United Kingdom HM Revenue & Customs Full time

    **Senior Engineer Application Operations (Database Technical Lead) Hybrid** **Job summary** Are you an accomplished Technical Lead with experience in database administration? Do you have experience in any of the following? Oracle/MySQL/MS SQL/Ingres. If so, continue reading to find out more about this fantastic opportunity to join HMRC - one of the...

  • Senior Database Administrator

    3 months ago

    Edinburgh, United Kingdom A.S.A Recruitment Ltd Full time

    Plan for backup and recovery of database information, ensuring they are carried out accordingly - Monitoring trends in database activity - Prototyping migration of Oracle databases from on-premise to cloud platformsRequirements - 5+ year's experience - Experience of Oracle 10g/11g/19c RAC GRID ASM infrastructure database administration - Oracle enterprise...

  • SQL Server Database Administrator

    3 months ago

    Edinburgh, United Kingdom Menzies Distribution Full time

    **Job role**: SQL Server Database Administrator **Location**: Edinburgh **Shift Pattern**: Monday -Friday 9am-5pm **Salary**: £35k-£40k per annum **Are you a skilled SQL Server Database Administrator looking for a new challenge?** Menzies Distribution have a fantastic opportunity for an experienced SQL Server Database Administrator. The Database Admin...

  • Database Administrator, Associate

    3 months ago

    Edinburgh, United Kingdom BlackRock Full time

    Description About this role The Database Hosting Team is an integral part of Platform Hosting Services which sits under the broader Aladdin Engineering. Hosting Services is responsible for operating and engineering the reliability, stability and performance of the firm's financial systems including Aladdin and ensuring its availability to our business...

  • Database Administrator, Associate

    4 months ago

    Edinburgh, United Kingdom BlackRock Full time

    Description About this role The Database Hosting Team is an integral part of Platform Hosting Services which sits under the broader Aladdin Engineering. Hosting Services is responsible for operating and engineering the reliability, stability and performance of the firm's financial systems including Aladdin and ensuring its availability to our business...

  • Project Database Administrator

    3 months ago

    Edinburgh, United Kingdom FINTEC recruit Full time

    FINTEC recruit is seeking a **Project Database Administrator** for a temporary 3 to 4 month duration based in Edinburgh. This is setting up a new Excel database which will provide quantitative analysis and trends; providing up-to-date construction industry costings data for future projects. Salary is negotiable by experience, working Monday to Friday 37...

  • Senior Database Engineer

    22 hours ago

    Edinburgh, United Kingdom IC Resources Full time

    The right to work in the UK without sponsorship is essential for this vacancy. An exciting opportunity for a Senior Database Engineer has arisen with a world class research and development organisation, developing next generation technology, based in Edinburgh. This is an excellent opportunity for a Senior Database Engineer to join the database team,...

  • Junior SQL Server Database Administrator

    1 week ago

    Edinburgh, Edinburgh, United Kingdom Jump IT Recruitment Full time

    About the RoleWe are seeking a highly skilled Junior SQL Server Database Administrator to join our client's tech team in Edinburgh. As a key member of the team, you will be responsible for ensuring the smooth operation of the company's SQL Server databases.Key ResponsibilitiesDatabase Management: Design, implement, and maintain databases to meet business...

  • Junior SQL Server Database Administrator

    1 week ago

    Edinburgh, Edinburgh, United Kingdom Jump IT Recruitment Full time

    About the RoleWe are seeking a highly skilled Junior SQL Server Database Administrator to join our client's tech team in Edinburgh. As a key member of the team, you will be responsible for ensuring the smooth operation of the company's SQL Server databases.Key ResponsibilitiesDatabase Management: Design, implement, and maintain databases to meet business...

  • Database Support Consultant

    5 days ago

    Edinburgh, Edinburgh, United Kingdom Cathcart Technology Full time

    Job DescriptionCompany OverviewCathcart Technology is a leading database consultancy in Edinburgh, providing 24/7 support services to its customers. We are seeking an ambitious recent graduate in an IT degree to join our team as a Graduate Database Support Consultant.Job SummaryWe are looking for a talented and motivated individual to assist with our...

  • Database Support Consultant

    5 days ago

    Edinburgh, Edinburgh, United Kingdom Cathcart Technology Full time

    Job DescriptionCompany OverviewCathcart Technology is a leading database consultancy in Edinburgh, providing 24/7 support services to its customers. We are seeking an ambitious recent graduate in an IT degree to join our team as a Graduate Database Support Consultant.Job SummaryWe are looking for a talented and motivated individual to assist with our...

  • Database Senior Researcher

    2 weeks ago

    Edinburgh, United Kingdom European Tech Recruit Full time

    Junior / Senior / Principal Database Researcher Edinburgh - Onsite We are looking for Researchers, whether you are just finishing your PhD or have been working in Research for 20+ years. Do you have experience with Database Management Systems and any of the following technologies: Transactional and/or analytical database management systems ...

  • Database Senior Researcher

    4 weeks ago

    Edinburgh, United Kingdom European Tech Recruit Full time

    Junior / Senior / Principal Database Researcher Edinburgh - Onsite We are looking for Researchers, whether you are just finishing your PhD or have been working in Research for 20+ years. Do you have experience with Database Management Systems and any of the following technologies: Transactional and/or analytical database management systems ...

  • Database Support Consultant

    4 days ago

    Edinburgh, Edinburgh, United Kingdom Cathcart Technology Full time

    About Cathcart TechnologyCathcart Technology is a leading database consultancy in Edinburgh, providing 24/7 support services to its customers. We are seeking an ambitious graduate with a passion for IT to join our team as a Graduate Database Support Consultant.Key ResponsibilitiesProvide basic database support on MSSQL and OracleWork closely with senior...

  • Database Support Consultant

    4 days ago

    Edinburgh, Edinburgh, United Kingdom Cathcart Technology Full time

    About Cathcart TechnologyCathcart Technology is a leading database consultancy in Edinburgh, providing 24/7 support services to its customers. We are seeking an ambitious graduate with a passion for IT to join our team as a Graduate Database Support Consultant.Key ResponsibilitiesProvide basic database support on MSSQL and OracleWork closely with senior...

  • Senior Database Researcher and Developer

    1 week ago

    Edinburgh, Edinburgh, United Kingdom European Tech Recruit Full time

    Job Title: Senior Database ResearcherJob Summary:We are seeking a highly skilled and experienced Senior Database Researcher to join our team at European Tech Recruit. As a key member of our research team, you will be responsible for conducting research and development in database systems, including transactional and analytical database management systems,...

  • Junior SQL Server Database Administrator

    5 days ago

    Edinburgh, Edinburgh, United Kingdom Jump IT Recruitment Full time

    We are seeking a skilled Junior SQL Server Database Administrator to join our team at Jump IT Recruitment. As a key member of our tech team, you will be responsible for ensuring the smooth operation of our SQL Server databases.Key Responsibilities:Capacity planning and performance tuning to optimize database performanceDatabase management and upgrades to...

  • Junior SQL Server Database Administrator

    5 days ago

    Edinburgh, Edinburgh, United Kingdom Jump IT Recruitment Full time

    We are seeking a skilled Junior SQL Server Database Administrator to join our team at Jump IT Recruitment. As a key member of our tech team, you will be responsible for ensuring the smooth operation of our SQL Server databases.Key Responsibilities:Capacity planning and performance tuning to optimize database performanceDatabase management and upgrades to...