Senior Lead Software Engineer - Oracle Database Administrator

hackajob is collaborating with J.P. Morgan to connect them with exceptional professionals for this role.

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

Preferred qualifications, capabilities, and skills

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

ABOUT US

JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process. 

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans

ABOUT THE TEAM

J.P. Morgan's Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.