Major responsibilities include designing, developing, testing, implementing and maintaining database systems, and for working closely with other IT professional’s diagnosing and troubleshooting applications and database-related issues.● Frequently importing high volumes of data into databases.● Ensuring accuracy as the data needs to pass audit checks. ● Working extensively on interfacing data between systems, by using linked servers, packages and SQL queries. This has required me to better my knowledge of SSIS and SSL encryption. ● Responsible for troubleshooting and supporting implemented database solutions. ● Recently became more involved in managing projects by ensuring all stakeholders are kept informed and pleased with progress on projects. ● Developed a good understanding of what’s required in terms of data security.● Consulting with clients to fully understand their needs and objectives.● Involvement in administrative requirements involved with regards to software projects.● Extensive experience with training and supporting software programs.● Responsible for database maintenance and troubleshooting. ● Responsible for database security.● Implemented interfaces which need to be POPPI Act compliant, whereby data security was a key concern.● Adding and modifying system/ user permissions to MS SQL databases.● SQL development, data analysis and administration.● Working with Transact SQL and Stored Procedures.● Implementing and troubleshooting of SQL Server Agent jobs. ● Responsible for creating tables, indexes and basic level querying.● Designing stored procedures, functions, tables, views, triggers, indexes and constraints.

I participated in the technical design of database applications and assisted in the reviewing and documenting of design applications.● Documenting product manuals.● Assisting with the business administration. ● Collected and processed client and prospect details and updated these in the company database. ● Trained clients on the use of software programs and managed the support of these projects post-training. ● Rolled out the application and database, ensuring that users are trained and supported.● Transitioned to the SQL database administration, development and implementation in 2014.● Proficient importing of data from other SQL databases, Access databases and Excel. ● Responsible for the administration and maintenance of client databases.● Involved in the product development and project management areas of the business. ● Continued learning how to develop solutions in Microsoft Access and became adept with MS SQL, in particular the administration and maintenance of databases for projects. ● Managed the backing up and restoring of databases for applications, version control, and development and testing.● Responsible for implementing databases for clients, including setting up logins and managing the associated permissions.