Oh Snap!
This job is no longer active - but you can still view the details below.

Lead Database (Oracle) Engineer

| North Suburbs

Job Description

At Discover, be part of a culture where diversity, teamwork and collaboration reign. Join a company that is just as employee-focused as it is on its customers and is consistently awarded for both. We’re all about people, and our employees are why Discover is a great place to work. Be the reason we help millions of consumers build a brighter financial future and achieve yours along the way with a rewarding career.

Responsible for the activities related to database administration and systems development support. Under indirect supervision, analyzes and implements the physical model of the database within established standards, ensuring the best performance. Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, systems feeds, and interfaces) with multiple concurrent users, ensuring control, integrity, and accessibility of data. Works on multiple projects simultaneously.

Responsibilities

  • Oracle 11g/12c, Exadata RAC Architecture, Configuration, and Administration

  • Troubleshoot for performance issues / database errors, special 10046 tracing, working with vendor

  • Support On-call pager rotation support Database installations and upgrades for Oracle 11g, 12c

  • Grid with MAA architecture Build DataGuard across data centers for large databases and troubleshoot / resolve standby synch issues, support replication, switchover / failovers.
  • Use RMAN to backup and point-in-time recovery / restore of databases, RDBMS tables
  • Administrative work Golden Gate active replication configuration and support using DBFS Oracle Enterprise Manager (12c / 13c ) installation, configuration and database monitoring / alerts
  • Oracle database patching and database vulnerability management Database weekend Change implementations, ability to run an implementation call with application teams Database migrations using Oracle Golden Gate
  • SQL Tuning, using indexes, baselines, statistics, EXPLAIN plans / access path evaluation Desired understanding of Oracle Exadata architecture.
  • Performs scheduled changes (patching, maintenance, deployment, decommission, configuration, performance tuning) for all hardware and software used to support the database infrastructure.
  • Independently handle production phone conference calls for database issues assisting in overall troubleshooting of the issues collaborating with other teams and present observations / on-the-spot analysis results from the database side.
  • Follow Change Management procedures Provide L3 DBA support to offshore / first level support DBA’s
  • Participates with infrastructure and application teams regarding project work, POCs, and/or troubleshooting exercises.
  • Participates in pager rotation to provide 24×7 support for all database system environments (Prod, Test, Development).
  • Monitors databases for performance degradation, connectivity issues, system events, and alerts. Updates and manages tickets through resolution with vendors and internal support groups. Tests, analyzes, performs corrective actions, and restores availability and services in a timely and accurate manner to eliminate/reduce application impact. Provides timely notifications to management/outage team and escalates tickets to the appropriate internal and external management as needed.

#LI-MF1

Minimum Qualifications

At a minimum, here’s what we need from you:

  • Bachelor’s Degree in Database Administration, IT, or related field
  • 4+ years of experience in Database, IT, or related field

If we had our say, we’d also look for:

  • 5+ years of extensive hands-on Oracle Database Administration experience for large database installations
  • Master’s Degree with a major in Computer technologies / sciences.
  • Desired Oracle Certified Professional (OCP)
  • Knowledge and experience in database performance tuning including ASH / AWR’s analysis, SQL execution plans, baselines & profiles, tuning SQL’s and memory components of the database
  • Familiarity with modern technological features and ability to quickly adapt to changing environment needs
  • Oracle Exadata
  • Familiarity with SOX, PCI, Cyber Ark and database security procedures / standards
  • Awareness of database security compliance requirements
  • Oracle Data Guard, Broker
  • Backup and Recovery
  • Oracle Enterprise Manager
  • Software Patching
  • Data Pump
  • LDAP OUD / OID
  • tnsnames, listener, SQLNET
  • Automatic Storage Management (ASM)
  • Change Management / Service Now
  • Oracle RDBMS 11g / 12c
  • Database Vulnerability Management
  • Database File System (DBFS)
  • AWR / ASH / ADDM / Memory tuning / STATSPACK / Optimizer
  • 24X7 On-Call pager support

Discover Financial Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status, among other things, or as a qualified individual with a disability.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • Neo4jLanguages
    • RLanguages
    • AngularJSFrameworks
    • HadoopFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • Amazon Web ServicesFrameworks
    • AnsibleFrameworks
    • AWS PortfolioFrameworks
    • BlockchainFrameworks
    • ChefFrameworks
    • CloudFoundryFrameworks
    • DockerFrameworks
    • Google Cloud PlatformFrameworks
    • KubernetesFrameworks
    • Lambda ArchitectureFrameworks
    • OpenAPIFrameworks
    • OpenShiftFrameworks
    • CassandraDatabases
    • HiveDatabases
    • MongoDBDatabases
    • OracleDatabases
    • TeradataDatabases
    • ServerlessDatabases
    • TerraformDatabases
    • Google AnalyticsAnalytics
    • SparkAnalytics
    • H20Analytics
    • Machine Learning Analytics
    • Natural Language Processing Analytics
    • Programmable BotsAnalytics
    • AgileManagement
    • SafeManagement
    • LeanManagement
    • Continuous Delivery Management
    • DevSecOpsManagement
    • Reactive ProgrammingManagement
    • Site Reliability EngineeringManagement
    • SalesforceCRM

Location

Our headquarters is located in the northwest suburbs of Chicago and we also have a downtown Chicago office which is known as the“The 606”.

An Insider's view of Discover

What’s the vibe like in the office?

The cool thing about working at Discover is the wonderful collaborative environment we have and all the smart, talented and fun people we work with every day to continuously work on innovations.

Hiba

AWS Cloud Engineer

What does your typical day look like?

I enjoy working at Discover because I get to work with and collaborate with talented people who are passionate about what they do, and together we get to help others. We work constructively and cross-functionally to provide the best and newest products for our users and provide exceptional support for our customers!

Mandy

Project Manager, Advanced Analytics Platform

How does the company support your career growth?

There are two reasons I enjoy working at Discover. First, I enjoy the challenging and meaningful work. Second, my career path at Discover is mine to shape. My managers have supported me when I wanted to learn more and move within the company.

George

Senior Manager, Software Engineering

What is your vision for the company?

My vision of the company is that we create rewarding experiences in lives of our customers every day through analytics.

Kumar

SVP, CDO Advanced Analytics Platforms

What’s the vibe like in the office?

I love working at Discover because of how the company invests in its people and innovation. The environment is encouraging and the smart people around you makes it an amazing experience every day!

Brent

Director, Digital Analytics

What are Discover Perks + Benefits

Discover Benefits Overview

Start enjoying great benefits Day 1 — We support you with the same dedication we bring to all of our customers.Our comprehensive benefits package features first-class insurance, financial planning support and excellent perks designed to help you reach your goals and live a rich, healthy life.

Check out more of our amazing employee benefits at mydiscoverbenefits.com

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
You can open a separate Health Care FSA (HCFSA) and contribute up to $2,650 tax-free from your paycheck to reimburse yourself for eligible out-of-pocket expenses.
Disability Insurance
Employees receive Short-Term Disability Insurance at no cost.
Dental Benefits
Discover offers two dental plan options — Standard and Premier — both are administered by MetLife.
Vision Benefits
Discover offers two vision plan options — Standard and Premier through VSP.
Health Insurance Benefits
Discover offers a variety of medical plans for you and eligible family members, so that you can choose the benefit plan that suits your needs.
Life Insurance
As a Discover employee, you receive Basic Life Insurance of one times your HWEE (up to $500,000) at no cost to you.
Pet Insurance
Purchase medical coverage at a discounted rate for your beloved family pet. The more pets you insure, the greater the discount.
Wellness Programs
Help balance your work and personal life with a wide variety of free and discounted resource and referral services including family and relationship counseling and financial guidance.
Onsite Gym
Discover has fitness centers and Weight Watchers® programs at all five major locations.
Retirement & Stock Options Benefits
401(K)
You may elect to contribute 1% to 30% of your eligible base salary, commissions and bonus on a pre-tax basis, up to IRS limits every year.
401(K) Matching
Discover matches up to 6% of the pre-tax contributions you make to the 401(k) Plan.
Employee Stock Purchase Plan
The ESPP provides eligible employees with an opportunity to purchase shares of Discover common stock through payroll deductions at a 5% discount.
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Discover helps eligible employees and their families with the costs of adoption by reimbursing certain expenses.
Vacation & Time Off Benefits
Generous PTO
Discover has a Paid Time Off of 4 to 5 Weeks of paid time per year.
Paid Volunteer Time
Paid Holidays
Discover provides 7 paid holidays.
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
When you enroll in the Commuter Benefits Program at WageWorks, you’ll save on taxes on mass-transit passes, parking and other eligible expenses.
Company Outings
Game Room
Parking
Recreational Clubs
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Discover provides tuition reimbursement and a full-ride bachelor's degree program for select online degree programs.
Diversity Program
More Jobs at Discover92 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Operations
Product
Project Mgmt
Project Mgmt
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Project Mgmt
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
Chicago
Developer
new
North Suburbs
Project Mgmt
new
North Suburbs
Operations
new
North Suburbs
Project Mgmt
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
Chicago
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Project Mgmt
new
North Suburbs
Data + Analytics
new
North Suburbs
Product
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Product
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Product
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Product
new
North Suburbs
Operations
new
North Suburbs
Developer
new
Chicago
Operations
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs