Job Description
Hi,
We have a requirement of Database Developer with our client in Noida
Shift: 1pm to 10 pm
Primary Skills:
Database (Oracle or SQL)
* Writes intricate, complex queries involving multiple tables, inner queries, self-joins, outer joins, group by functions etc. independently
* Demonstrates ability to improve performance of simpler queries by applying basic techniques like creating an index, changing data-type, consolidating the query etc.
* Demonstrates ability to write stored procedures leveraging cursors, managing transactions, exceptions, triggers etc.
* Describes DB locking, transaction mgmt. features and codes accordingly
* Demonstrates ability to use techniques like explain plan, optimization utilities (tkprof, trace) to analyze and improve performance
* Should be able to do performance optimization and query tuning
Secondary Skills
Java (20%) - Candidate should have clarity on OOPS concepts and knowledge of scripting. In Java, he should also have good knowledge of collections and familiar with Java 8 features like Lamda & Stream
Job Classification
Industry: IT-Software, Software Services
Functional Area: IT Software - Application Programming, Maintenance,
Role Category: Programming & Design
Role: Programming & Design
Employement Type: Full time
Education
Under Graduation: Any Graduate in Any Specialization, Graduation Not Required
Post Graduation: Post Graduation Not Required, Any Postgraduate in Any Specialization
Doctorate: Doctorate Not Required, Any Doctorate in Any Specialization
Contact Details:
Company: Spectra Consulting
Location(s): Noida, Gurugram
Keyskills:
Java
Performance Optimization
Oracle Database
Stored Procedures
Explain Plan
OOPS
Triggers
Index
Database Development
SQL