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
281603
Job Type
Permanent
Employer Type
Company
Date Added
8 Aug 2019
Expiry Date 5 Sep 2019
Expiry Date 5 Sep 2019
* There have been 27 applications to this job.
* This job has been viewed 5835 times.
Employer:
EBSphere
Location:
Gauteng (Jhb)
Salary:
ZAR600000 - ZAR900000 PA
Benefits:
Role details:
- - - - - - - - - - - - - -
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.
Travel
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.
Qualifications
IT related B.Com or B.Sc degree
Assessment
A technical assessment for this position is required and usually takes about 1 hour