Charles Schwab has been a leader in financial services for nearly four decades, working to make investing more affordable, accessible and understandable to all. Driven by our purpose to champion every client’s goals with passion and integrity, we’re committed to providing an environment that respects and appreciates the diversity of our employees, our clients, and the communities we serve. Our goal, as seen through clients' eyes, is that Schwab continuously improves on being a premier financial service provider through best in class service, technology, products, people and advice.
Organizational Objective/Purpose:
The AMTDE Technology Team, part of the CTS (Client &Trading Solutions) organization supports both internal and external facing web portals (B2B) in support of various business partners including the Managed Accounts, Alternative Investments, Insurance & Annuities, Clearing, CSTOA and Mutual Funds business. The AMTDE Technology Team utilizes a Microsoft SQL Server & Oracle environment to support both internally developed and 3rd Party integrated applications. The team is responsible for the planning, development, installation, and implementation of multi-tier application architecture. Work includes the development of interfaces, SSIS packages, scripts, SQL Objects and extracts for downstream systems.
Brief Description of Role:
This position will fulfill the role of subject matter expert (SME) for the provisioning, maintenance, and development of database & applications in support for numerous business-critical systems and processes. The candidate will be providing support for problem analysis and interfacing with internal support personnel.
• Responsible for supporting the SQL Server databases and ensuring their performance, availability and security
• Responsible for implementation and release of database changes according to agreed timescales
• Creates prototypes, codes, tests, debugs and implements more complex software applications
• Monitors system performance, troubleshoots and resolves system failures, and plans system changes necessary to respond to changes in the computing hardware and software infrastructure
• Provide support and leadership in critical production support issue resolution.
• Ability to leverage internally developed ETL solution developed in Microsoft SQL Server 2005/2008r2.
• Collaborate with developers, project managers and business analysts in conceptualizing, designing and developing new software applications and enhancements
• Building and maintaining production SQL jobs, ETL Scripts, & developing SQL queries, stored procedures for data analysis and extract.
• Creating installation scripts – including the base installation scripts to create the tables, indexes, stored procedures and initial data
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Understanding and analysis of applicable business systems and customer needs/requirements
• Ability to follow the defined System Development Lifecycle process which includes the creation of required documentation and required approvals for each phase
• Follows established Change Management process to maintain a stable IT environment and mitigate the risks associated with implementing new technologies and upgrading existing systems.
• Must support the Q/A team with data driven requests.
Technical/Functional Qualifications:
Requisite Knowledge, Skills & Abilities:
General:
• Ability to play an integral part in project delivery given tight constraints but uncompromising quality
• Ability to provide accurate and timely estimates for tasks, and to effectively multi-task project efforts
• Ability to develop productive business relationships in an effort to identify and develop solutions
• Strong communication (oral and written) and interpersonal skills required to interact with colleagues and clients
• Self-motivated with the ability to work both independently and in at team environment
• Excellent analytical, problem solving and troubleshooting abilities
• Able to prioritize and execute tasks in a high-pressure environment
• Ability to translate business requirements and technical specification documents into working solutions.
• Attention to detail, and ability to write clear supporting and turnover documentation
• Understanding and analysis of applicable business systems and customer needs/requirements
• Ability to follow the defined System Development Lifecycle process which includes the creation of required documentation and required approvals for each phase
• Follows established Change Management process to maintain a stable IT environment and mitigate the risks associated with implementing new technologies and upgrading existing systems.
• Ability to work in an ambiguous and dynamic environment and manage changing/conflicting priorities
Requirement:
• A minimum of 3-5 years experience with Microsoft SQL Server database development and administration experience utilizing Microsoft SQL Server 2005/2008
• Working knowledge of Solid Relational Database experience (SQL, Stored Procedures, DDL/DML). MS SQL, Oracle, and/or Teradata experience preferred
• BS Degree in Computer Science or related Information Technology field.
• Proficient in writing stored procedures, triggers, and functions and also provide database development assistance and code for software developers (including Hands on experience with SSIS, scheduled SQL Jobs)
• Should have a thorough knowledge of data backup/ recovery/ rollback planning and implementation
• Ability to review, analyze, and optimize complex stored procedures to increase speed and performance.
• Understanding of, and experience with, server-client computing and relational database environments
• Experience with data management and ability to flowchart data processes
• Knowledge of reporting and query tools and practices
• Knowledge of relational database constructs (indexes, partitions, compression, etc.) and data warehousing concepts (dimensional modeling, slowly changing dimensions, etc.)
• Strong experience in SQL Scripting and automation process
• Must be well versed in database development, database interfaces, data analysis, and database performance.
• Must be able to work with Configuration Management to migrate work though all project stages and environments.
• Strong knowledge of Oracle, SQL, PL/SQL and Unix Shell Scripting is required
