107 Erp Administrator jobs in South Africa

Senior ERP Administrator (SAGE) The purpose of a Senior ERP Administrator (SAGE) is to provide support and services related to the ERP software and digital transformation integrations within the Company. A critical function will be maintaining relevant procedures and standards and ensuring that systems are efficient and effective. The role incorporates end-user support, execution of user access requests, troubleshooting, and testing ERP and digital transformation applications. Desired Experience & Qualification Matric is essential A tertiary qualification such as a BCOM Degree will be an advantage Valid driver's license & own transport Minimum of 3 years working experience within an IT/Distribution environment Minimum 3 years of experience working on Sage (Finance, Warehouse, Distribution, Procurement, Product Builder, Manufacturing, and Planning) Experience in a support function for an ERP system is essential Sound understanding of accounting principles and concepts Both practical and theoretical knowledge of customer service (understanding how to support users with different personality traits) Knowledge of applicable data privacy practices and laws Experience conducting presentations and delivering training #J-18808-Ljbffr

Database Administrator required in Midrand, Johannesburg.

Database Administrator, preferably with a relevant tertiary qualification and minimum 5 years’ experience required to join this Financial Services Organisation, based in Midrand, Gauteng.

Minimum Requirements:

• Matric plus applicable tertiary equivalent experience or preferably, an ICT-relevant diploma or degree from a recognised tertiary institution
• Minimum 5 years’ experience as a database administrator, essential
• Relevant technical certifications
• Cloud database experience
• Ability to consult on data architecture and assess the impact of project changes to data architecture, required
• Experience working with SQL Server 2016 and 2019 as a database administrator, essential
• Design and development of MS SQL Server databases (DB design, optimization, tuning, ETL, stored procedures, triggers, and views)
• MCDBA certification advantageous
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) beneficial
• Must have Microsoft SQL Always On practical experience

Duties and Responsibilities:

• Implement appropriate designs for databases, data warehouses, marts, reports, and dashboards
• Specify database infrastructure requirements
• Design and implement database solutions for high performance and high availability using Microsoft SQL Always On.
• Responsible for planning and implementing database replication
• Perform query and database optimisation Be responsible for database maintenance
• Work with development teams to identify databases for decommissioning
• Monitoring database user access and security
• Writing database documentation, including data standards, procedures, and definitions
• Developing, managing, and testing disaster recovery processes and servers as well backup and recovery plans
• Keep abreast of new database technologies

#J-18808-Ljbffr

Job Summary:

The Database Administrator will take ownership of the databases across our clients'(Azure SQL Server) the optimal performance of all database tables, stored procedures, and views. This role involves identifying issues and making recommendations for infrastructure changes as needed.

Key Responsibilities:

1. Database Design and Management:

• Design, create, and maintain databases to meet the organizations requirements.
• Ensure data integrity and efficient data structures.

2. Setup and Maintain Data Factory for Power BI Reporting:

• Establish and manage data factory pipelines to support Power BI reporting needs.

3. Database Performance Tuning and Optimization:

• Monitor and enhance database performance through query optimization and indexing.
• Implement best practices for optimizing database performance.

4. Data Backup and Recovery:

• Set up and manage backup and recovery processes to safeguard data integrity.

5. Security and Access Control:

• Enforce security protocols to protect sensitive data.
• Manage user access permissions and roles.

6. Database Software Installation and Configuration:

• Install, configure, and upgrade database software as required.

7. Monitoring and Troubleshooting Database Issues:

• Proactively monitor database systems for issues and troubleshoot as needed.
• Implement solutions to prevent recurrence of problems.

8. Collaborating with Developers and BI Developers:

• Work closely with application developers and business intelligence developers toensure seamless integration with the database systems.

9. Database Documentation:

• Maintain comprehensive documentation of database schemas, configurations, andprocesses.

Qualifications and Skills:

1. Bachelors degree in computer science or a related field. (advantageous)
2. Minimum of 1 years of experience as a Database Administrator.
3. Relevant certifications, such as Microsoft Certified: Azure Database Administrator. (advantageous)
4. In-depth knowledge of specific database management systems, particularly SQL Server.
5. Proficiency in SQL and expertise in database query optimization.
6. Familiarity with best practices for database security.
7. Strong problem-solving and troubleshooting skills.
8. Effective communication and teamwork abilities.

#J-18808-Ljbffr

The incumbent will support the IT Infrastructure through best practice implementation and solutions whilst contributing to Infrastructure excellence.

Key Performance Areas (KPAS)

KPA 1: Finance

1. Oversee budget allocations for database infrastructure, ensuring efficient resource utilization.
2. Analyse cost-saving opportunities related to database management and maintenance and proposing alternate technology.
3. Prepare reports on database-related expenditures and forecast future costs.
4. Contribute to the annual departmental budgeting and business planning process.
5. Identify underutilized resources and recommend scaling down where appropriate.
6. Assess and implement cost-effective database solutions, such as cloud services or virtualization.
7. Monitor licensing agreements and ensure compliance to avoid unnecessary expenses.
8. Implement strategies that enhance database performance and reduce downtime, contributing to overall business productivity.

KPA 2: Customer

1. Act as the main point of contact for BI, BA, and ERP teams regarding SQL database needs and issues.
2. Conduct regular check-ins with stakeholders to gather feedback and address concerns proactively.
3. Facilitate training sessions for internal teams to maximize their effective use of database resources.
4. Ensure timely resolution of incidents and service requests according to established SLA metrics.
5. Regularly review and adjust SLA compliance processes to maintain high service levels.
6. Implement monitoring tools to track database health, performance, and security.
7. Develop and maintain automated alerts for critical performance issues and potential outages.
8. Lead root cause analysis sessions to identify and rectify recurring problems effectively.

KPA 3: Internal (Processes)

1. Utilize performance monitoring tools like Idera to track database metrics, identify bottlenecks, and suggest improvements.
2. Troubleshoot and isolate performance problems, ensuring minimal impact on user experience.
3. Perform routine database health checks, optimizing indexes and queries as needed.
4. Collaborate with development teams to optimize application queries and improve overall system performance.
5. Execute routine backups, ensuring data integrity and availability for recovery purposes.
6. Conduct security audits and implement necessary changes to protect against vulnerabilities.
7. Implement and maintain database security for databases, safeguarding sensitive information.
8. Document and establish procedures for database maintenance tasks, ensuring compliance with internal policies.
9. Design and implement database servers that meet the organization's requirements.
10. Research and propose the use of the most appropriate solution for the organization's database needs.
11. Provide and maintain documentation related to database and data warehouse structures, including configuration and setup.
12. Design and implement data transformation rules according to set standards and methodologies to ensure data quality.
13. Evaluate and implement approved updates and patches on designated platforms to enhance security and performance.
14. Implement and monitor DB clones used in the organization for testing and development purposes.
15. Evaluate and implement new hardware and software for capacity planning, ensuring future scalability.
16. Perform analysis and troubleshooting to resolve database issues as they arise.
17. Diagnose software and hardware problems and provide timely solutions, minimizing downtime and impact on operations.
18. Design database schemas to ensure data integrity and support business processes.
19. Integrate large data files and databases from disparate systems, ensuring seamless data flow and accessibility.
20. Implement a trend analysis toolset to provide management with insights and analysis for informed decision-making regarding resource management.
21. Work closely with developers to ensure database designs align with application needs and scalability.
22. Engage with network engineers to ensure optimal database connectivity and performance.
23. Participate in project planning sessions to provide input on database requirements and constraints.
24. Research and recommend new database technologies and best practices to enhance operations.
25. Lead pilot projects to test innovative solutions before broader implementation.
26. Gather and analyze feedback from users to continuously refine and improve database processes.
27. Implement and monitor early warning systems to detect potential issues before they escalate.
28. Contribute to the implementation of projects for the organization by ensuring project deliverables align with organizational goals.
29. Adhere to project timelines and budget schedules, ensuring efficient use of resources and meeting deadlines.
30. Communicate progress on the status of project tasks to relevant stakeholders, facilitating transparency and collaboration.
31. Adhere to the SANBS Project Management Methodology to ensure all projects are executed effectively and efficiently.
32. Participate in project meetings and provide input on technical requirements and challenges.

KPA 4: Learning and Growth

