Software Engineer III- PL/SQL Developer
JPMorganChase
Job Description:
You’re ready to gain the skills and experience needed to grow within your role and advance your career — and we have the perfect software engineering opportunity for you.
As a Software Engineer III at JPMorgan Chase within the Enterprise Technology Data Protection & Recovery product line, you will be an essential member of an agile team dedicated to enhancing, building, and delivering trusted, market-leading technology products in a secure, stable, and scalable manner. As an emerging member of a software engineering team, you execute software solutions through the design, development, and technical troubleshooting of multiple components within a technical product, application, or system, while gaining the skills and experience needed to grow within your role.
- Execute standard software solutions covering design, development, and technical troubleshooting.
- Write secure, high-quality code in at least one programming language with limited guidance.
- Design, develop, code, and troubleshoot with awareness of upstream/downstream systems and technical implications.
- Apply technical troubleshooting to break down solutions and resolve problems of basic complexity.
- Gather, analyze, and synthesize insights from large, diverse data sets to identify issues and inform secure, stable application development.
- Focus on control, stability, resiliency, capacity, and performance.
- Maintain awareness of risks and vulnerabilities, and apply effective mitigation strategies.
- Ensure robust code delivery with a drive toward zero post‑implementation issues.
- Participate in strategic planning and long‑term decisions with product and engineering leads.
- Plan, manage, and implement unit, SIT, and UAT testing.
- Promote and implement best practices, perform code reviews, and drive quality improvements.
Required qualifications, capabilities, and skills
Formal training or certification on software engineering concepts and 3+ years applied experience
- Demonstrate practical experience in system design, application development, testing, and operational stability.
- Develop Oracle Database and PL/SQL solutions (functions, stored procedures, materialized views) and automate jobs with DBMS_SCHEDULER across Oracle environments.
- Architect enterprise data platforms spanning logical/physical data modeling, ETL orchestration, real‑time analytics reporting, and performance optimization across hybrid on‑premises and cloud infrastructures.
- Build advanced ETL pipelines integrating high‑volume data from structured sources (Oracle, SQL Server), semi‑structured formats (JSON, XML), file‑based inputs (Excel, CSV, flat files), and real‑time feeds (REST APIs, web services, SharePoint).
- Optimize database performance via strategic indexing, query plan analysis, stored procedure refactoring, result set caching, and dynamic SQL tuning.
- Implement database DevOps by version‑controlling DDL/DML scripts in GitHub and running automated deployment pipelines for consistent schema management.
- Practice agile methodologies including CI/CD, application resiliency, and secure development practices.
- Provide Level 2/3 production support for critical applications and data platforms.
- Deliver across the full SDLC by developing, debugging, and maintaining code in large corporate environments; solve complex, large‑scale problems end‑to‑end; communicate clearly; and build stakeholder relationships.
Preferred qualifications, capabilities, and skills
- Mentor teammates and contribute to knowledge sharing across engineering and data platform practices.
- Automate testing and quality gates across unit, SIT, and UAT to improve release reliability.
- Lead code reviews and drive continuous improvement in coding standards and performance.
- Collaborate with product and engineering leads to shape long‑term technical strategy and roadmap.
Design and deliver market-leading technology products in a secure and scalable way as a seasoned member of an agile team