Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Advansoft International Team. If you also belong to the team, you can get access from here

Advansoft International Verified Tick

Compare button icon Compare button icon Compare
filter salaries All Filters

10 Advansoft International Jobs

PL-SQL Developer (5-7 yrs)

5-7 years

PL-SQL Developer (5-7 yrs)

Advansoft International

posted 1mon ago

Job Role Insights

Fixed timing

Job Description

We are seeking an experienced Oracle PL/SQL Developer to join our team. In this role, you will design, develop, and maintain database solutions using PL/SQL.


You will be responsible for creating efficient database schemas, optimizing queries, and ensuring the overall performance and reliability of Oracle database applications.


Key Responsibilities :


- Develop and maintain Oracle database applications using PL/SQL.


- Create and manage stored procedures, functions, packages, and triggers.


- Design and implement efficient and scalable database schemas to support application functionality.


- Analyze and optimize SQL queries and PL/SQL code to ensure high database performance.


- Implement indexing strategies and query tuning to improve data retrieval efficiency.


- Develop and execute comprehensive test plans to validate the functionality, performance, and accuracy of PL/SQL code.


- Ensure compliance with organizational coding standards and best practices.


- Diagnose and resolve issues related to database performance, integrity, and functionality.


- Provide support for production systems and resolve incidents in a timely manner.


- Prepare and maintain technical documentation for database structures, processes, and configurations.


- Collaborate with application developers, data analysts, and other stakeholders to understand and implement database requirements.


- Ensure data integrity, security, and compliance with relevant regulations.


- Manage data migrations, backups, and restoration processes.


Technical Skills Required :


- Strong proficiency in Oracle PL/SQL, including stored procedures, functions, packages, and triggers.


- Advanced knowledge of SQL query writing and optimization techniques.


- Experience in designing and managing relational database schemas.


- Understanding of normalization and denormalization techniques.


Performance Tuning & Optimization :


- Expertise in query tuning, execution plan analysis, and performance diagnostics.


- Knowledge of Oracle performance tools like TKPROF, SQL Trace, or AWR reports.


- Experience with PL/SQL debugging tools and testing frameworks.


- Ability to write and execute test scripts for validating database functionalities.


- Proficiency with Oracle database tools such as SQL-Plus, Toad, or SQL Developer.


- Familiarity with Oracle Enterprise Manager (OEM) for monitoring and management.


- Experience with data import/export and ETL processes.


- Familiarity with tools like Oracle Data Integrator (ODI) or Informatica is a plus.


- Knowledge of Unix/Linux scripting for database operations.


- Understanding of database security and data protection principles.


- Strong problem-solving and analytical skills.


- Excellent communication and documentation abilities.


- Ability to work collaboratively with cross-functional teams.


- Detail-oriented with a focus on delivering high-quality solutions.


- Oracle PL/SQL Developer Certified Associate (OCA).


- Oracle Database SQL Certified Associate.


- Oracle Database Administrator Certified Professional (OCP).


Functional Areas: Software/Testing/Networking

Read full job description

Prepare for Plsql Developer roles with real interview advice

What people at Advansoft International are saying

What Advansoft International employees are saying about work life

based on 54 employees
64%
93%
76%
54%
Strict timing
Monday to Friday
No travel
Day Shift
View more insights

Advansoft International Benefits

Cafeteria
Work From Home
Free Food
Job Training
Free Transport
Team Outings +6 more
View more benefits

Compare Advansoft International with

Infosys

3.6
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare

LTIMindtree

3.8
Compare

Mphasis

3.4
Compare

Hexaware Technologies

3.5
Compare

Persistent Systems

3.5
Compare

Magic Edtech

3.0
Compare

VDart

4.5
Compare

Saama Technologies

3.7
Compare

DISYS

3.0
Compare

Data-Core Systems

3.1
Compare

Arvato

3.5
Compare

Xchanging

4.0
Compare

11:11 Systems

3.8
Compare

Calpion Software Technologies

3.3
Compare

Equifax

3.3
Compare

Zen3 Info Solutions

4.1
Compare

Similar Jobs for you

Plsql Developer at Ximax Solutions

3-8 Yrs

₹ 15-25 LPA

Plsql Developer at JRK INFOTECH PRIVATE LIMITED

5-7 Yrs

₹ 15-20 LPA

Plsql Developer at PRACTICESUITE INDIA PRIVATE LIMITED

5-8 Yrs

₹ 15-30 LPA

Plsql Developer at Nityo Infotech Services Pvt. Ltd.

5-7 Yrs

₹ 15-30 LPA

Plsql Developer at Ara Resources Pvt Ltd

7-14 Yrs

₹ 25-28 LPA

Plsql Developer at ZestPire

3-5 Yrs

₹ 13-19 LPA

Plsql Developer at PRACTICESUITE INDIA PRIVATE LIMITED

5-8 Yrs

₹ 15-30 LPA

Plsql Developer at Talent Scout Management Solutions

3-8 Yrs

₹ 10-24 LPA

Plsql Developer at Burgeon It Services Pvt Ltd

7-10 Yrs

₹ 20-25 LPA

Plsql Developer at Zinnia

2-4 Yrs

₹ 12-15 LPA

PL-SQL Developer (5-7 yrs)

5-7 Yrs

1mon ago·via hirist.com

Angular Developer - HTML5/CSS3 (5-10 yrs)

5-10 Yrs

1mon ago·via hirist.com

Mainframe Developer - JCL/COBOL (4-11 yrs)

4-11 Yrs

1mon ago·via hirist.com

.Net Developer - C# (8-12 yrs)

8-12 Yrs

2mon ago·via hirist.com

Software Engineer - Web Apps (8-13 yrs)

8-13 Yrs

2mon ago·via hirist.com

Web Architect - Javascript/AngularJS (7-10 yrs)

7-10 Yrs

2mon ago·via hirist.com

Power BI Developer - BI Reporting (4-6 yrs)

4-6 Yrs

2mon ago·via hirist.com

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

JOBS

Corporate Landbase

No Jobs

JOBS

Kalpataru Limited

No Jobs

JOBS

Kalpataru Limited

No Jobs

JOBS

Investors Clinic

No Jobs

JOBS

Ayuni Associates

No Jobs

SALARIES

Investors Clinic

SALARIES

Surya Roshni

JOBS

Avid Technology

No Jobs

write
Share an Interview
How was your last interview experience?
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent
Sorry, this job is no longer available!