TRANSNET DATA BASE ADMINISTRATOR Operating Division: TPT POD Corporate H/O Employee Group: Permanent Department: TPT, ICT, DBN Location: Durban Reporting To: Navis Service Delivery Manager Grade: F Reference: req1130 The closing date is on . It is the responsibility of the applicant to ensure that HR has received the application before the closing date of the advertisement. Position Purpose Transnet SOC operates 9 of its Transnet Port Terminals (TPT) marine terminals and 9 of its Transnet Freight Rail (TFR) inland terminals using Navis N4 as its Terminal Operating System (TOS). End users of the TOS include internal employees and external customers from all over South Africa. The TOS is used in a 24/7 environment for planning and operational execution. The TOS team is based at TPT’s Head Office in Durban and reports to the Navis Service Delivery Manager. The SQL Database Administrator is responsible for the design, development, implementation, configuration, maintenance, performance, integrity, and security of all the organization’s new and existing SQL databases. The individual plays a crucial role in ensuring the smooth operation of all SQL databases Position Outputs 1. Administration - Develop and maintain technical and implementation plans. - Update technical documentation on a regular basis to ensure it is current and up to date. - Maintain technical configurations in accordance with related policies and procedures. - Record time allocation per task for project management and capitalization purposes. - Ensure all database change and release management tasks are completed in accordance with the policies and procedures. Contribute and manage database related changes through its lifecycle. - Contribute to the knowledge base for database administration staff. - Create end-user-friendly documentation that adheres to standard operating procedures (SOP) and best practices. - Create and maintain high-level activity plans with scheduling timelines for project tasks and activities. - Participate in planning sessions to gather and develop database requirements. - Participate in business and technical discussions related to database solutions. - Formulate reports of project technical activities. - Ensure that all pertinent documentation is kept up to date. 2. Technical Database Design - Work with developers and analysts to design efficient database structures that meet the organization's requirements for data storage and retrieval. Database Installation and Configuration - Install and configure database software according to best practice and the organization's needs and policies. Build database systems of high availability and quality. Database Security - Manage database security, including user access control, data encryption, and implementing security policies to protect the database from unauthorized access and data breaches. - Identify, report, and manage database security issues, audit trails, and forensics. Database High Availability, Backup and Recovery - Configure and manage high availability solutions like SQL Server Always On Availability Group, ensuring database availability and data protection in the event of failures. - Develop and implement backup and recovery plans to ensure that data is protected and can be restored in the event of a failure or disaster. Ensure database backup/restore strategy meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) - Regularly schedule, monitor, and report on full and incremental backups. - Conduct the backup and recovery test procedures periodically. Performance Monitoring and Tuning - Monitor database performance, identify bottlenecks, optimize, and enhance database performance through query optimization, index tuning, and other techniques. - Refine and automate regular repeatable, mundane database tasks. - Define and implement event triggers that will alert on potential database performance or integrity issues. Database Maintenance - Perform regular maintenance tasks such as updating software, applying patches, and managing storage to ensure the database operates efficiently and reliably. Data Integrity and Compliance - Ensure that data stored in the database is accurate, consistent, and compliant with regulatory requirements and organizational standards. - Secure data with precise access controls, authentication, and authorization mechanisms. - Uphold data integrity. Troubleshooting and Issue Resolution - Monitor database health and performance including incident and problem management. - In real-time, diagnose and troubleshoot database issues, identify root causes, track and implement solutions to prevent recurrence. - Assist the application specialists with any application issues associated to the database. Documentation and Reporting - Maintain documentation of database configurations, procedures, and standards, and generate reports on database performance and usage. Qualifications and Experience - Relevant Qualification / National Diploma in Information Technology/Computer science (NQF 6/7) - Minimum 5 years’ experience in SQL Server Database Administration. - Preferably 1 year supervisory or specialist DBA related experience. - A successful track record of supporting and managing SQL Server, including High Availability. - Experience supporting and working with cross-functional teams in a dynamic environment. - Advantageous: Transnet leadership Development Programme - Advantageous certification o SQL Server related certification. Number of years with lower level certificates/qualification - NQF Level 5 certificate (120 credits) - Minimum 6 years’ experience in SQL Server Database Administration. - Preferably 2 years supervisory or specialist DBA related experience. - A successful track record of supporting and managing SQL Server, including High Availability. - Experience supporting and working with cross-functional teams in a dynamic environment. - Advantageous: Transnet leadership Development Programme - Advantageous certification o SQL Server related certification. Competencies Skills Required: - Structured Query Language (SQL) - Relational Database Management System (RDBMS) - Microsoft SQL Server 2012 and later - SQL Server Management Studio - High Availability and Disaster Recovery options for SQL Server - Performance tuning and optimization - Knowledge management - Communication - Report writing - Conflict management - Change management - Configuration management - ICT Governance - Communication - Analysis & Attention to detail - Problem Solving - Big picture thinking - Drive and Results Orientation - Creativity & Innovation - Critical thinking - Flexibility & adaptability - Excellence & Quality Orientation Equity Statement Preference will be given to suitably qualified Applicants who are members of the designated groups in line with the Employment Equity Plan and Targets of the Organisation/Operating Division. APPLY NOW TRAINEE TRAIN ASSISTANT Operating Division: Transnet Freight Rail Employee Group: Trainee Department: OP-COR-EXEC-TCM-Diesel Team A-EMR Location: Ermelo Reporting To: Section Manager: Train Traffic Grade: SSTFT Position Purpose Assist the Train Driver in the safe and efficient driving/handling of all different types of trains/locomotive consists (airbrake, vacuum, high speed, heavy haul and passengers) to ensure that the customers freight/cargo reaches its destination in good condition, on time, in order to enable the organisation to satisfy the customers’ needs. Position Outputs 1. Sign on duty at designated work place and be allocated duties to be performed for the duration of the shift. · Determine which locomotive to be prepared · Obtain and place equipment on locomotive · Check and supplement prescribed equipment · Clean working area · Assist with starting up of locomotive as prescribed assist with locomotive brake tests · Couple locomotive · Sign on duty · Despatch locomotive 2. Prepare locomotives · Determine which locomotive to be prepared · Obtain and place equipment on locomotive · Check and supplement prescribed equipment · Clean working area · Assist with starting up of locomotive as prescribed · Assist with locomotive brake tests 3. Prepare communication equipment · Obtain radio’s/handsets/walkie talkie/telemeters when applicable · Check functionality of communication equipment 4. Performs the pre-trip preparation of the Locomotives and the whole Train prior the departure to adhere to roadworthiness and train working rules and safety standards · Attach/detach vehicles according to works order in absence of yard personnel i. Mount telemeters where necessary ii. Complete vehicle list and vacuum form iii. Mount train indicators iv. Examine train v. Do brake test in conjunction with train driver 5. Execute shunting activities in sidings and enroute according to directives to enhance safe working procedures. · Obtain works order · Performa shunting/placing/removing of trucks as per works order · Update vehicle list · Place and clear load/empty trucks at siding 6. Assist the train driver enroute to ensure the safe movement of the train from a required point to the destination, without delays or damage to locomotives, wagons, infrastructure track and other equipment, to ensure predictable service. · Verbally compare signal positions and display with train driver · Observe proceeding trains patrol locomotives · Reset locomotive trip-outs · Observe safe running of train · Protect train during incidents · Assist train driver during emergency circumstances 7. Comply to safety standards and laid down instruction to ensure that he is well motivated and competent. 8. Provide accurate feedback timeously to the Train Driver regarding any incidents and deviations along the route 9. Assist in performing various administration duties 10. Complete the Train journal and submit to the Section manager at sign-off after every shift to ensure timeous and accurate processing of monthly salary. Qualifications and Experience •Grade 12 with pure Mathematics and/or Physical Science Other requirements: •Be prepared to undergo periodic medical surveillance and safety behavioural risk assessments during the selection process and every 12 months. •Physical hearing, vision, mental, fitness (to be verified through medical tests and related safety behavioural risk assessments) •The operator shall not allow employees younger than 21 years of age to undertake train driver or train control duties. (SANS 3000, par 6.2.6.8). The following minimum Trainee pre-requisite: •The candidate should be a minimum of 1.6m tall. •Psychomotor ability (to be assessed through Vienna Testing System (VTS) standard) •Ability to carry heavy objects Functional Training: •Be prepared to successfully undergo Train Assistant duties (theoretical and practical) so as to be certified to work independently as a Train Assistant. •Be willing, prepared and capable to obtain a Train Assistant duties certificate (theoretical and practical) successfully and be certified to work independently as Train Assistant. Competencies Knowledge: 1.Various communication systems 2.Depot layout 3.Locomotive classes 4.Locomotive equipment 5.Route/road 6.Sections/stations and sidings 7.Signing on duty procedures 8.Train working rules 9.Trip report 10.Yard and siding layout 11.Knowledge of general TFR policies 12. Shunting procedures 13. Locomotive classes and their hauling capacities, constraints on the particular territory 14. Health and Safety Act 85 15. First aid 16. Basic conditions of employment act (BCEA) 17. SANS 3004 (Human factors) 18. HC policies and procedures 19. Train service/ITP 20. Train workings 21. Substance Abuse policy and procedures Skills required 1.Locomotive coupling and uncoupling 2.Locomotive preparation (Electrical and Diesel) 3.Locomotive Stabling 4.Observation 5.Shunting movement 6.Train handling skills 7.Time management 8.Stress handling 9.Assessment 10.Literacy 11.Communication 12.Judgement 13.Reasoning 14.Psychomotor skills (reactions/ coordination) 15.Concentration 16.Observation 17.Spatial 18.Depth perception psychomotor 19.Numerical 20.Train / locomotive handling and preparation 21.Problem solving 22.Electrical and diesel locomotive driving Attributes 1.Stress handling 2.Self-management 3.Safety conscious 4.Punctual 5.Willing to work shifts 6.Results orientated Equity Statement Preference will be given to suitably qualified Applicants who are members of the designated groups in line with the Employment Equity Plan and Targets of the Organisation/Operating Division. APPLY NOW
Comments are closed.
|