Responsibilities
•
Install, configure and maintain PostgreSQL, Microsoft SQL Server (MSSQL) and MongoDB databases.
•
Monitor and optimise database performance, including queries, indexes, configurations and resource usage.
•
Implement and maintain backup, restoration and disaster recovery procedures to protect data integrity.
•
Configure replication, clustering and failover to ensure database availability and reliability.
•
Troubleshoot database incidents, resolve performance bottlenecks and conduct root cause analysis.
•
Implement database security controls and manage users, roles and permissions in line with data privacy requirements.
•
Work with developers to design and optimise database schemas for scalability and maintainability.
•
Perform database upgrades, patching and maintenance, and maintain operational documentation and standards.
•
Use SSRS for report development and SSIS/ETL tools for data integration.
Requirements
•
Hands-on database administration experience with PostgreSQL, Microsoft SQL Server and MongoDB.
•
Strong knowledge of performance tuning, query optimisation and indexing.
•
Experience with backup and recovery, replication, clustering and high availability.
•
Familiarity with database security, access management and troubleshooting.
•
Experience with SSRS and SSIS/ETL tools.
•
Relevant certifications, such as Oracle Certified Professional or Microsoft Certified: Azure Database Administrator Associate, are an advantage.
You apply on MyCareersFuture, where this job was posted. Peter Nowak isn’t the employer and doesn’t check listings.
