Database Technology Lead - Oracle, PL/SQL & Legacy Modernization

About this role:

Wells Fargo is seeking a Lead Database Engineer.

In this role, you will:

• Lead complex or critical database management initiatives that typically involve multiple disciplines and business groups, including database architecture, design, integration and data modeling
• Provide the highest technical expertise for the planning, research, design implementation, maintenance, and control of server class databases
• Review and analyze complex database technologies that require in depth evaluation of multiple factors including intangibles or unprecedented factors
• Design and certify next generation database technologies
• Assist in database installations, including troubleshooting and problem resolution
• Recommend improvements to web application processing issues and design
• Consult with multiple client groups to provide strategic solutions, influencing long range internal and enterprise level database architecture and management strategies
• Provide technical leadership and recommendation into the future direction of database technology
• Collaborate and consult with peers, colleagues and managers to resolve issues and achieve goals

Required Qualifications:

• 5+ years of Database Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Desired Qualifications:

• Experience in investment performance, brokerage, wealth management, or financial-services data.
• Strong experience leading Database Engineering projects within large organizations, including significant hands-on Oracle experience.
• Experience with large data sets, transactional platforms, or a combination of both
• Knowledgeable in programming or scripting language using Oracle, PL/SQL, SQL loaders and Perl scripts.
• Strong technical and task/timeline-oriented skills necessary to ensure projects are completed in a timely and accurate manner.
• Advanced SQL and PL/SQL skills, including stored procedures, performance tuning, indexing, execution-plan analysis, and high-volume batch processing.
• Experience modernizing legacy database workloads and supporting old and new platforms concurrently.
• Working knowledge of Java, Spring Boot, or Spring Batch and the ability to collaborate effectively with application engineering teams.
• Strong knowledge of data migration, source-to-target mapping, reconciliation, parallel runs, and cutover planning.
• Experience with SQL Loader, flat-file ingestion, staging tables, and scheduled batch environments.

Job Expectations:

• Provide technical leadership for BAU operations, including nightly batch monitoring, incident triage, production recovery, root-cause analysis, and database performance tuning.
• Preserve the accuracy and precision of TWR, MWR/IRR, fee-adjusted returns, multi-period metrics, and benchmark calculations.
• Improve resilience around database upgrades, component restarts, failure recovery, and batch dependencies.
• Own schema design, staging and temporary-table strategies, indexing, query optimization, data retention, and deployment controls. 
• Establish automated controls for row counts, control totals, duplicates, missing records, financial precision, and source-to-target consistency.
• Build database observability covering job status, execution duration, row counts, reconciliation results, bottlenecks, and failures
• Review designs and code, enforce database engineering standards, mentor team members, and communicate migration risks to technical and business stakeholders.
• Lead analysis and conversion of Oracle stored procedures, PL/SQL, SQL Loader, and database-dependent Perl logic into maintainable Java or database components. 
• Strong understanding of numeric precision, transactional integrity, auditability, and controls for financial data.
• Excellent technical leadership, stakeholder communication, and troubleshooting skills.

Posting End Date: 

*Job posting may come down early due to volume of applicants.

We Value Equal Opportunity

Wells Fargo is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.

Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit’s risk appetite and all risk and compliance program requirements.

Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.

Applicants with Disabilities

To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo.

Drug and Alcohol Policy

Wells Fargo maintains a drug free workplace.  Please see our Drug and Alcohol Policy to learn more.

Wells Fargo Recruitment and Hiring Requirements:

a. Third-Party recordings are prohibited unless authorized by Wells Fargo.

b. Wells Fargo requires you to directly represent your own experiences during the recruiting and hiring process.