Background
Profile

Troels Kaldau

Software Developer with a focus on end-to-end mobile applications

Experience
Projects
Skills
Header Image

Persistence

  • MongoDB
  • PostgreSQL
  • SQLite
  • Firebase Storage
  • TL;DR

    Proven track record in designing, implementing, and managing diverse database systems. Proficient in both SQL and NoSQL solutions, ensuring data integrity, scalability, and efficient querying.

    MongoDB

    MongoDB is a NoSQL document-oriented database widely used for building scalable applications.

    I've been working extensively with MongoDB since 2022, using it in several professional projects. My responsibilities included designing database models, configuring streams and indexes, and optimizing queries for performance. Leveraging MongoDB Atlas monitoring, I identified and addressed bottlenecks through strategic indexing and schema refinements. Additionally, I am experienced with various MongoDB drivers and tools that reinforce schema adherence and data integrity.

    PostgreSQL

    PostgreSQL is an open-source relational database offering advanced indexing, JSON support, and ACID compliance.

    My experience with PostgreSQL comes primarily from educational projects, where I focused on designing efficient database schemas with varying degrees of normalization. I invested significant time refining query performance through both straightforward and complex methods of data extraction and merging. I have also set up triggers to support event-driven workflows.

    SQLite

    SQLite is a lightweight SQL database often used for local storage in mobile and embedded devices.

    I have integrated SQLite into mobile applications, particularly for caching and offline storage. My work involved creating database schemas to maintain offline functionality and ensuring data integrity through transactions and constraints.

    Firebase Storage

    Firebase Storage is a Google-powered cloud storage service that seamlessly integrates with Firebase Authentication and Firestore.

    I have developed applications relying on Firebase Storage for data persistence and have also guided migrations from Firebase Storage to alternative solutions. My experience includes manipulating data in Firebase Storage and extracting it via the Firebase CLI.