Database Administrator
optiva · Dhaka ·
- Category
- Devops
optiva · Dhaka ·
It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.
We are seeking an experienced Database Administrator (DBA) to manage, maintain, and optimize MariaDB, PostgreSQL, and Cassandra database platforms. The ideal candidate will ensure high availability, performance, security, and scalability of databases supporting mission-critical applications.
Key Responsibilities
Database Administration:
Install, configure, upgrade, and maintain MariaDB, PostgreSQL, and Apache Cassandra databases
Perform database capacity planning, performance tuning, and optimization
Monitor database health, replication, clustering, and availability
Backup, Recovery & High Availability:
Design and manage backup and recovery strategies (logical & physical backups)
Implement and manage replication, clustering, and failover solutions
Perform disaster recovery planning and regular DR drills
Security & Compliance:
Manage database security: users, roles, privileges, encryption, and auditing
Apply security patches and upgrades in compliance with company policies
Ensure compliance with data protection and regulatory standards
Performance & Troubleshooting:
Diagnose and resolve database performance issues and outages
Analyze slow queries, locks, and resource bottlenecks
Provide root cause analysis (RCA) for incidents
Automation:
Automate routine DBA tasks using scripts (Shell, Python, etc.)
Support containerized and cloud-based database deployments (if applicable)
Documentation & Support:
Maintain database documentation, SOPs, and operational runbooks
Provide on-call support for production database environments
Assist developers with schema design, indexing, and query optimization
Required Skills & Qualifications:
Technical Skills:
Strong hands-on experience with MariaDB / MySQL, PostgreSQL, and Apache Cassandra
Expertise in:
Replication & clustering (Galera, PostgreSQL streaming replication, Cassandra clusters)
Backup & recovery tools (mysqldump, pg_dump, pg_basebackup, nodetool, etc.)
Performance tuning and query optimization
Experience with Linux systems and shell scripting
Knowledge of monitoring tools (Prometheus, Grafana, Zabbix, Nagios, etc.)
Database Concepts:
ACID vs BASE principles
OLTP and distributed database architectures
Data modeling for relational and NoSQL databases