• Login Name       Password       Remember me       LOGIN LOGIN    FORGOT PASSWORD


SQL Developer

Job Ref
Job Type
Employer Type
Date Added 8 Aug 2019
Expiry Date 5 Sep 2019
* There have been 26 applications to this job.
* This job has been viewed 3248 times.

Gauteng (Jhb)

ZAR600000 - ZAR900000 PA


Role details:
EBSphere is looking to recruit a SQL developer to join a dynamic and growing company. EBSphere developed an administration and accounting software package that is tailored for the retirement fund industry. The successful candidate will join a team of highly skilled consultants who maintain and enhance our core products
- - - - - - - - - - - - - -
Database Knowledge
The individual must understand the fundamentals relational database design.

Microsoft T-SQL
Extensive knowledge of T-SQL in the Microsoft SQL Server Environment.

The candidate must be able to fluently code stored procedures, views and functions. The individual must have solid experience with the various T-SQL constructs (joins, temp tables, CTEs, variable tables, functions, user defined functions).

The candidate must understand the fundamentals of indexing and should be able to analyse the performance of stored procedures in order to determine a course of action. The individual should be able to interpret an execution plan and should be able to use performance analysis tools to identify problems.

Database administration
The candidate should be able to do basic database administration. This is 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 finance (Accounting and Investments) is required.

Roles and Responsibilities.
• Using our log tracking system, the candidate will be responsible for identifying drawbacks and make appropriate improvements, in addition, the person will identify existing problems and implement appropriate solutions.
• The role requires interactions with clients’ business analysts (or systems teams) to establish requirements for new enhancements. Analyze these requirements in order to build new business functions or enhance existing ones using T-SQL, to ensure that quality work is delivered in accordance with client’s specification. For example, developing workflows (using our integrated workflow tool) to design business process flows or develop customized screens.
• Testing of various procedures.
• Resolve support queries that are logged on our “issue log” system. (The candidate will use and interpret existing stored procedures in order to resolve queries/errors).
• Analyse and resolve any system errors originating from the database.
• Query optimization.
• 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 our training department to document any new processes or changes to existing ones.

Most of our clients are based in Gauteng. 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