Charles Schwab Sr Database Support in Lone Tree, Colorado

Description:

Lone Tree - CO, DENR2, 9800 Schwab Way, 80124

David Slade

20170504-2237

We believe that , when done right, investing liberates people to create their own destiny. We are driven by our purpose to champion every client’s goals with passion and integrity. We respect and appreciate the diversity of our employees, our clients, and the communities we serve. We challenge conventions strategically to create value for our clients, our firm and the world. We live and bring to life the concept of ‘own your tomorrow’ every day. We champion our employee strengths, guide their development, and invest in their long-term success. We hire optimistic, results-oriented, curious, innovative, and adaptable people with the desire to help our clients and one another succeed.

As a company, we were established by Chuck at http://www.aboutschwab.com/about/leadership/charles_schwab over 40 years ago to champion Main Street over Wall Street, and to help Americans transform themselves from earners to owners. Through advocacy and innovation, we work to make investing more affordable, accessible and understandable for all. As we enter our fifth decade, we are looking for talented, innovative and driven people who believe they can help themselves, and our clients, create a better future.

Our Opportunity:

This is a Technology Operations role based in Lone Tree, CO on the Production Management team in CSIM Technology.

What you’ll do:

This is a Sr. Database support role within the Production Management team for CSIM. Responsible for maintaining the production and pre-production servers including environment management and upgrading as required. Will ensure backed ups are scheduled, monitored, capacity is monitored and addressed and that the server data is secure from unauthorized access. May also produce and create reports, charts, manuals proposals and perform light programming (scripting).

What you have:

For this role, you must be able to plan, coordinate and implement software version changes and use utility tools to monitor elements of the system, such as memory, central processing unit (CPU) and program errors generated from a system or software problem. Must also have knowledge in systems design and configuration. Strong verbal and written communication skills is required.

  • Knowledge of Information Technology processes, standards, techniques, best practices, and the SDLC

  • Deep knowledge of ETL processes, standards, techniques, and best practices (experience with Informatica is a plus)

  • Analyze and integrate disparate data and systems using ETL processes and logic to provide timely and accurate information to our business partners

  • Comply with team and department standards, policies, and procedures

  • Participate in modernization projects to upgrade or replace older solutions

  • Understand business users and translate user specifications into technical designs

  • Analyze data models and raw data to develop ETL solutions

  • Creates complex solutions using SQL stack tools to meet business requirements

  • Reverse engineer and document legacy systems as needed for enhancements and to support business analysts

  • Manages code and deployment scripts utilizing Team Foundation Server

  • Provide team based operational On Call support on a scheduled rotating basis

  • Provide tier 3 technical support for non-production and production issues including production troubleshooting, query tuning, and process optimization

  • Provide problem-solving, code review, risk assessment, and security recommendations

  • Participate in the release lifecycle and deployment processes

  • Provide support for basic DBA duties, backups and restores, environment refreshes, database maintenance, and security tasks, most of which are automated.

  • 6-10 years of experience with Microsoft SQL Server technologies (SSMS, SSIS, SSRS, SSAS a plus)

  • Solid working experience with the following core technologies: SQL Server 2008 R2/2012, Visual Studio 2010/2012, SSIS, SSRS, Team Foundation Server or other source control systems, basic Active Directory security understanding

  • Solid working experience in T-SQL, performance tuning, production support and troubleshooting

  • Team player who openly shares knowledge and experience within the team

  • Excellent written and oral communication skills

  • Desirable Skills: C#, technical documentation, Jira, DevOps and CI/CD concepts

  • Modern OS Administration knowledge

  • Basic Networking knowledge

  • Active Directory knowledge and use

What you’ll get:

  • Comprehensive Compensation and Benefits package

  • Financial Health: 401k Match, Employee Stock Purchase Plan, Employee Discounts, Personalized advice, Brokerage discounts

  • Work/Life Balance: Sabbatical, Paid Parental Leave, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer, Employee Matching Gifts Program

  • Everyday Wellness: Health and Lifestyle Wellness Rewards, Onsite Fitness Classes, Healthy Food Choices, Wellness Champions

  • Inclusion: Employee Resource Groups, Commitment to diversity, Strategic partnerships

  • Not just a job, but a career, with an opportunity to do the best work of your life

Learn more about Life@Schwab at http://www.aboutschwab.com/careers/lifeatschwab/" .

Charles Schwab & Co., Inc. is an equal opportunity and affirmative action employer committed to diversifying its workforce. It is Schwab's policy to provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender identity or expression, national origin, ancestry, age, disability, legally protected medical condition, genetic information, marital status, sexual orientation, protected veteran status, military status, citizenship status or any other status that is protected by law.

Job Specifications

Relocation Offered?: No

Work Schedule: Days

Languages: English - spoken

Current Licenses / Certifications: None

Relevant Work Experience: IT-DBA-6+ yrs

Position Located In: CO - Lone Tree

Education: BA/BS

Job Type: Full Time

Category:Information Technology

Activation Date: Thursday, July 6, 2017

Expiration Date: Saturday, October 7, 2017

Apply Here