Sudhir Kumar

About Sudhir Kumar

A data engineering professional with over 12 years of experience -> First 6 years working on data warehouse developement, optimization and maintenace mostly using SQL databases(DB2). Skills : Database development, Schema Design(Normalization),SQL Development. SQL tuning, shell scripting, Reporting on SAP BO, requirement gathering, pipeline desing and optimization, dimension modelling(star & snowflake), Slowly changing dimensions etc-> Last 6 years working as database test developer for Oracle Database & Oracle Text- create data pipelines using Oracle (ORACLE AI VECTOR SEARCH), vector database (Text chunking & summarization, Embeddings) for both keyword & semantic Search applications.Worked on DML performance enhancement and Asynchronous Maintenance [with the help of background jobs] of Oracle Text (I.e. Full-text search), worked on Oracle Text version 2[simplified syntax].Works in Multi-tenant (CDB/PDB), Real Application Cluster (RAC), In-memory column store.Works with different (compute, storage, databases etc.) services in Oracle cloud platform (OCI).Skills - Oracle database, Oracle Text, AI vector search, vector DB, Hybrid Vector Index, Python(Programming, pandas), Spark SQL, Spark Dataframe APIs, ETL, optimization(Broadcast join, partitioning, bucketing etc.), Hive, Airflow, Object storage.Interested in senior/mid-senior Dev/test Dev roles in data engineering space.

Experience

1. Principal Member of Technical Staff

   Oracle

   Sep 2023 — Present · Bengaluru, IN

   Work on data pipelines using Oracle (ORACLE AI VECTOR SEARCH), vector database (Text chunking & summarization, Embeddings) for both keyword & semantic Search applications.Worked on DML performance enhancement and Asynchronous Maintenance [with the help of background jobs] of Oracle Text (I.e. Full-text search), worked on Oracle Text version 2[simplified syntax].Works in Multi-tenant (CDB/PDB) sharded DB environment.Works in Real Application Cluster (RAC) DB Environment.Works on In-memory column store feature of Oracle DB, its configuration, architecture, population, and optimization of in-memory queries.Works with different (compute, storage, databases etc.) services in Oracle cloud platform (OCI).

Education

• SCIENCE COLLEGE ,PATNA

  Intemediate, PCM

  2005 — 2007

• JNV SARAN

  Seconday, PCM

  2000 — 2005

• NIT CALICUT

  Bachelor of Technology (B.Tech.), Computer Science

  2008 — 2012