Database Administrator (DBA)

Tasks

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

Perks/Benefits

• Annual company offsite
• Development budget
• E-learning platforms
• Full-time remote work
• Global training workshops
• Internal mobility
• Online English classes
• Paid time off
• Public holidays
• Remote friendly schedule
• Sick leave

Skills/Tech-stack

Amazon RDS | Backup and Restore | Bash | Binary logging | CI/CD | Container Volumes | Data encryption | Database performance | Database performance tuning | Disaster Recovery | Docker | EXplain | GH-OST | GTID | Grafana | Index optimization | InnoDB | InnoDB Tuning | Least Privilege | Linux | Log Analysis | MariaBackup | MariaDB | Monitoring and Management | Online DDL | Online Schema Change | Percona Monitoring | Percona Monitoring and Management | Percona Toolkit | Percona XtraBackup | Performance Tuning | Point In Time | Point-in-time recovery | Prometheus | Pt online schema change | RDS Parameter Groups | Replication | Schema Change | Secrets management | Slow Query Log | Systemd | Transport layer | Transport layer security