Database Developer

Job Description

Job Responsibilities: Important Key Skills: My Sql, MongoDB, Vector DB, MS SQL • Creation of database objects like tables, view, synonyms, materialized view, stored procedure. • Packages using Oracle tools like SQL developer, PL/SQL developer. • Involved in updating procedure, function, trigger, and packages based on the changes requested. • Built complex queries using SQL and wrote stored procedures using PL/SQL. • Handling Implicit & Explicit cursor. Used ref cursors and collection for accessing complex data resulted from Joining of a large number of tables. • Write queries and scripts to retrieve data from the tables, design scripts to create database objects. • Analyze the slow running queries. • Involved in writing complex SQL queries. Using sub-queries to retrieve data from the database. • Managing data flow using control structure. • Extensively used join writing view in the database. • Involved in handling exceptions. • Write efficient SQL queries, stored procedure, function, trigger and packages. • Debug and troubleshoot PL/SQL code to identify and resolve issues. • Ensure code quality, performance and adherence to coding standards • Calling API in Store Procedures. • Scheduling Jobs.