Database Engineer – Century City

1 month ago


Cape Town, South Africa WNS Global Services Full time
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

Additional Information


  • Cape Town, South Africa MedE Recruit Full time

    Are you an experienced optometrist looking to join a thriving practice in Century City, Cape Town? Our esteemed client, a leading optometry practice, is seeking a dedicated Optometrist with 1+ years of experience to join their team. **Key Requirements**: - Relevant Qualification - HPCSA Registration **Skills Required**: - Exceptional people skills -...


  • Cape Town, South Africa Oona Kriedemann Full time

    Published - Mar 3, 2023 - Location - Cape Town, South Africa - Category - Business - Job Type - Full-time - Salary Type - Monthly Salary **Description**: HR / Office Administrator Century City R18000-R20000 HR Administration Manage new engagement process, orientation etc. Preparation of HR reports, letters and correspondences when required. Administer...

  • Credit Controller x 5

    1 month ago


    Cape Town, South Africa O'Brien Recruitment Full time

    Credit Controller x 5 based in Century City-Cape TownSeeking excellent Credit Controllers to assist with meeting our Targets by managing all money owed to our business. It is vital that the Credit Controllers build and maintain close links with all clients, to ensure smooth running of accounts and encourage timely recovery of payments.Knowledge and...

  • Credit Controller x 5

    1 month ago


    Cape Town, South Africa O'Brien Recruitment Full time

    Credit Controller x 5 based in Century City-Cape TownSeeking excellent Credit Controllers to assist with meeting our Targets by managing all money owed to our business. It is vital that the Credit Controllers build and maintain close links with all clients, to ensure smooth running of accounts and encourage timely recovery of payments.Knowledge and...


  • Cape Town, South Africa O'Brien Recruitment Full time

    Credit Controller x 5 based in Century City-Cape Town Seeking excellent Credit Controllers to assist with meeting our Targets by managing all money owed to our business. It is vital that the Credit Controllers build and maintain close links with all clients, to ensure smooth running of accounts and encourage timely recovery of payments. Knowledge and Skills:...


  • Cape Town, South Africa City of Cape Town Full time

    ELIGIBILITY CLOSING DATE 14.04.2023 REFERENCE NUMBER CS 70/23 ext SALARY **TCOE**: R912 661 p.a DEPARTMENT Information Systems and Technology DIRECTORATE CORPORATE SERVICES Senior Professional Officer - Database Administration **Requirements**: - National diploma supported by industry specific/related qualification and relevant experience -...


  • Cape Town, South Africa PeopleMax Full time

    Our client in the gaming industry would like to recruit a Cape Town based Technical Support Agent in their Technical Support Department with previous Technical Contact Centre experience. This position reports to the Gaming Technical Support Manager and will be based in the Century City Area **RESPONSIBILITIES OF THE POSITION INCLUDE BUT ARE NOT LIMITED...

  • Sales Account Manager

    4 weeks ago


    Cape Town, South Africa The Recruiters Full time

    **Salary**: - 25000 **Description**: - Our client is an independent communications solutions provider based in Century City, Cape Town is looking for an experienced Sales Account Manager to join their growing team. As a Sales Account Manager, you will play a crucial role in maintaining and expanding the company\'s client base. You will be responsible for...


  • Cape Town, South Africa Discovery Ltd. Full time

    **Business Unit**:Marketing**Function**:Marketing Management**Date**:13 Jul 2023- Discovery - Marketing Client Interaction Consultant - Century City / Sea Point - **About Discovery** - Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support...

  • Unit Manager: Theatre

    1 month ago


    Cape Town, South Africa Intercare Full time

    ABOUT Intercare is a dynamic healthcare company focusing on offering value-based healthcare to patients. As ambassadors of the Intercare brand, everything we do is guided by our purpose to make people feel better. Our shared values of People-centred, Integrity, Inclusivity, Compassion, Excellence and Innovation define what we believe and who we are....


  • Cape Town, South Africa Discovery Ltd. Full time

    **Business Unit**:Marketing**Function**:Client Service**Date**:1 Mar 2024- Discovery - Marketing - **Sales and Servicing Team Leader - Century City** **About Discovery** - Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support our core...

  • Data Entry Clerk

    5 days ago


    Cape Town, South Africa HR Talent Partner Full time

    **Job Overview**: **Date Posted**: Posted 1 month ago- **Location**: Cape Town, Western Cape- **Job Title**: Data Entry Clerk (Contract)- **Education Level**: High School / Matric- **Job Level**: Intermediate- **Minimum Experience**: 1 - 3 Years**Data Entry Clerk (Contract) - Century City, Cape Town.**: A renowned international travel and tourism company is...


  • Cape Town, South Africa City of Cape Town Full time

    ELIGIBILITY Suitable qualified CLOSING DATE 17.03.2023 REFERENCE NUMBER CS 44/23 ext SALARY DEPARTMENT DIRECTORATE Apprenticeship Programme 2023 - Engineering and Construction Trades **Requirements**: **Engineering Trades**: - A minimum of National Technical Certificate qualification (Mechanical and Trade Theory, Mathematics, Engineering...


  • Cape Town, South Africa Vodafone Full time

    **Role purpose**: Provide Analytical design and solutions to Vodacom’s Engineering E2E Team Execute on data driven insights developed and maintained to drive solutions within regional SPOC’s and team collaboration Track progress of solutions and measure impacts and new strategies to maintain Vodacom Do or Die Goals **Your responsibilities will...

  • Call Center Agent

    1 month ago


    Cape Town, South Africa WNS Global Services Full time

    Job DescriptionAn exciting opportunity for Lead Associates has just become available on our brand new campaign in Century City. Our client is a financing institution with a platform that enables financing for international postgraduate students at the world’s best universities, whilst delivering competitive financial and social returns to alumni,...


  • Cape Town, South Africa City of Cape Town Full time

    ELIGIBILITY CLOSING DATE 07.07.2023 REFERENCE NUMBER NRG 56/23 SALARY 912661.00 to 1281747.00 DEPARTMENT Sustainable Energy Markets DIRECTORATE ENERGY Senior Professional Officer **Requirements**: B degree in science, mathematics. engineering, finance or economics Five (5) years’ relevant experience Data management and analytical...


  • Cape Town, South Africa Frogg Recruitment Full time

    SAIPA Trainee Clerk Century City Cape Town Our SAIPA Client in Century City is looking for SAIPA Trainee Clerk to complete the 3 years SAIPA Learnership / SAIPA Article Clerks to start ASAP. You need to have completed qualified financial degree qualification OR in the progress completing your qualification. Frogg Recruitment SA **Job Types**: Full-time,...


  • Cape Town, South Africa Frogg Recruitment Full time

    SAIPA Trainee Clerk Century City Cape Town Our SAIPA Client in Century City is looking for SAIPA Trainee Clerk to complete the 3 years SAIPA Learnership / SAIPA Article Clerks to start ASAP. You need to have completed qualified financial degree qualification OR in the progress completing your qualification. Frogg Recruitment SA **Job Types**: Full-time,...


  • Cape Town, South Africa City of Cape Town Full time

    ELIGIBILITY City Careers Website CLOSING DATE 10.05.2024 REFERENCE NUMBER NRG 04/24 (External) SALARY R 422662.00 p.a (T11) DEPARTMENT Electricity Generation and Distribution DIRECTORATE ENERGY Specialist Engineering Artisan **Requirements**: - Completed Trade Test for Artisans or Telecoms PAX/PABX - Relevant 5 years’...

  • PROJECT MANAGER

    1 day ago


    Cape Town, South Africa Labournet Full time

    PROJECT MANAGER – Financial Services (Fund Operations, Governance & Control) – Century City, Cape Town (SA)Highly Competitive Package on Offer!Forming part of the Client Services Central Operations team of this highly reputable Global Investment firm, the Project Manager will be responsible for focusing on project supporting their Governance and Control...