


Improve the document storage system of a business application

IT-Hochschulpraktikum für Studierende
Bereich:
IT-Infrastrukturentwicklung
Projekt Zeitplan:

180 Stunden
Ausgangslage und Problemstellung
ePlix is an innovative Swiss web app optimizing pension management. In this IT internship, you'll help transition an application data storage from Microsoft SQL (MSSQL) database to the more versatile PostgreSQL. You will be able to work on the infrastructure and application sides of database migration. You'll be involved in setting up the PostreSQL database on cloud infrastructure and provisioning it for optimal performance. Additionally, you'll help update the application to utilize the new PostgreSQL persistence, ensuring a seamless transition for users.
Ziel der Arbeit und erwartete Resultate
Your task will involve designing and implementing a solution that transitions the database from MSSQL to Postgresql. This project aims to enhance efficiency and performance, making it an excellent learning opportunity for undergraduate students interested in IT, database management, and cloud computing.
Gewünschte Methoden, Vorgehen
For the successful implementation of this IT internship project, you will need to be familiar with a range of technologies and tools that will help you effectively migrate the database, such as: Kubernetes, Terraform, Helm, ArgoCD, Java, Spring Boot, Spring Data, Spring Testing, SSH, Shell, Linux
Kreativität, Varianten, Innovation
This project provides extensive creative scope, offering several areas to explore innovative solutions: Designing the migration process, Implementing the solution (coding, scripting, or even developing new tools), optimizing performance and creative problem-solving methodologies and hands-on learning in IT, database management, and cloud computing
Anforderungen, Vorkenntnisse
To successfully implement this IT internship project, an university student should possess a strong foundation in the following areas: Cloud technologies, Containerization and orchestration, Database Management, Software Development Lifecycle, Continuous Integration and Continuous Deployment (CI/CD), Git, Linux.
The project involves working with the eFrame's cloud infrastructure, code repositories and requires 1-2 weeks on-site presence at eFrame's office in Schwyz, after November 2023 in Rotkreuz.