Sr. Specialist - Database Site Reliability Engineer

Pay range: USD $115,000.00 - $139,000.00 / Year

Your opportunity

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.

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.

• 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.

• 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.

• 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