Database Administrator (DBA)

Responsible for the design, implementation, maintenance, and performance optimization of all database systems supporting our lottery and betting platform, ensuring high availability, data integrity, and security across Oracle and PostgreSQL environments.

Operational Responsibilities

Day-to-Day Operations
- Monitor database health, performance, and capacity
- Respond to alerts (connection issues, replication lag, disk space)
- Execute Liquibase migrations during deployments
- Manage database user accounts and permissions
- Troubleshoot slow queries and lock contention

Deployment Support
- Coordinate database changes with Ansible deployments
- Validate pre/post-deployment database state
- Execute schema migrations across environments
- Manage database credentials in Ansible Vault/KeePass

Performance Management
- Analyze and optimize slow queries
- Implement and maintain indexing strategies
- Configure connection pooling and resource limits
- Capacity planning and growth forecasting
- Generate performance reports and recommendations

Backup & Recovery
- Design and implement backup schedules
- Test recovery procedures regularly
- Manage backup retention and archival
- Document recovery runbooks

Security & Compliance
- Implement database-level encryption (TDE)
- Manage SSL/TLS connections to databases
- Audit database access and changes
- Rotate database credentials

Ansible Integration

Required Understanding
- Execute database-specific playbooks
- Troubleshoot Ansible database deployments
- Provide input for database automation improvements

Collaboration with DevOps
- Define database configuration as code
- Review Ansible roles for database changes
- Develop Liquibase changesets for automation
- Test database automation in sandbox environments