The South African National Roads Agency SOC Limited (SANRAL) is an independent, statutory company registered in terms of the Companies Act. The South African government, represented by the Minister of Transport, is the sole shareholder and owner of SANRAL. The Agency has a distinct mandate – to finance, improve, manage and maintain the national road network (the ‘economic arteries’ of South Africa) and is committed to carrying out its mandate by protecting and preserving the environment through context-sensitive solutions. The South African national road network consists of 22 197 km of roads. This network seamlessly connects major cities, towns and rural areas, supporting economic growth and social development and immensely contributing to job creation in the country. SANRAL adds value to all the developmental initiatives in the fields of transport, education, health, and development of communities. It revels in its role as partners in the development of all South African communities and sees this as closely aligned to our core function. SANRAL makes a significant contribution towards road safety by maintaining and improving our road environment, and by identifying and addressing road safety concerns. The organisation also aligns itself with local and international road safety authorities in order to learn and improve the safety of our road users. The organisation will continue to actively participate in communities across South Africa and support the development of South Africa’s human capital through tertiary institutions and cooperative governance.
Role Specification: ICT Principal Database Administrator EC#
1
ROLE SPECIFICATION ICT Principal DBA Position:
ICT Principal DBA
Region:
SANRAL – Head Office – Pretoria, Gauteng
Employment:
Permanent
INTERNAL AND EXTERNAL ADVERT SUBJECT REPORTS TO SALARY ROLE OFFICE
ICT Database Administrator ICT Manager Market-related Permanent 48 Tambotie Avenue, Val de Grace, Pretoria, Gauteng
POSITION OBJECTIVE The Principal Database Administrator in SANRAL will take overall ownership of all database systems as the principle DBA and play a pro-active role in achieving a stable and secure production database environment which performs according to predefined standards and is recoverable in case of hardware failure or disaster situations. SANRAL ICT’s primary goal is delivering technology solutions that drive business value, create social value, and improve the lives of those affected by IT. The successful applicant will: • • • • • • •
Understand the Client’s needs and contractual obligation Be aware of Client’s governance on one’s own area of responsibility Need to stay abreast of technological developments in the Industry and recommend Roadmap for upgrades Need to collaborate with other parties or partners in delivery of a quality service to the client Need to be aware of and adhere to SLA/OLA requirements Be required to have insight into relationships between 3rd party suppliers at operational level Provide guidance and mentoring to less- experienced staff members
Role Specification: ICT Principal Database Administrator EC#
2
MINUMUM QUALIFICATIONS: • • •
Grade 12, Diploma IT Engineering, Oracle certification OCP DBA 12c Oracle OCP APPS DBA R12.X
MINIMUM WORK EXPERIENCE: 6-10 years relevant experience in IT industry
KEY RESPONSIBILITIES: • • • • • • • • • • • •
Consultation Service Delivery Comply With Policies And Standards Financial Management Configuration Management Change Management Request, Incident & Problem Management Release Management Capacity Management Availability Management Continuity Management Security Management
KNOWLEDGE: • • • • • • • • • • • • • •
Best Practices In Database Administration Data Modeling Principles Knowledge Of ITIL & Quality Management Principles Leadership Skills Microsoft Office Suite Presentation Skills Product Knowledge Project Management Principles Call Logging System Operation 1Structured Query Language (SQL) Training Skills Understands Data Centre Operation Understands SANRAL’s Business Ethics And Values Workable Knowledge Of Operating Systems (OS)
TECHNICAL KNOWLEDGE/ SKILLS: Oracle: • • • •
Experience in Oracle 10g,11g,12C Expert Oracle DBA knowledge including upgrades, backup/recovery, patching strategies/capabilities and day to day support of application development personnel Strong understanding of Oracle performance tuning Strong understanding of SQL and PLSQL tuning and optimization of query plans
Role Specification: ICT Principal Database Administrator EC#
3
• • • • • • • • •
Experience with multiple facets of Data Guard (DG) including logical, physical, Active DG and the transient logical upgrade process Proven knowledge and experience in designing database schemas to align with development and business goals and objectives Knowledge of database firewall concepts Knowledge of database encryption Experience of Migration of Databases across platforms Knowledge of database encryption Experience in Database Cloning Experience in Oracle Grid Control Experience in logging Oracle SR and following up until closure
ADVANTAGEOUS MSSQL:
• • • • • • • • • • •
Experience in MSSQL 2012,MSSQL 2014 Expert MSSQL DBA knowledge including upgrades, backup/recovery, patching strategies/capabilities and day to day support of application development personnel. Install, configure and administer SQL server in clustered and standalone environments. Experience in Cluster, Replication and log Shipping Create SQL backup and restores Create, Modify and configure SQL Reports Configure and maintain security of SQL servers Experience in SSIS and SSRS Experience in T/SQL Knowledge and Experience using DMV’s Ability to read and understand query plans
MongoDB Skills: • • • • • •
Experience in MongoDB Manage and maintain Mongo DB servers across multiple environments. Design & implement sharing and indexing strategies. Monitor deployments for capacity and performance Implement and maintain mongo DB Management Services (MMS). Maintain database performance and capacity planning Ability to do Backup and Recovering
Oracle/ Linux: • • • • • •
Oracle PL/SQL Development Oracle Core Database Administration System Administration: Oracle E-Business Suite R12 Oracle BI Discoverer Operating System Experience: Microsoft Server, HP-UX, Red Hat Linux 5,6 & 7, AIX & Oracle Enterprise Linux 6.5 & 7 Veeam Backup Suite
Role Specification: ICT Principal Database Administrator EC#
4
PERSONAL ATTRIBUTES: • • • • • • • •
Action Planning Analytical Thinking Communication Conceptualization Customer Excellence Orientation External Actualization Listening Potential Organising
Role Specification: ICT Principal Database Administrator EC#
5
ORGANISATIONAL STRUCTURE INFORMATION AND COMMUNICATIONS TECHNOLOGY DEPARTMENT
ICT MANAGER
ICT PRINCIPAL DATABASE ADMINISTRATOR
Role Specification: ICT Principal Database Administrator EC#
6
Employment Reference Checks Employment reference checks are a requirement of SANRAL and forms part of the recruitment and selection process for all applicants on the shortlist for positions within SANRAL. In order for SANRAL to conduct these checks a consent form needs to be completed and signed by the applicant. By applying for the position, you give consent to the SANRAL to process all the documentation received from you, in order to validate your employability. Please note that this is a confidential document and is intended for internal use by SANRAL’s Human resources cluster only. All applications received from SANRAL employees will be considered in conjunction with a concurrent search conducted by an Employment Agency on behalf of SANRAL. This advert will be circulated internally and only suitable candidate will be considered for the position. Relocation costs will be borne by the incumbent. Employment Equity Appointments will be made in accordance with SANRAL’s Employment Equity plan. SANRAL reserves the right not to fill any vacancies.
Closing date for applications: 02 November 2017
Please submit your CV to: Nomfanelo Baba: Head Office Recruitment Specialist E-mail:
[email protected]
Role Specification: ICT Principal Database Administrator EC#
7
