Van Zyl - SQL Server Developer - Johannesburg, GP, South Africa

Marco Van Zyl

Johannesburg, GP, South Africa


SQL Server Developer


I was part of different projects where I was sitting in the initial discussion meetings with the business owners and had to identify all the relevant players and the structures they are part of.
had to document all information of the project using technologies like visio UML and basic notes.
I had to identify all entities and attributes and decide on the relevant datatypes to be used, and the entity relationships. I was also in charge of the planning and implementing phase of the designing installing of the sql servers and was responsible for the creation of a maintenance and backup strategies.
I was also responsible for the trouble shooting of long running queries and had to make recommendations for hardware upgrades and implementations of indexing and other querying techniques related to performance like partitioning tables and spreading the data over multiple files and file groups.
I had to be part of scrum meetings and had to report on any issues that I picked up within the design or performance of the database and had to meet deadlines created for the production environment.
I was also part of a project where I had to create a data mart and populate the OLAP tables with data using basic ETL techniques and had to create a CUBE accordingly so the customer could generate his reports more efficiently.

I automated the backup strategies by creating jobs that was executed on scheduled time periods and generated mails to be sent to key individuals for when an error or issue may arrise.

one other responsibility was to create new users and roles and apply and manage security for applications and users that needed access to the database.

Work History

IT/Network technician


From June 2009

➢ Responsible for the installation, maintenance and optimizing of the sql server
➢ Troubleshoot existing database structures and create or alter it for optimal performance using the various sql server 2008 tools(performance monitor, SQL-profiler, database management views and system functions)
➢ Automating backups and creating SSIS Packages
➢ Schedule jobs accordingly and setup operators to be notified when a failure or error occur.
➢ Looking at the database structure and procedures and creating / alter parameterized procedures and indexes and other programming objects
➢ Partition tables and creating files and file groups to spread the work loads and data accordingly for performance.
➢ Created a disaster and recovery strategy
➢ Giving advice to other developers on how to develop query structures optimising the queries for optimal performance and using resources efficiently within the applications that consumes the data and procedures.
➢ Creation and implementation of tables with constraints for data integrity and setting up relationships.
➢ Administering security on the databases and setting permissions accordingly
➢ Keeping documentation of all design and implementations and scrum meetings and report with management and give training to employees and students where necessary.
➢ Creating web applications for the local use by staff using and c#
➢ Implementing information structures and design by using different technologies like (, jQuery, Linq to Entity, css/HTML, ADO.NET, AJAX and MVC )with the different .Net frameworks up to version 4.5
➢ Planning and managing the process of development projects from beginning to end making sure it adhere to specific standards, models or deadlines put by management/client.

Qualifications & Certifications

New Horizons IT Learning Centre

Graphic Web Design

Prestige College

Skillpages has been acquired by! is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?