Skip to content
Engineer
Menu
Design
English

Engineer / Portfolio

Ran 10 PostgreSQL and MS SQL servers on Ubuntu

Designed, deployed, and maintained 10 PostgreSQL and MS SQL servers on Ubuntu Linux VPS, ensuring optimal server performance and reliability.

Situation. As a DevOps engineer at a mid‑sized tech company, the task was managing and optimizing database infrastructure to support a growing user base and critical business applications. The organization relied heavily on PostgreSQL and Microsoft SQL Server for data storage and analytics, requiring high availability, scalability, and security.

Task. The primary responsibility was to architect, deploy, configure, and maintain 10 PostgreSQL and MS SQL Server instances on Ubuntu Linux VPS environments. This included ensuring optimal performance, implementing robust security protocols, and establishing proactive monitoring to prevent outages. Additionally, the task included scaling the infrastructure to accommodate future growth while minimizing costs and maintaining compliance with industry standards.

Action. 1. Deployment & Configuration:

  • Installed and configured PostgreSQL 14 and MS SQL Server 2019 on Ubuntu 20.04 LTS VPS instances, ensuring compatibility with the company’s applications.
  • Set up automated backups using pg_dump for PostgreSQL and SQL Server Agent jobs for MS SQL, with retention policies and offsite storage.
  • Optimized server configurations (e.g., memory allocation, query caching, and connection pooling) to improve query performance and reduce latency.
  1. Monitoring & Maintenance:

    • Implemented monitoring tools like Prometheus, Grafana, to track CPU, memory, disk I/O, and query performance metrics in real time.
    • Conducted regular patching and updates for both databases and the Ubuntu OS to address security vulnerabilities and ensure compliance.
    • Created custom scripts for log analysis.
  2. Security & Scalability:

Result. - Achieved 99.9% uptime across all 10 database servers.

  • Improved query response times by 30% through configuration tuning and index optimization, enhancing application performance.
  • Reduced manual maintenance tasks by 50% via automation, freeing up 10+ hours per month for strategic projects.
  • Successfully scaled the infrastructure to support a 40% increase in user traffic without service degradation, contributing to a 20% revenue growth in the following quarter.
  • Received recognition from the CTO for implementing security best practices that prevented potential data breaches.

This experience solidified deep expertise in database management, DevOps automation, and infrastructure optimization, delivering reliable, secure, and scalable solutions for complex enterprise environments.

Contact

Still working out what you need?

Tell us what is going wrong, or what you are trying to build. We will tell you what it would take, roughly what it would cost, and whether we are the right people for it.

From 1,400 DKK an hour, excluding VAT — and less per hour on a longer booking.

welcome@engineer.company +45 50 10 61 84 Copenhagen, Denmark