Walk-in | PLSQL Developer

FPT Software; Hyderabad; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

FPT Software in Hyderabad is seeking an Oracle SQL/PLSQL Developer for production support with 3 to 10 years of experience. You will develop procedures, functions, triggers, and packages, and optimize SQL performance.

Requirements include ITIL-based incident management, familiarity with monitoring tools, and Unix scripting for automation. AWS cloud experience is a plus; a Bachelor’s degree in CS or IT is required.

Qualifications

• 3+ years of experience in production support or IT operations.
• Bachelor degree in Computer Science, Information Technology, or related field.
• Strong troubleshooting and analytical skills for enterprise applications.
• ITIL framework knowledge and incident management experience.
• Experience with monitoring tools (Splunk, Dynatrace, AppDynamics).
• Proficiency with ticketing systems (JIRA).
• Experience with AWS cloud services.
• SQL skills for database troubleshooting and data validation.
• Scripting experience (Unix, Shell) for automation.

Responsibilities

• Provide production support for Oracle databases and enterprise applications.
• Develop and maintain Oracle SQL/PLSQL objects (procedures, functions, triggers, packages).
• Optimize queries, plans, and indexes for performance.
• Handle incident management and operational dashboards.

Skills

Oracle SQL

PL/SQL

Bulk Collect

Dynamic SQL

Troubleshooting

Automation

Unix scripting

Performance tuning

Education

Bachelor's degree in CS/IT

Tools

SQL*Plus

SQL Developer

Splunk

Dynatrace

AppDynamics

JIRA

AWS

Job description

• Please come if you are having less than 30days Notice Period.
• Having experience in Oracle SQL & PLSQL Development with minimum 3 to 10 years of experience.
• Experience in developing Procedures, Functions, Triggers, Cursors and Packages.
• Experience in using advanced features like BULKCOLLECT, FORALL and Ref cursors.
• Good exposure to SQL queries and handling Exceptions in PLSQL.
• Good exposure to writing dynamic functions, procedures and packages.
• Worked with Tools like SQL*Plus and SQL Developer.
• Expertise in Dynamic SQL, Collections, cursors, Exception handling.
• Experience in stored procedures, functions and packages as per the business Requirement. Loaded external files Data into Oracle Tables using SQL Loader.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and optimize procedures and packages.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Development experience of materialized views for data replication in distributed environments.
• Good to have: Knowledge Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management.

Qualifications:

• 3+ years of experience in production support or IT operations.
• College degree (Bachelor) in Computer Science, Information Technology, or related field.
• Strong troubleshooting and analytical skills for enterprise applications.
• ITIL framework knowledge and incident management experience.
• Experience with monitoring tools (Splunk, Dynatrace, AppDynamics).
• Proficiency with ticketing systems ( JIRA).
• Experience with AWS cloud services.
• SQL skills for database troubleshooting and data validation.
• Scripting experience (Unix, Shell) for automation.