Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Prashant Dixit
Full Name
ACE Pro
Top Level Details
Job Role
Database Solution Architect
Company
RENAPS
Country
Canada
Top Expertise
Performance Management
Focus Area
Database
About Prashant
A seasoned Database Architect and Senior DBA with over 18 years of hands-on experience, specializing in database performance tuning, advanced troubleshooting, system stabilization, high availability, data replication, and large-scale migrations and upgrades across complex enterprise environments. His expertise spans both traditional and modern platforms, including Engineered Systems (Exadata), Oracle Cloud Infrastructure (OCI), and hybrid on-prem/cloud architectures. He brings a strong analytical mindset combined with practical execution skills, enabling him to design, implement, and operate resilient, scalable, and high-performing database platforms. His core strength lies in Oracle Database technologies, with deep experience in Oracle GoldenGate, Oracle Maximum Availability Architecture (MAA), RAC, Data Guard, Exadata, Oracle Sharding, Oracle NoSQL DBs, and mission-critical workloads such as Oracle E-Business Suite and other COTS and custom applications. Beyond Oracle, he has extensive hands-on experience with MySQL, PostgreSQL, MongoDB, Redis, CockroachDB, and Apache/DataStax Cassandra, supporting transactional, NoSQL, and distributed data platforms. He has helped clients migrate and modernize data workloads from these technologies to Oracle platforms, including Oracle Database/cloud and Oracle NoSQL, using a combination of replication technologies such as Oracle GoldenGate, ETL frameworks, and custom automation and scripting. His approach ensures minimal downtime, data consistency, and performance stability while enabling organizations to adopt Oracle-native solutions with confidence. As a senior technical leader, he guides customers through the entire database lifecycle from architecture and provisioning to deployment, optimization, and long term operations across on-premises, cloud-native, and hybrid environments. He works closely with infrastructure, application, and security teams to ensure end-to-end reliability and performance. Widely regarded as a go-to expert for resolving complex and high impact database issues, he is frequently engaged to troubleshoot obscure performance problems, stabilize critical systems, and support recovery efforts under pressure. In addition to operational excellence, he has a strong foundation in data architecture, data warehousing, and data profiling, making him a trusted advisor for delivering data driven solutions aligned with long-term business and modernization goals.
Expertises
Performance Management
Upgrade / Migration
GoldenGate
Exadata
WebLogic Server
Database Performance Management
MySQL Database
Oracle GoldenGate Service
Extract, Transform and Load (ETL)
Oracle NoSQL DB
Home Page
https://fatdba.com/
Cloud Customer Connect
https://community.oracle.com/hub/profile/discussions/FatDBA
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
Parquet, hadoop, and a quietly dying process : lessons from a migration test using GoldenGate 23ai DAA
Feb 08, 2026 - Blog post -
Oracle GoldenGate Service
GoldenGate
Oracle Database@Azure
#ACTIONS#
#SELECTION#
#ICON_HTML#
Lessons from Integrating Oracle 11g with GoldenGate – ORA-06512 ORA-06502
Feb 07, 2026 - Blog post -
GoldenGate
Oracle GoldenGate Service
Installation / Patching
#ACTIONS#
#SELECTION#
#ICON_HTML#
When GoldenGate decides to throw OGG-02912 just before New Years Eve.
Dec 31, 2025 - Blog post -
Oracle GoldenGate Service
GoldenGate
Oracle Database (EE)
#ACTIONS#
#SELECTION#
#ICON_HTML#
When Linux Swaps Away My Sleep – MySQL, RHEL8, and the Curious Case of High Swap Usage
Dec 12, 2025 - Blog post -
MySQL
Linux
Oracle Linux
Performance Management
Database Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
How Oracle 23ai Fixes Bad Plans Instantly.. A Live Demo of Real-Time SPM
Nov 23, 2025 - Blog post -
Database 23ai
Optimization
High-Frequency Automatic SPM Evolve Advisor Task
Database Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
From Painful Manual LOB Shrink to Automatic SecureFiles Shrink
Nov 15, 2025 - Blog post -
Database 23ai
Large Objects (LOBs)
#ACTIONS#
#SELECTION#
#ICON_HTML#
A New ACE Chapter…Oracle ACE Apprentice.. and I wasn’t even in Vegas
Oct 18, 2025 - Blog post -
Community
#ACTIONS#
#SELECTION#
#ICON_HTML#
DBMS_ILM HTML Dashboard Script .. The Missing Monitor for Oracle Archiving
Sep 15, 2025 - Blog post -
Advanced Compression
Data Warehouse
Heat Map
#ACTIONS#
#SELECTION#
#ICON_HTML#
Stop Writing Purge Scripts. DBMS_ILM Is the Hidden Hero You Ignored
Sep 14, 2025 - Blog post -
Advanced Compression
Heat Map
Warehouse Management
Archive Storage
#ACTIONS#
#SELECTION#
#ICON_HTML#
MySQL OPTIMIZE TABLE – Disk Space Reclaim Defragmentation and Common Myths
Aug 08, 2025 - Blog post -
MySQL
MySQL Database
MySQL EE
#ACTIONS#
#SELECTION#
#ICON_HTML#
Oracle AWR Scripts Decoded .. No More Guessing!
Jul 29, 2025 - Blog post -
Automatic Workload Repository (AWR)
Performance Management
Diagnostics & Tuning Pack
#ACTIONS#
#SELECTION#
#ICON_HTML#
fatdba explores Vector Search in Oracle 23ai
Jul 23, 2025 - Blog post -
Database 23ai
AI Vector Search
Database Performance Management
#ACTIONS#
#SELECTION#
#ICON_HTML#
Diagnosing a MySQL database performance Issue Using MySQLTuner
Jul 20, 2025 - Blog post -
MySQL Database
MySQL EE
#ACTIONS#
#SELECTION#
#ICON_HTML#
Demo on how to use Oracle XStream Replication Setup Using Java Client
Jun 15, 2025 - Blog post -
XStreams
Oracle GoldenGate Service
#ACTIONS#
#SELECTION#
#ICON_HTML#
oracle-support-new-ai-powered-search
Apr 08, 2025 - Blog post -
Partner Portal
#ACTIONS#
1 - 15
Next