Database Platform Engineer - PostgreSQL MySQL MongoDB Click hous

Mr. ABHAR P. K.

Senior DevOps / Database Platform Engineer (Ruby Python PHP PostgreSQL MySQL MongoDB Click house Full Stack Automation)

Email: ********@*****.*** Mobile: +91-974*-******

Professional Summary

Senior Software Engineer / Database Architect with 10+ years of experience designing scalable database platforms and enterprise web applications. Strong expertise in PostgreSQL architecture, High Availability/Disaster Recovery (HA/DR), performance tuning, ETL pipeline development, and large-scale data platform reliability. Proven experience delivering database solutions for enterprise clients including Volvo, HUS, Biogen, Singtel, Nokia, and ACB, including database migrations to HPE GreenLake, cluster automation with Patroni, observability using PMM, and building ETL workflows for data integration.

Hands-on experience across backend technologies (Ruby on Rails, PHP, Python) and frontend (React JS, HTML5, CSS3, JavaScript), enabling efficient application–database integration and scalable system design.

Technical Skills

Databases: PostgreSQL, MSSQL, MySQL, MongoDB, MariaDB

HA/DR & Infra: Patroni, ETCD, pgBackrest, HAProxy, Keepalived, PgBouncer

Data Engineering Tools: SSIS, Apache Airflow (Python DAGs), Azure Data Factory

Programming: Ruby on Rails, PHP, Python

Frontend: React JS, JavaScript, HTML5, CSS3, jQuery, AJAX, DHTML, DOM, YUI, Bootstrap

Frameworks: Ruby on Rails, CodeIgniter, Laravel 5, Node.js

Dev & Ops: Git, LAMP, WAMP, XAMPP

Servers: Apache, Microsoft IIS

Platforms: Linux, Windows Server, macOS

Professional Experience

Senior Engineer Hewlett Packard Enterprise Bangalore, India Jul 2019 – Present

Large Enterprise Database Platform Projects

Department of Post (DoP), India – PostgreSQL Platform Operations

Managing one of the largest PostgreSQL environments in the government sector, supporting high-volume transactional workloads with strict uptime requirements

Handling very large tables using effective partitioning strategies to improve query performance and maintenance efficiency

Actively managing VACUUM and AUTOVACUUM (manual and automated) to control table bloat and ensure consistent performance

Performing routine database maintenance including index management, statistics refresh, and space optimization.

Large Enterprise HA/DR Projects

Implemented PostgreSQL clusters with automated management, High Availability, and Disaster Recovery using Patroni, PgBouncer, ETCD, HAProxy, Keepalived, and pgBackrest.

Migrated SQL Server databases from on prem, AWS RDS, and AWS EC2 to HPE GreenLake with minimal downtime and full data integrity.

Delivered enterprise solutions for clients including Biogen, Singtel, Nokia (Dubai), and Asia Commercial Bank (ACB).

Application Development Projects (Full-Stack)

Installation Readiness Documentation System – React JS, Ruby on Rails

Built a web-based documentation platform to capture, validate, and track installation readiness across multiple environments

Implemented role-based access, versioning, and audit trails

Improved deployment readiness visibility and reduced manual effort

Employee Time Tracker System – Ruby on Rails

Designed and developed a time-tracking system for employees with daily, weekly, and monthly reports

Automated attendance calculations and exportable reports for payroll processing

Improved productivity tracking and management visibility

Ticket Creation & Management System – React JS, Python

Developed a full ticket lifecycle system including creation, assignment, escalation, and closure

Integrated frontend (React) with backend APIs for real-time status updates

Reduced manual follow-ups and improved SLA compliance

Project & Task Scheduling System – Ruby on Rails

Built a project planning and task scheduling system with user onboarding and roster management

Enabled workload allocation, timelines, and progress tracking

Helped teams improve delivery predictability and accountability

HRM Application – PHP

Developed an end-to-end HRM system including employee management, roles, attendance, and payroll

Implemented reporting modules for HR and finance teams

Software Consultant Etisalat Software Solution Pvt. Ltd. Bangalore, India Dec 2017 – Jul 2019

Built and customized data-driven web applications using PHP (CodeIgniter/Laravel) and React JS.

Integrated REST APIs and optimized MySQL/PostgreSQL queries to improve times.

Senior Software Engineer Suvision Holding Pvt. Ltd. (Indianmoney.com) Bangalore, India Aug 2015 – Dec 2017

Developed CRM, HRM, and task scheduling apps with PHP and Ruby on Rails; improved usability and throughput.

Implemented role-based access control, payroll modules, and reporting dashboards.

Graduate Engineer Trainee Amnova Infotec Tirur, India Oct 2014 – Jun 2015

Contributed to PHP/MySQL web apps and assisted in deployments and maintenance.

Freelance Developer Self-Employed Kerala, India Dec 2013 – Oct 2014

Built billing, accounting, retail stock management systems (PHP, CodeIgniter, MySQL).

Selected Projects

Volvo - PostgreSQL 14 HA/DR cluster on Ubuntu 20.04 with Patroni, PgBouncer, ETCD, HAProxy, Keepalived, pgBackrest.

HUS - PostgreSQL 14 HA/DR cluster on Ubuntu 20.04 with Patroni, PgBouncer, ETCD, HAProxy, Keepalived, pgBackrest; monitoring with Percona PMM.

Biogen – Migrated SQL Server databases from on prem/AWS RDS/EC2 to HPE GreenLake with minimal downtime.

Singtel – Implemented ELK (Elasticsearch, Logstash, Kibana) stack for integrated logging and analytics.

Singtel – EDB EPAS with EFM and Disaster Recovery (HADR) using Barman.

Asia Commercial Joint Stock Bank – PostgreSQL 14 HA/DR cluster on Ubuntu 20.04 with Patroni, PgBouncer, ETCD, HAProxy, Keepalived, pgBackrest; monitoring with Percona PMM.

Nokia Dubai – PostgreSQL 15 HA/DR cluster on CentOS with the Percona stack (Patroni, PgBouncer, ETCD, HAProxy, Keepalived, pgBackrest, PMM).

Education

B.E. Computer Science & Engineering Anna University, Chennai 2014 CGPA: 6.66

Languages

English, Malayalam, Hindi, Arabic, Tamil, Kannada

Contact this candidate