Zero Downtime Oracle Migration
- Migrated a 2TB Oracle database for an organization using DataGuard.
- Designed and tested a switchover plan with RMAN recovery validation.
- Achieved seamless migration with zero application downtime.
HAProxy Setup for Hospital Scheduling Portal
- Configured HAProxy to expose a staff scheduling application to the internet securely.
- Enabled external access via HTTPS without requiring VPN connectivity.
- Simplified access for medical staff using reverse proxy and routing rules.
Oracle & PostgreSQL Version Upgrades – Retail Sector
- Upgraded multiple Oracle 12c databases to 19c and PostgreSQL 13 to 14.
- Handled pre-upgrade analysis, RMAN backups and compatibility checks .
- Worked closely with dev teams for post-upgrade validation and issue resolution.
Linux & Oracle Audit with Linys / DBSA
- Performed technical audits on production Linux servers and Oracle databases.
- Used Linys and DBSA to detect config drift, and security issues.
- Delivered detailed audit reports with corrective actions and team follow-up.
PostgreSQL HA Cluster with Patroni
- Deployed a 3-node PostgreSQL high availability cluster using Patroni, Etcd, and HAProxy.
- Configured automated failover, WAL archiving, and TLS-secured traffic.
- Developed custom scripts to monitor replication lag and archive consistency.
Oracle DataGuard – Enterprise Edition
- Deployed DataGuard with primary/standby architecture for a business-critical environment.
- Configured log shipping, DGMGRL integration, and switchover testing.
- Monitored via Oracle OEM13c and improved RTO/RPO significantly.
Oracle SE2 High Availability with Dbvisit
- Implemented Dbvisit Standby on Oracle Standard Edition 2 for HA without Enterprise licensing.
- Configured custom log shipping, standby sync checks, and basic failover procedures.
- Improved service resilience and reduced operational risks in production environments.
Switchover & Failover Testing
- Validated switchover and failover operations on Oracle DataGuard and Dbvisit environments.
- Simulated different failure scenarios (network loss, disk issues, standby crash).
- Created step-by-step runbooks for production teams to follow during real incidents.
Centreon Monitoring Integration
- Deployed Centreon to monitor Oracle, PostgreSQL, and Linux system resources.
- Configured custom service checks (WAL lag, tablespace usage, archive errors, CPU/mem/disk alerts).
- Linked alert thresholds to escalation policies and created a dashboard for IT operations.
Backup Automation with Bash & PowerShell
- Developed backup scripts for Oracle (RMAN, expdp) and PostgreSQL (pg_basebackup).
- Included compression, retention policy, email alerts and logfile rotation.
- Scripts were used in production across Linux and Windows environments.