Database Developer
IOCO
Irene, South Africa
3d ago
source : Executive Placements

The Role :

We are recruiting a Database Developer to join our team in Irene, Centurion

Role Objective :

Liaise with the different Outsourced companies to ensure branch salaries are completed timeously and accurately and all statutory obligations in the different countries are complied with

Skills and Experience :

Qualifications Required :

  • B.Sc / B.Com Information Technology / Informatics / Computer Science
  • Experience required :

  • Proven experience as a Database Developer (3- 5years)
  • Experience within HRPayroll and Financial systems
  • 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 Symplexity and 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
  • Key Accountabilities :

    Duties / Responsibilities :

  • 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
  • Analyze 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
  • Other : Work environment :

    Work environment :

  • Open Plan office.
  • Hybrid work environment
  • Travel :

  • Must have a valid driverâ??s licence and own car
  • Travelling may be required.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form