SQL Developer(JB)Location : Rosebank, JohannesburgSalary : Negotiable based on experience up to R per annumRemote : Flexible for Senior DevelopersDuration : PermanentAbout the Company : Established over 20 years ago, this software solution company boasts strong staff retention, with products that are widely used in the retirement fund industry and opportunities for Senior staff members to work remotely.
The environment is casual, provides mentorship for senior staff and applications are open to anyone living in South Africa who meets the skill requirements.
About the candidate : Ideally, applicants should live in the Gauteng region, have completed a BSc Actuarial Science, BCom or BSc In Information Technology and have extensive experience in T-SQL in a Microsoft SQL Server Environment.
Candidates must be able to create calculated data in the back-end.Applicants must be willing to travel both within South Africa and Sub Saharan Africa to the client site when required.
About the position : We are looking for candidates with substantial Microsoft T-SQL experience. The successful candidate will be required to apply their skills across our various product offerings.
In addition, the candidate will be required to interact with stakeholders and provide and implement holistic solutions and should have a strong technical focus.
Candidates must understand the fundamentals of relational database design.The candidate must fluently code stored procedures, views and functions using Microsoft SQL Server Management Studio.
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 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.
The candidate should be able to do basic database administration. This is not a DBA role, but DBA knowledge would be beneficial.
Duties : Using a 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.
Analyse these requirements to build new business functions or enhance existing ones using T-SQL, to ensure that quality work is delivered according to the clients specification.
For example, developing workflows (using an 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 our issue log system. (The candidate will use and interpret existing stored procedures 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 the training department to document any new processes or changes to existing ones.