Apprentice - 7

Summary:

0

Duties & Responsibilities:

We are seeking a proactive and detail-oriented Database Administrator (DBA) Intern to join our Database Engineering team. This internship offers an excellent opportunity to gain practical experience in managing and supporting enterprise databases, including PostgreSQL, TimescaleDB, and MySQL.

The ideal candidate should possess a strong foundation in database concepts, SQL, and Linux, along with a keen interest in database administration, performance optimization, and high-availability technologies. You will work closely with experienced database professionals and contribute to database administration, monitoring, backup, maintenance, and automation activities.

Key Skills

• Basic knowledge of PostgreSQL and MySQL
• Good understanding of SQL and relational database concepts
• Familiarity with Linux/Unix operating systems
• Basic understanding of database backup and recovery concepts
• Knowledge of Shell scripting or Python is an added advantage
• Strong analytical and problem-solving skills
• Good communication and teamwork abilities
• Willingness to learn emerging database technologies such as TimescaleDB and ArangoDB

Roles & Responsibilities:

PostgreSQL & TimescaleDB

• Assist in the installation, configuration, and maintenance of PostgreSQL and TimescaleDB environments.
• Support database monitoring, health checks, and routine maintenance activities.
• Create and manage databases, schemas, users, and permissions under supervision.
• Assist with database backup, restoration, and recovery procedures.
• Support performance monitoring and basic SQL query optimization.
• Learn and work with TimescaleDB features such as hypertables, continuous aggregates, compression, and data retention policies.
• Maintain technical documentation related to database configurations and operational procedures.

MySQL

• Assist in provisioning and configuring MySQL database instances.
• Support routine database administration tasks, including monitoring, optimization, and maintenance.
• Assist with backup, recovery, and replication activities.
• Help troubleshoot database-related issues under the guidance of senior DBAs.
• Contribute to automating routine database administration tasks through scripting.

Learning Exposure

• Gain practical exposure to database replication, clustering, high availability, and database security.
• Learn cloud-based database deployment and administration practices.
• Assist in database migration and performance tuning activities.
• Work closely with senior engineers to identify and resolve database issues.

Eligibility

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related discipline.
• 0–1 year of experience in Database Administration, SQL Development, or related areas (internships, academic projects, or certifications are acceptable).
• Strong understanding of DBMS fundamentals and SQL.
• Basic knowledge of Linux administration.
• Passion for learning database technologies and building a career in database engineering.

Preferred Skills

• Exposure to PostgreSQL, MySQL, or TimescaleDB through academic projects or internships.
• Basic knowledge of Git, Docker, or cloud platforms (AWS, Azure, or GCP) is an advantage.
• Familiarity with Shell scripting or Python.
• Good analytical, communication, and documentation skills.

What You'll Gain

• Hands-on experience with enterprise database administration.
• Exposure to PostgreSQL, TimescaleDB, and MySQL environments.
• Practical knowledge of backup and recovery, monitoring, performance tuning, and database security.
• Mentorship from experienced database engineers.
• Opportunity to work on real-world database infrastructure and automation initiatives.

Pre-Requisites / Skills / Experience Requirements: