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. 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 a Database Architect / Database Architect (m/f/d) YOUR TASKS Design, 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 processes Data modelling and schema design taking into account performance, scalability and storage optimization for very large data volumes Implementation and maintenance of ETL processes with SSIS and/or Apache Airflow for high-volume data flows Ensuring synchronization between MSSQL and PostgreSQL systems, including the design of replication and transformation processes to harmonize the data models between the clusters Harmonization and standardization of existing versioning processes (currently Flyway, Alembic) Definition and implementation of database standards and governance guidelines together with internal and external partners Coordination of multiple service providers and internal teams to ensure uniform data architectures Support in monitoring and optimizing performance, index structures, partitioning and query plans YOUR PROFILE Completed (technical) university degree in (business) computer science, mathematics or a comparable course of study or a comparable qualification or comparable training with relevant professional experience At least 3 years of experience in the design, implementation and administration of productive database systems, ideally in the SHI environment Proven experience in the design, migration and further development of complex relational database schemas, including indexing, partitioning and versioning Deep understanding of transaction processing, locking mechanisms and query optimization for very large amounts of data Familiar with Red Hat OpenShift and Grafana Knowledge of Apache Airflow is desirable Very good knowledge of written and spoken German OUR OFFER A pleasant working atmosphere in a motivated and interdisciplinary team with a lively, open corporate culture and flat hierarchies Very good development and training opportunities Flexible working hours / mobile working Support for parents and carers to balance work and private life 30 days' vacation, increasing according to length of service, Christmas Eve and New Year's Eve are company holidays Company pension scheme State-of-the-art office workplaces and very good public transport connections Further extras for employees: Corporate benefits - offers with special conditions from well-known manufacturers and brands as well as JobRad leasing YOUR CONTACT PERSONS Manja Wentzel Tel: +49 30 586945-156 Vivien Franz Tel: +49 30 586945-175 YOUR APPLICATION If this challenging position appeals to you, we look forward to receiving your complete application documents. Berlin Otto-Ostrowski-Strasse 5 10249 Berlin Food Brunnenstrasse 15 - 17 45128 Essen Schwerin Am Grünen Tal 36 / House D 19063 Schwerin