Database Management
- Install, configure, and upgrade MSSQL and PostgreSQL database servers.
- Create, modify, and maintain database objects, including tables, indexes, views, and stored procedures.
- Monitor database performance and implement tuning strategies.
Backup & Recovery - Develop and maintain backup strategies.
- Implement and maintain high-availability and disaster-recovery solutions, including replication, clustering, and failover technologies to ensure data integrity and availability.
Security & Compliance
- Implement and maintain database security and compliance controls.
- Implement database security policies, including role-based access controls, permissions, and encryption.
- Ensure compliance with applicable data protection regulations (GDPR, HIPAA, etc.).
Performance Optimisation
- Continuously monitor and optimize database performance, capacity, and resource utilization.
- Analyze query performance and optimize SQL statements.
- Manage indexing strategies and partitioning.
Azure & Automation
- Administer and support Azure SQL Database, Azure SQL Managed Instance, and other database-related Azure services where applicable.
- Develop and maintain automation scripts using PowerShell, Bash, Python, or similar technologies to reduce operational effort and improve reliability.
Operational Support and Reliability
- Monitor database availability, capacity, scheduled jobs, backups, replication, and performance.
- Investigate and resolve database incidents and service requests.
- Perform root cause analysis for recurring or high-impact issues.
- Maintain operational documentation and support planned production changes in accordance with established procedures.
- Collaborate with infrastructure, DevOps, and application teams to support deployments, migrations, and operational improvements.
- Technical competencies include practical knowledge of relational database platforms; SQL and query-performance analysis; backup, restore, and disaster recovery methods; access control, encryption, and database security; monitoring and troubleshooting tools; and scripting or automation used for repeatable administrative tasks.
- Ability to communicate technical issues, risks, and recommendations clearly to technical and non-technical stakeholders.
- Professional proficiency in written and spoken English.
- Ability to collaborate effectively with infrastructure, application support, development, security, and business teams.
- Proactive, accountable, and solution-oriented approach to operational issues.