Database Engineer – Century City

Database Engineer – Century City - South Africa WNS Cape Town, Western Cape, South Africa Database Engineer – Century City - South Africa WNS Cape Town, Western Cape, South Africa Company 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 RoleYou 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 Qualifications Required:Essential Matric/Grade 12 Certificate A 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, MCDBAKnowledge and Skills:5+ year 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 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 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 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 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 technical and business perspective Behavioral Traits Required:Essential 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 Seniority level Seniority level Entry level Employment type Employment type Full-time Job function Job function Customer Service Industries Outsourcing/Offshoring Referrals increase your chances of interviewing at WNS by 2x Sign in to set job alerts for “Database Engineer” roles. Pinelands, Western Cape, South Africa 1 week ago Cape Town, Western Cape, South Africa 4 months ago Cape Town, Western Cape, South Africa 5 days ago Cape Town, Western Cape, South Africa 1 month ago Bellville, Western Cape, South Africa 1 day ago Cape Town, Western Cape, South Africa 3 weeks ago Cape Town, Western Cape, South Africa 4 days ago City of Cape Town, Western Cape, South Africa 1 week ago Cape Town, Western Cape, South Africa 3 months ago City of Cape Town, Western Cape, South Africa 3 weeks ago City of Cape Town, Western Cape, South Africa 3 weeks ago Cape Town, Western Cape, South Africa 23 hours ago Cape Town, Western Cape, South Africa 1 month ago Cape Town, Western Cape, South Africa 2 days ago Bellville, Western Cape, South Africa 1 day ago City of Cape Town, Western Cape, South Africa 1 week ago Senior SQL Server Database Administrator Cape Town, Western Cape, South Africa 4 days ago Cape Town, Western Cape, South Africa 2 months ago Cape Town, Western Cape, South Africa 2 weeks ago Cape Town, Western Cape, South Africa 2 weeks ago Cape Town, Western Cape, South Africa 1 month ago Cape Town, Western Cape, South Africa 1 week ago Cape Town, Western Cape, South Africa 4 months ago Software Engineer - Data Infrastructure - Kafka Cape Town, Western Cape, South Africa 1 month ago Cape Town, Western Cape, South Africa 1 month ago Software Engineer - Data Infrastructure - OpenSearch/ElasticSearch Cape Town, Western Cape, South Africa 1 month ago Cape Town, Western Cape, South Africa 1 week ago Cape Town, Western Cape, South Africa 1 week ago Python and Kubernetes Software Engineer - Data, AI/ML & Analytics Cape Town, Western Cape, South Africa 4 months ago Senior Clinical Database Developer (RAVE) (Home Based - South Africa) Cape Town, Western Cape, South Africa 1 month ago Cape Town, Western Cape, South Africa 2 months ago Python and Kubernetes Software Engineer - Data, Workflows, AI/ML & Analytics Cape Town, Western Cape, South Africa 1 month ago Senior/Staff Data Engineer (Fintech team) (Bangkok based, relocation provided) Cape Town, Western Cape, South Africa 20 hours ago CLOUD ENGINEER (Data Ops and Analytical Workflows) City of Cape Town, Western Cape, South Africa 1 week ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr