• Login Name       Password       Remember me       LOGIN LOGIN    FORGOT PASSWORD


SQL Developer

Job Ref
Job Type
Employer Type
Date Added 20 Jul 2018
Expiry Date 17 Aug 2018
* There have been 20 applications to this job.
* This job has been viewed 2519 times.


Market related


Role details:
Company Background
EBSphere is looking to recruit a senior SQL developer to join a dynamic and growing company. EBSphere develops an administration and accounting software package that is tailored for the retirement fund industry.

Database Knowledge
The individual must understand the fundamentals relational database design.

Microsoft T-SQL
Extensive knowledge of T-SQL in Microsoft SQL
- - - - - - - - - - - - - -
The individual must be able to fluently code stored procedures, views using the Microsoft SQL Server syntax. The individual must have a solid understanding of using the various T-SQL constructs such as joins, temp tables, variable tables, variables, user defined functions, built SQL functions, and common table expressions. Knowledge of SQL jobs and scheduling required.
The individual must understand the fundamentals of indexing and be able to analyses the performance of the database objects and create and modify indexes accordingly. This is an important requirement for us. Also with regards to performance tuning of the database, the individual must be able to interpret and act upon an execution plan in order to improve performance, and be able to use performance analysis tools. Individuals who have worked on very large databases would be beneficial for us.
This section above is the most critical requirement.

Database administration
The candidate should be able to do basic database administration such creating users as setting up or restoring a database for example when we do new client installations. This is however not DBA role, but DBA knowledge would be beneficial.

Accounting and Finance
Our system is an integrated accounting and admin system that operates in the financial sector. Knowledge of accounting would be highly beneficial. Knowledge of investments and investment management would be beneficial.

Roles and Responsibilities
Job responsibilities would be to analyze client’s requirements using and already existing system that is customized for our clients according to their needs. They will build various business functions or business processes using T-SQL, they will also be responsible for testing various procedures.
The person will be responsible for identifying drawbacks and problems with current processes and implement processes to improve them.
The person will also be responsible for developing workflows to accomplish these various business processes. The person would be involved in developing and maintaining processes that integrate with other systems such as banks and investment houses.
The role requires interactions with clients’ business analysts or clients systems team that establishes requirements.
The person will need to analyze and resolve any system errors.
There is also an element of data conversion and data cleansing (fixing) involved. We do use SSIS so SSIS would be beneficial.
The individual would need to optimize code as to minimize load on processing resources.
The person will liaise with our training department to document any new processes or expand on existing ones.
This is not a BI position.

The majority of our clients are based in Johannesburg. Work at clients might be required. We have clients in Midrand, Pretoria, Cape Town, Durban and a few clients in sub Saharan Africa. Travel outside Gauteng might be required.

IT related B.Com or B.Sc degree

A technical assessment for this position is required and usually takes about 1 hour.