Senior PL/SQL Developer

About the role

They need candidates who can offer valuable solutions to day-to-day problems during the interview and showcase solid hands-on PL/SQL development.

Must-Have Skills

• Core Oracle PL/SQL Engineering: Development of complex stored procedures, packages, database business logic, custom data types, and transactional data modeling.
• Advanced SQL Analytics & Data Manipulation: Analytical and windowing functions, complex joins, aggregation pipelines, set operators, and subquery optimization.
• Database Performance Tuning: Query optimization, reading execution plans, database diagnostics, PGA memory tuning, and partitioning strategies.

Expertise We’re Looking For

• Expertise writing Oracle SQL and PL/SQL code, performing data analysis, data modelling, designing and implementation of data APIs and performance tuning.
• Expertise writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys.
• Understanding of fundamental design principles for building a scalable application.
• Interest in writing clean, testable, readable, easily maintainable, and performant code.
• Knowledge in mid-tier technologies like Java, messaging technologies, web container and understanding how they interact with data.
• Comfortable working in an Agile software delivery environment, with exposure to continuous integration and continuous delivery tools.
• Ability to translate storyboards and use cases into applications that give Fidelity a strategic edge with critical thinking and strong problem-solving abilities.
• Understanding of CI / CD processes & tools and are passionate about delivering high-quality software.
• Providing leadership guidance, mentorship to empower team members to their optimum performance levels and career potential.

Benefits

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.