96 Senior Database jobs in South Africa
Database Administrator
Posted 13 days ago
Job Viewed
Job Description
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
Database Administrator
Posted 13 days ago
Job Viewed
Job Description
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:
- Bachelors degree in computer science or a related field. (advantageous)
- Minimum of 1 years of experience as a Database Administrator.
- Relevant certifications, such as Microsoft Certified: Azure Database Administrator. (advantageous)
- In-depth knowledge of specific database management systems, particularly SQL Server.
- Proficiency in SQL and expertise in database query optimization.
- Familiarity with best practices for database security.
- Strong problem-solving and troubleshooting skills.
- Effective communication and teamwork abilities.
Database Administrator
Posted 13 days ago
Job Viewed
Job Description
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 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.
Database Administrator
Posted 6 days ago
Job Viewed
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.
- 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.
- 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
- 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
- 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, identify and recommend database improvements.
- 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
- Minimum of 5 years proven MS SQL Database Administration
- Minimum of 2 years Microsoft Synapse experience
- MySQL experience (added advantage)
Database Administrator
Posted 7 days ago
Job Viewed
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
Database Administrator
Posted today
Job Viewed
Job Description
Database administrator
Posted today
Job Viewed
Job Description
Be The First To Know
About the latest Senior database Jobs in South Africa !
Database administrator
Posted today
Job Viewed
Job Description
Database Administrator (DBA)
Posted 2 days ago
Job Viewed
Job Description
The Database Administrator (DBA) will support the performance, availability, and security of SQL and PostgreSQL databases.
The role includes assisting with implementation, configuration, maintenance, monitoring, and optimization of critical SQL Server RDBMS systems to ensure consistent performance of business applications.
The DBA will also support ETL processes, reporting, backups, disaster recovery, and collaborate with development teams to optimise database schemas.
Salary: R20 000 – R30 000 per month.
Duties and Responsibilities:
- Operational Support
- Assist in managing and maintaining MSSQL and PostgreSQL databases.
- Support the design, implementation, and monitoring of secure and highly available database solutions.
- Help develop, implement, and optimise SSIS packages for ETL processes.
- Assist in creating and managing SSRS reports to support business intelligence needs.
- Perform database tuning and monitor performance.
- Support database upgrades, migrations, backups, and recovery procedures.
- Collaborate with development teams to optimise schemas and troubleshoot issues.
- Provide after-hours support, under supervision, for maintenance and emergencies.
- Implementation
- Shadow and support the DBA team during customer meetings, workshops, installations, and upgrades.
- Monitor production systems using reporting tools, logging and escalating issues as required.
- Assist with installation, configuration, testing, and maintenance of operating systems and applications.
- Contribute to ensuring maximum system and infrastructure availability.
- Service Desk
- Manage tickets and project tasks within the Service Desk system.
- Assist with design and support of operational systems.
- Liaise with vendors and IT personnel for issue resolution.
- Self-Learning & Development
- Become familiar with deployed systems and customer workflows.
- Complete relevant certifications and pursue continuous technical learning.
- Proactively identify developmental areas and engage in growth opportunities.
Key Performance Indicators (KPIs):
- Successful support and maintenance of databases to ensure performance, availability, and security.
- Effective delivery of delegated tasks and services.
- Positive customer outcomes measured by satisfaction feedback.
- Demonstrated continuous learning and personal development.
Minimum Requirements:
Education:
- IT-related degree / diploma advantageous.
- Certification in SQL DBA or related field (or equivalent experience).
- Coursework or exposure to SQL Database Administration.
Experience:
- Minimum 1–2 years MS SQL Server Administration.
- Understanding of High Availability (HA) and Disaster Recovery (DR).
- Familiarity with SSIS and SSRS.
- Experience with backups, restores, and recovery models.
- Experience with Windows Server and Active Directory.
- Knowledge of virtualization or containerization beneficial.
Skills Required:
- Strong problem-solving and troubleshooting ability.
- Effective communication and collaboration (written and verbal).
- Ability to learn quickly and manage workload in a fast-paced environment.
- Strong attention to detail with solid reporting skills.
- Ability to work independently and in a team environment.
- Patient, courteous, and adaptable.
Other Requirements:
- Own reliable transport.
- Availability to work after hours when required.
- Ability to support flexible working arrangements.
SQL Database Administrator
Posted 9 days ago
Job Viewed
Job Description
Position : SQL Database Administrator
Industry : Information Security
Sector : IT
Location : Woodmead - Gauteng
Salary : Market Related
MINIMUM REQUIREMENTS :
- Minimum 1 - 2 years MS SQL Server Administration experience.
- Understand High Availability (HA) and Disaster Recovery (DR) solutions.
- Familiar with SSIS and SSRS.
- Experience with backups, restores and recovery models.
- Experience working with Windows server, including Active Directory
- Experience with virtualization and containerization would be beneficial.
- IT Related Degree / Diploma will be advantageous
- Certification in SQL DBA, or a related field (or equivalent experience).
- Some experience or coursework in SQL Database Administration.
- Basic knowledge of MSSQL and PostgreSQL.