Database Technology Lead Oracle, PLSQL & 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 ofOracle stored procedures PL/SQL SQL Loader and database-dependent Perl logicinto 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 units 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 visitDisability 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.