Gokul K

PL/SQL developer with hands on experience of 3.6 Years 

Rudimax Solutions., Chennai, India | Oracle PL/SQL developer JULY 2019 - Present
Responsibilities
 Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
 Developed data model, PL/SQL Queries, SQL Query tuning process.
 Created and maintained tables, procedures, functions, and packages, and update, delete, and
 insert statements and compile them.
 Experience working with Oracle CLOB, BLOB, Materialized Views, Ref Cursors, Index 
 Tables, Partitions, Objects/Collections, Execute Immediate etc. 

 Formulated SQL queries, functions and processes as per requirement.
 Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding
 involved in writing database procedures, functions and packages.
 Worked with developers to repair and enhance current base of PL/SQL packages to testing
issues.
 Performed SQL and PL/SQL tuning and Application tuning using various tools like
EXPLAIN PLAN.
 Handled errors using Exception Handling extensively for the ease of debugging and displaying the
error messages in the application.
 Used Bulk Collections for better performance and easy retrieval of data, by reducing context
 switching between SQL and PL/SQL engines.
 Data Load into Oracle tables using SQL*Loader, and PL/SQL procedures
 Responsible for Unit Testing of Database PL/SQL Packages, Procedures, Functions and Database
Triggers.
 Defect tracking through JIRA and defect summary reporting.
 Worked on agile and test-driven environment, participated on daily scrum meeting, and
discussions.
Solubils corporate services, Chennai, India | process Executive Oct 2015 – Dec 2017
Responsibilities
 Understand the requirement and nature of the client’s business and will suggest incorporation plan 
 Documentation works.
 Regular follow up with the clients 
 Coordinating with other teams regarding the pending process.
 Reporting daily status and weekly review 
P

Bachelor of Engineering (Mechanical Engineering), from Vels University, Chennai, India - 2015