Database Administrator at PSG Konsult Ltd

Job description:

• An opportunity exists for a Database Administrator to work within a growing financial services organisation.

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

Minimum Requirements:

• At least 5 years’ experience as a database administrator
• Matric plus applicable tertiary equivalent experience or preferably, an ICT-relevant diploma or degree from a recognised tertiary institution
• Relevant technical certifications
• Cloud database experience
• Able to consult on data architecture and assess the impact of project changes to data architecture
• Experience working with SQL Server 2016 and 2019 as a database administrator
• 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