Intermediate SQL Developer

1 month ago

South Africa Recru-it Full time
Responsibilities/Tasks:
  • 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 scope and goals, track milestones, decide priorities, and report regularly to team leaders and BAs.
  • 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.
  • Work in a very data driven environment and use data analysis skills to anticipate and fix bugs.
  • Supporting production databases.
  • Monitor production databases regularly or respond to any database issues by bringing down the database or taking the database offline.
  • Monitoring or optimizing the performance, security, backup, recovery or integrity of database management systems.

Requirements:
  • Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences.
  • Relevant Microsoft Certification (SQL developer/Azure) will be beneficial.
  • 2 years 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
  • SQL Query optimization
  • SQL Query analysis
  • Database object design
  • XML and JSON structures (beneficial)
  • Good XML manipulation skills in XQuery (beneficial)
  • Basic understanding of front-end languages like HTML, CSS, JAVA script (Beneficial)
  • Ability to deliver production quality software by e.g. paying attention to detail, do extensive unit testing and support 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)

Personal Profile:
  • Self-starter, self-motivated, team player
  • Excellent communication, interpersonal and collaboration skills
  • Strong attention to detail and accuracy.
  • Able to work under pressure and meet deadlines
  • Able to apply standards
  • Strong sense of responsibility, not only for own scope of work but also for the entire solution and reputation of the company and clients.
  • Analytical thinking.
  • Quick learner and retainer of knowledge
  • Fast to comprehend and solve complex problems
  • Own transport and remote access capability to internet that is reliable.

  • Intermediate SQL Developer

    1 month ago

    South Africa Adzuna ZA B C2 Full time

    Responsibilities/Tasks: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...

  • Intermediate to Senior SolidWorks Mechanical Design Engineer

    2 hours ago

    Gauteng, South Africa Diverse Consulting Solutions Full time

    Intermediate to Senior SolidWorks Mechanical Design Engineer Gauteng Must have a 4-year Mechanical Engineering Degree, NFQ Level 8 Must have designing experience using Solidworks . Must have 1- 8+ years’ background experience as a Mechanical Design Engineer Must have working designing experience in 3D CAD modelling SolidWorks + Finite Element Analysis+...

  • intermediate to senior PHP Laraval with Vue and MySQL developer

    1 month ago

    South Africa Adzuna ZA B C2 Full time

    Job Description:As a Full Stack Developer at the company, you will play a key role in designing, developing, and maintaining the companys web applications. You will work closely with their cross-functional team to implement new features, improve performance, and ensure the highest level of security and user experience. Responsibilities:Develop and maintain...

  • intermediate to senior PHP Laraval with Vue and MySQL developer

    1 month ago

    South Africa Recru-it Full time

    Job Description: As a Full Stack Developer at the company, you will play a key role in designing, developing, and maintaining the companys web applications. You will work closely with their cross-functional team to implement new features, improve performance, and ensure the highest level of security and user experience. Responsibilities: Develop and...

  • Senior C# Developer

    2 months ago

    Johannesburg South, South Africa SavageOne Pty Ltd Full time

    Mandatory: Citizenship Requirement: South African Citizen Job Summary: We are seeking a highly experienced Senior C# Software Engineer to join our dynamic team at one of SA's Leading bank. The ideal candidate will bring extensive expertise in developing, testing, and maintaining complex C# applications within the banking sector. This senior role requires...

  • Data Analyst

    7 days ago

    Johannesburg, Gauteng, South Africa SixSense Full time

    A well-established short term insurer is seeking to appoint a Data AnalystThis role will be responsible for sourcing and transforming a wide range of data across the business into formats that can beused by end users to develop differentiating business insights. Qualifications:Bachelor’s degree (Statistics; Data or Computer Science; Engineering;...

  • Junior Data Analyst

    7 days ago

    Sandton, Gauteng, South Africa Bidvest Bank Limited Full time

    Role PurposeJunior data analysts play a crucial role in helping the make informed decisions based on data insights.ResponsibilitiesThe main purpose of a junior data analyst is to support data analysis activities within the Bank. Below are the key responsibilities: Data Collection and Cleaning: Gathering data from various sources and ensuring its accuracy and...

  • Data Analyst/Market Researcher

    2 weeks ago

    Johannesburg, Gauteng, South Africa StriveNest Full time

    Job DescriptionResponsibilities:Conduct in-depth market research to identify industry trends, competitive landscapes, and growth opportunities.Collect, analyze, and interpret data from various sources to extract meaningful insights and inform business decisions.Develop and maintain comprehensive databases and dashboards to track key performance indicators...

  • SVP Marketing Manager

    2 months ago

    Johannesburg South, South Africa The Vine Partners Full time

    Requirements & Duties: •To oversee and manage all aspects of the Marketing of the small Volume Parenteral (SVP) portfolio to ensure organizational commercial objectives are achieved•Medical and/or Sciences degree •3 years’ experience as Marketing manager – Essential •Must have experience in SVP •Generic Pharmaceutical experience- Essential...

  • LVP Marketing Manager

    2 months ago

    Johannesburg South, South Africa The Vine Partners Full time

    Requirements & Duties: •To oversee and manage all aspects of the Marketing of the large Volume Parenteral (LVP) portfolio to ensure Organisational commercial objectives are achieved. •Medical and/or Sciences degree •3 years as a Marketing Manager – Essential •Must have experience in (LVP) Large Volume Parenteral •Generic Pharmaceutical experience...

  • Project Architect

    2 weeks ago

    Johannesburg South, South Africa Hire Resolve Full time

    About the RoleHire Resolve is seeking a highly skilled and experienced Project Architect to join their client's team. As a Project Architect, you will play a pivotal role in the design and development of various architectural projects.Key ResponsibilitiesRepresent the practice at project briefing meetings and ensure effective communication with clients and...

  • Marketing Manager

    3 months ago

    Johannesburg South, South Africa Emporium Full time

    MARKETING MANAGER (BLOOD PORTFOLIO) – (POS24185)Area: AerotonSalary: R950 – R1kTo oversee and manage all aspects of the Marketing of the Blood business unit, servicing the Transfusion Therapies, Bioscience, Pathology / RDT . Optimizing growth and profitability within the unitQualifications & Experience Bachelor of Science (preferably in Nursing) or...

  • Marketing Manager

    3 months ago

    Johannesburg South, South Africa Emporium Human Capital Full time

    MARKETING MANAGER (SVP) (POS24187)Area: AerotonSalary: R950 R1kTo oversee and manage all aspects of the Marketing of the Small Volume Parenteral (SVP) portfolio to ensure Organisational commercial objectives are achieved.Qualifications & Experience:Medical and/or Sciences degree3 years as a Marketing Manager EssentialMust have experience in (SVP) Small...

  • Marketing Manager

    3 months ago

    Johannesburg South, South Africa Emporium Human Capital Full time

    MARKETING MANAGER (BLOOD PORTFOLIO) (POS24185)Area: AerotonSalary: R950 R1kTo oversee and manage all aspects of the Marketing of the Blood business unit, servicing the Transfusion Therapies, Bioscience, Pathology / RDT . Optimizing growth and profitability within the unitQualifications & Experience Bachelor of Science (preferably in Nursing) or equivalent...

  • Marketing Manager LVP

    3 months ago

    Johannesburg South, South Africa Emporium Human Capital Full time

    MARKETING MANAGER (LVP) (POS24184)Area: AerotonSalary: R950 R1kTo oversee and manage all aspects of the Marketing of the Large Volume Parenteral (LVP) portfolio to ensure Organisational commercial objectives are achieved.Qualifications & Experience:Medical and/or Sciences degree3 years as a Marketing Manager EssentialMust have experience in (LVP) Large...

  • Sales & Marketing - SVP

    1 week ago

    Johannesburg South, South Africa Emporium Human Capital Full time

    Sales & Marketing Manager (SVP) (POS24332)Area: AerotonSalary: R950 R1kTo oversee and manage all aspects of the Marketing of the Small Volume Parenteral (SVP) portfolio to ensure Organisational commercial objectives are achieved.Qualifications & Experience:Medical and/or Sciences degree3 years as a Marketing Manager EssentialMust have experience in (SVP)...

  • Project Architect

    2 months ago

    Johannesburg South, South Africa Hire Resolve Full time

    Hire Resolve is currently seeking a talented and experienced Project Architect to join their client's team in Johannesburg (JHB). As a Project Architect, you will play a pivotal role in the design and development of various architectural projects. This is a fantastic opportunity for a passionate architect to work on exciting new projects and be part of a...

  • Finance Clerk

    1 week ago

    Johannesburg South, South Africa Value Co Trading (Pty) Ltd Full time

    **REQUIREMENTS** - Grade 12 - NDip/ Degree in Finance/Accounting - Good work ethics - Good communication and time management skills - Willing to work after hours if necessary - 2 years’ experience within a Finance environment - Good working knowledge of MS Excel Intermediate and MS Word **KEY PERFORMANCE AREAS** To perform the following tasks: - Ensure...

  • Tender Manager

    1 day ago

    Johannesburg South, South Africa Emporium Full time

    Tender Manager Job DescriptionEmporium is seeking a highly skilled Tender Manager to join our team. As a key member of our pharmaceutical business, you will be responsible for managing tenders, maintaining price files, and applying for Single Exit Price increases.Key Responsibilities:Develop and maintain key partnerships with senior DoH managers, depot...

  • Marketing Manager

    3 months ago

    Johannesburg South, South Africa Emporium Full time

    MARKETING MANAGER (BLOOD PORTFOLIO) – (POS24185)Area: AerotonSalary: R950 – R1kTo oversee and manage all aspects of the Marketing of the Blood business unit, servicing the Transfusion Therapies, Bioscience, Pathology / RDT . Optimizing growth and profitability within the unitQualifications & Experience Bachelor of Science (preferably in Nursing) or...