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.