Entry-Level Database Engineer

Role Overview:

The Entry-Level Database Engineer will collaborate closely with the full stack developer to design, implement, and maintain the relational database systems that support multiple web applications. The role involves optimizing database performance, ensuring data security, and assisting in the development of efficient data models.

Key Responsibilities:

1. Database Design and Development:

• Assist in designing database structures and schemas based on application requirements.
• Develop and maintain database code, including stored procedures, queries, and scripts.

2. Data Modeling:

• Create logical and physical data models to support web application features.
• Collaborate with software developers and data analysts to ensure data integrity and efficient database operations.

3. Performance Optimization:

• Monitor and analyse database performance; identify and resolve performance bottlenecks.
• Assist in optimising queries and database structures to enhance performance.

4. Database Maintenance:

• Participate in routine database maintenance, including backups, indexing, and data integrity checks.
• Assist in setting up and maintaining development, test, and production database environments.

5. Data Security and Compliance:

• Implement security measures to protect sensitive data.
• Assist in ensuring databases comply with relevant data protection regulations.

6. Troubleshooting and Support:

• Work with developers to troubleshoot and resolve database-related issues.
• Provide support for database-related queries and application integration.

7. Documentation:

• Maintain comprehensive documentation of database designs, processes, and changes.
• Assist in writing user and technical guides for database management.

Required Skills and Qualifications:

Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

Technical Skills:

• Familiarity with relational databases (e.g., MySQL, PostgreSQL, SQL Server) and basic SQL.
• Understanding of database design principles and data normalization.
• Basic knowledge of NoSQL databases (e.g., MongoDB) is a plus.
• Familiarity with database performance tuning and optimization techniques.
• Basic understanding of database security best practices.

Soft Skills:

• Strong analytical and problem-solving skills.
• Good communication skills and ability to work collaboratively within a team.
• Attention to detail and a proactive approach to learning.

Preferred Qualifications:

• Exposure to version control systems (e.g., Git) for managing database scripts.
• Basic knowledge of web development to understand the integration of databases with applications.
• Experience with database management tools and IDEs (e.g., MySQL Workbench, pgAdmin).