Summary
Overview
Work History
Education
Skills
Tools Used
Certification
Timeline
OperationsManager

Rajeshkumar R

PL/SQL Developer
Chennai,TN

Summary

Results-driven and detail-oriented PL/SQL Developer with 8 years of experience in designing, developing, and optimizing database solutions for large-scale applications. Proficient in writing complex SQL queries, stored procedures, functions, and triggers to enhance database performance and ensure data integrity. Skilled in database modeling, performance tuning, and troubleshooting.

Overview

9
9
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work History

PL/SQL developer

Cognizant Technology Solution
12.2022 - Current
  • Designed and developed complex PL/SQL packages, stored procedures, functions, and triggers to support business logic and application requirements
  • Optimized SQL queries and database performance by analyzing execution plans, creating indexes, and partitioning large tables
  • Collaborated with business analysts and application developers to gather requirements and translate them into efficient database solutions
  • Performed database tuning and troubleshooting to resolve performance bottlenecks and ensure high availability
  • Ensured data integrity and security by implementing constraints, triggers, and role-based access controls

Data Analyst/NoSQL

Infosys Limited
09.2021 - 12.2022
  • Defined plans problems and resolutions and provided detailed reports to applicable management
  • Collect data from client to use in establishing organizational structure
  • Involved in data modelling, physical database design, data conversion, performance analysis and tuning
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain plan, Backtrace
  • Implemented data migration and ETL processes to integrate data from multiple sources into a centralized data warehouse
  • Manage end-to-end data migration, conversion and data modelling

PL/SQL Developer

Oracle Financial Services Software (OFSS)
04.2019 - 04.2021
  • Played Analyst role in converting Business Requirements into Functional Specification
  • Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views, Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic
  • Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan
  • Creating change requests in Quality Centre and follow up from development phase to testing phase
  • Designed & developed client specific product customizations through Oracle PLSQL programming, Oracle 12c
  • Generated statspack/AWR reports from oracle database and analysed the reports for oracle wait events, database growth, time consuming queries

PL/SQL Developer

Infrasoft Technologies Pvt Ltd
06.2016 - 01.2019
  • Worked on new release which involves developing stored procedures, functions, Triggers, Cursors, packages
  • Supported Oracle production and deployment at customer site
  • Experienced in Tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds)
  • Involved in Modifying various existing Procedures and functions according to new Business needs
  • Working as Production Support, attending production calls, troubleshooting the application and resolving bugs
  • Developing SQL scripts as per the given business requirements and sending reports to the Clients
  • Analysed AWR reports to identify on going / proactive issues and worked with primary DBA to resolve

Education

B.E - Electronics And Communication Engineering

ANNA UNIVERSITY
01.2010 - 01.2014

Skills

Oracle 11g/12c/19c

Tools Used

  • PL/SQL, JAVAScript, SQL, Oracle 11g, Oracle 12c, Oracle PL/SQL, SQL, PL/SQL Developer, SQL
  • PLUS, Oracle Flexcube RAD Tool, JIIRA, Bug Tracking Tool, SVN, Orient DB, Neo4j, Graph database, Windows series, Linux

Certification

OCI AI Foundations Associate

Timeline

OCI AI Foundations Associate

06-2024

PL/SQL developer

Cognizant Technology Solution
12.2022 - Current

Data Analyst/NoSQL

Infosys Limited
09.2021 - 12.2022

PL/SQL Developer

Oracle Financial Services Software (OFSS)
04.2019 - 04.2021

PL/SQL Developer

Infrasoft Technologies Pvt Ltd
06.2016 - 01.2019

B.E - Electronics And Communication Engineering

ANNA UNIVERSITY
01.2010 - 01.2014

Similar Profiles

CREATE PROFILE
Rajeshkumar RPL/SQL Developer