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 dashboardsSpecify database infrastructure requirementsDesign and implement database solutions for high performance and high availability using Microsoft SQL Always On.Responsible for planning and implementing database replicationPerform query and database optimisation Be responsible for database maintenanceWork with development teams to identify databases for decommissioningMonitoring database user access and securityWriting database documentation, including data standards, procedures, and definitionsDeveloping, managing, and testing disaster recovery processes and servers as well backup and recovery plansKeep abreast of new database technologies#J-18808-Ljbffr