Database Developer

 

Recruiter:

IOCO

Job Ref:

iOCO00880

Date posted:

Friday, May 6, 2022

Location:

Pretoria, South Africa

Salary:

Negotiable


JOB SUMMARY:
The Role:

Essential functions:

  • Development of high-quality database solutions 
  • Develop, implement, and optimize stored procedures and functions using T-SQL
  • Review and interpret ongoing business report requirements
  • Research required data

    JOB DESCRIPTION:

    The Role:

    Essential functions:

    • Development of high-quality database solutions 
    • Develop, implement, and optimize stored procedures and functions using T-SQL
    • Review and interpret ongoing business report requirements
    • Research required data
    • Build appropriate and useful reporting deliverables
    • Analyse existing SQL queries for performance improvements
    • Suggest new queries
    • Develop procedures and scripts for data migration
    • Provide timely scheduled management reporting
    • Investigate exceptions with regard to asset movements

     

    Skills and Experience:

    Preferred Qualifications:

    • B.Sc
    • B.Com Information Technology 
    • Informatics
    • Computer Science
    • 3 year Diploma Information 

    Experience required:

    • Proven experience as a Database Developer (3- 5years)
    • In-depth knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
    • Assisting in database design and technical specifications
    • Monitoring SQL performance issues and efficiency (Dead lock tracing etc.)
    • Creating and optimising complex SQL queries for data extraction
    • Developing and maintaining interfaces between other systems.
    • Ability to understand complex technical and logical concepts.
    • Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required.
    • Familiarity with RDBMS principles, database design and normalization
    • Experience with complex query design, stored procedures, views and functions
    • Understanding of index design and T-SQL performance tuning techniques

    Following skills are a plus:

    • Crystal 8.5, 10 or 11 knowledge
    • MS Reporting services
    • BI, SSIS and Cubes knowledge
    • General payroll and mining industry knowledge
    • VB, ASP .NET, C#, Javascript experience
    Other:

    Travel:

    • Must have a valid drivers licence and own car
    • Travelling might be required but the person will mostly be office based. Home based at the moment due to COVID

     

    NB! This job is now closed. You can apply for other jobs by uploading your CV.



     

 

 

Similar jobs you might be interested in:

Senior Developer
Location: Johannesburg
Salary:
Today


Software .Net Developer
Location: Cape Town
Salary:
Today


Software Developer
Location: Cape Town
Salary:
Today


Lead Developer (.NET & AWS)
Location: Cape Town
Salary:
Today


SQL Developer
Location: Cape Town
Salary:
Today


SQL Developer
Location: Durban
Salary: Market-Related
As a SQL developer, you will design, develop, and maintain high-performance SQL code and database structures that support critical retail and enterprise operations.
1 day ago


PHP Developer (Back-End)
Location: Johannesburg
Salary: 35000 Monthly
Are you a passionate PHP developer ready to take your back-end skills to the next level? Join a fast-paced, tech-driven team where innovation and collaboration are at the heart of everything we do.
1 day ago


Business Developer
Location: Cape Town
Salary: 800000 Annually
We’re recruiting on behalf of a Cape Town-based client looking for a dynamic and results-driven Business developer to join their team. This is a great opportunity for a motivated professional with strong commercial insight and a passion for renewable energy to drive growth and build lasting business partnerships.
1 day ago


IT Software Developer
Location: Port Elizabeth
Salary:
1 day ago


Java Developer
Location: Pretoria
Salary:
🚀 Java developers - Build, Innovate, and Scale!
4 days ago


Create a free job alert for Database Developer in Pretoria

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions