Senior Oracle PL/SQL Developer

Title: Senior Oracle PL/SQL Developer


Client: Fidelity


Location: Hybrid- Westlake TX


Duration: 6+ Months


Visa: Any Visa but H1B should be on 3B bench


Experience: 7+ Years


Rate: $60-65/hr. C2C


Note:


There will be ROPES Assessment before Interview.

• Candidate can interview on video but they must relocate to Westlake TX within 60 days.
• Please confirm with the candidate that they have not applied or been presented to Fidelity for contract roles through any vendors in the last 6 months.
• Team needs to hire 3 more candidates by Friday 9.11 that are local or ready to sit onsite in Westlake TX

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.


Job Responsibilities
• Expertise writing Oracle SQL and PLSQL 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
• Experience following ATDD (acceptance test driven development) and writing automated tests for database code.
• Experience with cloud technologies is a bonus: Snowflake, S3
• 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 Client 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.


The Expertise We're Looking For
• Expertise writing Oracle SQL and PLSQL 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.