Postgres DBA

| Remote
Sorry, this job was removed at 7:00 a.m. (CST) on Wednesday, July 14, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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 & growth, we provide monthly meditation and yoga classes and access to all LinkedIn Learning courses. 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 Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
  • People Operations
    • RubyLanguages
    • ClojureLanguages
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • CanvaDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • Google DocsManagement
    • JIRAManagement
    • Monday.comManagement
    • WordpressCMS
    • DocuSignCRM
    • SalesforceCRM
    • MailChimpEmail
    • SlackCollaboration
    • ZoomCollaboration
    • Monday.comProject Management
    • LatticeProject Management

Location

OppFi is located in the heart of downtown Chicago, adjacent to Michigan Avenue and across the street from beautiful Millennium Park.

What are OppFi Perks + Benefits

OppFi 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
Open door policy
OKR operational model
Team based strategic planning
Pair programming
Open office floor plan
Flexible work schedule
Remote work program
Diversity
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Team workouts
Mental health benefits
Financial & Retirement
401(K)
401(K) matching
Employee stock purchase plan
Performance bonus
Charitable contribution matching
Child Care & Parental Leave Benefits
Generous parental leave
Family medical leave
Vacation & Time Off Benefits
Unlimited vacation policy
Generous PTO
Paid volunteer time
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Free snacks and drinks
Some meals provided
Company-sponsored happy hours
Recreational clubs
Relocation assistance
Fitness stipend
Home-office stipend for remote employees
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.
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education stipend
Continuing education available during work hours
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 OppFi

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about OppFiFind similar jobs like this