About the Project
Our project is a commercial insurance pricing tool for medium to large-sized companies. It is built on a microservice architecture, using Java, Kotlin, Spring on the backend, and Angular, NodeJS, Express, Fastify on the frontend. It allows the user to capture all necessary exposure data, apply advanced terms and conditions, value the risks and calculate the cost of the policy. In addition, we use a central data store on PostgresDB to meet the client’s specific reporting needs.
About the Role
We are looking for a Senior Database Engineer and Administrator with database migration and cloud transitions practical experience, ready to join our team. Willing to be fully responsible for the designing and development of relational database with PostgreSQL. Also, to administer and maintain relational database instances. Ensure the project database performance efficiency and to actively interact with our customer and with internal application developers’ teams .
What you´ll be doing
- Design and development of relational database with PostgreSQL
- Migrate databases to and within the cloud(s)
- Administer and maintain relational database instances (configuration, performance, backup, recovery, access rights including row-level-security, permissions etc.)
- Get your head around and to the same for document-oriented MongoDB
- Create and maintain entity relationship diagrams and data dictionaries
- Data base performance tuning and troubleshooting in cooperation with application developers
- Collaborate on application implementation projects
- Design and implementation of ETL processes
- Actively communicate with stakeholders from different hierarchies' levels and diverse backgrounds, understanding the projects’ environment, obstacles and identifying possible solutions, demonstrating analytical and problem-solving skills
Your skills and experience
- Degree in IT or equivalent experience
- Proven experience in relational database modelling, implementation and administration, preferably in PostgreSQL
- Experience and/or knowledge with row-level-security implementations
- Knowledge of processing JSON data in a database (deserializing, reporting, etc.)
- Experience with OLTP systems
- Experience working in Agile (SAFe)
- Team-oriented, reliable, and self-driven
- Proactive, communicative and strong analytical capabilities
- Service-orientation with a strong focus on customer satisfaction
- Ability to cope with tight deadlines
Will be a plus
- Cloud infrastructure knowledge (Azure, AWS)