Database Architect

spectrumK is the innovative specialist with a high level of expertise in the SHI service landscape. Over 90 percent of statutory health insurance companies rely on our services. With our interdisciplinary team, we create unbeatable benefits for our customers with intelligent solutions. Together, we work towards the goal of providing better care for people with statutory health insurance. To achieve this, we rely on a corporate culture that puts our employees at the center. This includes distinct opportunities for participation as well as plenty of room for personal development. We see ourselves as a company that strives for holistic change. We cordially invite all employees to join us. The spectrumK group of companies includes InGef GmbH and SIDA Service GmbH.Wenn Sie wissen möchten, welche Anforderungen Sie für diese Stelle erfüllen müssen, lesen Sie weiter, um alle relevanten Informationen zu erhalten.spectrumK GmbH works on the digitalization and automation of processes in the healthcare sector with a special focus on the auditing and billing of services provided for statutory health insurance companies. In collaboration with our development partners, we have developed the innovative software platform daewy, which enables the real-time processing, verification and billing of electronic prescriptions. With daewy, billing processes in the healthcare sector are optimized and made more efficient.For our Berlin location and/or in hybrid working, we are looking for aDatabase Architect / Database Architect (m/f/d)YOUR TASKSDesign, setup and operation of database systems based on Microsoft SQL Server (HA cluster) and PostgreSQL (cloud-native deployments on Red Hat OpenShift)Design of the database architecture and harmonization of processesData modelling and schema design taking into account performance, scalability and storage optimization for very large data volumesImplementation and maintenance of ETL processes with SSIS and/or Apache Airflow for high-volume data flowsEnsuring synchronization between MSSQL and PostgreSQL systems, including the design of replication and transformation processes to harmonize the data models between the clustersHarmonization and standardization of existing versioning processes (currently Flyway, Alembic)Definition and implementation of database standards and governance guidelines together with internal and external partnersCoordination of multiple service providers and internal teams to ensure uniform data architecturesSupport in monitoring and optimizing performance, index structures, partitioning and query plansYOUR PROFILECompleted (technical) university degree in (business) computer science, mathematics or a comparable course of study or a comparable qualification or comparable training with relevant professional experienceAt least 3 years of experience in the design, implementation and administration of productive database systems, ideally in the SHI environmentProven experience in the design, migration and further development of complex relational database schemas, including indexing, partitioning and versioningDeep understanding of transaction processing, locking mechanisms and query optimization for very large amounts of dataFamiliar with Red Hat OpenShift and GrafanaKnowledge of Apache Airflow is desirable xgcbozq Very good knowledge of written and spoken GermanOUR OFFERA pleasant working atmosphere in a motivated and interdisciplinary team with a lively, open corporate culture and flat hierarchiesVery good development and training opportunitiesFlexible working hours / mobile workingSupport for parents and carers to balance work and private life30 days' vacation, increasing according to length of service, Christmas Eve and New Year's Eve are company holidaysCompany pension schemeState-of-the-art office workplaces and very good public transport connectionsFurther extras for employees: Corporate benefits - offers with special conditions from well-known manufacturers and brands as well as JobRad leasingYOUR APPLICATIONIf this challenging position appeals to you, we look forward to receiving your complete application documents.BerlinOtto-Ostrowski-Strasse 510249 BerlinFoodBrunnenstrasse45128 EssenSchwerinAm Grünen Tal 36 / House D19063 Schwerin