1. Pursue ongoing education opportunities to remain updated on the latest SQL Server features and technologies.
2. Attend industry conferences, workshops, and webinars to enhance professional knowledge and skills.
3. Share knowledge gained through training with the team to foster a culture of continuous learning.
4. Organize regular knowledge-sharing sessions to discuss challenges and solutions within the team.
5. Evaluate and recommend emerging technologies that could enhance the database environment.

KPA 5: Governance (Risk, Notifications, Compliance)

1. Develop and implement database policies that align with GDPR, HIPAA, and other relevant frameworks.
2. Conduct regular audits to ensure compliance with internal and external data protection regulations.
3. Collaborate with legal and compliance teams to address any potential risks related to database management.
4. Conduct risk assessments to identify vulnerabilities in database systems and operations.
5. Implement security measures such as encryption, access controls, and regular security updates.
6. Develop and maintain a disaster recovery plan to minimize downtime in the event of a data breach or system failure.
7. Maintain detailed logs of database activities, changes, and access to facilitate audits and compliance checks.
8. Create regular reports on database performance, security incidents, and compliance metrics.
9. Work with internal teams to ensure all database documentation is up-to-date and accessible.
10. Establish protocols for alerts related to database health, performance, and security breaches.
11. Implement a notification system for timely communication of critical issues to relevant stakeholders.
12. Regularly review alert criteria and thresholds to ensure they align with operational requirements.

Cognitive

• Analytical Thinking and Attention to Detail
• Change Management
• Judgement and Decision Making
• Problem Solving
• Planning, Organising and Monitoring

Personal

• Flexibility and Adaptability
• Orientation
• Ethical Behaviour

Interpersonal

• Customer Service Orientation
• Teamwork
• Communication
• Knowledge Sharing

Prof. Technical

• Business and Financial Acumen
• Systems Competence
• Computer Literacy
• SQL Server 2016 and newer
• MS SharePoint
• Blood Establishment Computer System (BECS) / SAP (or any other relevant programme / application)

Leadership

• Project Management

Education

• Current Microsoft Database Certification
• ITIL Skill set requirement (Problem Management/Incident Management/Change Management, etc.)

Experience and Knowledge Requirements

• Minimum of 3 years directly related work experience in Database Administration and Business Intelligence/Data Warehousing in an environment with multiple production databases.
• Hands-on professional experience must include an overall knowledge of database design, optimization, and troubleshooting, as well as Microsoft SQL 2016, 2017, 2019 and 2022.
• Experience with MS SQL Server, including use of Query Analyser, stored procedures, DTS, Jobs and Profiler.

#J-18808-Ljbffr

JOB DESCRIPTION
Database Installations

• Collaboration on the initial installation and configuration of a new databases either SQL/ MYSQL or Azure.
• Installation and configuration of database related software.
• Handling of data transfer from the existing system to the new platforms / cloud.
• Manage and maintain SFTP server and application.

Database Maintenance

• Manage SQL, MySQL and Azure Server databases to support various applications during projects and production.
• Manage Synapse and Power Bi.
• Maintenance of database servers and updating of processes/SOPs.
• Ensure high levels of performance, 97% availability and sustainability.
• Ensure that databases logs are tracked, issues are resolved on time.
• Works closely with IT Project Managers, Business Analysts, Enterprise Architects, Suppliers, Infrastructure team and development teams.
• Provide support to Application Productions team, Application Developers and Infrastructure team.
• Participates in the configuration, tuning and troubleshooting of the databases in use in Development, QA and Production.
• Performs backup recovery through restore testing and ensure databases are backed up accordingly.
• Participates in IT patch management to mitigate any application risks and remediate database vulnerabilities.
• Provide support for business-critical systems; and perform scheduled maintenance and support release deployment activities.
• Analyse and optimize database queries and indexing strategies.

Database Security

• Ensure potential weaknesses are identified and addressed for all on premise and Azure databases.
• Implementing best practices to minimise risks.
• Ensuring that there is audit logs should there be any security breach.
• Recommend best security practices for Databases to achieve business objectives (in line best practice and regulations), advises on risk assumptions for any variances granted, and provides alternatives to achieve desired end results

