PLSQL Developer at Panamax InfoTech Ltd. · Remote only · 3 - 12 years · ₹3L - ₹8L / yr · Profitable · Remote only · Posted 23 Sep 2022
Concepts 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.

Similar jobs (2)
Job Description – Database / SQL Developer
Company: Wissen Technology
Experience: 3.5 – 5 Years
Location: Mumbai
Role Overview
We are looking for a skilled Database / SQL Developer with 3.5–5 years of experience in SQL, UNIX scripting, and basic Python programming. The ideal candidate should have strong database knowledge, hands-on experience in writing and optimizing SQL queries, and the ability to work with UNIX shell scripting for automation and data processing.
Key Responsibilities
- Write, maintain, and optimize complex SQL queries, stored procedures, and database scripts.
- Work with relational databases and perform data extraction, transformation, and validation.
- Develop and maintain UNIX/Linux shell scripts for automation and batch processing.
- Use Python scripting for basic automation, data handling, and process improvement.
- Troubleshoot database-related issues and improve query performance.
- Collaborate with development and support teams to ensure smooth data processing and system operations.
- Monitor scheduled jobs, identify failures, and resolve technical issues.
Required Skills
- 3.5–5 years of relevant IT experience.
- Strong hands-on experience in SQL and database concepts.
- Good knowledge of UNIX/Linux commands and Shell scripting.
- Basic to intermediate knowledge of Python scripting.
- Understanding of relational databases, joins, indexing, and query optimization.
- Good analytical and problem-solving skills.
- Ability to troubleshoot and work independently.
Preferred Skills
- Experience with database performance tuning.
- Knowledge of batch processing and job scheduling.
- Exposure to ETL processes and data handling.
- Experience working in production or support environments.
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








