SQL Developer

Dotcom is a leading software development, IT consulting and cyber security entity. We have been operating in South Africa, since 2012. Our cutting-edge software has revolutionised varying sectors, with our main focus being the global insurance market. Dotcom's experienced footprint has grown substantially, which expands from South Africa into Africa - and even reaching as far as China.

We are currently recruiting a SQL Developer with the following skills: 

Job Description

1. Develop high-quality database solutions.
2. Use T-SQL to develop and implement stored procedures and functions essential for API and FE developers, such as Mobile and Policy Administration Systems.
3. Review and interpret ongoing business report requirements.
4. Research required data.
5. Build appropriate and useful reporting deliverables.
6. Analyze existing SQL queries for performance improvements.
7. Suggest new queries.
8. Develop procedures and scripts for data migration.
9. Provide timely scheduled management reporting.
10. Investigate exceptions with regard to asset movements.
11. Translate business needs to technical specifications. 
12. Design, build and deploy solutions which includes reporting tools. 
13. Create tools to store data. 
14. Conduct unit testing and troubleshooting when needed
15. Collaborate with teams to integrate systems 
16. Develop and execute database queries and conduct analysis. 
17. Create visualizations and reports for requested stakeholder needs. 
18. Develop and update technical documentation 
19. Treat client information as confidential and ensure data security at all levels. 
20. Implement data integrity and security measures. 

Tasks & Responsibilities

1. Database design and build 
2. Advanced T-SQL and SQL scripting experience 
3. 5+ years data analysis experience 
4. 5+ years data presentation design and build (reports and dashboard) experience 
5. 5+ years SQL Development experience 
6. Advanced Microsoft Excel 
7. Experience and sufficient knowledge: 
8. Microsoft SQL Server Integration Services
9. Microsoft SQL Server Reporting Services
10. Microsoft SQL Server Analysis Services

Soft Skills

• Must have an entrepreneurial spirit/negotiation skills. 
  • Must be able to communicate above average both verbally and non-verbally in English.  
  • Must be an active listener. 
  • Must have an analytical mind and be able to learn new concepts fast. 
  • Must have attention to detail. 
  • Must always be presentable. 
  • Must be a self-starter. 
  • Must have good time management. 
  • Must have good conflict resolution skills. 
  • Must have a good work ethic. 
    • Spell check all documents generated. 
    • Adhere to all internal and external HR policies.