As a Senior Lead Software Engineer at JPMorgan Chase within the Commercial and Investment Banking -Wholesale Loan Technology, you are part of an agile team that works to enhance, design, and deliver the software components of the firm’s state-of-the-art technology products in a secure, stable, and scalable way. 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.

Job responsibilities

• Administer and support Oracle databases in production and non-production environments, including Oracle RAC operations and coordination of patching/upgrades.
• Manage Oracle RAC availability and performance (clusterware/services, failover readiness, workload distribution).
• Provide DBA support for PostgreSQL (routine maintenance, backup/restore, replication/HA concepts).
• Develop and maintain PL/SQL objects (packages, procedures, functions, triggers) and optimize SQL/PLSQL performance.
• Plan and execute data migration activities, including validation/reconciliation, cutover, and rollback planning.
• Lead performance tuning for Oracle RAC and PostgreSQL (query optimization, indexing, statistics management).
• Perform deep-dive diagnostics using Oracle tools (AWR/ASH, ADDM, SQL Monitor, Explain Plan) and PostgreSQL tools (EXPLAIN/ANALYZE,pg_stat, VACUUM/autovacuum).
• Identify and remediate bottlenecks across database, OS, storage, and network layers via configuration and schema/index changes.
• Define and maintain performance baselines, monitoring/alert thresholds, and capacity forecasts; produce periodic health reports.
• Implement and maintain backup/recovery strategies, HA/DR readiness, and operational runbooks.
• Support incident/problem management and collaborate with application, infrastructure, and release/change teams to deliver stable deployments and secure operations.

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 5+ years applied experience
• Hands-on practical experience delivering system design, application development, testing, and operational stability
• Demonstrated hands-on experience as anOracle DBA, including:
• Oracle RACadministration (Clusterware; ASM)
• Backup and recovery (e.g.,RMAN), patching, upgrades, and performance tuning (e.g., AWR/ASH)
• StrongPL/SQL developmentcapability (beyond administration), including performance-oriented design and refactoring.
• Hands-onPostgreSQL administrationexperience, including operational maintenance and recovery.
• Proven expertise inOracle performance tuning, including RAC-specific considerations (e.g., service placement, interconnect behavior, global cache waits, node/load distribution).
• Working knowledge ofPostgreSQL performance tuning, including planner behavior, indexing, vacuum/analyze strategy, and connection management.
• Strong SQL skills and experience withdata validation and reconciliationtechniques.
• Demonstrated delivery ofdata migrations(e.g., Oracle-to-Oracle, Oracle-to-PostgreSQL, and/or platform modernization).

Preferred qualifications, capabilities, and skills

• Loan IQproduction support or implementation experience (schema familiarity, batch interfaces, upgrades/migrations).
• Experience with migration and replication tooling (e.g., GoldenGate, Data Pump, logical replication, ETL tools) and cutover coordination.
• Scripting/automation skills (e.g., Shell, Python) and exposure to monitoring/observability tooling.
• Knowledge of Linux/Unix operating systems and storage concepts.
• Familiarity withITILprocesses (incident, change, problem management).