JOB SEEKERS
EMPLOYERS
JOBS QUICK-SEARCH
.net
.net developer
a+
abap
account manager
accountant
admin
administrator
analyst
architect
bookkeeper
business analyst
business intelligence
c#
call centre
ccna
cisco
cloud
cobol
consultant
delphi
desktop
desktop support
developer
engineer
finance
graduate
graduates
helpdesk
internship
it manager
it support
it technician
java
java developer
junior developer
legal
linux
manager
marketing
mcse
network
network administrator
oracle
personal assistant
php
php developer
programmer
project
project administrator
project manager
receptionist
sales
sap
secretary
security
sql
support
technical support
technician
test analyst
tester
web developer
NEWSLETTER
FOLLOW US
SQL Developer
Job Ref
279379
Job Type
Permanent
Employer Type
Company
Date Added
20 Jul 2018
Expiry Date 17 Aug 2018
Expiry Date 17 Aug 2018
* There have been 20 applications to this job.
* This job has been viewed 4030 times.
Employer:
EBSphere
Location:
Gauteng
Salary:
Market related
Benefits:
Role details:
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
- - - - - - - - - - - - - -
Environment 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.
Travel
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.
Qualifications
IT related B.Com or B.Sc degree
Assessment
A technical assessment for this position is required and usually takes about 1 hour.