At Bosch, I support and maintain production PostgreSQL, MySQL, and MongoDB databases. My work includes backup and recovery validation, replication management, point-in-time recovery, upgrades, and routine maintenance.
I support MongoDB deployments in Kubernetes and OpenShift, troubleshooting pod issues and carrying out operational maintenance and upgrades. I also investigate PostgreSQL performance issues using query analysis, pg_stat_activity, and configuration tuning.
At Bosch, I implemented centralized monitoring dashboards and alerting with PMM, Grafana, and Prometheus to improve visibility and reduce email alert noise. I also automated recurring operational tasks with Ansible, reducing manual effort by approximately 40%.
In my PMM Monitoring & Observability Enhancement project, I enhanced dashboards for database and server health and implemented backup monitoring dashboards using Victoria Metrics. I also developed automation for operational tasks, certificate rotations, and database backups through Jenkins pipelines, Ansible playbooks, Bash scripts, and scheduled Cron jobs.
