Database Administrator
Internshala
About the job
Role: Junior Database Administrator MySQL & PostgreSQL (Monitoring)Role SummaryWe 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 ResponsibilitiesDatabase 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
Monitoring Setup & Alerting (Primary Skill Set)
- Assist in setting up and maintaining database monitoring
- Configure and tune alerts for critical metrics, including:
- CPU, memory, disk usage
- Database availability
- Replication health
- Slow queries and connection counts
- Analyze alerts and perform initial troubleshooting, escalating issues when needed
- Work with senior DBAs to improve alert accuracy and noise reduction
- Maintain monitoring dashboards and basic performance reports
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
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)
Don't want to miss the next one?
Subscribe to daily email alerts for roles matching your interests.