Prashant Gupta

5000+ RDS Oracle databases RU and Spatial patches—led planning, CTASK creation, execution
monitoring, and validations. Co-developed automation script with rollback readiness, snapshot backups, ServiceNow documentation, and audit compliance.

• Supported 5000+ Oracle, PostgreSQL, and SQL Server databases hosted across AWS, Azure, and OCI.
• Implemented backup/recovery strategies using RMAN, Data Pump, pg_dump, PITR, and Redgate.
• Led patching & upgrades (RU, Jetty, SPM, CDB) for 1000+ RDS databases, including rollback readiness & ServiceNow
documentation.
• Migrated workloads from GP2 to GP3, reducing latency and improving IOPS and cost-efficiency.
• Automated schema refresh using expdp/impdp and PostgreSQL utilities with configurable scheduling.
• Managed OEM deployments, PDB creation, ASM disk handling, RAC and Data Guard configurations.
• Tuned performance using AWR, ASH, Statspack, pg_stat_statements, SQL tuning tools.
• Coordinated PITR activities for Azure PostgreSQL and SQL Server databases.
• Worked in 24x7 rotational shifts supporting production, DR, and staging environments.
• Handled incident/change tickets via ServiceNow and collaborated with Oracle/AWS/Azure support teams.
• Mentored junior DBAs, conducted knowledge sessions on query tuning, and drove a culture of documentation and RCA ownership.

• Installed, configured, upgraded Oracle 12c/19c and PostgreSQL 10/11/13 on Linux platforms.
• Performed PITR, pgBackRest, logical backups, HA/DR replication setups for PostgreSQL.
• Conducted schema and data migrations across heterogeneous environments.
• Automated health checks, alerts, and reports using Bash and PowerShell scripts.
• Tuned SQL queries, implemented partitioning/indexing strategies to optimize performance.
• Enabled Data Guard and RAC for Oracle; managed SQL Server mirroring and backups.
• Ensured production-readiness through SOP enforcement, runbook documentation, and validation of backup/restore workflows.

• Designed and implemented database models and schemas for enterprise apps.
• Conducted data cleansing, archival, and security audits.
• Maintained daily backups, performed cloning, and ensured SLA compliance.
• Collaborated with app teams for data integration, version control, and report generation.

• Trained students and professionals on automation tools, SQL, scripting, and database fundamentals.
• Developed curriculum focused on real-time database administration and Linux automation.