About the position
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 defi nitions
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 tertiaryinstitution
Relevant technical certifi cations
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 certifi cation advantageous
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) benefi cial
Must have Microsoft SQL Always On practical experience
Desired Skills:
- Time Management
- Critical Thinking
- Spreadsheet software
- Judgment and Decision Making
- Active Listening
- Tax preparation software
- Accounting Software
