Database Administrator

OSOS LLC; Tipton; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading IT solutions provider is seeking a Database Administrator to manage and optimize PostgreSQL, MySQL, and MongoDB databases. This role requires 5-7 years of experience in database administration for cloud and on-premises environments. Responsibilities include implementing security policies, performing backups, and ensuring high availability. Candidates should possess a degree in Computer Science and experience with AWS and Azure services. Competitive salary and benefits offered.

Qualifications

• 5-7 years of experience as a Database Administrator managing PostgreSQL, MySQL, and MongoDB.
• Proven experience managing multi-terabyte databases with millions of records.
• Hands-on experience with AWS RDS and Azure Database.

Responsibilities

• Design, install, configure, and maintain databases.
• Monitor and optimize query performance.
• Implement backup and disaster recovery plans.

Skills

PostgreSQL

MySQL

MongoDB

SQL scripting

Performance Optimization

AWS RDS

Azure Database

Linux

Docker

Kubernetes

Education

Bachelor's degree in Computer Science or related field

Tools

pgAdmin

Prometheus

Datadog

New Relic

Job description

About the job Database Administrator (DBA)

Job Title: Database Administrator

Job Location: Colombo, Sri Lanka [On-site]

General Description:

We are a leading IT solutions provider, offering cutting-edge business function and support solutions on a SaaS model to help businesses achieve digital transformation and innovation.

This role is responsible for end-to-end database administration and management, ensuring high availability, scalability, security, and performance. The Database Administrator will work closely with Infrastructure, Development, Implementation, and Support teams to ensure seamless database operations.

Key Responsibilities:

• Design, install, configure, and maintain highly available PostgreSQL, MySQL, and MongoDB databases in on-premises customer environments and large-scale cloud multi-tenant databases across AWS, Azure, and GCP.
• Performance Optimization: Monitor and optimize query performance, indexing, partitioning, and troubleshooting slow queries, ensuring support for 3,000+ concurrent users.
• Configure database environment with appropriate parameters, properties or sizing that suits the need of day-to-day business operation and growth.
• Backup & Recovery: Implement backup, recovery, and disaster recovery (DR) plans with well-defined RPO (Recovery Point Objective) and RTO (Recovery Time Objective).
• High Availability & Scalability: Set up and manage clustering, replication, multi-instance, multi-tenant, mirroring, and standby databases, ensuring uptime of 99.9% or higher.
• Security & Compliance: Implement and enforce database security policies, encryption, and access controls.
• Storage & Infrastructure: Manage database storage, ensure efficient resource allocation based on workload demands, handling millions of records per day.
• Automation & Scripting: Develop automation scripts for database monitoring, maintenance, and deployment using Bash, Python, or SQL scripts.
• Troubleshooting & Support: Diagnose and resolve database-related issues while providing proactive support to development and infrastructure teams.
• Technology Evaluation: Research and recommend emerging database technologies and best practices.
• Required Skills & Qualifications:
• Minimum 5-7 years of experience as a Database Administrator (DBA) managing PostgreSQL, MySQL and MongoDB in cloud and on-premises environments.
• Proven experience managing large-scale databases (multi-terabyte size) with high transaction volumes (millions of records per day).
• Strong expertise in database architecture, installation, configuration, tuning, and optimization.
• Hands-on experience with AWS RDS, Azure Database for PostgreSQL/MySQL, or GCP Cloud SQL.
• Experience with replication, clustering, database mirroring, and high-availability solutions.
• Strong proficiency in SQL scripting, stored procedures, triggers, and indexing strategies.
• Knowledge of MSSQL, Oracle and NoSQL databases Cassandra is a plus.
• Proficiency in Linux and Windows server environments.
• Experience working with virtualization/containerization technologies (Docker, Kubernetes).
• Familiarity with database monitoring tools (pgAdmin, Prometheus, Datadog, New Relic, etc.).
• Strong understanding of data security best practices and compliance.
• Review database changes before deployed to quality environment. Make sure all changes are verified and follow best practices and compliance.

Preferred Qualifications:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• DBA Certifications (PostgreSQL, MySQL) are preferred.
• Azure/AWS Foundation or Associate Certifications will be an added advantage.