ianvdl Goto Github PK

Ian's notes 💻 • LinkedIn 🧳 • ORCiD 📝 • Shutterstock 📸 • [email protected] 📧

I am currently based in the beautiful city of Utrecht, in the Netherlands 🇳🇱. If you'd like to get in touch, send me an email at [email protected], or connect/follow/message me on LinkedIn 🙂

Pretending to be PostgreSQL: Part one

The infinitely patient vacuum – a case study of what happens when the PostgreSQL VACUUM never completes

A room with a view of the PostgreSQL autovacuum

Estimating the disk space needed for a VACUUM FULL on PostgreSQL

What do Norway and Namibia have in common?

Demystifying HTTP with Telnet

Hi, I’m Ian van der Linde (hence @Ianvdl and ivdl.co.za). In my current role, I am responsible for running PostgreSQL 24/7 for downtime-sensitive applications in high availability, and working on automation and CI/CD for infrastructure using Puppet and Ansible, and performance monitoring and tuning using a custom PostgreSQL extension and PowerBI.

Previously, I was responsible for full stack Python/Django software development (including all aspects of HTML/CSS/JS on the frontend), high performance PostgreSQL database administration and Linux system administration (on-premises in the form of bare-metal and containerised applications, and Microsoft Azure cloud services). I also worked with colleagues to establish patent analysis as a key function of the team.

I am a certified Linux systems administrator and software developer with experience in automation through version control (Git and SVN), orchestration (Rundeck and Ansible) and configuration management (Puppet), programming mainly in C# with ASP.NET and Python with Django. I have also worked in a high performance computing environment in all areas of hardware and software installation and configuration.

I have specialised experience in DSpace repositories, EZProxy configuration and Open Journal System (OJS) administration and debugging.

I have a further interest in machine learning, and completed my master’s degree on the topic of sentiment analysis.