Monitoring and reporting

• Database Performance monitoring and resolution implement and maintain storage, archiving, backup, and recovery procedures function correctly.
• Monitor database health and its performance on regular basis.
• Produce reports on various database e.g., capacity, availability, jobs run etc.
• Provide Business Intelligence (BI) Dashboard support.
• Provide necessary support for business Intelligence function through access management.
• Conduct regular performance audits and provide recommendations.
• Monitor Azure resource and Synapse costs

Policy Holder Data Acquisition

• Support business with Policy Holder Data acquisition programme by ensuring data is collected and availed for reporting purposes.
• Provide support for Policy Holder Data to enable business for data management.

Research and continuous improvement

• Research, identify and recommend database improvements.

Adhoc tasks

• Tasks allocated by management and any initiatives driven in IT department to support the Strategy.

JOB REQUIREMENTS
Qualifications

• Degree in Computer Science, Information Systems or IT relevant Degree
• Microsoft certified Database Administrator (Added Advantage)
• Cloud Certification (Added Advantage) and Relevant Database certificates

Experience

• Minimum of 5 years proven MS SQL Database Administration
• Minimum of 2 years Microsoft Synapse experience
• MySQL experience (added advantage)

Job Description:
• Apply knowledge of computer science principles, information management principles, automated data processing (ADP) functions, hardware and software systems' structures and operation, and computer programming languages and techniques to solve automation problems br>• nterface with and use minicomputer and mainframe computer systems in addressing project objectives < r>• U e standard or conventional approaches, methods and techniques to define, plan, organize, design, refresh/modify, test and integrate data base or data processing systems, computer hardware systems and simulation models < r>• A sist in formulating architectural design, functional specifications, interfaces and documentation of hardware or software system < r>• U e detailed specifications and adapt standardized techniques, methods, criteria and precedents to refresh or modify portions of a system or program < r>• R sponsible for segments or phases of broader and more complex projects < r>• K owledgeable of Windows Server 2019 Configuration and Administration < r>• K owledge of Internet Information Server (IIS) 8.5 administration < r>• A ility to implement DISA required Server configurations < r>• M intain Compliance provided by DISA STIGs < r>• C mplete Annual Security Audits with USARC Cyber Team < r>• D tailed knowledge of T-SQL querying < r>• E perience with SQL Server Reporting Server (SSRS) and SQL Server Integration Services (SSIS) < r>• A le to learn and understand AWMS processes and workflows < r>Minimum Qualifications
• D ploma or postgraduate Degree in computer science, information systems management, mathematics, operations research, statistics, or engineering from an accredited college or university; or eight (8) years of combined education (at the undergraduate level in any academic field) and at least three (3) years' experience < r>• 8 15 years of experience working with progressively more complex or large-scale databases. < r>• E perience and / or the ability to perform software program refreshment, systems testing, and production of graphic and statistical reports < r>• P oficient with Microsoft Office software, to include, but not limited to Word, PowerPoint, Excel, Outlook, etc. < r>• E cellent verbal and written communication skills, < r>• E perience with government systems and requirements for maintaining access to these systems < r>

Other Job Specific Skills
• K owledge of Azure infrastructure and security practices < r>• A ure Web App configuration and management < r>• P wer BI reporting knowledge < r>• K owledge of CI/CD configuration < r>• C ntinuous Risk Monitoring experience < r>• D tailed Knowledge of T-SQL Querying < r>• A le to learn and understand AWMS processes and workflows < r>
NB! CV FORMAT MUST BE PDF

