Imran Ansari

▶ Client & Stakeholder Management: Working closely with clients to resolve complex Oracle Database
and server issues, delivering L3-level support and ensuring seamless business operations.
Database Upgrade & Migration
▶ Performing major Oracle Database upgrades for Core Banking, Internet Banking, UPI, and other critical
systems from 12c to 19c.
▶ Migrating databases from Linux to Solaris and transitioning database storage from file system to ASM with
minimal downtime and zero data loss.
High Availability & Disaster Recovery
▶ Creating and configuring Cascade Data Guard environments to strengthen DR resilience and replication
reliability.
▶ Performing RAC setups as required to enhance system availability, scalability, and performance.
▶ Exadata & SuperCluster Support: Providing specialized support for patching and maintaining Exadata
Machines and SuperClusters, ensuring compliance with Oracles best practices.
Security & Compliance
▶ Implementing and configuring AVDF (Audit Vault and Database Firewall), including agent and target setup
to reinforce database security.
▶ Configuring OEM Server environments to enhance monitoring, governance, and operational transparency.
▶ Performance Optimization: Conducting performance tuning for high-volume databases to improve
query efficiency, response time, and overall system throughput.
▶ Team Leadership: Managing and guiding the technical team, ensuring timely issue resolution, capability
development, and sustained service excellence.

Database Operations & L3 Support
▶ Worked closely with clients to troubleshoot and resolve all Oracle Database and server-related issues as
part of L3 support, ensuring high availability and uninterrupted business operations.
▶ Provided specialized support for patching and maintaining Exadata machines and SuperCluster systems
owned by Oracle.
Database Upgrades, Installations & Platform Migrations
▶ Performed Oracle Database upgrades for Core Banking, Internet Banking, UPI, and other critical systems
from 12c to 19c across multiple environments.
▶ Executed RAC installations with 2-4 node configurations, including new server setups, 19c/12c client
deployments, and database installations on Windows, Solaris, and Linux.
▶ Led cross-platform database migrations from Linux to Solaris and transitions from file system storage to
ASM and RAC environments.
▶ Created ASM disks using Udev rules to support optimized storage configurations. Auditing & Compliance
▶ Set up and configured AVDF (Audit Vault and Database Firewall) for Punjab National Bank, ensuring
enterprise-wide auditing and compliance governance.
▶ Established audit policies across servers, generated alerts, and monitored activities to close
vulnerabilities.
▶ Added multiple servers to AVDF and continuously monitored audit data to ensure security compliance.
OEM & Automation
▶ Installed and configured OEM Server 13.5 to enable enterprise-level monitoring and governance.
▶ Deployed OEM agents, onboarded targets, configured alerts, and created customized OEM dashboards for
real-time monitoring.
▶ Performed OEM agent patching and upgraded TFA for enhanced diagnostics and stability.
▶ Rebuilt standby databases and configured primary-standby environments using Data Guard to strengthen
disaster recovery posture.
▶ Troubleshot RFS/MRP issues, performed regular DR drills, and established Cascade Data Guard setups for
multi-level standby configurations.
▶ Executed RMAN backup and restoration operations to ensure data recoverability and compliance with
recovery objectives.
Standards, Documentation & Governance
▶ Followed Oracle best practices and created POAs (Plans of Action) database activities
standardized, compliant, and auditable operations.

Backup, Recovery & Business Continuity Leadership
▶ Directed enterprise-wide backup and recovery operations using Commvault, ensuring full compliance with
RPO/RTO objectives and maintaining uninterrupted business continuity.
▶ Strengthened database ecosystems by implementing security hardening policies, mitigating risks, and
improving overall platform resilience.
▶ Established and configured high-availability Data Guard environments, delivering robust failover
capabilities across mission-critical systems.
▶ Led periodic DR drills, validating readiness and ensuring seamless recovery for critical banking
applications.
Database Cloning, Testing & Environment Management
▶ Oversaw end-to-end database cloning processes to support development, QA, and UAT environments,
enabling faster delivery cycles.
▶ Transitioned physical standby databases to snapshot standby environments to accelerate controlled
testing and reduce production risk.
Patch & Vulnerability Remediation Governance
▶ Executed quarterly database patching cycles, strengthening platform security and maintaining compliance
with internal and regulatory standards.
▶ Applied Oracle-released interim patches and bug fixes, proactively resolving vulnerabilities and ensuring
system stability across all environments.