Oracle Database Engineer

GB  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

Contract - Inside IR35

The Oracle Database Engineer will design and document strategies for backup and recovery, performance analysis, database clustering, and data management.

The Oracle Database Engineer will also be responsible for database connectivity using ODBC, JDBC or vendor specific architectures, provide user and developer assistance, and also be a point of escalation.

Enter the key responsibilities of the role:

1. Develop and maintain database build standards including security to industry standards, patching and high availability

2. Monitor and manage database resources to ensure optimum performance

3. Document and manage database server procedures such as backup and restore, upgrades and disaster recovery procedures

4. Undertake maintenance and upgrades, generally out of normal business hours including weekends.

5. Provide database design support to development projects.

6. Performance tuning and diagnostics, query plan analysis and the use of AWR/ASH/ADDM

7. Review database application code and advise accordingly.

8. Manage and maintain the source code control system for the database objects.

9. Assist Unix administrators as necessary to support applications that use the databases, eg Weblogic Application Server, Apache server.

10. Participate in the support shift cover 8am to 6pm and be available for on-call service. Shift cover will mean that you perform tasks that may be outside of the normal responsibilities.

11. Develop and maintain a strategy for database management to include both manual procedures/spot checks and automated alerts.

12. Assist IT Security in maintaining an appropriate database security policy. Evaluate and implement applications to police' adherence to policy.

Have experience in supporting business critical applications and Servers in a multi data center/multisite environment. In particular the jobholder will have experience in the following areas:

Oracle DBA.

1. Extensive experience in Oracle 10g, 11g, 12c, 19c database administration

2. RAC

3. ASM/ACFS

4. Data Guard

5. Exadata

6. PL/SQL

7. RMAN

8. Oracle Enterprise Manager

9. APEX (Application Express)

10. Solaris X86 and Sparc, Red Hat Enterprise Linux

11. Grid Infrastructure/Database Patching and Upgrades

OTHER REQUIREMENTS

1. Experience of working in the finance/banking sector would be an advantage.

2. Excellent verbal and written communication skills with the ability to communicate effectively at both business and technical level.

3. Excellent problem solving skills, able to think clearly under pressure and across technology boundaries.

4. The ability to plan and manage work and present a clear list of tasks and time frames to management.

5. Understanding of ITIL Service Framework

6. High Availability and Disaster Recovery.

7. Experience with Public Cloud: AWS/Microsoft Azure.

8. Familiarity with monitoring products such as DataDog.

9. Shell Scripting

10. DevOps and CI/CD Tools:

Bitbucket, GitLab, Jenkins, Ansible, Terraform

Start date
ASAP
From
WNTD
Published at
26.01.2022
Project ID:
2300389
Contract type
Freelance
To apply to this project you must log in.
Register