SQL Developer (CPT/PTA)
Full-time
Recruit-It
Responsibilities/Tasks:
Requirements:
Skills and Knowledge Requirements:
Personal Profile:
- Develop and maintain SQL queries, stored procedures, triggers and database objects.
- Contribute to database design and relational architecture for new and existing systems.
- Develop new / modify existing SQL objects based on business requirements.
- Troubleshoot SQL objects and resolve database-related issues.
- Support application performance troubleshooting using SQL profiling and query optimisation.
- Service business requests, including data extraction and process changes.
- Collaborate with Business Analysts to understand requirements and data sources.
- Participate in all phases of the SDLC, including development, testing and deployment.
- Investigate and resolve production issues and support database environments.
- Develop and test ETL processes.
- Monitor and maintain database performance, security, and integrity.
- Contribute to team standards and, where applicable, mentor junior developers.
Requirements:
- Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences and/ or Matric with at least 5-10 years relevant experience as a SQL developer as part of a team in a software development environment
- Relevant Microsoft Certification (SQL developer/Azure) will be beneficial.
- 5-10 years relevant experience as a SQL developer as part of a team in a software development environment, including the role of leading Developer within a team.
- 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:
- Understanding of SQL Server Administration
- SQL OLTP development
- SQL Query optimisation
- SQL Query analysis
- Database object design
- Database design principles
- XML and JSON structures (beneficial)
- Good XML manipulation skills in XQuery. (beneficial)
- Basic understanding of front-end languages like HTML, CSS, JavaScript (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
- Some knowledge of cloud services like Azure, AWS (Beneficial)
- Solid understanding of data integrity and security best practices.
- Hands-on experience in Exception Handling and Troubleshooting
- Troubleshooting slow-running queries, Profiling Performance Issues
- Ability to stay within the scope, timelines and constraints of the project and, if not possible, to raise/negotiate alternatives.
Personal Profile:
- Self-starter and highly self-motivated, with a strong sense of ownership and the ability to drive tasks and initiatives to completion.
- Resilient and emotionally mature, able to receive feedback constructively and not easily offended, maintaining professionalism in all interactions.
- Calm and composed under pressure, with the ability to work effectively in high-stress environments while delivering consistent results.
- Strong team player, with experience collaborating across cross-functional teams; prior experience in leading or mentoring development teams is advantageous.
- Excellent written and verbal communication skills, with strong interpersonal abilities suited to both technical and non-technical stakeholders.
- High attention to detail, with a strong commitment to producing clean, maintainable, and high-quality code.
- Proven ability to conduct root cause analysis in complex, integrated environments, especially under severe operational pressures.
- Strong analytical and problem-solving skills, with the ability to multitask and manage multiple priorities simultaneously.
- Lifelong learner, committed to ongoing professional development and staying current with evolving technologies and best practices.
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the SQL Developer (CPT/PTA) in Gauteng vacancy
- ...year. Solid proficiency in .NET C#, with proven expertise in developing enterprise-grade web applications. (VB is an advantage). A... ...utilisation, and structured data handling. Experience with SQL and relational database development, specifically Microsoft SQL...
- ...and Units Per Transaction (UPT) Improve overall store productivity Team Leadership & Performance Lead, motivate, and develop a high-performing sales team Drive sales per employee and team productivity Manage staff performance, training, and development...
- ...within the set standards required by the company thus contributing to the productivity of the branch. Assist the Broker Consultant to develop and maintain effective business relationships with brokers in order to attract develop and retain profitable business. Assist where...
- The Business Support Agent provides technical support and troubleshooting for customers using wireless, fibre, and voice services. This role involves first line support, striving for first-time resolution, and managing customer interactions across multiple channels. The...
- The IT Business Support Specialist plays a key role in delivering advanced technical assistance and ensuring a high standard of customer satisfaction. This role focuses on providing in-depth troubleshooting, supporting complex customer setups, and driving first-time resolution...
- ...Key Responsibilities: Develop and maintain full-stack web applications using C#, .NET, TypeScript, HTML, and CSS. Design and build... ...secure RESTful APIs and system integrations. Develop and optimise SQL databases, queries, and stored procedures. Mentor junior...
- Adendorff Machinery Mart sources equipment from all over the world to offer the greatest range of products at the best prices. The changing global economy is placing new and increasing demands on companies, and the market place is marked by increased competition worldwide...
- This is an excellent opportunity for an experienced mainframe developer to contribute to the design, stability, and performance of key enterprise... ...code reviews. ~ Technical Skills: Natural 4GL, Adabas, JCL, SQL, Power BI (advantageous) and Mainframe environments and tools (...
- ...Senior Automation Design Practitioner is responsible for designing, developing, and maintaining advanced automation solutions that drive... ...developer with experience on different languages (Java, C#, C++, SQL) Experience testing product functionality; Experience with...
- ...to join our expanding Guidewire/Insurance team. As a Guidewire Developer you will be responsible for participating in business requirements... ...working with GOSU, JAVA 5/ J2EE, Web Services (Axis 2), XML, SQL, Gradle, Spring, Hibernate, Castor, REST/ JSON and Enterprise Messaging...
- ...production runs. The programs that need to be run include software developed in-house as well as third party software. For all these, the... ...input files need to be created, usually by means of C/C++ programs, SQL and shell scripting. Some of these input files themselves can be...
- ...Mentoring / Team development: Actively coach other developers to understand and apply the Insure coding and architectural standards... ...JAXB SOAP Web services Message Driven Beans UML XML/XSD SQL Education and Experience Education: Matric...
- Key Responsibilities: Develop and maintain full-stack solutions using C#, .NET, TypeScript, HTML, CSS3 Design and build secure,... ...integrations (cloud, third-party, legacy) Write and optimize SQL queries and database structures Conduct code reviews and ensure...
- ...Graad in Inligtingstegnologie, Rekenaarwetenskap, Sagteware-ontwikkeling of verwante veld Minimum 2 jaar ervaring as Software Developer of in 'n soortgelyke ontwikkelingsrol Ervaring met backend-ontwikkeling Goeie kennis van JavaScript Ervaring met databasisontwikkeling...
- ...About the Role The Full Stack Microsoft Developer Engineer exists to build high-performance web and mobile applications. You will directly... ..., improve, and manage relational databases using Microsoft SQL Server daily. Make cloud-ready applications using Microsoft Azure...
- ...Basic AWS services (S3, Lambda, Glue, IAM, QuickSight) Strong SQL skills (Oracle, Postgres) GitHub version control Cloud architecture... ...DevOps practices and tooling Roles & Responsibilities Develop and maintain front-end and back-end application components...
- ...Key Responsibilities Develop and maintain full-stack applications (frontend + backend) Design and implement microservices and API-... ...frameworks Backend & Data Python RESTful Web Services SQL (Oracle, PostgreSQL) Microservices Architecture Cloud &...
- ...platform consulting and Technology company is looking for a Senior Developer to lead the team in Johannesburg, GP. You will play a key role... ...365 and Epicor). Develop high-quality C# and Microsoft SQL applications aligned with business needs. Implement integration...
- ...Minimum Requirements: Must have a minimum of 5 years experience as a Developer in the ICT Industry Bachelor’s degree in Computer Science, Software Engineering, Information Systems required Proficient in C# | HTML | .NET | MSSQL essential Strong knowledge of...
- ...of AWS services (S3, Lambda, Glue, IAM, QuickSight) Strong SQL skills (Oracle, PostgreSQL) Experience with GitHub and... ...Expertise in RESTful web services Proven experience designing and developing microservices and API-driven solutions Good understanding...
- ...level.The Role We are looking for a QA Engineer & Application Developer who wants the best of both worlds: ownership over software... ...testing releases, while also building UI components, writing advanced SQL, and developing edge functions. Key Responsibilities...
- ...Experienced Aesthetic Therapist/ Somatologist Urgently needed in Lynnwood – PTA JOB REQUIREMENTS ~ FULL Somatology Diploma. ~ First Aid & CPR Certificate. ~3-4 years of working experience in a busy Spa environment as a Somatologist doing Somatology Treatments....
- ...opportunity to make a real impact in the PSG success story. Design and Develop PSG Wealth transactional websites, Line of business systems and... ...frameworks. Strong expertise in C# .Net, .Net frameworks, and SQL Server (2012+). Proficiency in Angular. Knowledge of...
- ...opportunity to make a real impact in the PSG success story. Design and Develop PSG Wealth transactional websites, Line of business systems and... ...understanding of the software development process C# .Net SQL Server 2012+ "Modern JavaScript libraries" - Angular,...
- Welcome to PEP! PEP is AfricaâÃÂÃÂs largest single brand retailer operating around 1800 stores in Southern Africa. As well as clothing and footwear, PEP sells homeware, FMCG, cellular and airtime products and also offers a range of other services such as cash-backs...
- ...industry and our country. Key Responsibilities Assist in developing and testing AI-driven solutions and automation tools. Support... ...Microsoft Office Suite, especially Excel Exposure to Python, SQL, Power BI, or automation tools will be advantageous Strong...
- ...an enthusiastic and motivated Junior Business Intelligence (BI) Developer to join our growing team in either Cape Town (CT) or Johannesburg... ...to collaborate and learn from others. Basic understanding of SQL and database concepts is advantageous. Awareness of ETL processes...
- ...We are seeking a skilled and solutions-driven Senior Sage X3 Developer to design, develop, customize, and maintain Sage X3 ERP solutions... ...development, workflows, and system integrations. Proficiency in SQL, X3 Scripting, 4GL, GraphQL, C#, Java, PHP, HTML, and other relevant...
- ...with small and medium businesses, and render specialised services developed to adapt to any companyâÃÂÃÂs unique needs. We offer... ...with Git and version control workflows Exposure to databases (SQL preferred, e.g. SQL Server) Familiarity with HTML, CSS, and responsive...
- ...ceremonies. Meet with end users to understand Business requirements. Contribute to the refinement and sizing of user stories. Develop systems solutions in line with quality and delivery requirements. Identify risks / impediments and proactively resolve and / or...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to SQL Developer (CPT/PTA). Be the first to apply!
