Aug 2019 – Sep 2022 · 3 yrs 1 mo · Gurugram, Haryana, India

• ▪ working since Aug 2019 as an ORACLE PL/SQL Developer, involving Requirement
• Gathering, Analysis, Design, Development, Unit Testing, Production Deployment and Support.
• ▪ Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Cursors, Views
• and Exception handling for retrieving, manipulating, checking data sets inOracle.
• ▪ Coordinating with the front-end design team to provide them with the necessary stored
• procedures and packages and the necessary insight into the data.
• ▪ Optimizing query performance using related features such as Query Optimizer, Execution Plans,
• Table partitioning and Indexes.
• ▪ Handling errors using Exception Handling extensively for the ease of debugging and displaying
• the error messages in the application.
• ▪ Writing Cron jobs scriptsto automate job execution in oracle.
• ▪ Experience with UNIX including basic Commands.
• ▪ Having good experience on Client Interaction and Presentation Skills.
• ▪ Experience Agile and scrum methodologies.
• ▪ Good experience in UNIX script creation and execution for pre-production and production
• deployments.
• ▪ Experience in Deployments through Jenkins and use of GIT.
• ▪ Experience using PL/SQL Collections, Ref Cursor, strongly typed cursor, Weakly typed cursor,
• Bulk Collect, Pragma Autonomous Transaction.
• ▪ Hands-on experience in query optimization and exposure using GTT tables, Indexes etc.
• ▪ Understanding and Collecting requirements from Business Analyst/Client and try to convert that
• requirement to SQL queries or PL SQL.