Position: Intern DBA / PGSQL Database Engineer / Administrator
Location: Johar Town / Lahore
Duration: 6 months
Type: Internship
About Terasols: At Terasols, we are dedicated to crafting cutting-edge digital solutions that empower businesses and individuals. As a leading software and web development company, we pride ourselves on our innovative approach and commitment to excellence. Join us to be part of a dynamic team that transforms ideas into reality.
Role Overview: We are seeking a motivated and enthusiastic Intern DBA / PGSQL Database Engineer / Administrator to join our team. This is an excellent opportunity for someone looking to gain hands-on experience in database administration, management, and optimization in a fast-paced, supportive environment. You will work closely with our senior database administrators, contributing to real projects and learning the best practices in the industry.
Responsibilities:
- Assist in the installation, configuration, and maintenance of PostgreSQL databases.
- Monitor database performance and perform tuning and optimization tasks.
- Help manage database security and user permissions.
- Assist in backup and recovery procedures to ensure data integrity and availability.
- Participate in database design and development activities.
- Support data migration and transformation tasks.
- Troubleshoot and resolve database-related issues.
- Document database configurations, processes, and procedures.
Qualifications:
- Currently pursuing or recently completed a degree in Computer Science, Information Technology, or a related field.
- Basic understanding of relational database management systems (RDBMS).
- Familiarity with PostgreSQL and SQL language.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and organizational skills.
- Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint).
- Self-motivated with a strong desire to learn and grow in the field of database administration.
- Ability to work independently and as part of a team.
Preferred Qualifications:
- Previous internship or project experience in database administration or management.
- Knowledge of database performance tuning and optimization techniques.
- Familiarity with database backup and recovery procedures.
- Understanding of data security best practices.
- Experience with scripting languages (e.g., Python, Bash) for automation tasks.
What We Offer:
- Hands-on experience with real-world database administration projects.
- Mentorship from experienced database administrators.
- A collaborative and inclusive work environment.
- Opportunity to learn and grow within the company.
- Potential for future full-time employment based on performance.