36 Sql jobs in Cape Town

<>We’re looking for a dependable SQL Developer to join our team at iOCO. This is a BAU (Business-As-Usual) role focused on supporting and maintaining existing SQL systems, delivering regular reports, and assisting with data analysis. Youâ€ll play a key part in keeping business-critical systems running smoothly while helping teams make sense of their data.

What you†do:

• Develop, maintain, and optimize SQL queries, stored procedures, and functions.
• Create and manage SSRS reports for business users.
• Troubleshoot and resolve database-related issues.
• Perform root cause analysis and assist with ad hoc data requests.
• Monitor database performance and implement improvements where needed.
• Maintain existing data solutions and contribute to ongoing system stability.
• Work closely with business users to understand reporting needs and deliver insights.
• Assist with light business analysis to support reporting and process improvement.

Your expertise:

• 5 years†xperience working with SQL Server (T-SQL).
• Solid experience with SSRS (SQL Server Reporting Services).
• Understanding of relational databases and data structures.
• Strong troubleshooting and problem-solving skills.
• Experience working in a BAU or support environment.
• Good communication skills and ability to interact with both technical and non-technical stakeholders.

Other information applicable to the opportunity:

• Contract Position: 9 Months
• Location: Cape Town

Why work for us?

Want to work for an organization that solves complex real-world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies.â€

You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains.â€

Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft.â€

By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.â€

iOCO is an equal opportunity employer with an obligation to achieve its own unique EE objectives in the context of Employment Equity targets. Therefore, our employment strategy gives primary preference to previously disadvantaged individuals or groups.

About our client: Our client is a global leader in digital marketing and client reporting solutions, empowering financial professionals to enhance investor engagement and retention. With operations spanning four continents, they are rapidly expanding their team worldwide. Serving top-tier clients in the fintech sector, they seek individuals passionate about technical R&D and solution design, offering remote work opportunities. What you will be doing: Dive into diverse client data formats (CSV, XLSX, XML, JSON, etc.) to ensure accuracy and completeness, turning insights into actionable solutions.Craft tailored reporting strategies, keeping clients engaged and informed every step of the way.Champion seamless production runs, ensuring timely and precise report deliveries.Uncover core business challenges and unlock value through innovative problem-solving.Navigate client setups with ease, implementing enhancements and fixes with finesse.Harness the power of Studio Apps and technical prowess to tackle complex business puzzles.Shape JSON & SQL configurations to meet business needs, delivering top-notch solutions on time.Maintain a holistic view of client data and platform capabilities, adapting to diverse needs with agility.Thrive in a dynamic environment, collaborating with clients across multiple time zones.Foster strong partnerships with clients and internal teams, driving success through collaboration and communication.Fuel team growth through knowledge-sharing, training sessions, and staying ahead of industry trends. What you need: Proficiency in SQL, JavaScript, SQLite, and RESTful APIs (XML/JSON).Intermediate or advanced T-SQL development experience.Exceptional communication skills (verbal, written, interpersonal).Driven by self-improvement and team success.Deep understanding of data structures.Comfortable with JIRA, Confluence, and Microsoft Office.Proven track record in fostering positive client experiences.Detail-oriented with a knack for grasping complex technicalities swiftly.Thrives under pressure within collaborative team settings. Nice To Haves: Proficient in Design tools like InDesign.Background in Asset management or extensive industry knowledge.Familiarity with cloud service providers and emerging trends.Ability to confidently challenge and justify decisions.Demonstrated skill in configuring technical solutions, including data visualisation and structuring. Working Hours: US-hours: between 08:00 - 16:00 Pacific Standard Time zone (which relates to 17:00 - 02:00 / 16:00 - 01:00 SAST) depending on Daylight Savings time zone in the US. Job ID: J PS Even if you feel you don’t have all the skills listed or if this spec isn’t what you are looking for, feel free to send your CV as we probably have other opportunities that could interest you. For a more comprehensive and updated list of opportunities that we have on offer, do visit our website -

Senior SQL DBA

