PANKAJ KUMAR DUBEY

• Total IT Exp - 14 Yrs | 10+ Yrs-Oracle DBA | RAC | EXADATA | GoldenGate | PT | Cloud AWS|Azure| OCI | 7 Yrs - Postgresql | MongoDBA
• Hughes Systique Private Ltd, Noida 29th Sep’23 – 10 Oct’25 (Project Completed) Working as Database Architect Oracle primary Skills and Postgres and Mongo databases Secondary skills.

Oracle profiles (including EXATA):-

• Administering and monitoring 100+ Oracle Databases environments (Full Exadata Box, 4 Node RAC, Data Guard, and GoldenGate).
• Strong knowledge of Exadata architecture – Compute Nodes (DB Nodes), Storage Cell Nodes.
• Hands-on with CellCLI commands (cell servers) and dcli for parallel execution across multiple nodes.
• Expertise SQL tuning to leverage Exadata features.
• Monitoring cell single block reads vs smart scan reads, identifying offload issues, and resolving performance bottlenecks.
• Backup & recovery using RMAN, ZDLRA (Zero Data Loss Recovery Appliance), Tape Library, and Cloud backups.
• High Availability management with Oracle Data Guard, RAC, GoldenGate replication, and failover configurations.
• Applying Exadata patching (one-off, bundle, and quarterly PSU/patching cycles) and performing rolling patch upgrades (In-Place & Out-of-Place).
• Monitoring Exadata performance using OEM Cloud Control, ExaWatcher, OSWatcher, CellCLI/DCLI reports.
• Database security management with TDE (Transparent Data Encryption), Audit Vault, and Database Vault.
• Automation & Scripting: Shell scripting for health checks, automation of patching/monitoring using Ansible.
• Experience with database migrations (on-prem to Exadata, non-Exadata Cloud.
• Hands-on with Exadata in OCI Cloud ( Exadata) including monitoring and administration.
• Strong troubleshooting and Root Cause Analysis (RCA) for performance, availability, and replication issues.
• Skilled in incident resolution, SR handling with Oracle Support, documentation, and change management processes.

Postgres Profile:

• Experienced PostgreSQL/ARORA, Database Administrator with expertise in installation, configuration and management.
• Proficient in database performance tuning, backup & recovery using tools like Barman, and implementing high availability solutions such as Patroni.
• Skilled in query optimization, replication setup and monitoring, point-in-time recovery, and routine maintenance operations including vacuuming and re-indexing.
• Demonstrated ability to secure databases with pgaudit, SSL, and access control measures. Adept at automation using scripting for backup, monitoring, and reporting tasks. Possess working knowledge of PostgreSQL extensions and basic experience in Oracle to PostgreSQL migrations.
• Ensuring database integrity, high performance, and minimal downtime through robust disaster recovery and security practices MongoDB Profile:
• Managing 2 Cluster MongoDB and non-cluster Prod and UAT DBs.
• Administrating end-to-end database management, including backup and recovery
• Performance tuning MongoDB queries, enabling profiling to know slow running queries and tune.
• Proficient in configuring replication and high availability setups to maintain database reliability and scalability.
• Skilled in monitoring and logging database activities, as well as automating tasks through scripting for improved efficiency.
• Hands-on experience with cloud platforms and deploying MongoDB in cloud-native environments.
• Knowledge on data modeling and schema design to support application performance and scalability.
• Knowledge applying patches and upgrades to ensure optimal system performance. ORACLE 11gR2- 19c, Real Application Cluster (12and 19), DATAGUARD and Exadata box experience.
• NOSQLDB MongoDB, Content refresh, Azure data factory (cosmos db & pipeline etc) Postgres Administration, DB/cluster installation, streaming replication, backup & restoration (BARMAN), Tool knowledge PGbouncer, PgBadger, pgadmin, high availability (cluster) designing, managing schema, monitoring and optimizing database performance tuning etc. Mysql/MariaDB
• Administration, DB/cluster installation, configuration, HA solution (Master-master & Master-slave Replication) etc.
• Backup & restoration, managing schema, monitoring and optimizing database performance tuning
• Monitoring (Percona) growth of data and managed space allocation accordingly.
• Performed structural changes to database like creating tables, adding columns according to business requirement.
• Handling release management and user acceptance.
• Knowledge on Data migration (Oracle to Postgres).

• AWS Solution Architect 2025, Certified professional.
• Oracle Autonomous Database Cloud 2025 Certified Professional.
• Oracle Cloud Infrastructure 2025 Certified Architect Associate.