Rohit Uniyal

Oracle PL/SQL Developer with 4.5+ years of experience designing, optimizing, and supporting high-performance database solutions in production environments across the Insurance and Aviation domains.
At Tata Consultancy Services, I worked on mission-critical systems for New India Assurance, developing and maintaining 50+ PL/SQL objects including stored procedures, functions, packages, triggers, and views handling millions of policy records. My experience includes query optimization, batch processing, schema design, production support, and automation.
Key areas of expertise include:
▸ Oracle PL/SQL Development
▸ Stored Procedures, Packages, Triggers & Views
▸ Performance Tuning (EXPLAIN PLAN, Index Tuning, Bulk Collect/FORALL)
▸ SQL Optimization & Batch Processing
▸ DDL & Schema Management
▸ Production Support & Incident Management (P1/P2)
▸ Python Automation & Unix Shell Scripting
▸ Power BI Reporting & Data Analysis
In addition to database development, I built Python and Shell-based automation solutions that reduced manual operational effort by ~40%, and developed Power BI dashboards for business reporting and operational insights.
Currently expanding into Data Engineering with hands-on experience in:
▸ Apache Spark
▸ Apache Airflow
▸ ETL Pipelines
▸ Kafka
▸ Docker
▸ Google BigQuery
▸ MongoDB & Cassandra
▸ DBT
I recently completed the IBM Data Engineering Professional Certificate (Coursera/IBM), strengthening my expertise in modern data engineering, distributed processing, and analytics engineering workflows.
Open to opportunities in:
• Oracle PL/SQL Development
• Data Engineering
• Database Development
• ETL & Analytics Engineering