Home Credit India Finance

Pl sql Developer

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Gurgaon/Gurugram
  • Experience: 3-5yrs
  • No. of Positions: 10
  • Salary Range: 3-6 lac
  • Primary Skills: SQL Loader Oracle SQL SQL Development PLSQL
  • Secondary Skills: Performance Tuning Oracle 11G
  • Job Location: Gurgaon/Gurugram
  • Posted Date: 23 days ago
Job Description

 

Objective:

Assist different countries and business with various database related queries and work closely with SAS team for data related issues.

 

Responsibilities:

  • Provides 1st Level Application Support to users of the DB across 4 countries .
  • Provide 1st level issue resolution, timely escalation to 2nd level if needed.
  • Establish best practices for administering and loading sources of data.
  • Oversee, recommend and implement appropriate solutions and enhancements to ensure an improvement in system reliability and performance.
  • Assist in performance tuning of the systems and servers.
  • Create SDLC documentation and ensure alignment to overall SDLC and Change Management processes.
  • Contribute to the development of standards and operating procedures for the DB environments.
  • Evaluate and recommend new tools and methodologies to assist with change management and suggest upgrades of the DB environment as necessary.

 

Required:

  • Experience- 3-6 Years
  • Good understanding of Oracle Database 11g,12c, Oracle SQL, Oracle PLSQL.
  • Have in depth knowledge on relational database concepts
  • Well versed in writing SQL-Queries, Sub Queries, Joins, DML, DDL etc.
  • PLSQL: Stored procedure, Functions, Cursor, Packages, Exception handing etc.
  • SQL Developer / Toad & SQL Performance Tuning
  • Analytical Functions, Group Functions
  • Oracle utilities (like SQL loader, Import/export, data pump etc.,)
  • Migrating objects from one instance to another
  • Experience in trouble shooting performance issues
  • Good experience in performing joins
Relevant Skill Jobs
Software Engineer Asp Net MS SQL
Web Developer
Immediate Hiring For Java Specialist Full Stack
Android Application Developer
Dot Net Developer Immediate
Nodejs Back end