Job Description
- Develop complex T-SQL queries, Stored Procedures and Triggers.
- Assist in the design of the relational database architecture for new development projects.
- Develop new / alter existing SQL objects based off a set of requirements.
- Troubleshoot SQL objects that fail.
- Support the development team in troubleshooting application performance using SQL profiler and optimizing SQL queries or tuning indexing.
- Service requests from business, which include changes to processes or ad hoc data requests.
- Develop according to set coding standards and processes.
- Collaborate with Business Analysts to define the scope and goals, track milestones, decide priorities, and report regularly to team leaders and BA’s.
- Work with Business Analysts to identify and understand source data systems.
- Contribute to all phases of the SDLC process extending from requirements gathering and design to development, testing and deployment.
- Investigate and fix production issues.
- Develop and test extraction, transformation and load processes.
- Supporting production databases.
Desired Experience & Qualifications:
- Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences.
- Relevant Microsoft Certification (SQL Developer/Azure) will be beneficial.
- 2 years of relevant experience as an Intermediate SQL Developer as part of a team in a software development environment.
- Ability to work in a team environment: Follow mentorship/provide team leader mentorship, collaborate on a common (UML) design model.
- A good understanding of the SDLC process, tools, and techniques specifically as applied to software development methodology.
- Experience working with security-sensitive data (beneficial).
Skills and Knowledge Requirements:
- Knowledge of security vulnerabilities and working impact on solutions.
- Experience of the following in Microsoft SQL Server:
- Relational database design principles
- Understanding of SQL Server Administration
- SQL OLTP development, query optimization, SQL Query analysis
- Database object design
- XML and JSON structures (beneficial)
- Basic understanding of front-end languages like HTML, CSS, JavaScript is beneficial.
- Ability to deliver production-quality software by e.g. paying attention to detail, doing extensive unit testing, and supporting quality testing phases.
Knowledge and Experience of the Following Toolsets:
- SQL Server Management Studio 2012 upwards
- SQL profiler (beneficial)
- Some knowledge on cloud services like Azure, AWS (Beneficial)
- Good understanding of data integrity and security best practices
- Hands on experience in Exception Handling and Troubleshooting
- Troubleshooting slow running queries, Profiling Performance Issues (Beneficial)
Apply now!
If you possess the skills and experience required for this role, we invite you to apply and become an integral part of an innovative team.
If you are interested in this opportunity, please apply directly. For more IT jobs, please visit www.********.co.za. If you wish to send your CV per email forward your CV to *****@*****.co.za and copy the reference number in brackets in the subject line of your e-mail.
If you have not had any response in two weeks, please consider the vacancy application unsuccessful. Your profile will be kept on our database for any further possible positions.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Get references ready before you need them - keep in touch with past managers and colleagues.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Centurion: Receptionist/Telesales posted by Creative Leadership Solutions
REQUIREMENTSMinimum education (essential):National Senior CertificateMinimum applicable experience (years):1-3 yearsRequired nature of...
Centurion: Mechanical Engineering Graduates posted by Network Finance
Are you a recent graduate or busy finishing your degree for Mechanical Engineering ready to launch your career?We’re looking for…
View JobRichards Bay: Systems Analyst posted by Sharon Nurock Recruitment cc
This is a hands-on role that demands initiative, adaptability, and a sharp eye for detail. You’ll need to balance urgent…
View JobWestern Cape: Recruitment Specialist posted by Persona Staff
Responsibilities:Contribute to the overall management and strategic planning.Manage the vacancies and recruitment advertising channels.Develop and maintain...
View JobBoksburg: Technical Sales Rep. posted by Ann Swann Personnel Services
Key Responsibilities1. Lead Generation & Market ProspectingProactively identify and qualify sales leads through cold calling, networking, referrals, and...
View JobWestern Cape: Service Technician Millwright posted by West Coast Personnel
Role Overview:IPEX Machinery seeks a skilled Service Technician to provide on-site technical support, maintenance, and repairs for our range of…
View Job
Browse Employers
Job Alerts