SQL Developer MMH260911-12

Momentum; Gqeberha; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

Momentum in Gqeberha is seeking an experienced SQL Developer to design, develop and optimise SQL Server databases and data solutions for a high-volume claims processing environment.

You will translate business rules into reliable SQL logic, write efficient T-SQL, and maintain complex database objects while adhering to standards. Prior experience in healthcare or financial services is advantageous.

Qualifications

• Bachelor’s degree or diploma in Information Systems, Computer Science, Data Engineering or related field
• Strong SQL Server / T-SQL development experience
• Honours degree in related field (Advantageous)
• Relevant certifications (Advantageous)
• 6+ years of SQL development experience
• Strong experience with Microsoft SQL Server and T-SQL
• Proven experience developing and maintaining stored procedures, views, functions, tables, indexes and complex SQL queries
• 2–3+ years in healthcare, medical aid, insurance or financial services advantageous
• Experience in Agile/Scrum development environment advantageous
• Knowledge of SQL Server monitoring tools advantageous
• Role based in Gqeberha; relocation consideration

Responsibilities

• Develop, maintain and optimise SQL Server databases and database objects
• Design, develop and maintain complex stored procedures used by business applications
• Develop and maintain tables, views, functions and other database objects
• Write efficient, readable, maintainable and reusable T-SQL code
• Translate business requirements into reliable SQL solutions
• Ensure solutions comply with development standards and database best practices
• Develop and validate complex calculations
• Convert business rules into accurate and efficient SQL logic
• Validate calculations against expected outcomes
• Analyse impact of changes to benefit rules, limits, tariffs and other business rules
• Ensure calculations are accurate and consistent across large volumes of transactions
• Identify and resolve calculation discrepancies
• Assist with incident investigation and preventative measures
• Verify legitimacy of job advert on company page

Skills

SQL development

T-SQL

SQL Server

Agile/Scrum experience

Education

Bachelor's degree or diploma in Information Systems / Computer Science / Data Engineering / Software Engineering

Honours degree in Computer Science / Information Systems / Data Engineering

Tools

SQL Server monitoring tools

Job description

Role Purpose

Develop, maintain, optimise and support SQL-based applications, databases and data solutions within a high-volume claims processing environment.

Requirements

• Bachelor's degree or diploma in Information Systems, Computer Science, Data Engineering, Software Engineering or a related field (Essential).
• Strong SQL Server / T-SQL development experience required.
• Honours degree in Computer Science, Information Systems, Data Engineering or a related field (Advantageous).
• Relevant SQL Server, database or data engineering certifications (Advantageous).
• Must have 6+ years of SQL development experience.
• Strong experience with Microsoft SQL Server and T-SQL.
• Proven experience developing and maintaining: Stored procedures, Views, Functions, Tables, Indexes, Complex SQL queries, database structures and data solutions.
• 2–3+ years' experience in healthcare, medical aid, insurance or financial services is advantageous.
• Experience working in an Agile/Scrum development environment is advantageous.
• Knowledge of SQL Server monitoring tools would be advantageous.
• Please note: This role is based in Gqeberha, and applicants should either currently reside in Gqeberha or be willing to relocate to the area for this opportunity.

Duties and Responsibilities

SQL Development

• Develop, maintain and optimise SQL Server databases and database objects.
• Design, develop and maintain complex stored procedures used by business applications.
• Develop and maintain tables, views, functions and other database objects.
• Write efficient, readable, maintainable and reusable T-SQL code.
• Translate business requirements and business rules into reliable SQL solutions.
• Ensure solutions comply with development standards and database best practices.

Calculations and Business Rules

• Develop and validate complex calculations
• Convert business rules into accurate and efficient SQL logic.
• Validate calculations against expected business outcomes.
• Analyse the impact of changes to benefit rules, limits, tariffs and other business rules.
• Ensure calculations are accurate and consistent across large volumes of transactions.
• Identify and resolve calculation discrepancies.
• Assist with incident investigation and preventative measures to reduce recurring issues.

Data Quality and Governance

• Ensure the accuracy, consistency and integrity of data.
• Identify data quality issues and recommend corrective actions.
• Develop SQL queries and processes to validate and reconcile data.
• Ensure database changes follow appropriate development, testing and production processes.
• Maintain appropriate technical documentation for database solutions and processes.

As an applicant, please verify the legitimacy of this job advert on our company career page.-346021296