Vuyolwethu Mapete Email & Phone Number

City Of Cape Town, Western Cape, South Africa

Cape Town Area, South Africa

• Providing administrative support and maintenance on Oracle 11g, 12c and 19c installations on Linux and AIX, database creation, database security, database optimization and tuning.• Experience with providing and maintaining high availability and disaster recovery using Oracle RAC and Data Guard.• Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, and Explain Plan.• Maintain security policy through roles, profiles, privileges and password policies as per business requirements.• Cloning schemas, objects and databases on new server using data pump export/import.• Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.• Upgrading databases from 11g to 12c and 12c to 19c.• Plan and apply PSU patches on production and non-production database and bug fix patch.• Implementing, tuning and maintaining Oracle database using OEM.• Developing Standard Operating Procedures (SOPs) for database tasks.• Managing database structure, storage allocation, database access, roles and privileges• Day to day tasks including administration of concurrent manage process, users, healthcheck reports, database space and growth monitoring, attending to OEM alerts, and performance issues• Configuration of new builds into OEM 13c.• 24x7 standby remote support and on-call DBA rotation schedule

Plattekloof

Support and maintain 33 electricity prepaid system production database for variousmunicipalities● Consult for JHB City Power MDC and MDM RAC one node databases, Zambia Zescoelectricity prepaid system RAC 2 nodes database, Zimbabwe Zetdc electricity prepaidsystem database, Tanzania Tanesco electricity prepaid system database, Kenya KPLCelectricity prepaid system RAC 4 nodes database and Mozambique EDM electricityprepaid system database● Install oracle software 11g and 12c, create databases for new prepaid systems● Configure data guard and broker for physical standby● Perform analysis for the root cause of failures● Resolve/tune performance related issues for queries using AWR, ADDM and ASHreports● Pro-active space monitoring, database state, listener state, dataguard state and backupstatus by implementing health check scripts● Attend to user requirements and troubleshoot● Successfully upgraded City Power RAC one node MDC and MDM databases from11.2.0.3 to 12.2.0.1● Tested complete database restore and recover to a new server using RMAN● Do quarterly tablespace maintenance by doing table export/import for data archiving● Install ASM instance and create ASM disks using LUNs on a RAC environment● Configure DBVisit for testing purposes● Perform database migration from one server to another using export/import● Travel sometimes to african countries for quarterly database health checks, analysis andmaintenance● Provide after hours standby support

Space management by doing the below:• Partition exchange • Partition and subpartition renaming• Move objects from default tablespace to monthly tablespacesASM space monitor

Key Responsibility• Install Oracle 10 and 11g software and Client in Unix, Linux and Windows and create databases• RAC installation in Linux• OEM agent installation in Unix• ASM instance install in Unix• Apply patches and PSU when necessary • Upgrade database to 11g• Implement Data Guard in Linux• Do switchover of primary to standby• Space maintenance as per requirement for tablespace and segment (add and resize datafiles)• User and schema management (creating, dropping database user accounts, grant and revoke roles and privileges, change passwords, unlock and lock accounts, create and assign profiles and tablespaces to users)• Database Health Checks (ensure the instance is up, the listener is up, no critical errors reported in the alert log, tablespace size is not of a critical threshold, make sure the backups ran successfully)• Refresh test database from a production database• Perform import and export of data• drop and recreate database links• Performance tuning using ADDM and AWR reports• Manage/create monthly table partitions• Killing sessions on request• Good knowledge of RMAN backups• ftp file from server to server• schedule cron jobs• Advise developers for efficient SQL query and performance• Analyze capacity and growth of databases• Good knowledge in SQL scripting and basic knowledge in Shell scripting• Point Agent to different grid control OMS and repo without re-installation• Fix archive gap in the standby database• Fix block corruption using RMAN• Add asm disks to diskgroup• Moving asm disks from one diskgroup to another• Troubleshoot ORA errors • Add instances on OEM• Database migration from one server to another• Do standby support for the databases

Key ResponsibilityPrioritizing and managing open cases logged via Radical systemResponding within agreed time limits to open callsRapidly establishing a good working relationship with usersInstalling and configuring computer hardware operating systems and software applicationsTroubleshooting system problems, diagnosing and solving hardware/software faults Replacing hardware parts as requiredSetting up users' accounts and profiles and dealing with password issuesWorking continuously on a task until completion

Key ResponsibilityConfiguring and setting up new machines and laptops.Setting up user's accounts and profiles to the new machines and laptopsInstalling and configuring computer hardware operating systems and software applicationsTroubleshooting system problems, diagnosing and solving hardware/software faults Replacing hardware parts as required

Key ResponsibilityProviding 1st line technical customer support; answering support queries via telephone and e-mail Prompt and efficient logging and managing all incidents and service requests received via email and telephone in Remedy system. Providing remote support to users and help them with software application, internet and printing problems. Escalating complex problems to the proper party and taking ownership of the escalated calls. Maintain calls until closure.

Key ResponsibilityEnsuring the smooth running of computer systems and the network connection in the student computer labsMonitor and maintain computer hardware like computers, printers, and associated peripherals. Investigate the problems if any, take corrective actions, and escalate the unsolved problems to the computer technicians. Arrange for external technical support (MIT) for computers that are still under warranty and work with vendor support to resolve technical problems with desktop computing equipmentImage the computers in the labsAttending weekly Helpdesk meeting to review open calls.

• I was involved in the PC rollout project and setting up new machines to all Metrorail offices• Setting up user’s accounts and profiles to the new machines, • Doing the roll-out of new document management system • Setting up the projector for the meetings in the boardroom. • Monitoring user’s citrix connections and troubleshoot where necessary • Installing and configuring computer hardware operating systems and software applications• Replacing hardware parts as required

Key ResponsibilityAssisting lab assistants and students with the problems in using Microsoft office, internet, student email, applications/programs and printing problemsEnsuring the smooth running of computer systems and the network connection in the student computer labsMonitor and maintain computer hardware like computers, printers, and associated peripherals. Investigate the problem/s and escalate them to the desktop support.

Key ResponsibilityRegister students to use the computers in the computer lab and keep the statistics. Assist students in using computer hardware and softwareReplace printer paperMaintain lab equipment like disk drives, monitors, keyboards, and other lab hardware.Observe lab occupants upon entering and leaving the lab to secure lab equipment.