The latest articles on DEV Community by Siraj Ur Rahman (@sirajurrahman). https://dev.to/sirajurrahman https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2843634%2F52ec3901-18ff-407d-95d7-a1c3b9e45ea2.jpg https://dev.to/sirajurrahman en Siraj Ur Rahman Mon, 10 Feb 2025 18:24:48 +0000 https://dev.to/sirajurrahman/bridging-code-systems-and-real-world-impact-20d0 https://dev.to/sirajurrahman/bridging-code-systems-and-real-world-impact-20d0 <p>Over the past few months, I’ve been deep in the trenches of complex system integrations—working across .NET, Autofac, JWT authentication, SQL Server &amp; PostgreSQL, and optimising tax relief systems for big charities.</p> <p>Some of the key takeaways from this journey:</p> <p>✅ Multi-DB Challenges: Running SQL Server and PostgreSQL side by side isn’t just about ORM differences. Handling package references at runtime while keeping performance optimal is a different beast altogether.</p> <p>✅ Scaling Tax Relief Systems: Designing SubmissionOptions that balance automation and manual overrides taught me a lot about structuring business rules effectively.</p> <p>✅ Explaining Tech to Non-Tech: Whether it’s breaking down AccountMatching logic or simplifying complex SQL queries for non-technical managers, communication is as critical as code.</p> <p>One of the most rewarding parts? Taking these learnings beyond code—gathering firsthand insights from charity clients in the UK, understanding their pain points, and shaping solutions that actually help them.</p> <p>Curious—how do you handle multi-DB systems or optimize performance in high-volume applications? Let’s discuss!</p> <h1> dotnet #softwaredevelopment #systemdesign #devops #sqlserver #postgresql #charityTech #cloudcomputing </h1>