Technical Infrastructure Consultant

Position Overview

Direct Manager: Technical Infrastructure Services Manager

Direct Reports: Nil

Department: Infrastructure Services

Summary: Technical Infrastructure Consultants assist both OLR and its clients with their technical infrastructure requirements. This is achieved through the utilisation of knowledge of Oracle database administration, along with network and hardware systems to ensure appropriate installation, configuration, and operations of Oracle Retail application software running on underlying infrastructure components.

Essential Duties and Responsibilities:

General Responsibilities:

• Respond to client Oracle database issues through OLR's ticketing system
• Respond to critical Oracle database issues relating to OLR clients
• Plan, install and maintain Oracle RDBMS instances for both OLR and its client base
• Apply Oracle Database patches for both OLR and client databases as required
• Perform installation and configuration of Oracle Retail application database instances
• Perform installation, configuration and maintenance of web server and application server hardware and software environments for OLR and its client base
• Perform installation and configuration of Oracle Retail application software
• Apply Oracle Retail patches and releases as required
• Perform database and hardware sizing and capacity planning for OLR clients
• Assist in maintaining the OLR software development environment
• Provide on-call support as needed during non-business hours for both OLR and it’s client base
• Ensure that database storage, archiving, backup and recovery procedures are functioning properly

Secondary Duties and Responsibilities:

• Assist in maintaining UNIX operating systems for both OLR and its client base
• Assist in defining and ensuring adherence to both Oracle Retail and OLR database standards
• Assist project teams in defining software functionality and performing appropriate modifications and enhancements

Supervision Exercised:

• Nil

Essential skills: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Professional approach when dealing with internal and external customers, including clear and concise written and verbal communication skills
• High degree of initiative, accuracy, efficiency and attention to detail
• Ability to maintain a positive attitude under stressful circumstances
• Ability to maintain confidentiality when dealing with proprietary and personal information
• Excellent time management and organisational skills
• Ability to be flexible and adapt to change in a complex global organisation
• High aptitude for learning and high degree of self motivation
• Demonstrated ability to learn new technologies
• Strong problem solving and analytical capabilities
• Proficient with MS Office applications (Word, Excel, PowerPoint, Project, Visio)

Education and Experience:

• Bachelor’s degree, preferably in Computer Science or related field
• 1+ years Oracle Database Administration
• 1+ years PL/SQL experience
• C / C++ experience
• Oracle ProC experience
• UNIX (shell scripting)
• Oracle database performance tuning
• UNIX Administration (HPUX, AIX, Solaris) - desirable
• Linux Administration - desirable
• Strong written and verbal communication skills
• Strong ability to proactively identify and resolve issues
• Good time management skills

Physical demands and work environment:

To perform this job successfully, an individual must be able to meet the requirements listed below that represent the physical demands required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 This position requires sufficient hand, arm, and finger dexterity to operate computer keyboard or other office equipment. Substantial time is spent working on a computer.

 It requires visual acuity to read words and numbers. It also requires speaking and hearing ability sufficient to communicate in person or over the phone in English.

 Work is performed in a regular office setting with minimal exposure to health or safety hazards.

 For positions that require travel, primary form of travel for OLR is via aeroplanes travelling economy class.

Additional Information

• Travel – up to 50%

The statements contained herein describe the scope of the responsibility and essential functions of this position, but should not be considered to be an all-inclusive listing of work requirements. Individuals may perform other duties as assigned including work in other areas to cover absences or relief to equalise peak work periods or otherwise balance the workload.