Postgres DBA

| Chicago | Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Growth with a Purpose

OppLoans is a rapidly growing Fintech company that helps credit-challenged consumers build a better financial path through accessible products and five-star customer service. As one of Chicago's fastest-growing startups, we've made the Crain's Business Chicago Fast 50 (#4 in 2019, #8 in 2020) and the Deloitte Technology Fast 500 (twice), and we've ranked in Inc. 5000 five years in a row!

The Data Engineering team at OppLoans is focused on the design, development, and support for "all things data" at OppLoans. This includes the deployment of Postgres databases which support our applications, our Snowflake Data Warehouse and multiple Airflow and Hevo ETLs.

This new team member will be focused on:

  • Our PostgreSQL Service (OLTP) and Reporting (OLAP) Databases in AWS RDSProvisioning new databases and users with CI/CD tooling
  • Keep our data secure and private
  • Performance tuning and analysis
  • Data-related alerting in Datadog
  • User support
  • Documentation
  • High Availability and Disaster Recovery Planning/Drills
  • Tool evaluation and testing
  • Capacity planning and budgeting assistance
  • On-call Rotation for Production Support of all Database and ETL Systems
  • System administration of data-related Linux EC2/ECS servers
  • Frequent customer-centric collaboration with Reporting users, Developers and DevOps Engineers

What you will bring to the team:

  • 5+ years of experience as a Database Administrator or Engineer
  • 3+ years managing production PostgreSQL instances
  • Some experience with shell scripting and Python/Ruby script development
  • Experience with an ETL tool such as Hevo, Airflow, Informatica or something similar

Our Tech Stack:

  • Snowflake
  • AWS
  • Datadog
  • Terraform
  • Harness
  • Airflow
  • Hevo
  • Jira
  • Confluence
  • Tray.io

Things we are learning:

  • Stream processing
  • Kafka
  • Event Sourcing

Define your career at OppLoans

OppLoans is committed to providing an exceptional employee experience that allows you to define your career and purpose with us. New hire "Opptimists" go through orientation, shadow programs, a new hire lunch with our CEO, Jared Kaplan, and you can participate in different company culture events focused on diversity, equity, and inclusion. Our Onboarding team has designed programs to make you feel welcome and part of our team during your first year and beyond.

  • Define the mission (days 1-30): You will understand our company mission, values, and vision, and how your role at OppLoans plays a part in that.
  • Define your goals (months 1-3): You will be able to understand your role expectations and identify goals with your manager and mentor(s) to fulfill those expectations.
  • Define your belonging (months 3-6): You will understand OppLoans' culture and have opportunities to engage with and impact that culture. Business Resource Groups and other programs are offered to help with community connection both virtually and in-person.
  • Define your journey (6 months - 1 year): You will feel confident in your abilities to execute in your role and know the next step you will take to develop your career.
Compensation and Benefits

OppLoans offers a flexible remote environment, 401(k) matching program, and flexible paid vacation. Other benefits include medical benefits, dental and vision coverage, and tuition reimbursement. To support your wellness, you receive a free Audible membership, access to all LinkedIn Learning courses, and monthly meditation and yoga classes. We also offer Fringe, which is a lifestyle benefits platform that lets you decide how you want to spend your rewards from dozens of vendors like Uber, Doordash and Urban Sitter. Dress code is casual.

EEOC Statement:

We do not discriminate based on identity - race, color, religion, national origin or ancestry, sex (including sexual identity), age, physical or mental disability, pregnancy, veteran or military status, unfavorable discharge from military service, genetic information, sexual orientation, marital status, order of protection status, citizenship status, arrest record or expunged/sealed convictions, or any other legally recognized protected basis under federal, state, or local law.

OppLoans is committed to the full inclusion of all qualified individuals. As part of this commitment, OppLoans will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact our People team at [email protected]

Pursuant to the requirements of the California Consumer Privacy Act, OppLoans is providing the "OppLoans California Employee Privacy Policy", which details the categories of personal information collected and your rights under the policy. If you are a California resident, please review the policy here: https://www.opploans.com/careers/

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • RubyLanguages
    • ClojureLanguages
    • Google AnalyticsAnalytics
    • ConfluenceManagement
    • JIRAManagement
    • WordpressCMS
    • SalesforceCRM

Location

OppLoans is located in the heart of downtown Chicago, adjacent to Michigan Avenue and across the street from beautiful Millennium Park.
OppLoans' "People First" Ethos Inspires Employees to Make Great Tech
Watch

What are OppLoans Perks + Benefits

OppLoans Benefits Overview

Fully stocked kitchen with healthy snacks & drinks available.
Subsidized daily lunches.
CTA & Metra benefit program.
Free gym membership.
Free shuttle passes to Metra stations.
Casual dress policy.
Discounted Divvy memberships.
401(k) match program.
Free OppLoans apparel.
Competitive salary and benefits package.
Fun, fast-paced work environment.
Employee and peer recognition program.
Dynamic start-up culture and environment.
Ability to make an immediate impact in a growth stage company.
Flexible paid vacation policy.
Free health benefit options.
Intramural sports leagues.
Weekly office events (happy hours, massages, game nights, private yoga sessions, catered
breakfasts, etc.).
Dual monitors and stand-up work stations.
Convenient downtown Chicago office located in the heart of the city.
Awesome panoramic office view of Millennium Park and Lake Michigan, with rooftop access.
Equal opportunity employer.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
OppLoans gym is a state-of-the-art fitness center free to all employees, and provides yoga, kickboxing and pilates classes on site.
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Recreational Clubs
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

Additional Perks + Benefits

In addition to offering generous insurance benefits and 401(k) matching, we pride ourselves on a fun, collaborative and supportive company culture. Prior to COVID-19, this meant in-office events like game nights, bagel mornings and chair massages as well as semi-annual company parties. With all our teams working remotely right now, we’re holding digital events in their place, like trivia nights, Zoom cooking classes, movie nights, and coffee chats. Through our lifestyle benefits platform Fringe, employees can access discounted services that support a healthy work/life balance. We are always looking for ways to treat our employees well and show them they’re appreciated.

More Jobs at OppLoans31 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
Legal
Marketing
Operations
Product
Project Mgmt
Content
Finance
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Content
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView OppLoans's full profileSee more OppLoans jobs