Arindam Gupta

About Arindam Gupta

I am a Senior Oracle DBA with hands-on experience managing Oracle 11g, 12c, and 19c databases in large-scale Linux and Windows environments. I specialize in ensuring high availability, scalability, and performance across enterprise-grade systems using Oracle RAC, Data Guard, and Goldengate.My technical expertise spans across:Database Administration: Backup & Recovery (RMAN/Datapump), Patching, Upgrade, Tablespace & User Management, Performance Tuning, PL/SQL, Shell Scripting, Database Security, Auditing, OEM & Unix Administration.High Availability & Disaster Recovery: Expert in designing, implementing, and maintaining Oracle RAC, Data Guard, and GoldenGate environments for seamless replication, failover, and business continuity.Cloud & Automation: Extensive hands-on experience in Oracle Cloud Infrastructure (OCI), Oracle ADB, OCI GenAI, and application development using Oracle APEX. I have developed a Database Administration team management tool with Oracle APEX and Oracle Database integration, enabling the team to monitor and update database health, track backups, manage shifts and handovers, handle tickets, and track upcoming activities efficiently.Data Engineering: Skilled in designing, building, and maintaining data pipelines for ETL using Apache NiFi and Azure Databricks with PySpark, as well as performing data integration and analytics leveraging SQL, scripting, and cloud-native tools. I have built a pipeline to monitor database health like OEM, fetching data into Apache Zeppelin to create dashboards for real-time DB monitoring, along with performing data integration and analytics using SQL, scripting, and cloud-native tools.Cross-Cloud Expertise: Certified in OCI, GCP, and AWS, enabling seamless hybrid and multi-cloud database management strategies.AI Integration: Implemented Generative AI and Retrieval-Augmented Generation (RAG) in my application trackEXP to automate insights and generate personalized financial recommendations.As a Project Manager, I have effectively led cross-functional teams, managed complex migration and upgrade projects, and delivered business-critical database solutions on time and within scope. My strong communication and stakeholder management skills bridge the gap between technical depth and strategic vision.I am passionate about continuous learning, emerging technologies, and leveraging data, AI, and automation to drive performance, resilience, and innovation. I look forward to applying my experience and certifications to new challenges that create measurable impact for my organization.

Experience

1. Associate IT Consultant

   ITC Infotech

   Nov 2024 — Present · Kolkata, IN

   Architected, installed, and administered Oracle 12c/19c databases on Linux and Windows, managing Oracle RAC and ASM configurations to deliver high availability, load balancing, and fault tolerance. Database migration using full database/schema/table refresh using export and import(Datapump utility). Owned end-to-end backup, recovery, and DR strategy, implementing RMAN full/incremental backups, database refreshes (RMAN, EXPDP/IMPDP), and successfully executing Data Guard build, switchover, and DR drills, reducing recovery time objectives (RTO) by 30%. Implemented a variety of tasks, including DB link building, GRP creation, Password reset, Auditing, Redo log resizing, and standby sync Issues in Dataguard. Planned and executed patching strategies, applying PSU and one-off patches on standalone and multi-node RAC environments, coordinating change management and reducing post-patch incidents by 35%. Built standby database to configure Dataguard, performed DR-drill, and switch over activities. Led major database upgrades and migrations, including 12c → 19c upgrades and HP-UX to SUSE Linux migrations, ensuring zero data loss and minimal downtime for production systems. Drove database performance tuning initiatives, analyzing AWR/ASH reports, optimizing SQL, indexes, and storage structures, resulting in 25–40% improvement in query performance for critical workloads. Automated routine DBA operations using shell scripting and cron, including RMAN scheduling, tablespace/diskgroup monitoring, and alerting, improving operational efficiency by 20% and reducing manual intervention. Acted as escalation owner and technical mentor, guiding junior DBAs, standardizing DBA processes, and collaborating with application and infrastructure teams to resolve high-severity incidents within SLA

Education

• Meghnad Saha Institute Of Technology(MSIT)

  Bachelor of Technology - BTech, Electronics and Communications Engineering

  2016 — 2020