Sr. PL/SQL Database Developer

About the role

Strategic Advisors Technology (SAT) is looking for a Principal Software Engineer who has strong understanding of database technologies and experience building enterprise cloud enabled distributed systems. We are looking for individuals who continually strive to advance engineering excellence and technology innovation.

Responsibilities

• 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.

Requirements

• 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.

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.