DATABASE SPECIALIST: DBA ORACLE

POSITION NUMBER : 60066529

JOB GRADING : C5
REPORTS TO : MANAGER: IT INFRASTRUCTURE
BUSINESS UNIT : IT
LOCATION : HEAD OFFFICE: PRETORIA
POSITION STATUS : PERMANENT

Purpose of the Job:

• Install, upgrade, configure, administrate, maintain and deploy Oracle Databases, Oracle Application Servers and Oracle technologies. Maintain and support IT Database Infrastructure Development. Provide guidance and advice on Technical Architecture, Capacity Planning, Designing, Security Analysis, and Configuration Backup and Recovery, input to Disaster Recovery and Planning, development tools, enhancement, testing, fixes and documentations.

Job Responsibilities:

• Install, upgrade, configure, administrate, maintain and deploy Oracle Databases, Oracle Application Servers and Oracle technologies.
• Maintains and support IT Infrastructure Production databases.
• Provide guidance and advice on Technical Architecture, Capacity Planning, Designing, Security Analysis, and Configuration Backup and Recovery
• Give input into Disaster Recovery and Planning, development tools, enhancement, testing, fixes and documentations.
• Provide administration, 2nd and 3rd level support services for IT Databases Infrastructure Production.
• Participate in IT project implementation.
• Maintain and support IT Database Infrastructure Oracle Databases.
• Documentation of IT Database Infrastructure development.
• Ensure compliance with IT and company policies, procedures and standards.
• Implement and administer large Oracle database solutions.
• Provide expert advice and guidance in a customer facing role.
• Manage all change requests as per change management procedures.
• Establish fit for purpose test criteria that meet business specifications.
• Perform unit testing of Oracle Database modules
• Update and support user acceptance test criteria.
• Update test criteria for production acceptance.
• Support production acceptance and implementation testing.
• Conduct delivery assurance according to (ITIL, CoBiT, SLAs) etc.
• Perform capacity planning, security analysis and configuration backup and recovery, disaster recovery planning. Provide advice and guidance on Technical Architecture
• Evaluate, monitor and manage the clients’ database, application server and application performance.
• Implement Oracle Optimal Flexible Architecture ( ASM)
• Work alongside the customer, colleagues, partner (s) and other third party.
• Ensure client issues are resolved, either as an individual or with assistance from other Oracle lines of business.
• Maintain an up to date knowledge of practice specific, Oracle products and services.
• Promptly trouble shoot solve Oracle Database problems
• Manage the performance and capacity of an Oracle Database systems environment.
• Anticipate user requirements and identify and resolve complex problems with minimal supervision.
• Assess internal and external operating practices, anticipate future system requirements.
• Research and analyse emerging technologies.
• Conduct and prepare feasibility studies; develop client proposals, including estimates for costs, time and resources; prepare statistical reports: complete cost / benefit analysis and conduct business.

Qualifications and Experience:

• National Diploma in Information Technology (NQF Level 6) or equivalent
• Oracle Database certification
• 3-5 Years relevant Oracle DBA experience, particularly in relation to performance tuning, security, reliability, scalability, and capacity sizing, backup and recovery.

Knowledge and understanding of:

• Proven experience of designing, implementing and administering large Oracle database solutions, Demonstrate experience of providing expert advice and guidance in a customer facing role, Proven success of working on own initiative, Hands on experience of Oracle 9i and 10G/11G and 12C and Real Application Cluster (RAC)/Preferable to have experience in the following Oracle 10g/11g/12c Application Server, Dataguard, RMAN, OLAP services, Spatial, Single Sign-on, Identity Management, PL / SQL knowledge Strong Unix (AIX 5L, Sun Solaris) skills essential, additional MS Windows skills useful, Knowledge of technology stack underpinning the Oracle Application, i.e. workflow, J2EE, and the Forms / Reports technology will be useful, Working knowledge of EMC Networker and Data Domain, Working knowledge of Oracle Enterprise Manager Documentation
• Excellent technical knowledge and aptitude in the areas of networks, hardware and software, and troubleshooting techniques.
• Knowledge of planning / enhancements / installations: Quality of service on the Oracle Database environment
• Knowledge of: IT Hosts and Database Infrastructure Architecture models, BS7799 Security standards, IT Governance, Internal business policies and procedures, IT Standards (CobiT, ITIL, etc.), PFMA, SAPO IT Architecture, Audits requirements: IT Database Infrastructure Architecture models, Database Licensing, Problem and business priorities, Change management, Customer services, Optimization of IT Oracle Database infrastructure, Planned Maintenance of IT Database Infrastructure, IT Infrastructure backup and DRP recovery, IT Database Infrastructure standards, IT Database Infrastructure policies and procedures, IT Strategy and Architecture including IT Oracle Database, Infrastructure: SAPO Business operations priorities, Testing methods and protocols, Support production acceptance and implementation testing, IT Measurement and communication: IT Standards (CobiT, etc.) and Quality Management
• Installation, upgrade, administration and maintenance of the Oracle database and technology stack in line with customer requirements, Capacity planning, security analysis and configuration backup and recovery, disaster recovery planning. Provide advice and guidance on Technical Architecture, Evaluating, monitoring and managing the clients database, application server and application performance
• Implementing Oracle Optimal Flexible Architecture ( ASM), Working alongside the customer, colleagues, partner (s) and other third party, Ensuring client issues are resolved, either as an individual or with assistance from other Oracle lines of business
• Developing and maintaining an up to date knowledge of, practice specific, Oracle products and services, Excellent trouble shooting skills, Ability to promptly solve Oracle Database problems, Managing the performance and capacity of an Oracle Database systems environment, IT Oracle database development methods, IT Oracle Database Information analysis, IT Database services and products, Ability to assess internal and external operating practices, anticipate future system requirements, Research and analyse emerging technologies, Ability to effectively adapt to rapidly changing technology and apply it to business needs, Ability to conduct and prepare feasibility studies; develop client proposals, including estimates for costs, time and resources; prepare statistical reports: complete cost/benefit analysis and conduct business. Project management tools, Thorough understanding of distributed systems architecture and comprehensive knowledge of multiple technical disciplines.

Skills

• Strong inter-personal skills. Time and priority management. Ability to work under pressure and to deliver against deadlines. Business orientation

Attributes

• Attention to detail / accurate. Fluent in written and spoken English. Strong inter-personal skills, Assertive. Problem solving. Fast learner. Analytical. Disciplined. Logical thinker. Team player. Assertiveness

How to Apply

• If you wish to apply and meet the requirements, please forward your Curriculum Vitae (CV) to recruitmentSN@postbank.co.za Please indicate in the subject line the position you are applying for. To view the full position specification, log on to www.postbank.co.za and click on Careers.

Closing Date:

• 04 April 2023

Disclaimers:

• The South African Postbank SOC Limited is committed to the achievement and maintenance of diversity and equity in employment, especially with regard to race, gender and disability. In compliance with the banks employment equity plans, first preference will be given to candidates from designated groups. Correspondence will be limited to short listed candidates only.
• If you do not hear from the South African Postbank SOC Limited or its Agent within 3 months of this advertisement, please accept that your application has been unsuccessful. The South African Postbank SOC Limited reserves the right not to fill the positions or to re-advertise the positions at any time.
• POPIA provides that everyone has the right to privacy and it includes a right to protection against the unlawful collection, retention, dissemination and use of personal information. By applying for employment you consent to the processing of your personal information with Postbank. Your personal information and any attached text or documentation are retained by Postbank for a period in accordance with relevant data legislation.