One of our clients is seeking a highly experienced and skilled Senior SQL DBA to join their dynamic team within the financial services industry. As a Senior SQL DBA, you will play a crucial role in managing our database systems, ensuring their reliability, performance, and security. Your expertise in MsSQL, SSIS, SSRS, SSAS, and DBMS will be instrumental in maintaining and optimizing our data infrastructure.

Responsibilities:

1. Manage and maintain our SQL database systems, ensuring high availability, performance, and security.
2. Monitor database performance and proactively identify and resolve any issues.
3. Design and implement effective backup and recovery strategies to safeguard critical data.
4. Collaborate with cross-functional teams to analyze and translate business requirements into database solutions.
5. Develop and optimize SQL queries, stored procedures, and functions to support application development and reporting needs.
6. Perform database tuning, index optimization, and query optimization to enhance system performance.
7. Implement and manage database security measures to protect sensitive data.
8. Stay up to date with the latest industry trends and technologies related to SQL databases and provide recommendations for process improvements.

Requirements:

1. National Diploma or Bachelor's degree in Computer Science, Information Systems, or a related field.
2. Proven experience as a SQL Database Administrator, specifically with MsSQL, SSIS, SSRS, SSAS, and DBMS.
3. Strong understanding of database architecture, performance tuning, and optimization techniques.
4. Proficiency in writing complex SQL queries, stored procedures, and functions.
5. Experience with database backup and recovery strategies.
6. Familiarity with database security and access controls.
7. Excellent problem-solving and troubleshooting skills.
8. Strong communication and collaboration abilities to work effectively with cross-functional teams.
9. Prior experience within the financial services industry is a plus.

If you are a highly skilled and motivated SQL DBA seeking a challenging opportunity within the financial services industry, we would love to hear from you. Join this team and make a significant impact on their database systems, contributing to the success of their organization.

#J-18808-Ljbffr

Responsible for analysis of user requirements, technical design, development, maintenance and support of systems/ applications.

Key Responsibilities:

• Analysis, technical design and development aligned to team processes & requirements
• Develop technical specifications from systems specifications.
• Design and code programmes of greater complexity and size from technical specifications.
• Maintain and support existing systems
• Interpret complex user requirements and translate into systems design.
• Investigate and solve complex systems issues.
• Ensure systems documentation is kept up to date.
• Implement approved changes as per change control and security process
• Demonstrate the ability to apply advanced technical skills and knowledge to enhance system performance and create system stability.
• Track and report on performance and service levels
• Solve operational issues and risks promptly
• Collaborate with other units and stakeholders
• Plan, organise and control own work effort, including regular progress feedback to own and other relevant areas
• 3 year IT Diploma
• 5 years + programming experience
• Specific analysis and development skills + SDLC
• Project management methodology, (Agile & DevOps)
• Relevant business process context knowledge
• General understanding of internet technologies & understanding of API web services
• Ability to build and interrogate SSIS & SSRS reporting
• Strong documentation skills & a detail orientated acumen.
• A basic understanding of batch processes & scheduling thereof.
• A basic understanding of Retail operations, including store operations and working with large data sets.
• Ability to perform Standby
• Experience in conducting data quality checks, data cleansing, and data validation
• Critical thinking and problem-solving skills to identify data trends, patterns, and anomalies, and provide recommendations based on data-driven insights

ADDITIONAL CRITERIA

