Database Administrator (DBA)

Tasks

• Audit and rotate credentials
• Audit slow query logs
• Conduct knowledge sharing with DevOps
• Define and test failover and switchover runbooks
• Define safe schema migration procedures
• Design and execute GTID migration plan
• Enforce no deploy before migration
• Ensure data at rest and in transit encryption
• Implement and verify backup strategy
• Implement schema migrations in CI CD pipeline
• Integrate secrets management
• Maintain migration history and rollback procedures
• Maintain point in time recovery
• Manage MariaDB replication topology
• Manage database users roles and access policies
• Monitor replica lag
• Own and operate multi engine database infrastructure
• Participate in on-call rotation
• Set up database observability for metrics
• Test restore procedures
• Tune database parameters for workload
• Write and maintain database runbooks

Perks/Benefits

• Annual company offsite
• Competitive leave
• Development budget
• E-learning platforms
• Full time remote working
• Global training workshops
• Internal growth opportunities
• On-call rotation
• Online English language classes
• Public holidays
• Sick leave

Skills/Tech-stack

AWS | AWS RDS | Bash | Binlog | CD | CI | CI/CD | Data encryption | Database monitoring | Disaster Recovery | Docker | EXplain | GH-OST | GTID | Grafana | In Transit Encryption | InnoDB | InnoDB Tuning | Linux | Log Analysis | MariaBackup | MariaDB | MySQL | Online DDL | Online Schema Change | PMM | Percona Toolkit | Percona XtraBackup | Point In Time | Point-in-time recovery | PostgreSQL | Prometheus | Pt online schema change | RDS Parameter Groups | Replication | Schema Change | Secrets management | Systemd