Available for New Projects

Chiranjib Dhal

Database Developer | Oracle & PL/SQL Expert

Senior Database Developer with 4+ years of expertise in designing, optimizing, and maintaining enterprise-level database systems. Specializing in high-performance SQL, complex data migration, and production stability.

Professional portrait of Chiranjib Dhal
Database Oracle 19c
Optimization 99.9% Uptime

About Me

As a Senior Database Developer with over 4 years of experience, I specialize in architecting and optimizing enterprise-level database solutions. My expertise spans the complete database lifecycle, from initial design and implementation to performance tuning and maintenance.

I have a proven track record of improving system performance, reducing query execution times, and implementing robust data security measures. My work has consistently resulted in enhanced application responsiveness and reduced infrastructure costs for organizations.

I'm passionate about solving complex data challenges and leveraging database technologies to drive business value. Whether it's optimizing a slow-running query or designing a new database schema, I approach each problem with analytical thinking and best practices.

Database Design

Expert in designing scalable, normalized database architectures for enterprise applications

Performance Optimization

Proven track record of improving query performance by up to 85% through indexing and tuning

Data Security

Implementing robust security measures and access controls for sensitive data protection

Complex SQL Development

Creating sophisticated stored procedures, triggers, and functions for business logic

Technical Skills

A comprehensive toolkit for building and optimizing enterprise database solutions

Databases

Oracle 12c/19c/21c MySQL PostgreSQL SQL Server MongoDB

Languages

SQL PL/SQL T-SQL Python Shell Scripting

Core Concepts

Stored Procedures Triggers & Functions Indexing Strategies Query Optimization Database Design Data Migration SQL Loader Partitioning

Tools & Technologies

SQL Developer TOAD Git / GitHub Jira SQL Plus MySQL Workbench Linux / Unix Oracle APEX

Professional Experience

Associate IT Consultant

ITC Infotech
Aug 2025 - Present Kolkata, India
  • Worked as a PL/SQL Developer with hands-on experience in designing and optimizing complex database solutions.
  • Optimized complex SQL queries resulting in 75% reduction in execution time
  • Developed automated PL/SQL procedures reducing manual effort by 60%
  • Developed and maintained stored procedures, functions, packages, triggers, and performance-tuned SQL queries.
  • Collaborated with business analysts and application teams to translate requirements into efficient database logic.

Sr. Software Engineer

CSM Technologies
Dec 2021 - Jul 2025 Bhubaneswar, India
  • Contributed as a PL/SQL Developer focusing on data processing, reporting, and backend database development.
  • Built 100+ stored procedures, triggers, and functions
  • Worked on performance tuning using indexes, execution plans, and query optimization techniques.
  • Participated in end-to-end development, testing, and deployment while following coding and documentation standards.
  • Supported production systems, handled bug fixes, and improved query performance for critical business applications.

Projects & Case Studies

Real-world database challenges solved with measurable business impact

Customer Data Management Optimization

Problem

The customer database faced slow response times and frequent performance bottlenecks due to large data volumes and inefficient queries.

Solution

Redesigned database schema, optimized 40+ SQL queries, implemented indexing strategies, bulk collect, and PL/SQL performance tuning techniques.

Impact
  • Reduced customer data retrieval time by 60%
  • Improved batch processing performance by 45%
  • Increased system reliability and reduced production incidents
  • Enhanced end-user experience for business teams

Financial Transaction Reporting Automation

Problem

Manual and semi-automated financial reports caused delays, errors, and high dependency on database support teams.

Solution

Developed automated PL/SQL procedures, complex joins, and scheduled jobs; implemented exception handling, logging, and data validation.

Impact
  • Reduced report generation time from 3 hours to under 10 minutes
  • Eliminated manual errors and improved report accuracy
  • Enabled real-time financial insights for stakeholders
  • Reduced operational workload for database support teams

Legacy Data Migration & Validation

Problem

Migration of legacy data to a new system risked data loss, duplication, and integrity issues across millions of records.

Solution

Created PL/SQL ETL scripts using bulk operations, validation rules, and reconciliation procedures to ensure clean data migration.

Impact
  • Achieved 100% data accuracy during migration
  • Migrated 5+ million records with zero downtime
  • Reduced post-migration defects by 70%
  • Ensured seamless system go-live without business disruption

Certifications

Industry-recognized credentials validating database expertise

Oracle APEX Cloud Certified Developer Professional

Issued by: Oracle

Date: Oct 2025

Credential ID: 102968317APEX24CDOCP

View Credential

Oracle Data Platform 2025 Foundations Associate (1Z0-1195-25)

Issued by: Oracle

Date: Oct 2025

Credential ID: 102968317OCI25DCFA

View Credential

Problem Solving Certificate

Issued by: HackerRank

Date: Sep 2024

Credential ID: AB8DFFD558BD

View Credential

SQL (Advanced) Certificate

Issued by: HackerRank

Date: Sep 2024

Credential ID: BAC61BE0BF17

View Credential

Resume

A comprehensive overview of my professional journey and qualifications.

Get In Touch

Have a project in mind or want to discuss database solutions? I’d love to hear from you.

Email contact@chiranjibdhal.in
Phone +91-637116343*
Location Bhubaneswar, India