• Understanding of database and a database language
• Experience working on projects or large continuous improvement initiatives
• Project management methodology
• Exposure to DevOps ways of working & tools (Azure, TFS )
• Experience working in an agile environment with peers and business counterparts
• Strong leadership & collaborating skills
• Ability to represent the area and drive pieces of work proactively
• A self-motivated team player who can contribute future fit and innovative solutions to a dynamic technical landscape.
• Is aware of and responsive to internal and external events and influences on the technical landscape
• Ability to research technology-related concepts, trends and best practices, and apply findings
• Appropriately derives and organises the essence of information to draw solid conclusions
• Looks beyond symptoms to uncover root causes of problems to be solved
• Synthesises data from different sources to identify trends
• Presents problem analysis and a recommended solution rather than just identifying and describing the problem itself
• Demonstrates a results-oriented mindset in planning and implementing activities/projects
• Clearly defines objectives and translates them into workable activities
• Anticipates potential obstacles and their impact on the accomplishment of goals and timelines and propose/ take corrective action where required
• Monitors and tracks progress to ensure delivery of all planned commitments, and keeps the appropriate people informed
• Listens attentively and checks understanding of the message being received.
• Prepares clear, well-structured presentations using a variety of tools and techniques.
• Manages existing partnerships within established agreements or contracts; negotiates adjustments when mutually beneficial to do so.
• Discusses issues and exchanges information with partners to identify areas of mutual interest and benefit.
• Convinces others by identifying benefits for all; looks for ways to increase the value of the partnership for all parties.
• Genuinely cultivates personal bonds with colleagues in order to enhance performance throughout the organisation.
• Adjusts to work effectively within new work structures, processes, requirements, or cultures
• Actively seeks out positive spin-offs of change and investigates ways in which change can be used
• Anticipates change and continuously remains prepared for change
• Demonstrates resourcefulness in acquiring necessary knowledge, skills and competencies to adapt to change.

#J-18808-Ljbffr

Responsible for analysis of user requirements, technical design, development, maintenance and support of systems/ applications. Key Responsibilities: Analysis, technical design and development aligned to team processes & requirements Develop technical specifications from systems specifications. Design and code programmes of greater complexity and size from technical specifications. Maintain and support existing systems Interpret complex user requirements and translate into systems design. Investigate and solve complex systems issues. Ensure systems documentation is kept up to date. Implement approved changes as per change control and security process Demonstrate the ability to apply advanced technical skills and knowledge to enhance system performance and create system stability. Track and report on performance and service levels Solve operational issues and risks promptly Collaborate with other units and stakeholders Plan, organise and control own work effort, including regular progress feedback to own and other relevant areas 3 year IT Diploma 5 years + programming experience Specific analysis and development skills + SDLC Project management methodology, (Agile & Dev Ops) Relevant business process context knowledge General understanding of internet technologies & understanding of API web services Ability to build and interrogate SSIS & SSRS reporting Strong documentation skills & a detail orientated acumen. A basic understanding of batch processes & scheduling thereof. A basic understanding of Retail operations, including store operations and working with large data sets. Ability to perform Standby Experience in conducting data quality checks, data cleansing, and data validation Critical thinking and problem-solving skills to identify data trends, patterns, and anomalies, and provide recommendations based on data-driven insights ADDITIONAL CRITERIA Understanding of database and a database language Experience working on projects or large continuous improvement initiatives Project management methodology Exposure to Dev Ops ways of working & tools (Azure, TFS ) Experience working in an agile environment with peers and business counterparts Strong leadership & collaborating skills Ability to represent the area and drive pieces of work proactively A self-motivated team player who can contribute future fit and innovative solutions to a dynamic technical landscape. Is aware of and responsive to internal and external events and influences on the technical landscape Ability to research technology-related concepts, trends and best practices, and apply findings Appropriately derives and organises the essence of information to draw solid conclusions Looks beyond symptoms to uncover root causes of problems to be solved Synthesises data from different sources to identify trends Presents problem analysis and a recommended solution rather than just identifying and describing the problem itself Demonstrates a results-oriented mindset in planning and implementing activities/projects Clearly defines objectives and translates them into workable activities Anticipates potential obstacles and their impact on the accomplishment of goals and timelines and propose/ take corrective action where required Monitors and tracks progress to ensure delivery of all planned commitments, and keeps the appropriate people informed Listens attentively and checks understanding of the message being received. Prepares clear, well-structured presentations using a variety of tools and techniques. Manages existing partnerships within established agreements or contracts; negotiates adjustments when mutually beneficial to do so. Discusses issues and exchanges information with partners to identify areas of mutual interest and benefit. Convinces others by identifying benefits for all; looks for ways to increase the value of the partnership for all parties. Genuinely cultivates personal bonds with colleagues in order to enhance performance throughout the organisation. Adjusts to work effectively within new work structures, processes, requirements, or cultures Actively seeks out positive spin-offs of change and investigates ways in which change can be used Anticipates change and continuously remains prepared for change Demonstrates resourcefulness in acquiring necessary knowledge, skills and competencies to adapt to change. #J-18808-Ljbffr

