Your opportunityAt 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.Stock Plan Services focuses on supporting equity compensation for our B2B clients. We have multiple applications that support this effort, and our mission is to launch a consolidated platform of microsites to combine these segregated applications into a holistic user experience. While executing this goal we strive to maintain excellent customer support and deliver on sustaining engineering objectives. We are fueled by a diverse team of talented team-members who continuously raise the bar on delivering best-in-class products and services to people all over the world.Essential Functions:
Analyze complex T-SQL and PL/SQL code to gain insight on performance improvement opportunities
Design and implement data models for scalable and performance solutions with large data volumes
Use Oracle Data Integrator to manage and maintain data integrations between interconnect databases
Identify & address application data issues that affect application integrity
Ensure that the database design fulfills functional & technical requirements, including design-for-performance
Develop, analyze, and maintain technical documentation for database patterns, common used functions, and other critical areas of the databases
Work effectively with Technical leads, Architects and Database Developers to create and maintain the overall data architecture, priorities, and success measures for the enterprise
Review the deliverables throughout development to ensure quality & traceability to requirements and adherence to all quality management plans & standards
What you haveRequired Qualifications:
7+ years in a developing, modeling, and deploying enterprise solutions with Oracle database focus
5+ years of experience with ODI and OBIEE
5+ years of experience with data modeling, ETL design and ETL tools
5+ years of experience with PL/SQL programming, including creating packages, functions, stored procedures and views
5+ years of experience writing and deciphering complex SQL queries
5+ years of experience with Unix/Shell scripting
Experience with Linux/Unix operating system
Experience with creating a scalable and performing solution with large data volumes in the Oracle DB
Experience with complex data models
Experience using Oracle Data Visualizer
What’s in it for youAt 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
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 planPaid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positionsPaid parental leave and family building benefitsTuition reimbursementHealth, dental, and vision insuranceSchwab is an affirmative action employer, focused on employing and advancing in employment, qualified women, racial and ethnic minorities, protected veterans, and individuals with disabilities in the workplace. If you have a disability and require reasonable accommodations in the application process, contact Human Resources at applicantaccessibility@schwab.com or call 800-275-1281.