SQL AND PL/SQL DEVELOPER (ORACLE)
Send a job offer directly to this candidate
Software developer with 11+ years (5 years non-IT) experience in Oracle SQL and PL/SQL.
Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created
Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and
PL/SQL.
Onward Technologies Limited, Pune — Sr.
August 2016 - October 2022
To create a database table by using oracle, where client can store his customer information,
retrieve, manipulate the data by using Software application. All Software operations can be performed using SQL Developer.
● Writing SQL queries, Cursors, collection, Sub programs like Procedures, Functions,
Packages and Triggers in PL/SQL blocks.
● Perform DML, DDL Operations as per the Business Reports.
● Used different Joins, sub queries and nested query in SQL query.
● Plan and analyze requirements and modeling data in the database.
● Developing SQL sub queries, applying constraints, creating views, sequences and indexes.
● Writing complex queries to generate reports using SQL Developer.
● Using Indexes and Materialized Views for optimizing performance.
● Creating External Table and loading the data from external data file.
● Using collections in procedures to generate high performance queries and PL/SQL code.
● To Compile and analyze codes and solve all bugs and troubleshoot problems.
● Working alone or with team members on coding stored procedures as well as other programming tasks as defined by the overall system architecture or other specifications.
● Proficient in the data model and data structures and efficiently responding to business queries and requests.
● Communicating with Business users across firms to gather requirements or troubleshoot problems and convert business requirements into technical solutions.
● Providing ongoing maintenance and support of database schema.
JAWAHARLAL NEHRU TECHNOLOGIES UNIVERSITY HYDERABAD
— Mechanical Engineering
July 2008 - June 2011, Khammam.
