Oracle PL/SQL Developer

Skills

Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data application business in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Contributes to existing test suites (integration regression performance); Analyzes test reports identifies any test issues/errors; Triages the underlying cause. Documents and communicates required information for deployment maintenance support. and business functionality

Description

The Global Markets Business Finance Office team within Finance Technology consists of extremely talented engineers, who develop industry leading financial management platforms that provide solutions to subledger application for traded products like Derivatives, Securities etc. globally. The candidate would perform development using Oracle as backend and some basic front end on Net and browser-based platforms to develop and deliver complex software requirements to accomplish business goals and ensure software is developed to meet functional, non-functional, and compliance requirements.

Responsibilities

• Strong knowledge in Oracle database Design, Query and tuning.
• Strong foundation understanding of database concepts and development technologies.
• Extensive SQL and PL/sQL experience required,
• Experience designing tables, data analysis, writing queries (SOL and PL/sOL), performance tuning, and table partitions.
• Authority on Oracle PL/SQL development and Oracle Performance tuning.
• Proficiency with Unix/Linux Shell scripting (Korn Shell (KSH), BASH, etc.).
• Must have strong PL/SQL skills and must be proficient with Oracle; T-SQL/SQL Server skills are nice to have.
• Strong knowledge of triggers, stored procedures, third party tools, and transaction monitoring.
• SQL Tuning (within Oracle applications), SOL traces, SQLLDR Oracle Application utilities.
• Tune/Optimize overall database and specific database objects performances.
• Design, implement and maintain data loading scripts/programs.
• Confer with co-workers to determine impact of database changes on other systems in a production environment.
• Troubleshoot/Resolve any database issues.
• Design, implement and maintain date loading scripts/ programs.
• Tune/ Optimize overall database and specific database objects performances, Experience in web based Net software application development is a plus.
• Experience With DevOps CV/CD tools like Jenkins, Ansible, GitHub, Bitbucket Able to work individually or with a team and take End-to-End ownership of tasks.
• Strong analytical, innovative, independent thinker and problem solver Some ETL Development, primarily in Python.
• Demonstrated Experience in Data Warehouse implementations in a technical SME capacity.
• Excellent problem solving and troubleshooting skills, coupled with a desire to take on responsibilities.

Educational Requirements

• • Takes pride and ownership in their working
• • Be passionate about quality, programming, and software development in general.
• • Hands-on experience in database development with efficient sOL, performance tuning and debugging skills.
• • Good understanding of performance tuning and debugging/Problem-solving skills.
• • Working knowledge on Agile Scrum/ Kanban process as a Team developer.
• • Knowledge of Finance and Global Markets products - Derivatives, Securities, SET is a plus.
• • Bachelor's degree in computer science, Computer Engineering, or a closely related field.
• • Track record of being detalled oriented, self-starter and deliverables with minimal defects.
• • Must be able to quickly grasp complex concepts and learn new technologies.
• • Ability to work well independently with minimal direction and together as a member of cross-functional teams.
• • Must be solutions-oriented and a critical thinker.
• * Strong analytical and problem-solving skills.
• • Ability to effectively manage multiple, competing, high-priority projects with varying deadlines