Arpit Agrawal

• As STC (Deputy Head of Database Engineering at Fidelity, I co-manage global team of around 10+ engineers providing next generation engineered solutions.
• Enabling democratized AI adoption across engineering teams through tools such as GitHub Copilot, MCP servers, and vector databases.
• Community Leader for All India Oracle Users Group (AIOUG), North India, driving regional engagement, knowledge sharing, and professional development across the Oracle ecosystem.
• Regular speaker and panelist at AIOUG conferences, meetups, and technical forums, presenting on enterprise databases, cloud, automation, and emerging technologies.
• Proven ability to ensure adherence to Audits, National Insurance Regulators, PCI DSS, and other industry compliance and regulations.
• Author of the book “Tableau Server Administration” and contributor of multiple technical articles within the Oracle community, sharing best practices on AI driven engineered data platforms, automation, and enterprise analytics.
• Led and scaled multi-disciplinary engineering teams (database, cloud, platform, automation, and data engineers), enabling end-to-end product delivery of enterprise-grade, AI-enabled database platforms.
• Owned engineering strategy, execution, and delivery, ensuring high-quality outcomes across architecture, build, deployment, and operations for both cloud (AWS) and on-premise engineered systems.
• Architected and delivered managed database platforms similar to AWS RDS, enabling self-service provisioning, automated patching, scaling, backup, failover, and monitoring through AI-driven orchestration and policy engines.
• Designed and implemented on-premise end-to-end database stacks, covering infrastructure, security, HA/DR, observability, and automation, supporting mission-critical enterprise workloads.
• Established engineering best practices, standards, and reference architectures, ensuring consistency, security, and compliance across all database engineering initiatives.
• Built a strong delivery culture, mentoring engineering managers and individual contributors, driving accountability, continuous improvement, and high team engagement.
• Implemented data visualization products like Tableau, PoweBI and OAS (delivery health, performance, availability, cost, and SLA metrics) to provide real-time visibility to leadership and stakeholders.
• Collaborated closely with product, business, and client stakeholders to translate requirements into scalable, reliable engineering solutions, enabling faster time-to-market and improved customer satisfaction.
• Drove DevOps, CI/CD, and Database-as-a-Service (DBaaS) maturity, empowering teams to deliver products faster, safer, and with greater operational efficiency.

Key Technologies

Oracle 12c/19c, Exadata X8, RAC, Active Data Guard (ADG), ZDLRA, GoldenGate, ODA, Delphix, Ansible, Terraform, Python, Shell, OEM, AWR/ASH, SQL Monitor, Grafana, AWS Glue, Databricks Delta Lake, dbt, Airflow, Snowflake, KMS, IAM, CloudWatch, Azure Monitor, OCI CLI, ServiceNow

Key Responsibilities & Achievements

• Hybrid Cloud Database Leadership
  Led and optimized large-scale Oracle 12c/19c RAC and Active Data Guard platforms supporting fund valuation, NAV, and order-management systems. Architected hybrid DR and analytics architectures by integrating on-premise Exadata X8 with AWS RDS Oracle, enabling cross-region replication and read-only analytics workloads.
• Automation & Systems Engineering
  Designed and implemented end-to-end database automation frameworks across engineered and non-engineered environments using Ansible, Python, Terraform, and REST APIs, reducing maintenance windows by 60%.
  Built self-service provisioning and rollback capabilities through Delphix API and ServiceNow integration, enabling on-demand database cloning without DBA intervention.
  Automated ZDLRA backup orchestration and Flashback validation, ensuring compliance with zero data-loss and enterprise recovery objectives.
• Performance Engineering & Reliability
  Led end-to-end SQL and workload performance optimization using AWR/ASH, SQL Monitor, and SQL Plan Baselines, reducing high-latency batch execution times by 45%.
  Implemented proactive performance and bottleneck detection dashboards using Prometheus, Grafana, and OEM to improve system reliability and incident response.
  Optimized critical PL/SQL workloads through refactoring, parallel execution, and partition pruning for high-volume order-management systems.
• Data Engineering & Analytics Enablement
  Architected real-time and near-real-time data replication pipelines from Oracle to Snowflake using GoldenGate, supporting analytical and regulatory reporting.
  Developed scalable ETL/ELT pipelines using AWS Glue and Databricks Delta Lake, ensuring low-latency data availability.
  Implemented dbt-based transformation frameworks and orchestrated cross-platform workflows using Airflow with automated Slack/Teams notifications.
• Security, Governance & Compliance
  Implemented data masking and secure cloning using Delphix to protect PII in non-production environments.
  Enforced GDPR, SOX, and internal compliance controls using TDE, KMS, IAM role segregation, and audit frameworks.
  Automated compliance evidence generation, including RMAN validation, Flashback verification, and DR drill reporting.
• DevOps & Observability Integration
  Partnered with global DevOps teams to integrate CloudWatch, Azure Monitor, and OEM telemetry into centralized alerting and incident workflows using SNS and collaboration tools.
  Developed reusable Terraform modules for standardized Oracle provisioning, capacity forecasting, and AI-assisted cost optimization based on historical usage trends.

Key Technologies: Oracle Database (RAC, ASM, High-Performance Architecture), Shell Scripting, Ansible, Rundeck, CI/CD Frameworks, Self-Healing & Auto-Remediation Frameworks, Database Build & Stack Automation, Oracle RMAN, Data Pump, Database Cloning & Refresh Automation, Performance Tuning & Optimization, OEM, SQL*Plus, Grid Control, Cloudera Hadoop, Kafka, Cassandra (NoSQL), Tableau, Power BI, OBIEE, Denodo (Data Virtualization), Big Data & Analytics Platforms

Key Responsibilities & Achievements

• Led end-to-end engineering and automation of database and analytics ecosystems, delivering fully automated Database, OBIEE, and Tableau Server stack builds using Ansible, Rundeck, and Shell scripting.
• Engineered and deployed self-healing frameworks for proactive remediation of Database FRA and Tablespace alerts, significantly reducing operational incidents and manual intervention.
• Designed and built high-performance Oracle database platforms from scratch, implementing industry best practices in architecture, scalability, and resilience.
• Tuned underperforming and degraded databases, restoring systems to baseline and optimal performance levels through SQL optimization and architectural improvements.
• Developed enterprise-grade shell automation frameworks for database provisioning, refresh, cloning, and patching activities.
• Implemented robust backup and recovery strategies using RMAN and Data Pump to ensure data integrity and compliance with recovery objectives.
• Engineered and administered Big Data platforms, including Cloudera Hadoop and Kafka, along with NoSQL solutions such as Cassandra, enabling scalable data processing architectures.
• Designed and supported data visualization platforms including Tableau, Power BI, and OBIEE, ensuring high availability, performance, and seamless user adoption.
• Built and implemented data virtualization solutions using Denodo, enabling unified data access across heterogeneous data sources.
• Contributed to CI/CD framework development for database and analytics platforms, enabling faster, reliable, and repeatable deployments.
• Acted as Product Owner for Tableau, driving platform roadmap, feature enablement, and stakeholder alignment.
• Served as a people manager for Emerging Data Services, leading, mentoring, and upskilling engineers at early and mid-career stages.
• Conducted formal training and knowledge-sharing programs on Database Administration, Performance Tuning, OEM, Cassandra, Tableau, and automation practices.
• Collaborated with cross-functional automation teams to deliver shared enterprise solutions, including automated DNS creation and teardown for network teams.
• Fostered a culture of engineering excellence, automation-first thinking, and continuous improvement, enabling teams to deliver scalable and reliable data products.

Key Technologies

Oracle Database 10g/11g, Oracle RAC (2-Node), Active Data Guard, Standby & Snapshot Standby, Oracle ASM, ASMCA, Oracle Enterprise Manager (OEM/Grid Control), RMAN, Data Pump (EXPDP/IMPDP), Flashback Database, SQL Loader, SQL*Plus, DBCA, TimesTen In-Memory Database, Sybase ASE 15.0, High Availability & Disaster Recovery, Database Upgrades & Migrations, Backup & Recovery Automation, Performance Monitoring & Alert Threshold Tuning, Production Support & Incident Management

Key Responsibilities & Experience

• Managed and resolved production database alerts by tuning Oracle Grid Control thresholds to improve signal-to-noise ratio and operational stability.
• Performed schema and database refreshes using EXPDP/IMPDP and production backup restores to support UAT, DEV, and QA environments.
• Refreshed and maintained TimesTen in-memory databases to ensure data consistency and application performance.
• Synchronized and maintained physical standby databases, restoring missing archive logs and resolving lag issues to maintain data integrity.
• Designed, configured, and managed Oracle Data Guard environments; executed DR failover and switchover drills to validate high availability and disaster recovery readiness.
• Installed, configured, and upgraded Oracle Enterprise Manager (OEM) agents, ensuring accurate monitoring and alerting across environments.
• Built and administered Oracle 11g standalone and 2-node RAC databases, including service configuration for application workloads.
• Configured role-based services in Oracle 11g RAC to support workload isolation and high availability.
• Performed database upgrades from Oracle 10g to 11g, ensuring minimal downtime and application compatibility.
• Demonstrated strong expertise in ASM, creating and managing disk groups using ASMCA to support resilient storage architecture.
• Created and provisioned databases using DBCA across non-production environments.
• Recovered databases following filesystem failures by coordinating restores with system administration teams.
• Deployed DDL and DML changes to production databases following change management and release processes.
• Developed and executed RMAN and Data Pump automation scripts for background backup, restore, and refresh operations.
• Actively collaborated with application teams to diagnose and resolve blocking sessions, deadlocks, and long-running queries, improving system responsiveness.
• Utilized Flashback Database during release cycles to safely roll back data changes when required by application teams.
• Converted physical standby databases to snapshot standby for application testing and reverted them back post-testing.
• Relocated RAC services during planned maintenance windows and restored services post-maintenance to ensure minimal application disruption.
• Evaluated and implemented new Oracle 11g Data Pump features, enhancing existing automation and refresh workflows.
• Integrated data loads from Sybase ASE to Oracle using SQL Loader and refreshed Sybase ASE environments (v15.0) across DEV, QA, and UAT.

Key Technologies

Oracle Database, Database Cloning, Standby & Data Guard, RMAN Backup & Recovery, Data Pump (EXPDP/IMPDP), Oracle RAC & Standalone Databases, OPatch, Unix/Linux, Cron Scheduling, SQL Server (Dual Support), Production Monitoring & Incident Management, High Availability & Disaster Recovery

Key Responsibilities & Achievements

• Designed and managed database cloning, standby database creation, and ongoing standby lifecycle management to support high availability and disaster recovery requirements.
• Monitored and resolved critical production alerts, including instance/database outages, agent failures, ASM space issues, backup and job failures, archiver hung scenarios, and Oracle errors (ORA-xxxx).
• Supported application teams by executing Data Pump export/import operations for schemas and database objects across environments.
• Created production database clones to support development and testing teams while ensuring data consistency and access controls.
• Managed and automated RMAN backup strategies, scheduling hot and cold backups through Unix cron jobs to meet recovery objectives.
• Collaborated directly with clients and application stakeholders to resolve operational issues, including tablespace resizing, session locks, deadlocks, schema refreshes, and performance-related requests.
• Actively participated in customer review and operational governance meetings, providing updates on system health, incidents, and remediation actions.
• Performed schema refreshes from production to development and staging environments in line with change management and client requirements.
• Applied Oracle OPatch updates across standalone and RAC environments, ensuring platform stability and security compliance.
• Executed server and database release activities across production and non-production environments with minimal downtime.
• Provided dual support for SQL Server environments, monitoring health, responding to alerts, and assisting with operational issues.