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
PL/SQL
SQL
RAD Tool
Linux
Orient DB
Neo4j
Bug Tracking Tool
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