at J.P. Morgan
Bulge Bracket Investment BanksPosted 3 days ago
No clicks
**Senior Lead Software Engineer - Oracle Database Administrator** - **Manage** Oracle RAC, optimize PL/SQL, and PostgreSQL, migrate data, and troubleshoot at senior level. - **Administrate** Oracle databases (production, non-production) and PostgreSQL; **design**, develop, and optimize PL/SQL/SQL structures. - Senior role requires 5+ years software engineering experience, Oracle/Python scripting, and cross-functional team collaboration. - **Experience** needed: Oracle/PostgreSQL administration,ogén% patching/upgrades, performance tuning, with expertise in Oracle RAC, data migration, and SQL validation. - **Support** incident/problem management, implement backup/recovery strategies, and define performance baselines. - Preferred experience with Loan IQ, migration tools, scripting, and ITIL processes; knowledge of Linux/Unix and storage concepts. - **Lead** software engineering teams to enhance, design, and deliver stable, secure tech products within JPMorgan Chase's Wholesale Loan Technology.
- Compensation
- Not specified
- City
- Jersey City
- Country
- United States
Currency: Not specified
Full Job Description
Location: Jersey City, NJ, United States
Youre 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 firms 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.
- 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.
- 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).
- 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).
