Director of Data Management
Resume:
MARCHANT BOTHA
CURRICULUM VITAE
CONTACT DETAILS
Phone – Cell
071-**-**-*** / +27-71-41-77-999
Phone – Home
021-***-**** / +27-21-979-****
E-mail Address
*************@*****.***
Physical Address
13 Charles Way, Sonstraal Heights, Durbanville, Cape Town (SA), 7550
https://www.linkedin.com/in/marchantbotha/
@mb_sqldba
PERSONAL DETAILS
Surname
Botha
Name
Marchant
Passport No
414479715
Current Position
Principal Database Services / Senior Performance Analyst
Notice
1 month
Location
Cape Town
Date of Birth
1975/05/03
Title
Mr
Gender
Male
Affirmative Action
No
Nationality
South African
CAREER DETAILS
Main Skills
Principal SQL DBA
Senior Performance Analyst
BIG Data (HADOOP, Azure, AWS), Data Sciences, Python, Machine Learning
EDUCATION – SECONDARY SCHOOLING
Year Matriculated
1993
Last School Attended
Stellenberg High School
Subjects
Afrikaans, English, Mathematics, Business Economics, Biology, Geography
Matriculation Exemption
Yes
Activities
Rugby (First Team)
Athletics (Provincial Colours)
Cycling & Running
EDUCATION – TERTIARY
Period
Currently
Course Attended
Management Skills - Team Leadership Skills Masterclass 2020
Period
2020
Course Attended
Ultimate AWS Certified Solutions Architect Associate 2020
Period
2019
Course Attended
CCA 131 - Cloudera Certified Hadoop and Spark Administrator
Period
2019
Course Attended
CCA159 Advance Hive & Sqoop - Big Data Analytics & Ingestion
Period
2019
Course Attended
Data Sciences 2019
Subjects
Understanding of the data science field and the type of analysis carried out
Mathematics
Statistics
Python
Applying advanced statistical techniques in Python
Data Visualization
Machine Learning
Deep Learning
Tableau
Period
1994
Course Attended
Certificate in Business Practice/Computing
Institution
Cape Peninsula University of Technology
Subjects
Cost - and Management Accounting
Information Systems
Introduction to Programming
Business Practice
Development Software
Technical Programming
Statistics
COURSES COMPLETED
Year
Course
Institution
1994
Certificate in Business Practice/Computing
Cape Peninsula University of Technology
1999
Sybase DBA
Sybase (Cape Town)
1999
Seagate Crystal Reports 7
CS Holdings (Tokai)
2000
Redbrick Data Warehousing
CS Holdings (Tokai)
2006
SQL Server 2005 DBA
Netscope (Durbanville)
2006
SQL Server 2005: Designing Highly Performance and Reliable Systems
Microsoft SA (Kimberly Tripp, USA)
2011
MySQL DBA
2KO (Greenpoint Cape Town)
2015
Microsoft SQL Server 2012 Internals
Microsoft
CAREER HISTORY
Period
Current Employer
Current Position
Principal Database Services
Company
Sanlam (www.sanlam.co.za) & Santam www.santam.co.za
Industry
Financial Services & Insurance.
Responsibilities
Primary responsibilities are clinical data management, data analysis and database design.
Clinical data management includes interaction with project managers, software developers and clients regarding data quality and data transfers.
Data analysis includes descriptive analysis of reader performance and other metrics to assess the quality of services offered.
Database design is critical in big datasets for optimal performance.
Manage the planning, development and implementation of datasets to ensure adequacy, accuracy and legitimacy of data to enable the production of analysis and reports.
Drive and implement inovative solutions for performance problems on database technologies affecting relevant applications.
Provide database direction, architecture and strategic decisions for databases to enhance database experience.
Partner with the IT Management to drive the implementation of the IT Roadmap with regards to database technologies and new features in the database environment.
Ensure that business relevance and customer service experience are entrenched in delivery of fast performing database applications.
Identify business risks in area of responsibility and develop strategies for risk management and mitigation in accordance to IT Governance.
Focusing on resolving performance issues in the beginning of the SDLC (System Development Life Cycle) to circumvent potential issues once changes are implemented into production.
Assist application developers with problem analysis and resolution of development and production issues.
Initiate and manage projects related to production problems with development in the appropiate environments.
Coordinated with integrations and developers to ensure consistent, reliable and secure applications.
Provide guidance and knowledge transfer to development to support their goals and meet the requirements of the lines of business.
Assisting developers with database design, T-SQL tuning and using databases optimally.
Investigate and resolve bad performing code or potential bottlenecks.
Analyse database design, definition and performance of databases to improve existing business functions.
Period
October 2010 – November 2011
Current Position
Snr SQL DBA
Company
Mxit (www.mxitlifestyle.com)
Industry
Social Networking on Mobile phones.
Technologies
SQL 2005, 2008 & SQL Clustering and MySQL.
Responsibilitiy
My reposibilities are very much the same as can be seen below at my previous job at The Foschini Group with the inclusion of MySQL.
Reason for Leaving
MXit was sold and merged with another company. I was looking for security for my family.
Period
July 2005 - October 2010
Position
Snr SQL DBA
Present Company
The Foschini Group
Industry
Retail / Financial Environment
Technologies
SQL 2000 / 2005 + 64 Bit Itanium Cluster Servers.
Responsibilities
Responsible for the physical design, definition, control, monitoring and performance of all SQL Server databases at Head Office and Stores, which is in the region of about 1000 plus servers.
Provide technical services, consultancy guidance and education to support the goals and meet the requirements of the lines of business.
Production Support:
Provide and maintain technically stable and performing production environments.
Database Design and Definition:
Responsible for the design and implementation of the physical definition of databases in conjunction with application systems analysts.
Database Administration:
Establish and review processes and procedures for the effective use and exploitation of SQL Server database management systems.
Database Maintenance:
Enhance and maintain databases to accommodate new business functions and improve existing business functions.
Developer Support:
Assist application developers with problem analysis and resolution of development and production failures.
Database Consultancy:
Provide consultancy and guidance in the use and exploitation of database environments and infrastructures.
Recommend technical solutions to the client base.
Daily Activities:
Monitoring databases for performance tuning and capacity management purposes.
Building, managing and monitoring both production and non-production database environments.
Ensures optimal databases performance and database configuration and maintenance.
Investigates and resolves database problems and set standards, implements database security principles and guidelines.
Maintains knowledge of architectures, software and facilities available and potential value to the organisation.
Document all databases and keeping documentation up-to-date.
Design processes and procedures to ensure successful application availability, usage and data integrity.
Defining and maintaining database security structures.
Assisting application developers with database design, T-SQL tuning and using databases optimally.
Analysing and archiving database error logs.
Install, maintain, modify and upgrade database software and associated toolsets.
Provide thorough documentation of designs, procedures and best practices.
Committees
Foschini Group Social Committee 2006.
Reason for Leaving
New challenges with SQL Server 2008 exposure.
Period
January 2002 – June 2005
Position
SQL DBA
Industry
Financial / E-Commerce Environment
Company
DataCash
Technologies
SQL 7, SQL 2000
Responsibilities
Responsible for the back office management and processing of local and foreign online gambling transactions.
My primary functions as the DBA was to build, maintain and performance tune critical production databases.
This included everything from replicating data between SA, Australia and UK, writing stored procedures, backups, installation, configuration and administration of database software, designing effective and efficient logical and physical databases, reviewing database design changes and assessing impact of changes, calculating optimum database parameters, monitoring database performance, performance tuning, data analysis, establishing and administering database security, modeling data, SQL optimization and disaster recovery.
Also coordinated with integrations and developers to ensure consistent and secure applications.
Also troubleshoot user performance, monitor critical 24x7 processes and he was also responsible for the implementation and migration of MS SQL 7.0 databases to 2000, and beyond.
Achievements
Received the Top Ten Performers Award, 2003
Reason for Leaving
Company went through changes and I was looking for stability.
Period
1 August 2000 – 31 December 2001
Position
SQL DBA
Company
News 24 (Kalahari.com)
Industry
E-Commerce Environment
Technologies
SQL 7, SQL 2000, Oracle 8i
Responsibilities
Analyzed and designed database structures.
Created database, tables, views, users, indexes etc.
Developed stored procedures.
Performance tuning and troubleshooting.
Managed transfer of data between databases.
Managed database security.
Upgrades and general database maintenance.
Various ad hoc development requests.
Interacted with users to determine database requirements.
Backup and restore of databases as required by users.
Assisted development teams with database design.
Database replication.
Reason for Leaving
Contract ended.
Period
1 July 1999 – 31 July 2000
Position
Sybase DBA
Company
Finsource
Industry
Financial
Technologies
SQL 7, Visual Basic 6, Access, FrontPage, VB Script, HTML, Crystal Reports
Responsibilities
Maintained and developed production Sybase and SQL 7 databasis.
Developed systems over multiple platforms for our Unit Trust and Asset Management departments using Visual Basic 6, SQL, Access, FrontPage, VB Script, HTML and Crystal Reports.
Managed and maintained the Data Warehouse by creating scripts for loading and extracting data to Redbrick.
Reason for Leaving
Was looking for more E-commerce experience.
Period
1 May 1998 – 30 June 1999
Position
Analyst / Programmer
Company
Rousseau Consulting
Industry
Financial
Technologies
Visual Basic 6, Visual Basic 5, SQL, Access, Crystal Reports, Pastel Toolkits
Responsibilities
Developed applications that communicated with various Pastel Accounting packages.
Developed these programs using Visual Basic 5 and Visual Basic 6, SQL, Access, Pastel Toolkits and Crystal Reports.
Our clients where mostly small businesses like jewellery stores, bookstores etc.
Reason for Leaving
Career growth.
Period
1 February 1997 – 30 April 1998
Position
Programmer
Company
WAM Technology
Industry
Engineering
Technologies
Visual Basic 4, Visual Basic 5, SQL, Access
Responsibilities
The company I worked for designed systems for the CSIR and the Department of Water Affaires.
The systems had mainly to do with Coastal Engineering, like the calculation of pipeline flows, sea currents and harbour profiles.
Developed and maintained new and existing systems in Visual Basic 4 and 5, SQL 7and MS Access.
Reason for Leaving
Wanted to get more financial experience.
PROJECTS / WEB SITES DESIGNED
Period
2000 – 2001
Project URL
www.kalahari.net
Technologies
SQL DBA.
REFERENCES
Company
MXit
Contact person
Wessel Fourie
Position
Operations Manager
Phone Number
Company
The Foschini Group
Contact person
Edward Woolls
Position
Operations Manager
Phone Number
Company
Mercantrade (ProcCyber / DataCash)
Contact person
Stephen Moore
Position
Development Manager
Phone Number
Company
Kalahari.net
Contact person
Frank Theron
Position
IT Manager
Phone Number
Company
Rousseau Consulting
Contact person
Mr. Pierre Rousseau
Position
MD
Phone Number
Company
Finsource
Contact person
Richard Freeman
Position
IT Manager
Phone Number
Company
Stellenberg High School
Contact person
Mr. S Neethling
Position
Principal
Phone Number
021 991 029
Contact this candidate