Description
Oracle DBA-- Remote - UK - Permanent
Role purpose:
As part of an exciting Digital Transformation journey, my client is seeking a skilled Oracle DBA to support strategic project initiatives. Reporting to the Oracle OCI Architect DBA, the Oracle DBA (BOS) will play a crucial role in maintaining the Oracle EBS business-facing platform, which encompasses the primary business operating system, client portal, system integrations, and field service platform.
The Oracle DBA will be responsible for the administration, performance tuning, and optimization of the Oracle EBS business-facing platform. This includes managing database configurations, ensuring data integrity, and implementing backup and recovery strategies. The DBA will also monitor system performance, troubleshoot database issues, and apply necessary patches and upgrades to maintain system reliability. Additionally, they will collaborate with development teams to design and implement database solutions that meet business requirements, ensuring efficient data management and accessibility.
Furthermore, the Oracle DBA will be tasked with writing and executing scripts to analyze and update data within the BOS platform, ensuring alignment with business needs. This role will also involve implementing and overseeing monitoring activities for the BOS platform and its integrations with other business systems, facilitating a seamless flow of data across platforms and enhancing overall system performance.
Key Responsibilities:
Database Administration: Manage and maintain the Oracle EBS database environment, ensuring optimal performance, availability, and security.
Performance Tuning: Monitor and analyse database performance, implementing tuning strategies to enhance efficiency and responsiveness.
Backup and Recovery: Develop and execute backup and recovery plans to safeguard data integrity and ensure business continuity.
Patch Management: Apply necessary patches and updates to the database systems to maintain security and functionality.
Data Integrity: Ensure data accuracy and consistency through regular audits and validation processes
Scripting and Automation: Write and maintain scripts for data analysis, updates, and automation of routine database tasks.
Collaboration with Development Teams: Work closely with application developers to design and implement database solutions that meet business requirements.
Monitoring and Reporting: Implement monitoring tools and generate reports to track database health, performance metrics, and incident resolution.
Incident Management: Troubleshoot and resolve database-related issues, coordinating with relevant teams to ensure timely resolution.
Knowledge Management: Maintain comprehensive documentation of database configurations, procedures, and changes to support knowledge sharing and compliance. Document KBA solutions and best practices to build a knowledge base for future reference.
Technical / Professional Qualifications / Requirements:
Technical Skills:
Proficiency in Oracle database management systems (currently 19c).
Skills with Oracle Exadata, GoldenGate, and other Oracle tools.
Familiarity with SQL and PL/SQL programming languages.
Knowledge of database design, documentation, and coding practices.
Skills with Fusion Middleware,.Knowledge of integration tools and middleware solutions.
Operating Systems: Skills with UNIX/Linux and Windows operating systems, including shell scripting.
Performance Tuning: Strong skills in database performance tuning, optimization, and troubleshooting.
Backup and Recovery: Expertise in backup and recovery strategies, including RMAN (Recovery Manager).
Monitoring Tools: Familiarity with database monitoring tools and techniques to ensure system health and performance.
Job Title: Oracle Database Administrator
Location: Birmingham, UK
Rate/Salary: 60000.00 - 65000.00 GBP Yearly
Job Type: Permanent
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at https://www.allegisgroup.com/en-gb/privacy-notices.
To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go to https://www.allegisgroup.com/en-gb/privacy-notices.
We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice at https://www.allegisgroup.com/en-gb/privacy-notices for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. If you are resident in the UK, EEA or Switzerland, we will process any access request you make in accordance with our commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.