PLSQL Developer at Panamax InfoTech Ltd. · Remote only · 3 - 12 years · ₹3L - ₹8L / yr · Profitable · Remote only · Posted 23 Sep 2022
JavaConcepts of RDBMS, Normalization techniques
Entity Relationship diagram/ ER-Model
Transaction, commit, rollback, ACID properties
Transaction log
Difference in behavior of the column if it is nullable
SQL Statements
Join Operations
DDL, DML, Data Modelling
Optimal Query writing - with Aggregate fn, Group By, having clause, Order by etc. Should be
hands on for scenario-based query Writing
Query optimizing technique, Indexing in depth
Understanding query plan
Batching
Locking schemes
Isolation levels
Concept of stored procedure, Cursor, trigger, View
Beginner level - PL/SQL - Procedure Function writing skill.
Spring JPA and Spring Data basics
Hibernate mappings
UNIX
Basic Concepts on Unix
Commonly used Unix Commands with their options
Combining Unix commands using Pipe Filter etc.
Vi Editor & its different modes
Basic level Scripting and basic knowledge on how to execute jar files from host
Files and directory permissions
Application based scenarios.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Panamax InfoTech Ltd.
About
Company social profiles
Similar jobs (1)
.NET
HTML/CSS
Javascript
Angular (2+)Experience and Required Skill Sets:
1 Solid experience in software design and development using Microsoft ASP.NET framework, C#, Visual Studio, and in writing clean, readable, and easily maintainable code
2 5+ years of experience in WCF, WPF, VB.NET, SQL Server, JQuery, Angular 10 and above.
3 5+ years of experience in developing highly scalable REST/Web APIs
4 5+ years of experience in developing highly efficient SQL/NoSQL Queries
5 5+ years of experience in Relational and Document databases
6 Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.
7 Experience in using the MVC framework, working knowledge in APIs, and Service Oriented Architecture
8 Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.
9 Experience in Angular version 10 and above is required
10 Expert in SQL programming & Database Design (Stored procedure, Function, Trigger, Constraints, Replication)
11 Strong ability in HTML and JavaScript (AJAX, DOM)
12 Development experience with data integration technologies including REST, SOAP, JSON, XML
13 Expertise in programming and usage of any unit testing framework. Expertise in integration testing and continuous integration.
14 Experience working in a DevOps environment will be an added advantage.
Responsibilities:
• Ability to create complex, enterprise-transforming applications that meet and exceed client expectations.
• Responsible for the bottom line. Strong project management abilities. Ability to encourage the team to stick to timelines.
• Follow best-in-class coding practices and review the solutions vis-à-vis the requirements and technical specifications.
• Should demonstrate strong client interfacing capabilities like emails and calls with clients in the US/UK
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon