
Sr Specialist - Database Developer
Charles Schwab23 hours ago
Responsibilities
- Build scalable database platforms supporting critical workplace applications and millions of retirement plan participants.
- Develop and optimize SQL Server databases, T-SQL code, stored procedures, functions, views, triggers, and SSIS ETL/ELT processes.
- Support API and foundational system modernization, legacy-to-modern migrations, cross-database migrations, and reusable data-processing modules.
- Improve platform stability, performance, resilience, observability, reliability, and operational efficiency.
- Perform data mapping, transformation, validation, reconciliation, data-quality improvement, and production support.
- Design and optimize relational database structures, schemas, indexes, execution plans, and enterprise data warehouse workloads.
- Use AI-assisted development tools and custom MCP servers to improve data engineering workflows.
- Collaborate with product management, developers, architects, DBAs, and data engineering teams while mentoring teammates and influencing technical decisions.
Requirements
- At least 6 years of hands-on experience as a SQL Server Database Developer in enterprise-scale environments, including SSIS ETL/ELT, bulk data loads, batch processing, and T-SQL.
- At least 1 year of experience with financial services data processing and database structures supporting enterprise data warehouses, analytics, reporting, and BI workloads.
- Expert-level T-SQL and SQL Server development experience, including complex stored procedures, functions, views, and triggers.
- Experience with cloud database products such as Azure SQL or Google BigQuery for data ingestion, cloud migration, pipeline development, data processing, and analytics.
- Experience with data migration, data modeling, relational database design, normalization, schema optimization, query performance tuning, indexing, execution plans, and SQL Server internals.
- Strong understanding of data quality, production support, transactions, isolation levels, locking, concurrency, and error handling.
- Experience using AI-assisted development tools such as GitHub Copilot and Claude, including custom Model Context Protocol servers.
- Familiarity with version control, database deployment, code review, and Scrum-based software delivery.
- Strong technical and business communication skills, collaboration skills, mentoring ability, and capacity to influence across organizational levels.
- BA or BS degree in Computer Science or equivalent.
Benefits
- The role is expected to be performed on site in the specified location.
- The position is eligible for bonus or incentive opportunities.
Tech Stack
Google BigQueryMicrosoft SQL Server
Categories
Data Engineering
About Charles Schwab
Charles Schwab provides brokerage, banking, and wealth management services for individual investors and independent investment advisors. Its business spans trading platforms, advisory and custody services (Schwab Advisor Services), ETFs and mutual funds, and a U.S. bank offering deposits and lending. Founded in 1971 and headquartered in Westlake, Texas, Schwab is publicly traded on the NYSE (SCHW) and expanded its retail and advisor footprint through the acquisition of TD Ameritrade.