Were looking for a Database Administrator to manage the performance, security, and availability of database systems supporting enterprise software and client environments. Youll work with cross-functional teams to design and maintain scalable, high-performing databases and provide on-site support for implementations, upgrades, and troubleshooting. Periodic travel required. : Install and manage on-prem/cloud database servers Monitor performance and optimize queries, schema, and indexes Ensure database security, access control, and auditing Manage backups, restores, and disaster recovery testing Develop and maintain data models, procedures, views, and triggers Support development teams with data issues and test data Assist in deployment planning and post-release support Troubleshoot database issues and perform root cause analysis Document configurations and best practices Stay updated on new DB technologies and suggest improvements Travel as needed for client support and implementations : Bachelors degree in IT, Computer Science, or related field 35 years DBA experience, ideally in software or IT services Proficient in at least one major RDBMS (PostgreSQL, SQL Server, Oracle, or MySQL) Strong grasp of database design, optimization, and normalization Knowledge of security, compliance, and data privacy best practices Familiar with replication, high availability, and disaster recovery Cloud DB experience (e.g., AWS RDS, Azure SQL) is a plus Skilled in scripting/automation (SQL, Bash, PowerShell) Open to regular travel for client and project support Contact Hire Resolve for your next career-changing move. Apply for this role today, contact Sune Pienaar at Hire Resolve or on LinkedIn You can also visit the Hire Resolve website: hireresolve.us or email us your CV: We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable, we will put your CV on file and contact you regarding any future vacancies that arise

We’re looking for a Database Administrator to manage the performance, security, and availability of database systems supporting enterprise software and client environments. You’ll work with cross-functional teams to design and maintain scalable, high-performing databases and provide on-site support for implementations, upgrades, and troubleshooting. Periodic travel required.: Install and manage on-prem/cloud database servers Monitor performance and optimize queries, schema, and indexes Ensure database security, access control, and auditing Manage backups, restores, and disaster recovery testing Develop and maintain data models, procedures, views, and triggers Support development teams with data issues and test data Assist in deployment planning and post-release support Troubleshoot database issues and perform root cause analysis Document configurations and best practices Stay updated on new DB technologies and suggest improvements Travel as needed for client support and implementations : Bachelor’s degree in IT, Computer Science, or related field 3–5 years’ DBA experience, ideally in software or IT services Proficient in at least one major RDBMS (Postgre SQL, SQL Server, Oracle, or My SQL) Strong grasp of database design, optimization, and normalization Knowledge of security, compliance, and data privacy best practices Familiar with replication, high availability, and disaster recovery Cloud DB experience (e.g., AWS RDS, Azure SQL) is a plus Skilled in scripting/automation (SQL, Bash, Power Shell) Open to regular travel for client and project support Contact Hire Resolve for your next career-changing move. Apply for this role today, contact Sune Pienaar at Hire Resolve or on Linked InYou can also visit the Hire Resolve website: hireresolve.us or email us your CV: We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable, we will put your CV on file and contact you regarding any future vacancies that arise #J-18808-Ljbffr

The incumbent will support the IT Infrastructure through best practice implementation and solutions whilst contributing to Infrastructure excellence. Key Performance Areas (KPAS) KPA 1: Finance Oversee budget allocations for database infrastructure, ensuring efficient resource utilization. Analyse cost-saving opportunities related to database management and maintenance and proposing alternate technology. Prepare reports on database-related expenditures and forecast future costs. Contribute to the annual departmental budgeting and business planning process. Identify underutilized resources and recommend scaling down where appropriate. Assess and implement cost-effective database solutions, such as cloud services or virtualization. Monitor licensing agreements and ensure compliance to avoid unnecessary expenses. Implement strategies that enhance database performance and reduce downtime, contributing to overall business productivity. KPA 2: Customer Act as the main point of contact for BI, BA, and ERP teams regarding SQL database needs and issues. Conduct regular check-ins with stakeholders to gather feedback and address concerns proactively. Facilitate training sessions for internal teams to maximize their effective use of database resources. Ensure timely resolution of incidents and service requests according to established SLA metrics. Regularly review and adjust SLA compliance processes to maintain high service levels. Implement monitoring tools to track database health, performance, and security. Develop and maintain automated alerts for critical performance issues and potential outages. Lead root cause analysis sessions to identify and rectify recurring problems effectively. KPA 3: Internal (Processes) Utilize performance monitoring tools like Idera to track database metrics, identify bottlenecks, and suggest improvements. Troubleshoot and isolate performance problems, ensuring minimal impact on user experience. Perform routine database health checks, optimizing indexes and queries as needed. Collaborate with development teams to optimize application queries and improve overall system performance. Execute routine backups, ensuring data integrity and availability for recovery purposes. Conduct security audits and implement necessary changes to protect against vulnerabilities. Implement and maintain database security for databases, safeguarding sensitive information. Document and establish procedures for database maintenance tasks, ensuring compliance with internal policies. Design and implement database servers that meet the organization's requirements. Research and propose the use of the most appropriate solution for the organization's database needs. Provide and maintain documentation related to database and data warehouse structures, including configuration and setup. Design and implement data transformation rules according to set standards and methodologies to ensure data quality. Evaluate and implement approved updates and patches on designated platforms to enhance security and performance. Implement and monitor DB clones used in the organization for testing and development purposes. Evaluate and implement new hardware and software for capacity planning, ensuring future scalability. Perform analysis and troubleshooting to resolve database issues as they arise. Diagnose software and hardware problems and provide timely solutions, minimizing downtime and impact on operations. Design database schemas to ensure data integrity and support business processes. Integrate large data files and databases from disparate systems, ensuring seamless data flow and accessibility. Implement a trend analysis toolset to provide management with insights and analysis for informed decision-making regarding resource management. Work closely with developers to ensure database designs align with application needs and scalability. Engage with network engineers to ensure optimal database connectivity and performance. Participate in project planning sessions to provide input on database requirements and constraints. Research and recommend new database technologies and best practices to enhance operations. Lead pilot projects to test innovative solutions before broader implementation. Gather and analyze feedback from users to continuously refine and improve database processes. Implement and monitor early warning systems to detect potential issues before they escalate. Contribute to the implementation of projects for the organization by ensuring project deliverables align with organizational goals. Adhere to project timelines and budget schedules, ensuring efficient use of resources and meeting deadlines. Communicate progress on the status of project tasks to relevant stakeholders, facilitating transparency and collaboration. Adhere to the SANBS Project Management Methodology to ensure all projects are executed effectively and efficiently. Participate in project meetings and provide input on technical requirements and challenges. KPA 4: Learning and Growth Pursue ongoing education opportunities to remain updated on the latest SQL Server features and technologies. Attend industry conferences, workshops, and webinars to enhance professional knowledge and skills. Share knowledge gained through training with the team to foster a culture of continuous learning. Organize regular knowledge-sharing sessions to discuss challenges and solutions within the team. Evaluate and recommend emerging technologies that could enhance the database environment. KPA 5: Governance (Risk, Notifications, Compliance) Develop and implement database policies that align with GDPR, HIPAA, and other relevant frameworks. Conduct regular audits to ensure compliance with internal and external data protection regulations. Collaborate with legal and compliance teams to address any potential risks related to database management. Conduct risk assessments to identify vulnerabilities in database systems and operations. Implement security measures such as encryption, access controls, and regular security updates. Develop and maintain a disaster recovery plan to minimize downtime in the event of a data breach or system failure. Maintain detailed logs of database activities, changes, and access to facilitate audits and compliance checks. Create regular reports on database performance, security incidents, and compliance metrics. Work with internal teams to ensure all database documentation is up-to-date and accessible. Establish protocols for alerts related to database health, performance, and security breaches. Implement a notification system for timely communication of critical issues to relevant stakeholders. Regularly review alert criteria and thresholds to ensure they align with operational requirements. Cognitive Analytical Thinking and Attention to Detail Change Management Judgement and Decision Making Problem Solving Planning, Organising and Monitoring Personal Flexibility and Adaptability Orientation Ethical Behaviour Interpersonal Customer Service Orientation Teamwork Communication Knowledge Sharing Prof. Technical Business and Financial Acumen Systems Competence Computer Literacy SQL Server 2016 and newer MS Share Point Blood Establishment Computer System (BECS) / SAP (or any other relevant programme / application) Leadership Project Management Education Current Microsoft Database Certification ITIL Skill set requirement (Problem Management/Incident Management/Change Management, etc.) Experience and Knowledge Requirements Minimum of 3 years directly related work experience in Database Administration and Business Intelligence/Data Warehousing in an environment with multiple production databases. Hands-on professional experience must include an overall knowledge of database design, optimization, and troubleshooting, as well as Microsoft SQL 2016, 2017, 2019 and 2022. Experience with MS SQL Server, including use of Query Analyser, stored procedures, DTS, Jobs and Profiler. #J-18808-Ljbffr