Sr. Specialist - Database Site Reliability Engineer

Charles Schwab Inc.
Southlake, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Southlake, United States of America

Tech stack

Query Performance
Microsoft Windows
Artificial Intelligence
Amazon Web Services (AWS)
Azure
Cloud Computing
Databases
ETL
Data Manipulation Languages
Data Systems
Software Debugging
Linux
Github
Python
Liquibase
Oracle Applications
Performance Tuning
Query Optimization
Reliability Engineering
Ansible
Runbook
Shell Script
Software Engineering
PL-SQL
SQL Databases
T-SQL
Datadog
Data Logging
Google Cloud Platform
Grafana
Database Performance
Information Technology
Terraform
Splunk
Appdynamics
Jenkins

Job description

The Workplace Services Engineering - Stock Plan Technology organization leads the development and maintenance of Schwab's Workplace Services platforms to server our clients equity compensation and trade monitoring needs., The Database Site Reliability Engineer (DB SRE) plays a crucial role in maintaining the performance, reliability, and availability of an organization's database systems. These professionals are responsible for ensuring that data remains accessible and secure, which is vital for supporting the business's operational goals. Through the optimization of database performance and the implementation of best practices, DB SREs help enhance the efficiency of daily operations, reduce downtime, and ultimately contribute to higher customer satisfaction and business growth.

  • Performance Tuning: Optimizing query performance, indexing, schema design, and storage engines, particularly in large-scale systems.
  • Collaboration: Working closely with software engineers to review database migrations, optimize queries, and integrate databases into application workflows.
  • Data Quality & Governance: Define rules, write validation tests, and ensure the integrity and quality of data.
  • Automation: Use languages such as Python, Go, and Shell, and use tools like SALT and Ansible to automate operational tasks and minimize manual intervention.
  • Monitoring & Observability: Implement monitoring, alerting, and logging solutions to maintain database health and ensure that Service Level Objectives (SLOs) are consistently met.
  • Incident Response: Support and debug database production issues across various services and stack layers. They participate in on-call rotations and lead root cause analysis (RCA) for database incidents.
  • Collaboration with Peer SREs: Work closely with performance engineering teams to define, optimize, and govern Oracle data loading and DML scripting standards, with a strong focus on high volume, large table operations and database performance.
  • Performance Engineering: Collaborate with performance engineers to establish and maintain loading procedures for Oracle-based data systems.
  • Runbook Management: They develop and maintain runbooks to guide the maintenance and troubleshooting of database systems.

Requirements

  • Bachelor's in Computer Science, Software Engineering, or related technical field.
  • At least 5+ years of experience as an Application DBA and/or Database Developer.
  • Advanced skills in PL/SQL and T-SQL, with a strong understanding of schema design, query optimization, and performance tuning.
  • Proficiency in automating operational tasks using Python or Shell Script, and experience with tools such as Github, Liquibase, Jenkins, Terraform, and SALT.
  • Demonstrated experience optimizing complex SQL queries in high-volume or performance-sensitive environments.
  • Experience working with Windows and Linux systems, networking fundamentals, and troubleshooting systems issues.
  • Familiarity with logging and observability tools, including SPLUNK, OEM, Grafana, AppDynamics, Datadog, and SQL Developer.
  • Experience with data refreshes and scrubbing procedures.
  • Understanding of site reliability engineering (SRE) principles, including reliability, scalability, and operational excellence.

Preferred Qualifications

  • Experience supporting 24/7 production environments and participating in on-call rotations.
  • Experience with Cloud Platforms like PCF, GCP, AWS, Azure.
  • Experience with Gen AI tools- Github Copilot or equivalent.

Benefits & conditions

We offer a competitive benefits package that takes care of the whole you - both today and in the future:

  • 401(k) with company match and Employee stock purchase plan
  • Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions
  • Paid parental leave and family building benefits
  • Tuition reimbursement
  • Health, dental, and vision insurance

What's in it for you:

At Schwab, we're committed to empowering our employees' personal and professional success. Our purpose-driven, supportive culture, and focus on your development means you'll get the tools you need to make a positive difference in the finance industry. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.

We offer a competitive benefits package that takes care of the whole you - both today and in the future:

401(k) with company match and Employee stock purchase plan

Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions

Paid parental leave and family building benefits

Tuition reimbursement

Health, dental, and vision insurance

About the company

At Schwab, you're empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us "challenge the status quo" and transform the finance industry together. Schwab Technology Services enables the future of how clients manage their money by providing innovative and reliable technology products and services as part of our ongoing commitment to democratize access to investing and financial planning. Workplace Service Engineering is an organization within Schwab Technology Services that delivers modern, stable, and high-performing digital platforms supporting a massive participant base and managing hundreds of billions in assets for industry leaders., At Schwab, you're empowered to shape your future. We champion your growth through meaningful work, continuous learning, and a culture of trust and collaboration-so you can build the skills to make a lasting impact. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.

Apply for this position