Lakheni Voko

I hold a B-tech in Information Technology. I have been working in the Information technology space for over +8 years. During the years that I have worked I have gained experienced as well as knowledge of a number of progamming languages and softwares that are currently operational in the industry which include: SQL, MsSqL, MySQL, Oracle, Linux, CentOS, javascript, Qlikview, Google Data Studio, Google Cloud Platform, Visual Basic, MsExcel, Microsoft Outlook.

I am currently employed as a Database Administrator at SA Home Loans. My role is to carry out Database maintenance and administration, Database ugrades, ensure the accuracy and high standard of the data model, Leverage databases and information to ensure accuracy of data, maintain a standard meta throughout databases, monitor and analyse master data and relationship within the data and give support to backend production, technical as well as development teams.

Database Administrator - SA Home Loans

(2022-05)

Provide support to development, test and production databases. As a DBA I ensure to always attempt to troubleshoot issues and I am proactive in identifying potential problems. I pride myself in my ability to work closely with other teams including development and production support teams.

• Review database changes on the backlog, and assist with implementing and deployment of updates and scripts.
• Always strive towards product and technical excellence
• Investigates and reports on new technologies and solutions as and when needed.
• Is creative and innovative!
• Adheres to project management task prioritizations and allocations
• Takes accountability for his/her actions and ideas.
• Sets an example of quality and good work ethic to fellow team members, and raises the level of quality from your team
• Use database monitoring tools to send alerts and to configure, and refine these system monitoring tools and alerts to reduce false positives
• Respond to failure notices and escalation requests to fix production systems
• Assists with day-to-day administration of MS SQL Server and PostgreSQL databases like backups, restores, monitoring and running of jobs etc.
• Assisst with the implementation of systems enhancements
• Resolve environment issues timeously.
• Adhere to our change control processes.
• Implement, maintain and support best practices process related to the management of our DB infrastructure
• Exercise technical consistency within the IT environment.
• Strive to meet task deadlines as per project plans.
• Ensure stable operation, performance, and availability of development, test and production MS SQL Server and PostgreSQL environments through proactive monitoring, maintenance, and management
• Adhere to corporate policies in change management, incident management, and information security
• Exhibits progressive attitude to technology
• Assist with documentation on the configuration, infrastructure, and processes associated with the environment
• Manage application and user access to environments
• Assist with the execution of Month-End runs.
• Assist with UAT and Production deployments
• Deploy and test database server patches, maintenance jobs, and change scripts in development, test and production environments
• Fulfil requests for data exports between production and non-production environments
• Comply with best practices, development and management methodologies

Database Administrator - Vertex Communications Solutions (Promed Computer Services)

(2019-05 - 2022-05)

Perform database monitoring, maintenance and security. Enforcing database standard and ensuring integrity, validity and security of data. Designing database models and procedures to cope with large amounts of data. Carry out as400 migration to MySql and manage the flow of data between the two. Provide data analytics and visualization per client requests through the use of stitch data, Google BigQuery and Google Data studio.

• Manage and monitor the integrity of data at every client site
• Create tools for real time data availability and reporting
• Maintain a consistent standard of client metadata
• Manage the integrity of data and maintain the standard that is required by the client.
• Upgrade or update data models as growth of application occurs
• Upgrade databases
• Create procedures to enforce a level of consistency in the client application
• Creating a data model for new client
• Make additional changes to existing data models
• Perform integrity checks
• Indexing of databases
• Synchronize database model with client database (when upgrading the version of the database)
• Extract data from MySql into stitch
• Analyze data for reporting
• Create database replication
• Perform integration between databases
• Perform an upgrade of databases through linux
• Monitor linux server by checking activity (security)
• Configure database settings
• Checking client database size and growth and report findings
• Deploy mysql tuner and adjust databases to increase performance and stability
• Create logs for queries and save into a text file
• Make alerts for any security breaches
• Building resilient streaming systems
• Serverless Data Analysis with Google BigQuery and Cloud Dataflow
• Make use of this tool to analyse and visualize data
• Reports and dashboards as per client requests
• Find trends in visual data to help decision making

Analyst Mobility Support - Smollan (Mondelez)

(2018-04 - 2019-05)

• Functional Requirements Specification
• Managing monitoring application
• Make changes to application (adding features)
• Pull sync reports from qlikview
• Testing and implementation of new business processes/systems; working within project management teams; working within strategy and/or an operations environment, diagnosing process improvement opportunities and developing solutions using principles of process excellence and related tools, experience in Process Mapping and Business Process Reengineering (Process design and documentation)
• Microsoft SQL (for information needed in reporting)
• Managing an internal workflow application (front end)
• Design and implementation and maintenance specific reports using Qlikview and SQL as the delivery platforms
• Liaising with stakeholders around data collection and possible issues in the data supplied
• Working with stakeholders to support the definition and implementation of client service best practice
• Review data requirements and ensures that it is feasible to meet the needs of stakeholders
• Ensure that delivery occurs as committed
• Research, analyze, respond and resolve queries
• Reporting
• Data integrity checks and uniformity to ensure accuracy

IT Intern/Learnership Managed Service - EOH

(2017-05 - 2018-12)

Internship and Learning

• Server Infrastructure management, maintenance

Operational Intelligence (IT Intern) - EOH

(2016-06 - 2017-06)

Graduate Intern position

• First Line / Office support: SysAid queries (reporting and responding), device setup, setting up new users.
• IT Quotes for office equipment, Autotrack queries (reporting and responding), Stannic reporting (regarding reporting on company cars and allowances)
• Smollan Mobile application support: responding to queries from field staff

B-Tech - Information Technology - Tshwane University of Technology (2021)

National Diploma - Information Technology - Vaal University of Technology (2015)

Matric - Grade 12 - Germiston High School (2009)