Database Administrator (DBA) — AMK
Summary
Database administrator installing, tuning, and maintaining PostgreSQL, Microsoft SQL Server, and MongoDB — handling performance optimisation, backups and disaster recovery, replication/high availability, security and access control, plus reporting with SSRS and data integration via SSIS/ETL tools.
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.