Applications Developer 4

1. About the Team

We are part of a global software engineering organization focused on building highly scalable, data-intensive, enterprise-grade platforms that power critical business processes for customers worldwide. Our team specializes in database-driven architectures, performance engineering, and cloud-enabled solutions, working closely with cross-functional stakeholders to deliver secure, reliable, and high-performance products. Technical depth, ownership, and customer focus are central to our culture.

2. Job Summary

As a Senior Software Engineer - PL/SQL & Oracle Technologies, you will play a critical role in designing, developing, and optimizing complex database-centric applications. You will work on non-routine and highly complex problems involving advanced Oracle database design, PL/SQL development, and performance tuning. This role requires deep expertise in Oracle technologies, strong analytical skills, and the ability to lead technically while collaborating with global engineering and QA teams.

3. Key Responsibilities

• Analyze external customer specifications and translate them into robust database and application designs.
• Design, develop, and enhance complex PL/SQL packages, procedures, functions, and triggers supporting enterprise applications.
• Perform advanced Oracle database performance tuning, including query optimization and resource management.
• Troubleshoot and resolve complex issues related to databases, applications, and integrations.
• Build and execute unit tests and contribute to integration and regression test planning and reviews.
• Collaborate with QA, porting engineering, and other stakeholders to ensure data integrity, performance, and quality.
• Support cloud-based and microservices-enabled architectures through efficient database design and integration.
• Act as a technical leader by mentoring team members and promoting best practices in database engineering.

• Hands on experience on building highly scalable enterprise grade application with built in high availability and disaster recovery.

• Work with cross-functional team members from Architecture, Product Strategy & Development, QA, Sales & Services, and other Central teams to architect and design multiple products

• Excellent in technical design, internally recognized as highly competent in technical areas, will review and participate in product architecture and design

• Passionate for continuous learning, experimenting and applying cutting edge technology and software paradigms

• Deeper understanding of design principles and methods, technology and standards, actively stay abreast of trends and standards, recommend best practices and share learning

• Troubleshoot defects and provide recommended solutions to optimize existing application

• In this role, you'll leverage your knowledge of Oracle database development and be instrumental in the successful implementation of our browser-based, enterprise software product.

4. Qualifications & Skills

Mandatory

• BE / MS in Engineering, Computer Science, or equivalent practical experience.
• 8+ years of hands-on experience in PL/SQL and Oracle Database development for enterprise applications.
• Strong expertise in PL/SQL programming, including complex packages, cursors, collections, and performance tuning.
• In-depth knowledge of Oracle database internals, including indexing strategies, optimizer behavior, partitioning, redo/undo management, and memory tuning.
• Hands-on experience analyzing and interpreting AWR, ADDM, ASH, SQL Trace, TKPROF, and AWR reports.
• Strong understanding of database performance optimization, explain plans, and SQL tuning techniques.
• Must have experience in working in RAC and EXADATA.
• Experience working with Fusion Middleware and WebLogic Server in database-backed enterprise systems.
• Exposure to application-layer technologies such as Java/J2EE, Javascript and REST/SOAP services for integration purposes.
• Exposure to Database design for cloud solutions.
• Experience executing test cases manually and using automated tools to ensure data accuracy and system reliability.

As a Senior Software Engineer - PL/SQL & Oracle Technologies, you will play a critical role in designing, developing, and optimizing complex database-centric applications. You will work on non-routine and highly complex problems involving advanced Oracle database design, PL/SQL development, and performance tuning. This role requires deep expertise in Oracle technologies, strong analytical skills, and the ability to lead technically while collaborating with global engineering and QA teams.

Career Level - IC4