Oracle/SQL DBA

Posted 24 November 2022
Salary Negotiable
Contact NameStewart Bryson

Job description

Key Accountabilities:

  • Provide database and application support for Oracle / SQL Server databases, applications, and tools

Key Responsibilities:

  • Deliver a service compliant with the Service Level Agreements and monitor Service Level Agreements to ensure that all supported services continue to operate in line with business requirements.
  • Undertake problems investigation with supported services, ensuring that they are diagnosed and resolved in a timely manner.
  • Monitor activity and trends against supported services and work with colleagues and customers to initiate regular exercises to optimise database performance.
  • Develop and maintain database/application configurations and standards, ensuring that all standards are applied.
  • Develop and support database interfaces, to ensure that data is managed and controlled appropriate to the classification of the data.
  • Monitor, review and implement database security in-line with company policy and industry best practice. Identify and articulate risks associated with processing information within computer systems and networks in relation to supported services.
  • Reviewing and applying database product patches, inline with vendor recommendations.
  • Undertake the building, cloning and patching of support environments. Provide and maintain scripts to automate the monitoring and cloning of environments for quick and effective fault diagnosis.
  • Maintain installations, upgrades and maintenance of the database server, applications and tools.
  • Monitor database/application storage and growth trends, and initiate capacity management plans for supported services.
  • Maintain the backup mechanism. Develop and test database recovery plans on a regular basis and initiate recovery procedures when necessary.
  • Control and manage database changes or enhancements in line with current Change Control policies.
  • The implementation of code releases and configuration changes throughout the system life cycle. Review relevant change and custom releases for risk and impact analysis as part of the whole team to ensure a robust and efficient production system.
  • Create and maintain system/process documentation.
  • Assist other roles such as Developers, Functional Consultants and users with technical issues.
  • Ensures that account is taken of any relevant statutory or external regulations, standards and codes of good practice.
  • Provide support to project delivery managers to upgrade, develop and implement new systems, applications and services appropriate to the role and to agreed timescales.

Our role in supporting diversity and inclusion
As an international workforce business, we are committed to sourcing personnel that reflects the diversity and values of our client base but also that of Orion Group. We welcome the wide range of experiences and viewpoints that potential workers bring to our business and our clients, including those based on nationality, gender, culture, educational and professional backgrounds, race, ethnicity, sexual orientation, gender identity and expression, disability, and age differences, job classification and religion. In our inclusive workplace, regardless of your employment status as staff or contract, everyone is assured the right of equitable, fair and respectful treatment.