Database Administrator (MariaDB, PostgreSQL, Cassandra)

About the role

Optiva is looking for an experienced Database Administrator to manage, maintain and optimize MariaDB, PostgreSQL and Cassandra database platforms. The role ensures high availability, performance, security and scalability of databases supporting mission-critical applications.

Key responsibilities

• Install, configure, upgrade and maintain MariaDB, PostgreSQL and Apache Cassandra databases
• Plan capacity, tune and optimize performance, and monitor health, replication, clustering and availability
• Design backup and recovery strategies (logical and physical), implement replication, clustering and failover, and run disaster recovery drills
• Manage security: users, roles, privileges, encryption and auditing, and apply security patches in line with company policy
• Diagnose performance issues and outages, analyze slow queries, locks and bottlenecks, and provide root cause analysis
• Automate routine tasks with scripts (Shell, Python) and support containerized and cloud-based deployments
• Maintain documentation, SOPs and runbooks, provide on-call support, and help developers with schema design, indexing and query optimization

Required profile

• Strong hands-on experience with MariaDB / MySQL, PostgreSQL and Apache Cassandra
• Knowledge of ACID vs BASE principles, OLTP and distributed database architectures, and data modeling for relational and NoSQL databases

Required skills

• Replication and clustering (Galera, PostgreSQL streaming replication, Cassandra clusters)
• Backup and recovery tools (mysqldump, pg_dump, pg_basebackup, nodetool)
• Linux systems and shell scripting
• Monitoring tools such as Prometheus, Grafana, Zabbix and Nagios