Log In

Don't have an account? Sign up now

Lost Password?

Sign Up

Photo

Velile **** Developer

Roodepoort, Gauteng R30 000 / Month linkedIn VELILE-JUTA-CV-2.pdf
Administration / OfficeGeneralInformation Technology
  • Nationality: South African
  • Gender: Male
  • Ethnicity: African
  • Employment Level: Intermediate
  • Career Experience: 3 - 5 Years
  • Employment Status: Employed
  • WHY DATABSE DESIGN

    Databases are incredibly important in our modern world. Database administration and design it’s one of the most important skill to obtain as they remain a mystery to most people, but they are easy to use if you know just a few things. I want to be able to demonstrate my broad skill sets in SQL Server administration and in building enterprise-scale data solutions both on-premises and in cloud environments and given skills in database installation, maintenance, configuration and provisioning tasks.
    I can fluently code stored procedures, views and functions using Microsoft SQL Server Management Studio. I have solid experience with the various T-SQL constructs (joins, temp tables, CTEs, variable tables, functions, user-defined functions). I understand the fundamentals of indexing and I’m able to analyse the performance of stored procedures to determine a course of action. I’m able to interpret an execution plan and able to use performance analysis tools to identify problems.
    I will be responsible for identifying drawbacks and make appropriate improvements, in addition, I can also identify existing problems and implement appropriate solutions.
    My role requires interactions with clients business analysts or systems teams to establish requirements for new enhancements. Analyse these requirements to build new business functions or enhance existing ones using T-SQL, to ensure that quality work is delivered according to the clients specification. For example, developing workflows (using an integrated workflow tool) to design business process flows, or develop customised reports.
    Resolve support queries that are logged on our “JIRA” system and Agile principles.

    Analyse and resolve any system errors originating from the database.
    Writing of reports and creating report templates.
    Data conversion, and data cleansing will be required at times. Knowledge of SSIS would be advantageous.
    Liaising with the training department to document any new processes or changes to existing ones.
    I have been involved in major web development and data clean-up projects like:
    • Automating custom reports for clients using data tools (SSIS)

    Electronic FICA (KYC: Know Your Client) verifications and validations.

    Cleaning, fixing, matching and enrichment of customer data.
    Address cleaning.
    Tracing tools.

    • Processing big data sets (CPA load reports and bureau batch enquiries)

    Data mining.

    • Involved in the daily and monthly billing processes of the company

    Education

    2021-01-02 DATABASE DESIGN AND ADMINISTRATION at ATTI BLOEMFONTEIN

    • Querying data with Transact-SQ
    • Developing SQL Databases
    • Administering a SQL Database Infrastructure
    • Provisioning SQL Database

    14-04-2020 SQL Fundamentals at SOLO LEARN

    SQL Fundamentals course

    24-07-2019 Blockchain_Intro at IBM
    24-07-2019 Cloud_Intro_Badge at IBM
    21-11-2019 Coding_Intro_Badge at IBM
    16-12-2019 Create_Your_Own_Web_Page_Badge at IBM
    22-10-2019 JavaScript_Badge at IBM

    Experience

    2018-05-01 Developer at Xpert Decisions Systems

    I can fluently code stored procedures, views and functions using Microsoft SQL Server Management Studio. I have solid experience with the various T-SQL constructs (joins, temp tables, CTEs, variable tables, functions, user-defined functions). I understand the fundamentals of indexing and I’m able to analyse the performance of stored procedures to determine a course of action. I’m able to interpret an execution plan and able to use performance analysis tools to identify problems.