Hello,
I am Arindam Gupta, an Oracle Certified Professional (OCP) Oracle Database Administrator.

oracle_admin_portfolio.sql

DECLARE
v_name VARCHAR2(50) := 'Arindam Gupta';
v_role VARCHAR2(80) := 'Oracle DBA | Data Engineer';
v_exp NUMBER := 5;
TYPE t_skill_tab IS TABLE OF VARCHAR2(60);
v_skills t_skill_tab := t_skill_tab(
'RAC', 'DataGuard', 'OCI', 'Performance Tuning',
'PLSQL', 'RMAN', 'EXPDP', 'Migration', 'Patching & Upgrade'
);
FUNCTION is_hireable RETURN VARCHAR2 IS
BEGIN
RETURN CASE WHEN v_exp >= 5 AND v_skills.COUNT >= 5
THEN '✅ Highly Hireable' ELSE '⚙️ Growing Professional' END;
END;
BEGIN
DBMS_OUTPUT.PUT_LINE('👨‍💻 ' || v_name || ' - ' || v_role);
DBMS_OUTPUT.PUT_LINE('Exp: ' || v_exp || ' yrs | Skills: ' || v_skills.COUNT || ' | Status: ' || is_hireable);
END;
/

ABOUT ME

Who I am?

My name is ARINDAM GUPTA. I am a dedicated and experienced Oracle Database Administrator with expertise in Oracle Cloud Infrastructure, Oracle RAC, Oracle DataGuard, Oracle Autonomous Database, and Oracle APEX. I am passionate about database optimization, cloud technologies, and exploring emerging technologies like GenAI and Data Engineering. With a strong foundation in Oracle technologies, I excel at managing complex database environments and ensuring high availability and performance. I am always eager to learn and implement cutting-edge solutions in database management and cloud computing.

Experiences

Total Experience: 5 Years 0 Months

1 Year 2 Months

Present

Senior Oracle Database Administrator

ITC Infotech

3 Years 10 Months

Oracle Database Administrator

DXC Technology

1 Year 0 Months

Intern

Micropro

Skills

MY APPS

Featured★

Web Application

Personal Portfolio Website

A modern, responsive portfolio website built with Next.js and Tailwind CSS showcasing my projects, skills, and experienc...

Next.jsReactTailwind CSSJavaScript

GitHub Live App

Featured★

Web Application

TrackEXP

TrackExp is an all-in-one personal finance web app that helps you track expenses, manage budgets, and gain smart insight...

PostgreSQL DatabaseReact.jsTailwind CSSTypeScriptRender

GitHub Live App

PROJECTS

Enterprise Oracle RAC Implementation

DECLARE
v_nameVARCHAR2(200) := 'Enterprise Oracle RAC Implementation';
v_roleVARCHAR2(120) := 'Lead Oracle DBA';
TYPEt_tool_tabIS TABLE OFVARCHAR2(100);
v_tools t_tool_tab := t_tool_tab(
'Oracle RAC', 'Oracle DataGuard', 'Oracle ASM', 'Linux', 'Shell Scripting', 'Oracle Enterprise Manager', 'Oracle Grid Infrastructure'
);
v_descriptionCLOB := 'Implemented Oracle RAC 19c with Data Guard for HA & DR; configured shared storage, cluster interconnects and tuned performance to deliver 99.9% uptime.';
FUNCTIONtool_countRETURN PLS_INTEGER IS
BEGIN
RETURNv_tools.COUNT;
END tool_count;
BEGIN
NULL; -- Placeholder execution block
END;
/

Oracle Cloud Migration Project

DECLARE
v_nameVARCHAR2(200) := 'Oracle Cloud Migration Project';
v_roleVARCHAR2(120) := 'Oracle Cloud Specialist';
TYPEt_tool_tabIS TABLE OFVARCHAR2(100);
v_tools t_tool_tab := t_tool_tab(
'Oracle Cloud Infrastructure', 'Oracle Autonomous Database', 'Oracle APEX', 'Oracle Data Pump', 'Oracle GoldenGate', 'OCI CLI', 'Terraform'
);
v_descriptionCLOB := 'Migrated on‑prem Oracle DBs to OCI using Autonomous DB & APEX; automated backups, improved scalability, and cut costs by ~40%.';
FUNCTIONtool_countRETURN PLS_INTEGER IS
BEGIN
RETURNv_tools.COUNT;
END tool_count;
BEGIN
NULL; -- Placeholder execution block
END;
/

