Project Role : Custom Software Engineer
Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills : Microsoft SQL Server
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
Summary
Experienced Oracle PL,SQL Lead, Developer with expertise in designing, developing, optimizing, and supporting enterprise database applications using Oracle SQL and PL-SQL. Responsible for delivering scalable, high-performance solutions, supporting production environments, and collaborating with cross-functional teams to meet business objectives.
Roles & Responsibilities
Design, develop, test, and maintain Oracle database applications using SQL and PL-SQL.
Develop and support Packages, Procedures, Functions, Triggers, Views, and Materialized Views.
Analyze business requirements and translate them into technical solutions.
Optimize SQL queries and perform database performance tuning.
Troubleshoot application and database issues, conduct root cause analysis, and support production incidents.
Participate in code reviews, testing, deployments, and release activities.
Collaborate with business analysts, architects, and cross-functional teams.
Prepare and maintain technical documentation.
For Lead roles: Provide technical guidance, mentor team members, and ensure adherence to development standards and best practices.
Must Have Skills
Strong expertise in Oracle SQL and PL-SQL
Experience with Packages, Procedures, Functions, Triggers, Views, and Materialized Views
SQL Query Optimization and Performance Tuning
Database Design and Data Modeling Concepts
Exception Handling and Troubleshooting
Oracle Database Fundamentals
Production Support and Incident Management
Agile/Scrum Methodology
Version Control Tools (Git, Azure DevOps, Bitbucket)
Good to Have Skills
ETL-Data Migration Experience
Shell Scripting (Unix/Linux)
CI/CD and DevOps Practices
AWS/Azure Cloud Exposure
Autosys / Control-M Scheduling Tools
Jira and Azure DevOps
Additional Information
Experience: 3–8 Years
Preferred: Exposure to Banking, Financial Services, or Data Processing applications.
15 years full time education
