Database Administrator

Database Administrator

 

Full Job Description

Perform activities related to the day-to-day administration and maintenance of Oracle databases. Handle installations, upgrades, backups, and configurations. Collaborate with appropriate managers regarding problems with and capabilities of Oracle databases. The ideal candidate will have hands-on experience working with Oracle Database in a production environment, both on prem, and in the cloud.

Key Responsibilities
:

  • Administration of Oracle databases across different versions
  • Knowledge in Oracle technology such as SQL, PL/SQL, backup, restore, Data Guard, etc.
  • Help plan backup/recovery strategy for all database servers
  • Data Guard maintenance and enhancement
  • Participate in project meetings to understand application and database requirements
  • Incorporate new features of Oracle Database and OS software
  • Develop maintenance and backup procedures, change control processes, and operational documentation
  • Maintain multiple production, development, and QA Oracle environments
  • Monitor file system space, database allocation, etc.; verify efficient use of disk storage; optimize space allocation and avoid out-of-space situations
  • Work with Oracle Support Services to resolve issues and be familiar with Oracle\’s escalation procedures
  • Responsible for tri-weekly software releases onto our Oracle-based systems
  • 24/7 on-call coverage (on rotation)
  • Knowledge in Oracle Database installation, configuration, and upgrades as required
  • Work with analysts/developers on installing and maintaining 3rd-party software packages including helping to identify and resolve performance issues
  •  

Person Specifications (Skills and Experience)
:

Education

  • High School diploma or GED required
  • Bachelor\’s Degree in Computer Science and/or equivalent experience required

Experience

  • 3-5 years of experience working on Oracle Databases in a production environment
  • Experience managing data, import and export, as well as with data replication techniques
  • Experience with Oracle tools and utilities
  • Experience working with file systems hosted in a SAN environment
  • Experience in Oracle DR technologies (RAC, Data Guard, GoldenGate, etc.)

Knowledge & Skill

  • Entry-level for more complex professional roles requiring a specific degree (e.g., computer science, accounting, etc.)
  • General professional knowledge or specialized vocational/technical skills for a variety of technical or administrative policies and procedures
  • Sound understanding of the skills and working knowledge required for a variety of practices and procedures
  • Specialized assignments usually requiring originality, relying on experience and judgment
  • Good understanding of the roles of the relevant functional groups within own area

Scope of Impact

  • Builds awareness of costs related to own work
  • Accountable for determining the approach used to address routine professional issues
  • May coordinate the work of others doing similar work
  • May serve as team leader for a group of support or operations employees
  • Provides guidance or specialized services that directly support or affect results

Strategic Planning

  • Solves routine or standard problems using general professional or specialized vocational/technical knowledge
  • Understands, interprets, and sets personal priorities for reaching goals
  • Limited decision-making authority, works within technical guidelines and direction to achieve objectives and meet deadlines
  • Makes decisions involving interpretation of data, planning own work, or refining the methods and techniques to be used
  • Evaluates suggestions of others to improve efficiency

Customer Focus

    • Fundamental understanding of the customer, customer needs, and priorities
    • Responds to routine or standard requests from internal and/or external customers
    • Communicates information, asks questions, and checks for understanding
    • Gains support from colleagues for ideas/initiatives
    • Can recommend changes to current processes in own area to respond to customer needs

If you think this would be a great opportunity for you, please apply today by submitting your cover letter and cv.

Due to the volume of applications for this role, we may only be able to respond to shortlisted candidates.

Employer questions

Your application will include the following questions:

Which of the following statements best describes your right to work in Australia?

Please provide a brief description of enterprise level projects that you have been involved in.