Rijavan Inamdar

• Provide technical support for Percona's open-source database products, including Percona Server for MySQL, Percona Distribution for PostgreSQL, and Percona Server for MongoDB.
• Analyse system logs, error messages and performance metrics to identify root cause and recommend preventive measures.
• Maintain BCP/DR documentation aligned with ISO 22301:2019 standards.
• Support integration between BMS/SCADA systems and backend databases (PostgreSQL, MySQL) for power, cooling, and facility monitoring.
• Troubleshoot and remediate PHP-based ETL/billing cron pipelines feeding data center operational dashboards.
• Perform root-cause analysis on data pipeline failures (missing data, duplicate records, credential issues).
• Prepare DR drill reports, BIA documentation, and risk registers for audit readiness.

• Lead database operations for a large-scale financial institution covering PostgreSQL, MySQL, and MongoDB environments, ensuring 99.99% availability.
• Implemented comprehensive security hardening (CIS benchmarks + RBI guidelines) across all database servers; zero audit findings during regulatory reviews.
• Managed end-to-end patch lifecycle for PostgreSQL, MySQL and MongoDB — from lab validation to rolling production deployment with zero downtime.
• Architected and maintained Google Cloud SQL instances (PostgreSQL & MySQL), handling version upgrades, DR drills, switchover/switchback, and migration from Enterprise to Enterprise Plus tier.
• Deployed and administered MongoDB Enterprise with Ops Manager for centralized monitoring, backup automation, and cluster management (standalone, replica set, sharded).
• Designed automated Bash scripts for daily health monitoring — disk space alerts, replication lag checks, query performance reports — reducing manual effort by ~60%.
• Oversaw integration with enterprise backup solution (Veritas) for remote offsite backups; defined and tested RTO/RPO targets aligned with business continuity policy.
• Managed vendor relationships (EDB, MongoDB, Google), process/change/service-request governance, and mentored a team of junior DBAs.
• Implemented Cloud SQL config points and security controls to meet internal security policies and external regulatory requirements.

• Handled inbound technical support for EDB Postgres Advanced Server (EPAS) and community PostgreSQL across global enterprise clients.
• Diagnosed and resolved complex issues spanning replication lag, connection pooling, backup failures, upgrade regressions, and query performance degradation.
• Provided remote guidance (phone/email/Zoom) to clients on installation, configuration, and tuning of EFM, Barman, PEM, PgBouncer, and Repmgr.
• Escalated critical issues to EDB engineering with detailed reproduction steps, log analysis, and recommended patches; accelerated resolution cycles.
• Authored and maintained internal knowledge-base articles, reducing repeat ticket volume by ~25% quarter-over-quarter.
• Supported clients across North America, Europe, and APAC, delivering 24×7 on-call coverage for Severity 1 incidents.

PostgreSQL / EPAS

• Installed, configured, and maintained PostgreSQL 9.6 through 14 using multiple methods (source, RPM, binary, EDB installer); managed 50+ database instances across production, UAT, and dev.
• Implemented streaming and logical replication; configured Repmgr for automatic failover and Barman for full + incremental physical backups with PITR.
• Performed major version upgrades (9.6 → 10 → 12 → 14) using pg_upgrade with pre/post validation checklists; zero data-loss during upgrades.
• Installed and tuned PgBouncer (connection pooling) and Pgpool-II (load balancing), reducing connection overhead by ~40% on high-traffic OLTP workloads.
• Configured DR sites with automated failover; conducted regular DR drills validating RPO < 5 min and RTO < 15 min.
• Performed Oracle-to-PostgreSQL migrations using ora2pg and Oracle FDW; validated data integrity and application compatibility post-migration.
• Tuned slow queries via explain/analyse, index rebuilding, table statistics refresh, and vacuum tuning; achieved up to 70% reduction in query runtime on key reports.
• Scheduled check_mk monitoring jobs; generated database health reports with pgBadger and pgBench benchmarking results shared with stakeholders monthly.

MySQL

• Managed MySQL databases (5.7/8.0) including installation, user/role administration, replication (Master-Slave, multi-slave), and performance tuning.
• Handled 24×7 incident tickets (Sev 1–3); performed RCA for problem tickets; proactively identified capacity risks and recommended scale-up plans.
• Conducted table optimise/analyse/repair, slow-query analysis (EXPLAIN plan), and InnoDB buffer pool tuning to maintain optimal throughput.
• Maintained ISO audit documentation and space management reports; delivered weekly/monthly/yearly operational reports to client stakeholders.

MongoDB

• Installed and upgraded MongoDB (4.0 → 4.2 → 4.4 → 5.0 → 6.0); configured replica sets (including arbiter, hidden, and delayed nodes) and sharded clusters.
• Managed mongodump/restore, mongoexport/import backup processes; scripted CPU/memory/disk usage alerts and backup verification.
• Provided production DBA support to clients including Shoppers Stop, Northern ARC, Atos-Worldline, VARStreet, NTT Group, and others.