Software Engineer II

94-1687665 Bank of America, National Association; Kennesaw (GA); On-site; USD 140,000 - 180,000; Full time

Job summary

Bank of America, National Association is seeking an SQL Database Feature Lead to drive database performance, reliability, and operational excellence across Oracle 12c+ environments. You will provide technical leadership in query troubleshooting and tuning, mentor teammates, and translate complex concepts into clear, business-friendly language.

You will implement CI/CD practices, participate in story refinement, and lead efforts to optimize JSON/XML data structures, AWR reports, and day-to-day

Qualifications

• Experience with PL/SQL and Oracle 12c+
• Knowledge of XML/JSON database structures
• Strong SQL performance tuning in Oracle environments

Responsibilities

• Lead SQL performance tuning and troubleshooting in Oracle 12c+
• Mentor team members and collaborate across stakeholders
• Contribute to CI/CD and Agile/Waterfall processes
• Analyze AWR reports and identify remediation actions
• Utilize TOAD and OEM for day-to-day DB development and operations
• Produce executive-ready updates and documentation

Skills

Application Development

Automation

Collaboration

DevOps Practices

Solution Design

Agile Practices

Architecture

Result Orientation

Solution Delivery Process

User Experience Design

Analytical Thinking

Data Management

Risk Management

Technical Strategy Development

Test Engineering

Tools

TOAD 12.x

Oracle Enterprise Manager (OEM)

Job description

Position Summary

The SQL Database Feature Lead is responsible for leading database performance, reliability, and operational excellence across Oracle environments (12c and above). This role provides technical leadership in query troubleshooting and tuning, mentors team members, and serves as a key bridge between technical and business stakeholders by translating complex database concepts into clear, actionable language.

Responsibilities

• Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements
• Utilizes multiple architectural components (across data, application, business) in design and development of client requirements
• Performs Continuous Integration and Continuous Development (CI-CD) activities
• Contributes to story refinement and definition of requirements
• Participates in estimating work necessary to realize a story/requirement through the delivery lifecycle
• Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause
• Performs spike/proof of concept as necessary to mitigate risk or implement new ideas
• Leads troubleshooting and performance tuning of complex SQL queries in Oracle 12c or higher environments
• Uses Toad 12.x or higher to analyze, optimize, and support day‑to‑day database development and operations
• Queries and validates JSON and XML database structures to support application and reporting requirements
• Monitors and manages Oracle database health using Oracle Enterprise Manager (OEM)
• Reads, interprets, and explains AWR reports to identify bottlenecks and recommend remediation actions
• Communicates technical findings and database strategies in business‑friendly terms for non‑technical stakeholders
• Provides strong leadership, mentoring, and cross‑functional collaboration across varied levels of influence
• Produces clear, high‑quality written documentation, recommendations, and executive‑ready updates

Required Qualifications

• Payments or Banking background is highly preferred
• Ability to learn quickly and adapt to team environment
• Experience working in Agile or Waterfall methodology and understanding of various phases of the Software Development Life Cycle
• Experience developing packages and stored procedures using PL/SQL
• Experience querying XML/JSON database structures
• Experience and proficient knowledge of how to troubleshoot and performance tune queries
• Experience working with Toad 12.x or higher

Desired Qualifications

• Database Administration experience
• Experience developing with JDK for PL/SQL, Java, Oracle Stored procedures
• Knowledge and awareness of other non‑Oracle DBMS technologies

Skills

• Application Development
• Automation
• Collaboration
• DevOps Practices
• Solution Design
• Agile Practices
• Architecture
• Result Orientation
• Solution Delivery Process
• User Experience Design
• Analytical Thinking
• Data Management
• Risk Management
• Technical Strategy Development
• Test Engineering

Shift: 1st shift (United States of America)

Hours Per Week: 40

Privacy Statement: https://careers.bankofamerica.com/en-us/privacy-notice