Reference: JHB -HLG-2

Exciting opportunity for a SQL Developer / BI Developer - Intermediate to Senior (3 - 5 years relevant work experience)
Location: Cape Town
The company has been operating within the medical industry for over 100 years and is located in many locations across South Africa and cross border. Promoting the prevention and control of diseases in both the healthcare and agricultural sectors, this well-established national technology-driven practice offers stability and the opportunity to work within the exciting medical industry.

Duties & Responsibilities

Working within the Human Resources Department, this role provides analytical and consultative support to the HR function of the Group. Your capacity for multitasking, strong analytical skills and passion for delivering meaningful data-driven insights will ensure the HR technology systems effectively support HR processes and contribute to the overall success of the organisation.

Requirements

Qualifications:
3-year Bachelor’s degree/tertiary qualification in Information Systems preferred.
3 – 5 years relevant work experience including the following:

• Proficiency in writing complex SQL queries
• Database Administration
• Data Modelling
• Strong SSRS and SSIS experience
• Solid experience with SQL features such as window functions, common table expressions and recursive queries
• Understanding of advanced data manipulation techniques, such as pivoting and unpivoting data is an advantage
• Scripting and Automation (T-SQL, PowerShell)
• Performance Tuning
• Data Integration
• Azure Cloud Skills advantageous
• Troubleshooting and Debugging
• Experience using Power BI including connecting to various data sources, design compelling visuals, and use Power BI's functionality for insightful data interpretation
• Advanced Excel Skills

Package & Remuneration

R 30 000 - R 45 000 - Monthly plus Health Care Allowance, plus company contribution to Pension fund

#J-18808-Ljbffr

Reference: JHB -HLG-2 Exciting opportunity for a SQL Developer / BI Developer - Intermediate to Senior (3 - 5 years relevant work experience)Location: Cape TownThe company has been operating within the medical industry for over 100 years and is located in many locations across South Africa and cross border. Promoting the prevention and control of diseases in both the healthcare and agricultural sectors, this well-established national technology-driven practice offers stability and the opportunity to work within the exciting medical industry. Duties & Responsibilities Working within the Human Resources Department, this role provides analytical and consultative support to the HR function of the Group. Your capacity for multitasking, strong analytical skills and passion for delivering meaningful data-driven insights will ensure the HR technology systems effectively support HR processes and contribute to the overall success of the organisation. Requirements Qualifications: 3-year Bachelor’s degree/tertiary qualification in Information Systems preferred.3 – 5 years relevant work experience including the following: Proficiency in writing complex SQL queries Database Administration Data Modelling Strong SSRS and SSIS experience Solid experience with SQL features such as window functions, common table expressions and recursive queries Understanding of advanced data manipulation techniques, such as pivoting and unpivoting data is an advantage Scripting and Automation (T-SQL, Power Shell) Performance Tuning Data Integration Azure Cloud Skills advantageous Troubleshooting and Debugging Experience using Power BI including connecting to various data sources, design compelling visuals, and use Power BI's functionality for insightful data interpretation Advanced Excel Skills Package & Remuneration R 30 000 - R 45 000 - Monthly plus Health Care Allowance, plus company contribution to Pension fund #J-18808-Ljbffr

Senior SQL DBA

One of our clients is seeking a highly experienced and skilled Senior SQL DBA to join their dynamic team within the financial services industry. As a Senior SQL DBA, you will play a crucial role in managing our database systems, ensuring their reliability, performance, and security. Your expertise in MsSQL, SSIS, SSRS, SSAS, and DBMS will be instrumental in maintaining and optimizing our data infrastructure.