AI-Powered Database Performance Optimization

DECLARE
v_nameVARCHAR2(200) := 'AI-Powered Database Performance Optimization';
v_roleVARCHAR2(120) := 'Database Performance Engineer';
TYPEt_tool_tabIS TABLE OFVARCHAR2(100);
v_tools t_tool_tab := t_tool_tab(
'Oracle Database', 'Python', 'Machine Learning', 'Oracle Enterprise Manager', 'SQL Tuning Advisor', 'Oracle AWR', 'Pandas', 'Scikit-learn'
);
v_descriptionCLOB := 'Built ML-based Oracle performance tuner predicting bottlenecks and recommending query & parameter optimizations via OEM + Python scripts.';
FUNCTIONtool_countRETURN PLS_INTEGER IS
BEGIN
RETURNv_tools.COUNT;
END tool_count;
BEGIN
NULL; -- Placeholder execution block
END;
/

Data Engineering Pipeline with Oracle

DECLARE
v_nameVARCHAR2(200) := 'Data Engineering Pipeline with Oracle';
v_roleVARCHAR2(120) := 'Data Engineering Lead';
TYPEt_tool_tabIS TABLE OFVARCHAR2(100);
v_tools t_tool_tab := t_tool_tab(
'Oracle GoldenGate', 'Oracle Data Integrator', 'Oracle Analytics Cloud', 'Oracle Streams', 'PL/SQL', 'Oracle Warehouse Builder'
);
v_descriptionCLOB := 'Engineered real-time data pipeline: GoldenGate replication, ODI ETL, analytics dashboards; processes >1TB/day with sub-second latency.';
FUNCTIONtool_countRETURN PLS_INTEGER IS
BEGIN
RETURNv_tools.COUNT;
END tool_count;
BEGIN
NULL; -- Placeholder execution block
END;
/

Educations

2025

Oracle Certified Professional (OCP)

Oracle Database Administration

Oracle University

2016 - 2020

Bachelor of Technology

Electronics & Communication Engineering

Meghnad Saha Institute of Technology

2014 - 2016

Higher Secondary

Pure Science

Barisha High School

Certifications

Oracle Certified Professional (OCP)

Oracle•

SEP 2025

Oracle Database Administration 2019 Certified Professional demonstrating advanced skills in Oracle Database administration.

Oracle ADB 2025 Certified Professional

Oracle•

OCT 2025

Certified specialist in Oracle Autonomous Database, skilled in provisioning, managing, and monitoring Autonomous Database workloads on Shared Exadata Infrastructure.

OCI 2025 Certified DevOps Professional

Oracle•

OCT 2025

Demonstrated proficiency in Oracle Cloud Infrastructure (OCI) DevOps/DevSecOps practices, including CI/CD pipelines, containerization, and infrastructure as code (IaC).

OCI 2025 Certified Generative AI Professional

Oracle•

OCT 2025

Certified expert in building Large Language Model (LLM) applications using OCI Generative AI service, with deep knowledge of LLM architecture and fine-tuning.

OCI 2025 Certified Architect Associate

Oracle•

OCT 2025

Validated knowledge in designing secure, scalable, and highly available infrastructure solutions on Oracle Cloud Infrastructure (OCI).

OCI 2025 Certified Foundations Associate

Oracle•

AUG 2025

Fundamental understanding of Oracle Cloud Infrastructure (OCI) services, cloud computing concepts, and OCI security and compliance models.

Oracle Database SQL Certified Associate

Oracle•

2021

Certified in Oracle Database SQL fundamentals, demonstrating proficiency in SQL querying and database operations.

Associate Cloud Engineer

Google Cloud•

2022

Google Cloud Associate Cloud Engineer certification validating skills in deploying applications, monitoring operations, and managing enterprise solutions.