Senior SQL Server & Azure Data Engineer

U.S. Bank; Irving (TX); Hybrid; USD 112,000 - 131,000; Full time

Benefits offered by this job

Healthcare (medical, dental, vision)

401(k) and employer-funded retirement

Paid vacation

Up to 11 paid holidays

Job summary

U.S. Bank is seeking a Senior Database Engineer to architect, optimize, and modernize enterprise SQL Server platforms supporting high-volume transactional systems.

This role emphasizes database performance engineering, automation, cloud integration, and scalable data architecture rather than traditional DBAs. You will design data models for large OLTP environments, implement features like Query Store and CDC, drive CI/CD deployments, and collaborate with application teams to apply best practices

Qualifications

• Bachelor’s degree, or equivalent work experience.
• Five to six years of relevant experience.
• Strong financial-services background, preferably ETF, mutual funds, fund accounting, custody, or asset servicing, or larger organization.
• Advanced SQL Server / Azure SQL and database design.
• Azure Data Factory (ADF).
• Data warehouse architecture and dimensional/data modeling.
• High-volume data processing and performance tuning.
• ETL/data pipeline modernization.
• Data reconciliation, lineage, auditability, and historical data management.
• 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, 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, root cause analysis, and establish database engineering standards.

Skills

SQL Server / Azure SQL

Database performance

Data modeling

ETL/ELT

DevOps CI/CD

Cloud data platforms

Education

Bachelor's degree or equivalent

Tools

Azure Data Factory

SQL Server

Job description

U.S. Bank is seeking a Senior Database Engineer to architect, optimize, and modernize enterprise SQL Server platforms supporting high-volume transactional systems.

This role emphasizes database performance engineering, automation, cloud integration, and scalable data architecture rather than traditional DBAs. You will design data models for large OLTP environments, implement features like Query Store and CDC, drive CI/CD deployments, and collaborate with application teams to apply best practices