DBA
Main Purpose of Job
We are currently looking for applicants that will be responsible for the implementation, maintenance, performance, integrity and security of a number of Oracle databases.
Duties will include the design and creation of databases, planning and maintenance of database configuration, implementation and enforcement of database security and investigating and resolving database and production system errors.
Key Skills will include being able to monitor and tune database performance, establish and manage objective database performance criteria. With regards to the SQL element, you will be expected to establish and manage standards for SQL queries within the system, review SQL, server & application error logs and troubleshoot issues.
You will also be expected to establish database security procedures and enforce their application, advise on database design requirements.
Main Responsibilities
• Database and Grid infrastructure installation and configuration
• Database and Grid infrastructure maintenance in terms of patching and upgrades
• Database performance investigation, tuning and recommendations
• Database table creates and integration with in-house DB-manager PL/SQL solution in terms of:
i. Automated data archiving
ii. Automated data compression
iii. Automated table partitioning
• Data restoration
• Oracle Enterprise Manager monitoring deployment and configuration
• Oracle RMAN backup integration using various Media Management layers
• Resolution of customer requests within allocated priority base timeline
• Generate audit and user/environment review based reports
• Generate capacity utilization historical trending and forecasting reports
• Generate any required adhoc based reports where needed
KPI’S
• Service Desk and SLA fulfilment
i. Maintain and resolve Service Desk tickets as per the designated priority assigned
• Time logging
i. Ensuring all work log detail and time spent reflects correctly
• Change control
i. Ensuring OSI change requests are submitted on time
ii. Ensuring change work implementation is completed correctly and on time
• Projects
i. Ensuring project timelines are met
• Personal Development
i. Ongoing training and certifications to be completed as per Personal Development Plan
Qualifications and Experience
• Senior Certificate
• Relevant IT Qualifications (Diploma or Degree)
• Basic Unix/Linux knowledge advantageous
• Knowledge of relational database and stored procedures advantageous
• Relevant database sql query structure knowledge advantageous
• Knowledge of ERD and USE Case diagrams advantageous
• Oracle certifications advantageous
Key competencies and skills
• Excellent written and verbal communication
• Creative approach to problem solving
• Exposure to/understanding of GSM technologies
• Strong analytical skills
• Ability to follow instruction
• Strong drive to learn
Personal attributes
• Be able to work overtime and standby when required as per standby roster
• Be able to work in a team
• Ability to work well under pressure, especially in maintaining a balanced and logical approach
• Self-motivated and self-managed
• Be able to take ownership and show initiative
• Be able to learn fast and willing to self-study when necessary
• Able to communicate effectively
• Report on progress and raise issues / problems when necessary
• Timekeeping
• Be able to travel outside the borders of South Africa when required