Oracle DBA

Posted 01 February 2023
Salary Up to £470 per day
Job type Contract
Contact NameJona Aliaj

Job description

Oracle DBA

Start: ASAP

Length: 12 Months
Location: Remote

Rate - £470PD

IR35: Inside

Trust in Soda have partnered with a multi-national consultancy providing information and digital services to various renowned clients. This role as an Oracle DBA will be working with a public sector end client, with the opportunity to work on enterprise solutions and various projects such as cloud transformation, administrating, monitoring and tuning database performance.

  • Working with other DB Engineers and Consultants on enterprise solutions
  • Cooperation with other teams on various projects including cloud transformation
  • Hands on experience Oracle DBA activities,
  • Experience in Oracle DB administration; monitoring & tuning DB performance,
  • Experience with managing DB Access rights, schema objects (tables, indexes, and views).

  • Installation and management of Oracle database software, both RAC and single instance options (when necessary, this may involve patching of O/S software (RedHat, Solaris etc) to the required level that's compatible with the Oracle version
  • Installation and management of Oracle Automatic Storage Management (ASM) instances for efficient storage management
  • Installation configuration and management of Oracle Data Guard for efficient failovers
  • Implementing a resilient backup strategy with Oracle RMAN, ensuring backups are run regularly, occasionally doing test database restores
  • Upgrade of Oracle software to ensure systems are not running on unsupported versions of Oracle
  • Execute failover from primary to DR databases if the need arises
  • Uploading anonymised data from production databases to staging/testing databases using various options e.g. Oracle Data pump, Oracle streams, imp/exp, RMAN restore, bespoke scripts etc
  • Writing shell script wrappers for Oracle jobs for various reasons e.g. so they can be executed from Unix crontab
  • Performance monitoring and tuning of Oracle databases
  • Monitoring of OS components that may impact the performance of the Oracle database e.g. host memory usage (RAM), CPU usage, disk and network performances
  • Implement automation and development projects if the need arises using SQL, PL/SQL, Python and Shell scripts