Charles Schwab Oracle Aplication DBA - Westlake (DFW) in Westlake, Texas
Westlake - TX, TX2050R, 2050 Roanoke Road, 76262-9616
Lara Lynn Nolen
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.
Join a fast paced and dynamic distributed technology development team supporting Schwab's Enterprise Security Master (ESM) platform built on a vendor supplied product from GoldenSource. ESM is an emerging platform and will continue to be a vital component of Schwab's modernization. We have customized the platform to enhance performance and delivery with both security and pricing objects, caching of data, message publication and inquiry and update services insuring we are using optimal technical capabilities.
Note: For clarification, the GoldenSource Enterprise Security Master is the firm’s system of record for Financial Securities, covering all instruments and asset classes including, Equities, Fixed Income, Options and Mutual Funds. It is not related to Information Security.
This team support Schwab’s Enterprise Security Master platform. This is a highly visible and critical distributed platform (Oracle, Java, .Net) that will supply security descriptive data, rating, and end of day pricing data across all asset classes in support of business users and other applications.
What you’ll do:
This is a key role responsible for production and test environment availability across all DB instances, application maintenance deliverables and Data Governance support. The successful candidate can effectively prioritize and multi task as they handle a broad range of different technologies.
This role focuses on the application, but is not an Oracle DBA position that focuses underlying DB administration. However, an Oracle DBA background is helpful to have for this position.
Responsibilities include the following:
Assist in monitoring, alerting, performance tuning and diagnosing issues for key databases and environments
Diagnose database server reliability and performance issues
Tuning SQL queries to improve performance
Using tools to find the most frequently run queries and other performance issues (AWR, OEM, AppDynamics, Zabbix)
Ensure that new database code meets Schwab standards for readability, reliability and performance
Design indexes for existing applications
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
Review, deploy and test scripts/code
Respond to database related alerts and escalations and work to come up with strategic solutions to recurring problems
Ability to conduct research into database issues, standards, and products as required.
Support Data Governance – know your data
Support the application Data Warehous
What you have:
Bachelor degree Computer Science, Information Technology, Engineering or related discipline
8+ years overall IT experience
6+ years Oracle DBA experience, including the following:Experience with Oracle 11g (12c a plus) Grid/ASM, RAC, Compression, partitioning, Data Guard and high availability techniques.
Solid understanding of database High Availability. Emphasis on minimal or zero down time.
Understanding of Oracle Patch management and upgrades
Proficient use of OEM (preferred 12C version)
Diagnostics , tuning and configuration management expertise
Familiarity with reading explain plans
6+ years development experience in Perl, Shell scripts, Unix and Oracle
Proficient AIX and LINUX skills
Expert in SQL and at a minimum intermediate PLSQL
Familiar with histograms, indexes, and bind variables
Familiar with ASH - Active Session History
Data Governance tools knowledge: Collibra, EDQ, IGC
Database administration knowledge
Distributed development knowledge
Excellent Written and Verbal communication skills
Team player, collaborative across organizations and geographic locations
Self-motivated and able to take the initiative to resolve technical issues
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.
Relocation Offered?: No
Work Schedule: Days
Languages: English - spoken
Current Licenses / Certifications: None
Relevant Work Experience: IT-DBA-6+ yrs, IT-Other Specialty Engineering-6+ yrs
Position Located In: TX - Westlake
Job Type: Full Time
Activation Date: Tuesday, October 10, 2017
Expiration Date: Wednesday, December 13, 2017