Database / SQL Developer (CH988)

Capital H Staffing; Johannesburg; Presencial; ZAR 900.000 - 1.200.000; Jornada completa

Descripción de la vacante

Capital H Staffing is seeking a seasoned Database Developer in Johannesburg to design, maintain and optimize SQL Server databases, ensuring data quality and performance.

You will implement data warehousing concepts, build ETL pipelines, and collaborate with developers to integrate with API layers (Java/Spring). The role requires 7+ years MS SQL experience and strong problem-solving skills.

Formación

• Bachelor's degree in IT or related field.
• Exposure to Agile methodology.
• Microsoft certifications in SQL Server or Azure SQL (preferred).

Responsabilidades

• Database design and data analytical patterns.
• Assisting in incident resolution.
• Creating performant code that follows SQL best practices.
• Planning, estimation and delivery.
• Perform code reviews and peer reviews.
• Understand complex structures with minimal documentation.
• Provide solutions for third-party integrations using data.
• Create technical specs and detailed unit testing.
• Integrate into API layer with Java/Spring.

Conocimientos

Data modelling

Data warehousing

Problem solving

Communication

Batch processing

Analytical thinking

Educación

Bachelor's degree in IT or related field

Herramientas

SQL Server

Azure SQL Database

SSIS

SSAS

SSRS

T-SQL

ETL pipelines

Descripción del empleo

Database Developer

Our client, a company that provides various HR Solutions and software, is looking for a Database Developer. The Database Developer will create and maintain database structures, ensure that data is stored efficiently, and write and test database code, including SQL (Structured Query Language) queries, procedures, and functions. Create best practice reporting structures and apply data warehousing frameworks.

As a Database Developer, you will be responsible for participating in product development, from ideation to deployment and beyond. You will work on ground-breaking product features, issues, and improvements that are critical to the success of your customers, and you will need to collaborate with the broader company to maintain and help optimize existing systems.

MINIMUM REQUIREMENTS

• A bachelor’s degree in IT or related field
• Exposure to working in an Agile methodology
• Microsoft certifications in SQL Server or Azure SQL database (preferred)

MINIMUM EXPERIENCE REQUIRED

• 7+ years in MS SQL development.
• Proficient with data modelling, data warehousing, and building ETL pipelines.
• Strong problem-solving and communication skills.
• Batch environment experience (advantageous)
• Essential experience required in TSQL, SSIS, SSAS, SSRS

RESPONSIBILITIES

• Database design and data analytical patterns.
• Assisting in incident resolution.
• Creating performative code that meets SQL best practices.
• Planning, estimation, and delivery.
• Ability to perform code reviews and peer reviews.
• Ability to understand complex structures without the need for detailed documentation.
• Providing solutions to third-party integrations using data.
• Create concise technical specifications and detailed unit testing.
• Ability to integrate into API layer with Java/Spring.

PERSONAL ATTRIBUTES

• Propensity to Own: The habit of taking ownership of a task and stepping up to challenges.
• To Simplify: The ability to break complex scenarios into manageable tasks.
• Resilience: The ability to overcome challenges and complete tasks despite difficulties.
• Frustration Handling: The ability to deal with obstructions effectively.
• Self-Confidence: Acting with conviction and trusting one's abilities.
• Conceptual Application: Strong application of conceptual abilities.
• Task Efficiency: Effectiveness in completing job tasks.
• Attitude: Involved and assertive when necessary.

REQUIRED COMPETENCIES

• Critical thinker and good problem-solver
• Team player
• Ability to prioritize and meet deadlines
• Ability to work within tight deadlines

REPORTING

• Reports to Delivery Lead
• Works closely with:
• Delivery Leads
• Business Analysts
• Quality Assurance
• Project Manager
• Product Owners
• Other Developers

General:

• Only shortlisted candidates will be contacted. Should you not hear from us after 30 days, you may consider your application unsuccessful.
• In keeping with our client’s employment equity requirements, only South African citizens will be considered.
• Please include your current salary and salary expectations.