Database Administrator

Summary

• Design, maintain, and support the company’s database infrastructure.
• Ensure data integrity, availability, and performance optimisation.
• Implement database backups, disaster recovery procedures, and security measures.
• Collaborate with development teams to optimise database performance and queries.
• Monitor system performance, diagnose and troubleshoot database issues.

Key Skills

• Proficient in database management systems (e.g., MySQL, PostgreSQL, Oracle, MSSQL).
• Experience in database tuning and performance optimisation.
• Familiarity with database backup and recovery procedures.
• Strong understanding of database structures, principles, and best practices.
• Excellent problem-solving skills and attention to detail.

Standard Industry Training

• Certifications related to specific database technologies (e.g., Oracle DBA Certification, Microsoft SQL Server Certification).

Interview Questions:

1. How do you handle a situation where the database performance suddenly drops?
2. Describe a time when you had to recover data from a backup. What was the situation and how did you handle it?
3. How do you ensure the security of sensitive data in the database?
4. What are your strategies for database scaling and replication?
5. Explain the difference between normalisation and denormalisation.