At a Glance
- Tasks: Manage and optimise databases, ensuring high availability and performance.
- Company: Join a leading tech firm focused on mission-critical systems.
- Benefits: Attractive salary, flexible working options, and ongoing training opportunities.
- Other info: Exciting career growth potential in a supportive environment.
- Why this job: Be part of a dynamic team that tackles real-world challenges in database management.
- Qualifications: 5-8 years DBA experience with MSSQL and MongoDB expertise required.
The predicted salary is between 54000 - 66000 £ per year.
Role Overview
We are seeking a hands‑on Operations DBA to support the mission‑critical system operating in a secured environment.
Key responsibilities
- 1. 24/7 Production Database Operations
- Provide L2/L3 support for MSSQL and Mongo DB in Production and DR environments.
- Participate in standby/on‑call roster for critical incidents.
- Troubleshoot and resolve: Database outages, Always On failover issues, Blocking/deadlocks, Performance bottlenecks, Storage/IOPS constraints and Perform root cause analysis (RCA) & implement preventive measures.
- 2. High Availability & Reliability Management
- Microsoft SQL Server (MSSQL)
- Manage Always On Availability Groups.
- Monitor replication and failover health.
- Perform database patching and cumulative updates.
- Maintain backup and restore strategy (Full, Differential, Log backups).
- Conduct periodic DR drills and restoration validation.
- Optimise indexing strategies and execution plans.
- Mongo DB
- Manage Replica Sets & automate failover.
- Monitor memory, disk and index performance.
- Manage backup/restore and periodic recovery validation.
- Maintain cluster health and sharding (if applicable).
- 3. Performance & Capacity Management
- Conduct proactive health checks.
- Analyse query execution plans (MSSQL), slow queries and indexing (Mongo DB), perform database tuning & optimisation and forecast capacity growth and scaling requirements.
- 4. Change & Release Support
- Review database scripts prior to production deployment.
- Support data migration and release windows.
- Validate database stability post‑deployment.
- Ensure proper rollback and recovery procedures are in place.
- 5. Security & Compliance (Government Environment)
- Implement database security hardening.
- Manage role‑based access control & auditing and logging.
- Support vulnerability (VA) remediation.
- Ensure compliance with government security policies.
- Maintain proper documentation and SOPs for audit readiness.
- Technical Requirements
- 5 – 8+ years of DBA experience.
- Strong hands‑on experience: Microsoft SQL Server (Always On, HA, performance tuning) & Mongo DB (Replica Sets, backup/restore).
- Experience supporting 24/7 mission‑critical systems.
- Experience handling Severity 1 production incidents.
- Experience in supporting application deployment (data patching, data seed, etc.).
- Strong troubleshooting and analytical skills.
Interested candidates, please send your CVs to nabilah. azman@tg-hr. com.
Regret to inform that only shortlisted candidates will be notified.
#J-18808-Ljbffr
Database Administrator (MSSQL & MongoDB) in Penarth employer: APBA TG HUMAN RESOURCE PTE. LTD.
As an Automation Engineer at our company, you will thrive in a dynamic work environment that prioritises innovation and collaboration. We offer competitive benefits, a strong commitment to employee development, and opportunities for growth within the pharmaceutical sector, all while adhering to GMP standards. Our supportive culture encourages teamwork and continuous learning, making it an excellent place for professionals seeking meaningful and rewarding careers.
Contact Details:
APBA TG HUMAN RESOURCE PTE. LTD. Recruitment Team
