Internship, Database Administration

📋 Description

• • Embark on a foundational journey into the critical field of Database Administration with this exciting internship opportunity at VSP Vision. This role is meticulously designed for aspiring Database Administrators eager to translate academic knowledge into tangible, real-world experience, significantly expanding their technical skillset and professional acumen.
• • As a GTS Database Administrator Intern, you will become an integral part of a dynamic team, partnering closely with seasoned Database Administrators. This collaboration will provide unparalleled exposure to the multifaceted operations of an enterprise-level IT infrastructure, fostering the development of essential business competencies through hands-on involvement in a variety of critical tasks.
• • Your responsibilities will span the entire lifecycle of database management, offering a comprehensive understanding of what it takes to maintain robust and efficient data systems. You will gain practical experience in the installation and upgrading of database systems, ensuring they are current, secure, and performant.
• • A significant aspect of the role involves contributing to the security configuration of databases. This includes understanding and implementing measures to protect sensitive data, a paramount concern in today's digital landscape. You will learn to apply security best practices to safeguard information assets.
• • You will have the opportunity to execute SQL scripts, a fundamental skill for any database professional. This involves updating data to reflect business changes or modifying database schemas to support new functionalities and improve data structure and integrity.
• • The internship will provide direct involvement in capacity planning, a crucial element for ensuring that database systems can handle current and future demands. This involves monitoring resource utilization, forecasting growth, and recommending necessary adjustments to hardware or software configurations.
• • You will participate in the analysis of database performance issues. This entails identifying bottlenecks, understanding query execution plans, and learning techniques to optimize database operations for speed and efficiency.
• • A key contribution will be the creation of development and testing databases in non-production environments. This supports the work of development teams by providing them with stable, representative environments to build and test new applications and features without impacting live systems.
• • Furthermore, you will engage in the critical process of data masking for secure databases intended for non-production use. This ensures that sensitive information is anonymized or obfuscated, protecting privacy while still allowing for realistic testing and development scenarios.
• • This internship is an exceptional chance to learn about the intricate workings of enterprise databases, including Microsoft SQL Server, PostgreSQL, and IBM DB2, and to gain exposure to advanced tools like Delphix for virtual databases.
• • You will develop a keen eye for detail and hone your analytical abilities as you tackle complex database challenges. The program is structured to provide a broad range of experiences, preparing you for a successful career in database administration.
• • The program runs from June 1st to August 7th, requiring a full 10-week commitment, offering an intensive and rewarding learning experience. This immersive period is designed to maximize your exposure and learning within a supportive and professional environment.
• • By the end of this internship, you will possess a solid understanding of database administration principles, practical skills in managing and optimizing databases, and a valuable foundation for future roles in IT and data management.