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
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, MCDBA
Knowledge 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
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.