Sr. Software Engineer (SQL Server Database Engineer)

U.S. Bank•Atlanta, GA

8d•$111,605 - $131,300•Hybrid

About The Position

U.S. Bank is seeking a Senior Database Engineer to architect, optimize, and modernize enterprise SQL Server platforms supporting high-volume transactional systems. The role focuses on database performance engineering, automation, cloud integration, and scalable data architecture rather than traditional DBA administration. The engineer will own modern data architecture, data pipelines, database performance, reconciliation, and migration of legacy processing into the Azure data platform. The role requires working from a U.S. Bank location three or more days per week.

Requirements

Bachelor’s degree or equivalent work experience.
Five to six years of relevant experience.
Strong financial-services background, preferably in ETF, mutual funds, fund accounting, custody, or asset servicing, or experience in a larger organization.
Advanced SQL Server/Azure SQL and database design skills.
Experience with Azure Data Factory (ADF).
Knowledge of data warehouse architecture and dimensional/data modeling.
Experience with high-volume data processing and performance tuning.
Experience with ETL/data pipeline modernization.
Knowledge of data reconciliation, lineage, auditability, and historical data management.
Experience with Azure cloud data architecture.
Experience modernizing legacy data/SSIS workloads.
Ability to translate financial business rules into data models and pipelines.

Responsibilities

Design and develop SQL Server databases, stored procedures, functions, views, and ETL solutions.
Optimize database performance through query tuning, indexing, execution plan analysis, and workload optimization.
Troubleshoot and resolve locking, blocking, deadlocks, concurrency issues, and performance bottlenecks.
Design scalable data models and database architectures for large-scale OLTP environments.
Collaborate with application teams on database design, data access patterns, and performance best practices.
Implement modern SQL Server capabilities, including Query Store, Columnstore Indexes, CDC, Temporal Tables, and In-Memory OLTP.
Drive database automation, CI/CD deployments, and modernization initiatives using DevOps tools.
Lead production issue resolution and root cause analysis, and establish database engineering standards.
Own modern data architecture, data pipelines, database performance, reconciliation, and migration of legacy processing into the Azure data platform.

Benefits

Healthcare coverage, including medical, dental, and vision.
Basic term and optional term life insurance.
Short-term and long-term disability coverage.
Pregnancy disability and parental leave.
401(k) and employer-funded retirement plan.
Paid vacation of two to five weeks, depending on salary grade and tenure.
Up to 11 paid holiday opportunities.
Adoption assistance.
Sick and Safe Leave accruals of one hour for every 30 hours worked, up to 80 hours per calendar year unless otherwise provided by law.
Incentive and recognition programs.
Equity stock purchase and 401(k) contribution.
Pension, subject to eligibility requirements.