Role description
We are seeking a Junior MySQL & PostgreSQL Database Administrator with around 1 year of hands-on experience to support the operation, and maintenance of PostgreSQL and MySQL and other relational databases. This role is ideal for someone with good foundation in database administration, database design concepts, and Linux systems comands, while working under the guidance of senior DBAs.
The ideal candidate has a good understanding of MySQL and PostgreSQL fundamentals, basic database design principles, and is comfortable working in Linux environments.
Key Responsibilities
- Database Administration & Operations
- Assist in the day-to-day administration of MySQL and PostgreSQL databases in development, test, and production environments
- Monitor database health, availability, and performance under senior DBA guidance
- Perform routine DBA tasks such as: User and role management
- Schema changes and basic maintenance activities
- Log review and investigation
- Support database start/stop, backups, restores, and basic recovery tasks
- Database Design & Development Support
- Understand and apply database design concepts, including: Normalization and denormalization
- Primary keys, foreign keys, indexes, and constraints
- Assist application teams with Table design and index recommendations
- Backup, Recovery & Maintenance
- Execute and validate database backup and restore procedures for MySQL and PostgreSQLAssist with patching, minor upgrades, and version changes under supervision
- Linux & System Support
- Work in Linux environments to manage and support database systems
- Use common Linux commands for: File system navigation
- Log analysis
- Process and disk usage monitoring
- Monitoring, Documentation & Support
- Respond to basic database s and incidents, escalating when required
- Maintain documentation, runbooks, and standard operating procedures
- Participate in knowledge-sharing and learning sessions with senior DBAs
