Senior Lead Software Engineer - Oracle Database Administrator

JPMorganChase•Jersey City, NJ

About The Position

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 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.

Requirements

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 an Oracle DBA, including: Oracle RAC administration (Clusterware; ASM) Backup and recovery (e.g., RMAN ), patching, upgrades, and performance tuning (e.g., AWR/ASH)
Strong PL/SQL development capability (beyond administration), including performance-oriented design and refactoring.
Hands-on PostgreSQL administration experience, including operational maintenance and recovery.
Proven expertise in Oracle performance tuning , including RAC-specific considerations (e.g., service placement, interconnect behavior, global cache waits, node/load distribution).
Working knowledge of PostgreSQL performance tuning , including planner behavior, indexing, vacuum/analyze strategy, and connection management.
Strong SQL skills and experience with data validation and reconciliation techniques.
Demonstrated delivery of data migrations (e.g., Oracle-to-Oracle, Oracle-to-PostgreSQL, and/or platform modernization).

Nice To Haves

Loan IQ production 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 with ITIL processes (incident, change, problem management).

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.