SQL Support Developer & Consultant

 

Recruiter:

Key Recruitment

Job Ref:

33935

Date posted:

Tuesday, May 18, 2021

Location:

Johannesburg Metro, South Africa

Salary:

Attractive package


SUMMARY:
Opportunity for a SQL Support Developer & Consultant with a top line software development business

POSITION INFO:

SQL Support Developer & Consultant

Our client is a top line software development, support and administration business specialising in the provision of a software solution specifically tailored for the retirement fund industry. They are looking to appoint a highly competent Support Developer & Consultant to join their team of highly skilled consultants who maintain and enhance their core products.

Specifically we are looking for someone with substantial Microsoft T-SQL experience as you will be required to apply your skills across our client''s various product offerings. In addition, you will be required to interact with various stakeholders and should be able to provide and implement holistic solutions.

The role requires that you understand the fundamentals of relational database design and be able to do basic database administration. This is not a DBA role, but DBA knowledge would be beneficial.

Specifically your tasks will include:

  • Using the tracking system, you will be responsible for identifying drawbacks and make appropriate improvements, in addition you 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. Analyse 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 the client''s specification. For example, developing workflows (using their integrated workflow tool) to design business process flows, or develop customised screens.
  • Testing of various procedures and their interactions.
  • Resolve support queries that are logged on "issue log" system. (You 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.

Required experience and educational profile

  • Extensive knowledge of T-SQL in Microsoft SQL Server Environment.
  • Your ability to fluently code stored procedures, views and functions using Microsoft SQL Server Management Studio is essential.
  • You are also required to have solid experience with the various T-SQL constructs (joins, temp tables, CTEs, variable tables, functions, user defined functions).
  • Furthermore you need to understand the fundamentals of indexing with ability to analyse the performance of stored procedures in order to determine a course of action. In addition you should be able to interpret an execution plan and should be able to use performance analysis tools to identify problems.

The business delivers an integrated accounting and admin system that operates in the financial sector. Knowledge of finance (Accounting and Investments) is required preferably supported by a B.SC Actuarial Science, or B.Sc (IT) / B.Com (IT) degrees.

On offer is a very competitive reward package including employee benefits, flexible working options relating to core hours and location and the opportunity to grow and be part of the evolving success story of a smart company.

To discuss the role please contact Allan Pike. Please submit your application ASAP via the online link associated with this advertisement but before the closing date of 1 June 2021.



 

NB! This job is now closed. You can apply for other jobs by uploading your CV.



 

 

 

Similar jobs you might be interested in:

Intermediate Software Developer
Location: Johannesburg
Salary: Market-Related
As an Intermediate Software developer, you''ll play a key role in designing, developing, and maintaining innovative software solutions.
2 days ago


Natural Adabas Developer
Location: Johannesburg
Salary: 600000 Annually
Salix Recruitment is partnering with a leading organisation in the car rental industry to appoint a Natural Adabas developer to join their dynamic IT team. This is an excellent opportunity for an experienced mainframe developer to contribute to the design, stability, and performance of key enterprise systems that drive operational excellence.This role offers the chance to work on business-critical...
4 days ago


Business Intelligence Developer
Location: Johannesburg
Salary: 600000 Annually
Are you a dynamic and innovative BI developer with a passion for data-driven solutions?
4 days ago


Software Developer
Location: Johannesburg
Salary: 800000 Annually
Our client is looking for the services of Software developer to be based in Sandton. You will need to have skills in C#, React, Angular, sql and Mobile applications. Send your CV now! 
7 days ago


BI Analyst / BI Developer
Location: Johannesburg
Salary:
7 days ago


Business Solutions Developer – Power Platform & Integrations
Location: Johannesburg
Salary:
Are you passionate about streamlining operations and building smart, scalable internal tools? Join a dynamic logistics and tech-driven environment where innovation meets impact.
8 days ago


Oracle e-Business Suite Application Developer
Location: Pretoria
Salary:
Join one of South Africa’s leading financial institutions as an Oracle E-Business Suite Application developer, supporting critical enterprise systems across Finance and Human Capital Management. This is a 12-month fixed-term contract offering exposure to large-scale systems, cutting-edge Oracle technologies, and the opportunity to contribute to high-impact enhancement and upgrade initiatives...
8 days ago


Full Stack Developer
Location: Johannesburg
Salary: 700 Annually
Full Stack developers wanted — Solve problems, build solutions, and make your code count.
13 days ago


PHP Developer
Location: Johannesburg
Salary:
Are you a passionate Full Stack developer ready to tackle complex challenges and drive digital innovation? Join a dynamic technical team at a leading communications and technology solutions provider, where your creativity, analytical mind, and technical expertise will help shape the next generation of omni-channel communication systems
13 days ago


Systems Administrator (ERP & Microsoft)
Location: Johannesburg
Salary: 700 Annually
If servers, ERP, and Microsoft 365 are your playground, we want you on our team!
13 days ago


Create a free job alert for SQL Support Developer & Consultant in Johannesburg Metro

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions