Oracle Database Developer

company banner
Charles Schwab & Co., Inc.
Full Time
Work from home not available Travel not required

Job Description


Westlake - TX, TX2050R, 2050 Roanoke Road, 76262-9616
Jeanie Lynn Bannon

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 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:

The Stock Plan Services Technology team is responsible for building applications to support the equity compensation business.  These solutions are essential to manage company’s equity compensation plans, taxation, reporting, and much more. We are seeking a Staff Database Developer to manage our databases that run our business

What you’ll do:

We have an exciting role for a Staff Database Developer who is up for helping us deliver transformational applications.  We are looking for a self-motivated Database Developer who is experienced in various aspects of administration and development across different database products to tackle the following objectives:

  • Provide support to our production data operations team by reviewing data update scripts
  • Partner with our application engineering team by creating and modifying schemas, reviewing sql queries, building stored procedures, reviewing code to understand impacts to database usage and performance
  • Investigate production issues
  • Proactively identify and address database performance issues
  • Partner with other technology organizations within Schwab to define segregation of duties and identify responsible parties for various tasks
  • Provide oversight and guidance for the Unified Data Model project
  • Analyze and assist with a conversion from Oracle to MSSQL over the next 2 years
  • Routinely refresh, sanitize and scrub data from production environments into QA and Development environments
  • Lead the implementation of scripts to automate routine database management functions
  • Build relationships with technical partners across the organization
  • Ensure stored and transmitted data meets Schwab’s security and encryption policies
  • Learn the business of Stock Plan Services @ Charles Schwab & Co
  • Provide 2nd tier on-call support for troubleshooting and analysis for production issues
  • Proactively engage technical and business partners to overcome roadblocks and resolve issues

What you have:

  • Experience with database Design, Creating DDL scripts, Normalization of design.
  • Writing complex queries / DML statements, familiarity with tools like TOAD, SQL Developer etc
  • Working knowledge on Creating PL/SQL scripts; specifically Triggers , Stored Procedures and Packages
  • Experience with Performance Tuning, specific to SQL tuning using EXPLAIN_PLAN; familiarity with tools like OEM (oracle Enterprise Manager, AWR (Automatic Workload Repository), ASH (Active Session History) reports
  • Experience with Data Modelling and familiarity with tools like ERWIN
  • Implementing Database Security features like Data Masking, Encryption, Virtual Private Database.
  • You will have effectively communicated with both technical and business partners
  • You are able to make things happen without being told what to do
  • You are a self-starter and are willing to dig in and learn
  • Bachelor's degree in Computer Science, Engineering, or a similar field
  • Understands business strategy and cascades business intelligence needs to the database level
  • Willingness to work flexible / odd hours (as needed)
  • Successful experience working in a team environment
  • Excellent written and verbal communication skills

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.

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. Schwab also does not discriminate against applicants or employees because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. At Schwab, we believe that every employee, through their diverse abilities and experiences, can contribute to our growth, innovation and client loyalty. We embrace diversity and are committed to providing equal opportunity to all employees and applicants. If you have a disability, and require reasonable accommodations in the application process, call Human Resources at 800-725-3535. We will be happy to assist you. Schwab will only share your accommodation request with those individuals who have a specific need to know. The request for an accommodation will not affect Schwab's hiring decisions. All other submissions should be performed online.

Job Specifications
Relocation Offered?:No
Work Schedule:Days
Languages:English - spoken
Current Licenses / Certifications:None
Relevant Work Experience:IT-DBA-2-5 yrs
Position Located In:TX - Westlake
Job Type:Full Time

Category:Information Technology
Activation Date: Monday, January 14, 2019
Expiration Date: Tuesday, April 16, 2019
Apply Here

Company Information

At Schwab, we inspire the driven; individuals who want to take ownership of their career and their future. You are appreciated for your work, respected for your unique strengths and rewarded for the possibilities you create for our clients. Working in Schwab Technology is not just a job; it's an opportunity to do the best work of your life. This team drives Schwab's mission to harness the power of data to deliver the next gen client experience. They relentlessly pursue simplification and modernization, laying the foundation for the digital enterprise. They act boldly together to provide security for our clients and enterprise, safeguarding client trust all while delivering on their core commitments to availability, capacity and project execution with excellence and efficiency. If you are looking to be challenged with projects that stretch and grow your abilities, and push you towards further developing your expertise, apply to one of our openings today.
Dice Id : 10228622
Position Id : 20190108-143

Similar Positions at Charles Schwab & Co., Inc.