Database Administrator (DBA)

We are looking for an experienced and highly skilled Database Administrator (DBA) with strong expertise across relational, NoSQL, analytical, and distributed database platforms. The ideal candidate should have hands-on experience in database administration, performance optimisation, high availability (HA), replication, backup and recovery, disaster recovery, monitoring, and database security. The candidate should be capable of managing production-grade database environments handling large-scale workloads, mission-critical applications, and high-availability architectures across cloud and on-premises infrastructure.

Responsibilities:

• Install, configure, upgrade, patch, and maintain database systems across multiple environments.
• Manage and administer SQL, NoSQL, in-memory, and analytical databases.
• Design and implement High Availability (HA), clustering, failover, and disaster recovery solutions.
• Configure and manage database replication across multiple instances and regions.
• Perform database performance tuning, query optimisation, indexing, and capacity planning.
• Implement and manage backup strategies including Full, Incremental, Differential, and Point-in-Time Recovery (PITR).
• Perform database restoration and disaster recovery drills.
• Configure and monitor database health, availability, replication lag, storage, and performance metrics.
• Implement database monitoring and alerting solutions using industry-standard tools.
• Manage Change Data Capture (CDC) and real-time data replication pipelines.
• Ensure database security, encryption, access control, auditing, and compliance standards.
• Troubleshoot production database incidents and perform root cause analysis (RCA).
• Automate routine DBA activities using scripting and Infrastructure as Code practices.
• Collaborate with DevOps, Application, Infrastructure, and Security teams for deployments and optimisation.
• Create and maintain technical documentation, SOPs, architecture diagrams, and operational runbooks.

Requirements:

• Required Technical Skills: SQL Databases.
• Strong hands-on experience with: PostgreSQL, MySQL, Microsoft SQL Server (MSSQL), MariaDB, Oracle Database, NoSQL Databases.
• Experience with: MongoDB, Vector Databases (such as Milvus, Pinecone, Weaviate, Qdrant, ChromaDB, or equivalent).
• In-Memory Databases, Redis, Analytical / Search Databases, ClickHouse, OpenSearch, Elasticsearch.

Required Expertise:

Database Administration:

• Database installation, configuration, migration, patching, and upgrades
• Database schema management and optimization
• Database lifecycle management

High Availability and Replication:

• Multi-node clustering
• Master-Slave / Primary-Replica replication
• Multi-master replication concepts
• Streaming replication
• Failover and switchover mechanisms
• Cross-region replication strategies

Performance Optimisation:

• Query tuning and execution plan analysis
• Index optimization
• Connection pooling
• Storage optimization
• Partitioning and sharding concepts
• Resource utilization analysis

Backup and Recovery:

• Full Backup
• Incremental Backup
• Differential Backup
• WAL/binlog-based recovery
• Point-in-Time Recovery (PITR)
• Disaster Recovery planning and testing

Monitoring and Observability:

Experience with monitoring tools such as:

• Prometheus
• Grafana
• ELK Stack
• OpenSearch Dashboards
• Percona Monitoring and Management (PMM)
• Database-native monitoring solutions

CDC and Data Replication:

Knowledge of:

• Change Data Capture (CDC)
• Debezium
• Kafka Connect
• Logical replication
• Real-time data synchronisation pipelines

Additional Preferred Skills:

• Experience with Kubernetes-based database deployments and operators.
• Knowledge of cloud-managed database services on Private Cloud, AWS and Azure.
• Experience with Infrastructure as Code (Terraform, Ansible, Helm).
• Familiarity with containerised environments and DevOps practices.
• Knowledge of data lake, warehouse and analytics architectures.
• Understanding of database security best practices and compliance standards.
• Experience handling large-scale production databases (TB/PB scale environments).
• Scripting knowledge in Bash, Python and PowerShell.
• Experience implementing database automation and self-healing mechanisms.

Soft Skills:

• Strong troubleshooting and analytical skills.
• Excellent communication and documentation abilities.
• Ability to work in high-pressure production environments.
• Strong ownership and proactive problem-solving mindset.
• Ability to collaborate across cross-functional teams.
• Experience with distributed systems and large-scale data platforms.

Skills

ClickHouse, DBA, Elasticsearch, MSSQL, MariaDB, MongoDB, MySQL, OpenSearch, Oracle, PostgreSQL, Redis, database