Database Engineer – Century City - South Africa

WNS; Cape Town; Hybrid; ZAR 420,000 - 700,000; Full time

Job summary

WNS Global Services Inc. in South Africa seeks an experienced Database Developer to lead a team responsible for designing, implementing and maintaining high-performance SQL Server databases.

You will develop complex T‑SQL and ETL processes, SSRS reports and automation using Python, C#, and Java. A strong problem-solver with Agile mindset is essential to drive data-driven decisions.

Qualifications

• 5+ years of experience with Microsoft SQL Server and related RDMS.
• Strong coding ability to write and review codes to extract data from multiple sources using SQL, Python and other languages.
• Experience in designing high-functioning database systems and data models.

Responsibilities

• Design new databases based on company needs and user load; develop data models and cubes.
• Write and maintain database programs to handle traffic and data volume.
• Monitor databases and related systems for high functionality.
• Write scripts to increase data storage and fix database problems.
• Troubleshoot, debug and validate database code and reports.
• Mentor junior team members and promote agile practices.
• Support IT strategy, architecture and compliance considerations.

Skills

SQL Server

T‑SQL

Python

C#

Java

ETL

SSRS

SSIS

DW/BI concepts

ETL tools

Scripting

Agile

Education

Bachelor's degree in computer science or related field

Tools

SSRS

SSIS

ETL tools

Job description

Company Description

WNS Global Services Inc. (NYSE: WNS) is a global Business Process Management (BPM) leader. WNS offers business value to 400+ global clients by combining operational excellence with deep domain expertise in key industry verticals, including Banking and Financial Services, Consulting and Professional Services, Healthcare, Insurance, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Telecommunications, Travel and Utilities. Globally, the group’s over 41,000+ Professionals serve across 60 delivery centers in 16 countries worldwide, including China, Costa Rica, India, the Philippines, Poland, Romania, South Africa, Sri Lanka, UK and US.

WNS South Africa has been in operation since 2003 and built a reputation as the industry leader for Business Process Outsourcing (BPO) in South Africa, with a growing footprint into Africa. We are a strategic partner for delivering a full range of basic to complex processes from our eight delivery centers across South Africa, employing 4000+ people.

Why Join Us?

We promise our employees to experience role clarity, coaching and mentoring, professional development and structured career path through our 5 people promises and keeping employee experience at the core. Experience the culture of outperformance, engagement, celebration and also contribute to society through our WNS Cares Foundation, where you have the opportunity to support meaningful initiatives and make an impact in the community.

Job Description

Purpose of the Role: You will be leading a team of technical professionals that are required to support all areas of the enterprise, ensuring all databases run at optimal performance. Database structures and tables are designed and implemented to deliver dynamic reporting at multiple levels. Ensure that industry‑wide security standards are properly implemented. Develop and optimize complex T‑SQL and PL/SQL code. Design and develop SQL code, ETL processes and SSRS reports based on provided requirements. Maintain and develop automation applications using various programming languages.

Qualifications

Essential

• Matric/Grade 12 Certificate
• Bachelor’s degree in computer science, software engineering, or a related field of study with a minimum of 5 years previous work experience in database development.
• Database engineers who possess extra education, such as a master’s degree, can substitute education for work experience.
• Microsoft Certification (MCSD, MCDBA)

Knowledge and Skills

• 5+ years experience on Microsoft SQL Server and or related RDMS.
• Computer coding – write and review computer codes to design high‑functioning database systems, support programs, and debug systems. Can design, write and deploy complex code to extract data from various data sources in a big data environment using SQL, Python and other relevant code.
• Programming languages – proficient to write in several common programming languages, including Python, C# and Java.
• Problem‑solving – identify potential problems in the database, and work to solve these issues before and after they occur.
• Attention to detail – comb through lines of code to spot potential error‑causing problems and possible database security and storage capacity issues.
• Database Architecture – able to structure, integrate and organise data to create and extend data models for an information system by applying certain formal techniques typically implemented in a database management system.
• Good Understanding of T‑SQL.
• Microsoft Reporting Services (SSRS) or similar.
• Microsoft SQL Server Integration Services (SSIS).
• Understanding of DWBI concepts.
• Understanding of ETL concepts.
• Exposure to ETL tools.
• Scripting tools.
• Agile – understands agile methodologies (e.g., Kanban, Lean, Scrum, Scaled Agile) and applies agile ways of working. Is a role model of the agile mindset and principles.

Role Responsibilities

• Design new databases based on company needs, data storage needs, and the number of users accessing the database. Design and develop data models and cubes.
• Write and maintain database programs: write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.
• Monitor databases and programs: continuously monitor databases and related systems to ensure high functionality.
• Write programs and scripts: write new support programs and scripts for databases to increase data storage capacity and fix existing database problems.
• Troubleshooting: troubleshoot database code, checking for potential problems that affect database functionality and related database programs.
• Debugging: look through coding language to debug existing database scripts and programs.
• Review database reports: review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working.
• Leadership and mentoring skills: training and mentoring of direct reports; cross‑skilling to enable everyone to work on all environments. Train and mentor junior team members on process and technology.
• Licensing, risk management and compliance: service monitoring and alerting. Consulting on IT strategy and architecture from a technical and business perspective.

Behavioral Traits

• Strong communication skills (verbal, written and interpersonal).
• High attention to detail.
• An ability to quickly grasp complex technical issues.
• Curiosity and passion for understanding data to develop reporting to help identify trends and support decision making.
• Desire to continually research and learn (new technologies, tools, techniques, platforms).
• Ability to work under pressure in a fast‑paced and dynamic environment.
• Great at building individual, team and partner relationships.
• A strong sense of ownership and accountability.
• Able to prioritise workload effectively and deliver to deadlines.
• Strong stakeholder management.
• Honest and reliable, delivers on promises or commitments.
• Ability to work remotely and independently as well as part of a team.