Database Technology Lead - Oracle, PL/SQL & Legacy Modernization
Wells Fargo18 hours ago
Bengaluru, IndiaStaff+
Responsibilities
- Lead complex database management initiatives involving architecture, design, integration, data modeling, and multiple business groups.
- Plan, research, design, implement, maintain, and control server-class database technologies.
- Provide technical leadership for database operations, including nightly batch monitoring, incident triage, production recovery, root-cause analysis, and performance tuning.
- Own schema design, staging and temporary-table strategies, indexing, query optimization, data retention, deployment controls, and database observability.
- Establish automated controls for row counts, control totals, duplicates, missing records, financial precision, and source-to-target consistency.
- Modernize legacy workloads by converting Oracle stored procedures, PL/SQL, SQL Loader, and database-dependent Perl logic into maintainable Java or database components.
- Lead data migration activities including source-to-target mapping, reconciliation, parallel runs, and cutover planning.
- Review designs and code, enforce database engineering standards, mentor team members, and communicate migration risks.
- Preserve accuracy and precision for TWR, MWR/IRR, fee-adjusted returns, multi-period metrics, and benchmark calculations.
- Improve resilience around database upgrades, component restarts, failure recovery, and batch dependencies.
Requirements
- At least 5 years of database engineering experience, or equivalent demonstrated through work experience, training, military experience, or education.
- Strong hands-on Oracle experience and experience leading database engineering projects in large organizations.
- Knowledge of Oracle, PL/SQL, SQL Loader, and Perl scripting.
- Advanced SQL and PL/SQL skills, including stored procedures, performance tuning, indexing, execution-plan analysis, and high-volume batch processing.
- Experience with large data sets, transactional platforms, or both.
- 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 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.
- Strong understanding of numeric precision, transactional integrity, auditability, and controls for financial data.
- Experience in investment performance, brokerage, wealth management, or financial-services data is desired.
- Strong technical leadership, task and timeline management, stakeholder communication, and troubleshooting skills are desired.
About Wells Fargo
Wells Fargo & Company is a U.S.-based financial services firm providing consumer and commercial banking, mortgages, credit, and wealth/investment services to individuals, small businesses, and enterprises. It earns revenue from interest income and fees across retail banking, payments, lending, and capital markets. Founded in 1852 and headquartered in San Francisco, it is publicly traded on the NYSE (WFC) and operates nationally with offices in multiple countries.