Database Engineer – Century City - South AfricaFull-timeWNS 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.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.Purpose of the RoleYou will be leading a team of technical professionals that arerequired 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 Required:Matric/Grade 12 CertificateA 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 experienceMicrosoft Certification (MCSD, MCDBAKnowledge and Skills:5+ year experience on Microsoft SQL Server and or related RDMSComputer coding–write and review computer codes to design high-functioning database systems, support programs, and to 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 codeProgramming languages– proficient to write in several common programming languages, including Python, C# and JavaProblem-solving– identify potential problems in the database, and work to solve these issues before and after they occurAttention to detail– comb through lines of code to spot potential error-causing problems and possible database security and storage capacity issuesDatabase 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 systemGood Understanding of T-SQLMicrosoft Reporting Services (SSRS) or similarMicrosoft SQL Server Integration Services (SSIS)Understanding of DWBI conceptsUnderstanding of ETL conceptsExposure to ETL toolsScripting toolsAgile - Understands agile methodologies (e.g. Kanban, Lean, Scrum, Scaled Agile) and apply agile ways of working. Is a role model of the agile mind-set and principles.Role Responsibilities:Design New Databases - 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 workingLeadership 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 technologyLicensing, Risk Management and Compliance - Service Monitoring and Alerting. Consulting on IT strategy and architecture from technical and business perspectiveStrong communication skills (verbal, written and interpersonal)High Attention to detailAn ability to quickly grasp complex technical issuesCuriosity and passion for understanding data to develop reporting to help identify trends and support decision makingDesire to continually research and learn (new technologies, tools, techniques, platforms)Ability to work under pressure in a fast paced and dynamic environmentGreat at building individual, team and partner relationshipsA strong sense of ownership and accountabilityAble to Prioritise workload effectively and deliver to deadlinesHonest and Reliable delivers on promises or commitmentsAbility to work remotely and independently as well as part of a team#J-18808-Ljbffr