Responsibilities:

1. Manage and maintain our SQL database systems, ensuring high availability, performance, and security.
2. Monitor database performance and proactively identify and resolve any issues.
3. Design and implement effective backup and recovery strategies to safeguard critical data.
4. Collaborate with cross-functional teams to analyze and translate business requirements into database solutions.
5. Develop and optimize SQL queries, stored procedures, and functions to support application development and reporting needs.
6. Perform database tuning, index optimization, and query optimization to enhance system performance.
7. Implement and manage database security measures to protect sensitive data.
8. Stay up to date with the latest industry trends and technologies related to SQL databases and provide recommendations for process improvements.

Requirements:

1. National Diploma or Bachelor's degree in Computer Science, Information Systems, or a related field.
2. Proven experience as a SQL Database Administrator, specifically with MsSQL, SSIS, SSRS, SSAS, and DBMS.
3. Strong understanding of database architecture, performance tuning, and optimization techniques.
4. Proficiency in writing complex SQL queries, stored procedures, and functions.
5. Experience with database backup and recovery strategies.
6. Familiarity with database security and access controls.
7. Excellent problem-solving and troubleshooting skills.
8. Strong communication and collaboration abilities to work effectively with cross-functional teams.
9. Prior experience within the financial services industry is a plus.

If you are a highly skilled and motivated SQL DBA seeking a challenging opportunity within the financial services industry, we would love to hear from you. Join this team and make a significant impact on their database systems, contributing to the success of their organization.

#J-18808-Ljbffr

Duties & Responsibilities

About our client:
Our client is a global leader in digital marketing and client reporting solutions, empowering financial professionals to enhance investor engagement and retention. With operations spanning four continents, they are rapidly expanding their team worldwide. Serving top-tier clients in the fintech sector, they seek individuals passionate about technical R&D and solution design, offering remote work opportunities.

What you will be doing:

• Dive into diverse client data formats (CSV, XLSX, XML, JSON, etc.) to ensure accuracy and completeness, turning insights into actionable solutions.
• Craft tailored reporting strategies, keeping clients engaged and informed every step of the way.
• Champion seamless production runs, ensuring timely and precise report deliveries.
• Uncover core business challenges and unlock value through innovative problem-solving.
• Navigate client setups with ease, implementing enhancements and fixes with finesse.
• Harness the power of Studio Apps and technical prowess to tackle complex business puzzles.
• Shape JSON & SQL configurations to meet business needs, delivering top-notch solutions on time.
• Maintain a holistic view of client data and platform capabilities, adapting to diverse needs with agility.
• Thrive in a dynamic environment, collaborating with clients across multiple time zones.
• Foster strong partnerships with clients and internal teams, driving success through collaboration and communication.
• Fuel team growth through knowledge-sharing, training sessions, and staying ahead of industry trends.

What you need:

• Proficiency in SQL, JavaScript, SQLite, and RESTful APIs (XML/JSON).
• Intermediate or advanced T-SQL development experience.
• Exceptional communication skills (verbal, written, interpersonal).
• Driven by self-improvement and team success.
• Deep understanding of data structures.
• Comfortable with JIRA, Confluence, and Microsoft Office.
• Proven track record in fostering positive client experiences.
• Detail-oriented with a knack for grasping complex technicalities swiftly.
• Thrives under pressure within collaborative team settings.

Nice To Haves:

• Proficient in Design tools like InDesign.
• Background in Asset management or extensive industry knowledge.
• Familiarity with cloud service providers and emerging trends.
• Ability to confidently challenge and justify decisions.
• Demonstrated skill in configuring technical solutions, including data visualisation and structuring.

Working Hours:

• US-hours: between 08:00 - 16:00 Pacific Standard Time zone (which relates to 17:00 - 02:00 / 16:00 - 01:00 SAST) depending on Daylight Savings time zone in the US.

Job ID:
J

#J-18808-Ljbffr