Illustration of a woman standing at a desk working on a laptop

What does an oracle database administrator do?

An Oracle database administrator (DBA) develops, executes, and monitors a company’s Oracle database. Since it is a highly technical role, an Oracle DBA doubles as a gatekeeper for the most sought-after IT database management system, which is Oracle. The role requires understanding and working toward the performance, availability and security of the Oracle database. The act of maintaining the database is ongoing, given its complex storage structures, which require tweaking to meet the evolving needs of the company. With simplifying and optimising the database architecture as cornerstones, the Oracle DBA job involves problem-solving on a daily basis.

You might hire an oracle database administrator to:

  • Install, organise, and maintain the Oracle database system in a way that aligns with the business goals and vision
  • Optimise the performance, flexibility and scalability of the Oracle database through strategic Oracle database administration services
  • Debug and fix issues in the database by troubleshooting it and figuring out the root cause
  • Monitor the database and optimise it in order for it to perform up to its full potential
  • Ensure that the database has a solid backup and recovery plan in case something goes wrong
  • Train users on how to access the data and information in the database

Intro

We strongly believe at [Company X] that data is the future of decision-making, as it paves the way for intuition. We are seeking a highly skilled Oracle database administrator to manoeuvre through the murky waters of raw data, to bring meaningful insights to our business. The Oracle DBA in question must be open to continuous learning, developing, and prototyping while dabbling with Oracle as a database management tool. With a solid sense of technical skills, the Oracle DBA candidate must be a maestro in Oracle management tools as well as architecture design principles. A self-starter with a keen eye for detail and unwavering focus is the ideal Oracle DBA that we are actively seeking.

Objectives of this role

  • Ensure the optimum availability, flexibility, security and performance of the Oracle database management system
  • Work towards the efficient and effective use of the Oracle system by partaking in a plethora of activities, from installation and configuration to maintenance and troubleshooting
  • Resolve any issues or glitches in the Oracle database management system in a timely manner
  • Plan and craft a reliable backup strategy that is futuristic in its approach

Responsibilities

  • Develop and oversee database objects such as tables, views and stored procedures
  • Monitor the running status of the database continually and optimise it as per its scope for improvement
  • Implement security policies that will act as a shield of protection to the database and update the security protocols periodically
  • Extend technical know-how to the team on how to effectively use the database
  • Help the team set up database user accounts to meet the growing needs of the company

Required skills and qualifications

  • Bachelor’s degree in computer engineering, computer science or a related discipline
  • Prior experience working as an Oracle database administrator
  • Proficiency in Oracle database 11g/12c/18c/19c
  • Sound knowledge of database backup procedures, recovery systems, and SQL
  • Knowledge of Oracle management tools such as Data Guard, Oracle RAC, and ASM
  • Outstanding verbal, written, and interpersonal communication skills

Preferred skills and qualifications

  • Knowledge of programming languages and API
  • Experience in database upgrading and patching
  • Understanding of Oracle cloud infrastructure, Oracle GoldenGate and Oracle database security