SQL Support Developer & Consultant

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.