Role: Junior Database Administrator – MySQL & PostgreSQL
Role Summary
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 commands, 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 alert 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 PostgreSQL
- Assist 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 alerts and incidents, escalating when required
- Maintain documentation, runbooks, and standard operating procedures
- Participate in knowledge-sharing and learning sessions with senior DBAs
Required Skills & Qualifications
- 1 year of experience working with MySQL and/or PostgreSQL
- Basic understanding of relational database fundamentals
- Familiarity with Linux operating systems and standard Linux commands
- Basic understanding of SQL Queires (Select, Insert, Update, Delete)
- Good problem-solving and communication skills
Good to Have (Nice-to-Have Skills)
- Exposure to MSSQL
- Monitoring tools (basic exposure is sufficient)
- Basic scripting knowledge in Bash or Python
- Awareness of cloud databases (AWS / Azure) is a plus
