Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Rakesh Ramesh

Bengaluru

Summary

Highly skilled Oracle PL/SQL Developer with 4+ years of experience in designing, developing, and optimizing database solutions. Proven expertise in solving complex business challenges, performance tuning, and automation using PL/SQL, SQL, and Unix shell scripting. Adept at client interactions, delivering high-quality results under pressure, and driving innovation in the FinTech domain. Key contributor to Citibank corporate lending banking in Flexcube, resulting in enhanced operational efficiency.

Overview

4
4
years of professional experience

Work History

PL/SQL Developer

Oracle
Belfast
11.2022 - Current
  • Leveraging technical skills of PL/SQL, SQL, Oracle Database, Oracle Forms and UNIX in the UK onsite location I adeptly managed client interactions and resolved issues in high-pressure environments
  • My role required exceptional problem-solving skills and meticulous attention to detail, enabling me to deliver optimal results
  • Identified and resolved slow-running queries, significantly improving system performance.
  • Experienced in SQL and PL/SQL performance tuning, understanding database execution plans, analyzing AWR reports, and optimizing SQL for performance.
  • Source Code & Version Control Management: Proficient in managing project source code, version control, and promoting code in compliance with enterprise standards
  • Problem Solving: Proven ability to solve complex problems efficiently and effectively
  • Linux and Shell Scripting: Proficient in Linux operating systems and shell scripting for automation and system management

PL/SQL Developer

Oracle
Bengaluru
09.2020 - 11.2022
  • Developed complex database objects like stored procedures, functions, packages, and triggers using SQL and PL/SQL.
  • Leveraged standard Oracle packages (e.g., UTL_FILE), dynamic SQL, records, arrays, PL/SQL tables, and file handling.
  • Identified and resolved slow-running queries, significantly improving system performance.
  • Debugged and troubleshot complex database issues, minimizing downtime.
  • Developed comprehensive documentation and provided clear communication to stakeholders.
  • Collaborated in Agile environments to deliver on-time, high-quality solutions.

Education

B.E - Electronics and Telecommunications

B.M.S College of Engineering
Bengaluru
08.2020

Skills

  • Database Development: PL/SQL, SQL, Oracle Database (latest version), PostgreSQL, Oracle APEX
  • Automation & Scheduling: Linux shell scripting, Autosys scheduling
  • Performance Optimization: Query optimization, performance tuning, Explain Plan, Hints
  • Development Features: Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, External tables
  • Monitoring Tools: ITRS monitoring
  • Development Methodologies: Agile development, Scrum, SDLC, source control (Git), Atlassian tools (JIRA, Confluence, BitBucket)
  • DevOps Tools: UC4, Maven, Jenkins, CI/CD
  • Tools & Technologies: Oracle Forms, Data Modeling, Data Analysis

Additional Information

  • Solid experience and comfort with UNIX/Linux platforms and sufficient commands.
  • Open to relocation and flexible with work environments.
  • Passionate about leveraging technology to solve business challenges.
  • Keen interest in continuous learning and professional development.

Timeline

PL/SQL Developer

Oracle
11.2022 - Current

PL/SQL Developer

Oracle
09.2020 - 11.2022

B.E - Electronics and Telecommunications

B.M.S College of Engineering

Similar Profiles

CREATE PROFILE
Rakesh Ramesh