Job Summary
We are seeking a highly skilled and customer-focused Database Administrator (DBA) to join our team. In this role, you will be responsible for the health, performance, and reliability of database environments for a portfolio of clients. The ideal candidate will have a strong background in managing both Oracle and SQL databases. This position requires deep technical expertise, strong analytical/problem-solving ability, and excellent client communication skills.
Key Responsibilities
* Database Maintenance & Health: Perform proactive and scheduled database maintenance, including index management, statistics updates, integrity checks, and patching for multiple client environments.
* Performance Tuning: Continuously monitor database performance, identify bottlenecks, and conduct in-depth query and server tuning to ensure optimal speed and reliability for client applications.
* Backup & Disaster Recovery: Design, implement, and manage robust backup, recovery, and high-availability solutions (e.g., Always On Availability Groups) across both on-premise and cloud platforms. Regularly test and document recovery procedures against RTO/RPO targets.
* Azure Database Administration: Administer and support a range of Azure database services, including Azure SQL Database, Managed Instances, and related PaaS offerings.
* On-Premise Server Management: Manage all aspects of on-premise SQL Server instances from installation and configuration to security and decommissioning.
* Client Support & Collaboration: Act as a trusted advisor for our clients. Respond to database-related incidents and requests, provide root cause analysis, and communicate technical information clearly to stakeholders.
* Automation & Efficiency: Develop and maintain PowerShell or T-SQL scripts to automate routine tasks, streamline processes, and improve operational efficiency across the client base.
* Monitoring: Establish standardised monitoring dashboards and alerts (via LogicMonitor) and align thresholds to client SLAs.
Required Qualifications & Skills
* Experience: 3-5+ years of dedicated experience as a Oracle DBA.
* Technical Expertise: In Oracle and SQL Server administration, including performance tuning, T-SQL scripting, and security best practices.
* Cloud Proficiency: Hands-on experience managing and migrating databases in the Microsoft Azure cloud.
* Backup & Recovery: Proven ability to design and manage comprehensive backup and disaster recovery strategies. (Veeam, SQL Agent Jobs, etc.)
* Problem-Solving: Strong analytical and troubleshooting skills with the ability to manage priorities in a multi-tenant MSP environment.
* Communication: Excellent interpersonal and communication skills, capable of building strong relationships with clients.
Preferred Qualifications
* AWS Experience: Familiarity with AWS database services such as RDS or Aurora.
* Certifications: Azure Database Administrator Associate (DP-300) or similar industry certifications. (MSCA Database Administrator also highly regarded)
* Scripting: Proficiency in PowerShell for database automation.
* High Availability: In-depth experience with SQL Server Always On Availability Groups and Failover Clustering.
* Data Orchestration: Experience with SSIS pipelines, Azure Data Factory or other ETL/ELT tools.