Job description

Must Have Technical/Functional Skills • Strong hands-on experience in Oracle SQL and PL/SQL development. • Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries. • Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting. • Experience working with large-volume transactional databases and complex data structures. • Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects. • Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL. • Ability to analyze business requirements and translate them into technical/database solutions. • Experience with Unix/Linux and Shell Scripting. • Familiarity with Git, JIRA, and Agile development methodologies. • Experience in Banking, Financial Services, or Capital Markets is preferred. • Strong analytical, debugging, and problem-solving skills. Roles & Responsibilities Design, develop, test, and maintain complex Oracle SQL and PL/SQL components. Develop and enhance procedures, packages, functions, triggers, views, and database scripts. Analyze and optimize complex SQL queries to improve application and database performance. Perform query tuning, execution-plan analysis, indexing, and database performance optimization. Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions. Support data extraction, transformation, validation, reconciliation, and migration activities. Troubleshoot application/database issues and perform root-cause analysis. Support UAT, production deployments, release activities, and post-production validation. Participate in code reviews and ensure adherence to database development standards and best practices. Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures. Track development activities, defects, and deliverables through JIRA. Salary Range: $90,000 to $115,000 per year

Requirements

Must-haves

Must Have Technical/Functional Skills
Strong hands-on experience in Oracle SQL and PL/SQL development.
Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries.
Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting.
Experience working with large-volume transactional databases and complex data structures.
Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL.
Ability to analyze business requirements and translate them into technical/database solutions.
Experience with Unix/Linux and Shell Scripting.
Familiarity with Git, JIRA, and Agile development methodologies.
Strong analytical, debugging, and problem-solving skills.
Roles & Responsibilities
Design, develop, test, and maintain complex Oracle SQL and PL/SQL components.
Develop and enhance procedures, packages, functions, triggers, views, and database scripts.
Analyze and optimize complex SQL queries to improve application and database performance.
Perform query tuning, execution-plan analysis, indexing, and database performance optimization.
Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions.
Support data extraction, transformation, validation, reconciliation, and migration activities.
Troubleshoot application/database issues and perform root-cause analysis.
Support UAT, production deployments, release activities, and post-production validation.
Participate in code reviews and ensure adherence to database development standards and best practices.
Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures.
Track development activities, defects, and deliverables through JIRA.

Nice-to-haves

Experience in Banking, Financial Services, or Capital Markets is preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqljiraagile

Platform: careers-page
Effort: medium