Senior Lead Software Engineer Oracle Database Administrator

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.

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/ANALYZEpgstat 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).