An established software development company which does advertising management based in Johannesburg is looking 2nd Line Support Engineer to fulfil and uphold the company values of personalised, high quality service by finding solutions to problems that team members and users alike are experiencing. The candidate will become part of a young and dynamic team of technology enthusiasts. The candidate will be offered an opportunity to learn new products and technologies, so that they may deliver the highest level of support to client facing colleagues and service to customers.
MS SQL Based Support
Provide telephonic, e-mail and onsite support
Support first line staff members where further technical assistance is required
Troubleshooting and resolving technical issues
Onsite diagnosis of technical problems
Interacting with development staff where solution requires their input
The ideal candidate will need a strong proficiency in Microsoft SQL. This includes:
Creation and understanding of SQL Objects
Includes Views, Tables, Stored Procedures & Functions
Understanding of SQL Data Types
Data Analysis & Queries
Querying Data view Select Statements
Usage of subqueries
Working with JOINS & AGGREGATE FUNCTIONS
Combining of data sets (via UNIONS)
Troubleshooting & Optimisation
Ability to identify optimisations to queries / views / procedures
Usage of SQL transactions
Development of Data Import mechanisms
Usage of Temp Tables
Imports from other data structures (CSV, TXT, API, Other databases)
Firm understanding of XML structures and format
Experience and knowledge that would be advantageous for this role include:
A logical thinker and problem solver with analytical skills
Experience in Report Writing (SSRS)
Experience in general IT / Network support.
Experience with data manipulation using Microsoft Excel
A background in software application support
Ability to function well under pressure
An understanding of financial concepts and bookkeeping processes or a background in working on or supporting financial systems such as Pastel, Accpac, QuickBooks, Sage, SAP or any of the Microsoft Dynamics ERP packages.
Good interpersonal and communication skills. Must be able to talk about technology in simple terms
A willingness to learn and to keep up to date with the latest technology
Strongly self-motivated and able to organise their own day
Ability to work independently
General technical knowledge and aptitude.
Familiarity with the advertising industry
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to firstname.lastname@example.org and mention the reference numbers of the jobs.