Senior PostgreSQL DBA -DevOps

| San Francisco
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

AGERO + SWOOP

San Francisco based Swoop, an Agero company, provides simplicity and peace of mind in the chaotic world of roadside assistance. Agero + Swoop combined provide roadside protection for 100M+ Americans and performs 12M+ roadside services annually. As a connected vehicle service, we are in deep discussions with leading car manufacturers about their connected and autonomous vehicle experiences. We combine the benefits of a stable, profitable parent company, while offering the career opportunities and pace of a Silicon Valley startup. 

Swoop, a next generation SaaS based platform powers thousands of tow operators and partners with car makers, insurers, and fleet operators to deliver a roadside product that is fast, transparent, and easy.

Our team is passionate about addressing real-world problems with digital solutions. We’re looking for enthusiastic problem solvers who are ready to join a fast paced team and make a big impact.

Learn more at https://joinswoop.com & www.agero.com

POSITION SUMMARY

This position is responsible for full life cycle support of all databases. The DBA works within an agile/DevOps culture and environment of rapid growth. Effectively addresses and resolves database related issues and requirements as they emerge and collaborates with the Architecture team on design and development activities leveraging “infrastructure as code” best practices. Monitors the availability, stability, performance and overall health of the database environment(s). Works closely with development and customer support. Primarily supports DBA initiatives in the west coast office. May participate in strategic initiatives across the organization.

 KEY OUTCOMES

  • Monitoring and uptime of PostgreSQL production databases
    • Pro-active remediation of database operational problems
    • Pro-active development / improvement of procedures for automated monitoring, proactive intervention, and remediation of problems related to database availability/stability/data integrity
  • Database deployments and modifications in support of application development activities
    • Database capacity planning (storage, load, etc.)
    • Database backup and recovery
    • Regular PostgreSQL database maintenance activities
  • Participates in the creation of development (Local/Docker), staging, and production database instances, and the migration from one environment to another
  • Participates in application development projects and responsible for the associated database architecture and design
  • Creation of database stored procedures and triggers in support of application development
  • Participates in SQL code review (to ensure queries are optimized and tuned to perform efficiently prior to production release)
  •  Performs query tuning and preventative maintenance
  •  Implements process automation for improved efficiencies
  •  Collaborates with DevOps / Engineering teams on projects and initiatives
  • Supports complex web-based applications

EDUCATION, EXPERIENCE & SKILLS

EDUCATION: Bachelor’s Degree in Computer Science or equivalent required; Masters Degree in Computer Science or equivalent preferred;

EXPERIENCE:

  • 5-7 years of relevant experience with at least 4 years experience supporting production critical workloads on PostgreSQL
  • 3 years Docker Experience
  • PostgreSQL experience with version 11.x
  • Strong AWS knowledge and experience with RDS / EC2 / CloudFormation
  • Strong Linux or UNIX knowledge
  • Experience working with offshore support teams
  • Experience with database architecture, logical and physical design, installations, catalog navigation, monitoring and tuning (system, db, resource contention), backup and recovery, replication, HA/DR
  • Experience with automation, documentation, shell scripting, PL/ SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
  • Experience with change management in DevOps environments
  • Familiarity with shell scripting (Bash, Python, etc.)
  • Understanding of Ruby on Rails and web application framework
  • 3 years Docker Experience
  • Familiarity with or knowledge of Terraform (or similar product)
  • Strong collaboration, analytical, verbal and written communication skills
  • Experience working with offshore support teams
  • S. in Computer Science, Engineering, Mathematics or equivalent work experience
  • Technical certifications for DBMS platforms, AWS, or Linux/Unix a plus
  • Experience with other relation and non-relational DBMS platforms a plus

COMPLEXITY: Utilizes sound decision making skills and communicates well with other team members and business users. Identifies problems and recommends solutions. Performance will be measured by his/her ability to deliver quality applications on time.

WORKING RELATIONSHIPS: Works in a team environment, including cross-functional teams and teams with business users throughout the company. Interacts with all levels of management and staff across the organization

About Swoop

Swoop, along with our parent company, Agero, has set out to redefine the roadside assistance experience by offering real time transparency, unmatched scale and seamless integration with most of the major automotive and insurance brands. Combined, we protect over 125 million drivers and are making the roads safer by using the best technologies, customer service and partnerships with companies like Lyft.

Here's a brief video about Swoop: https://vimeo.com/206753666.

You can see examples of our work through our public API :https://api.joinswoop.com/

About Agero

Agero’s mission is to safeguard consumers on the road through a unique combination of platform intelligence and human powered solutions, strengthening our clients’ relationships with their drivers. We are a leading provider of driving solutions, including roadside assistance, accident management, consumer affairs and telematics. The company protects 100+ million vehicles in partnership with leading automobile manufacturers, insurance carriers and other diversified clients. Managing one of the largest national networks of service providers, Agero responds to more than 12 million requests annually for assistance. Agero, a member company of The Cross Country Group, is headquartered in Medford, Mass., with operations throughout North America. To learn more, visit www.agero.com and follow on Twitter @AgeroNews.

 

THIS DESCRIPTION IS NOT INTENDED TO BE A COMPLETE STATEMENT OF JOB CONTENT, RATHER TO ACT AS A GUIDE TO THE ESSENTIAL FUNCTIONS PERFORMED. MANAGEMENT RETAINS THE DISCRETION TO ADD TO OR CHANGE THE DUTIES OF THE POSITION AT ANY TIME.

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
    • JavascriptLanguages
    • RubyLanguages
    • SqlLanguages
    • ReactLibraries
    • Ruby on RailsFrameworks
    • PostgreSQLDatabases
    • RedisDatabases
    • InVisionDesign
    • SketchDesign
    • JIRAManagement
    • HubSpotCRM

Location

Located in the heart of the Financial District! Close to BART & MUNI. A variety of coffee shops/boba and many different cuisines are all steps away.

An Insider's view of Agero + Swoop

How would you describe the company’s work-life balance?

I’m surrounded by teammates who work hard to get the job done but once the workday is over, we have the rest of the day/night to ourselves. Everyone recognizes that we each have fulfilling lives outside of work, many with young families, fun hobbies, side projects, and healthy social lives. We don’t have to sacrifice this to reach our goals.

Roschelle

Sr. Product Manager

What projects are you most excited about?

I am excited for all of our new clients scheduled to launch this year, as well as the cross-functional teamwork that goes into making processes around these launches scalable and successful.

Sarah

Customer Success Manager

How does the company support your career growth?

Before Swoop, I felt like a cog in a machine. My experience here has been entirely different; within weeks my work was tied directly to company success. Over two years, I’ve learned valuable skills, developed insights, attended trainings and been given tools to invest in my future. Swoop truly cares about employees current and future success.

Dom

Sales Engineer

What is your vision for the company?

With vehicles evolving to be increasingly autonomous and electric, our platform is evolving ahead of this transformation to be able to grow our existing stewardship of over 100M vehicles in the U.S. We’re now beginning to roll this blueprint out internationally as well on a path to becoming the global operating system for roadside assistance.

Robert

General Manager, SaaS Platform & Head of SF Office

What’s the vibe like in the office?

Everyone is locked into their work but no one is chained to their desk. At any moment you will hear people laugh or head over to the foosball table for a quick game. Everyone works really hard and everyone helps celebrate each other's work. It is a pleasure to go into the office and work with amazing people.

Pierre

Director of DevOps

What are Agero + Swoop Perks + Benefits

Agero + Swoop Benefits Overview

Agero+Swoop is focused on providing a resource rich, creative environment driven by exciting work as well as a multitude of opportunities to accelerate your technology career. In support of this mission, we offer a wide range of benefits to include:
- Flexible time off policy
- Tuition reimbursement
- Robust internal career development programs designed to support the growth of each employees career
- Weekly happy hours, and many more!

Culture
Friends Outside of Work
Eat Lunch Together
Intracompany Committees
Culture Committee
Open Door Policy
Team-Owned Deliverables
Team-Based Strategic Planning
Group Brainstorming Sessions
Open Office Floor Plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Agero + Swoop employees can contribute up to $2,750 annually to their FSA.
Disability Insurance
Disability insurance covers 60% of pre-disability earnings.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Employer covered life insurance is equal to 1x an employee's annual salary. Employees also have the option to purchase supplemental life insurance up to 5x their annual salary.
Pet Insurance
Wellness Programs
Team Workouts
We have daily meditation sessions, 10 minute core workouts 3x a week, and push up challenges. Also, some associates play golf and basketball outside of the office.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Agero+Swoop provides employees with a 401(k) matching plan managed by Fidelity Investments. We match 100% of the first 2% of contributions, and 50% of the next 4% of contributions.
Performance Bonus
Whether you are an engineer or a contact center representative, a piece of your annual compensation is delivered via an annual bonus, paid 2 per year. Target bonus amounts vary by role.
Child Care & Parental Leave Benefits
Flexible Work Schedule
Agero + Swoop provides employees with a flexible work schedule that includes Flexible start and end times.
Remote Work Program
Our remote work program includes work from home 1 day per week and work remotely on occasion as needed.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Agero hosts company outings Semi-annually.
Some Meals Provided
Happy Hours
Happy hours are hosted Once per week.
Pet Friendly
Agero + Swoop's pet policy is Occasional bring your pet to work days.
Fitness Subsidies
$150/year towards fitness reimbursement
Professional Development Benefits
Tuition Reimbursement
Our tuition reimbursement plan offers an annual max of $5,250, pre-tax.
Lunch and Learns
Agero hosts lunch and learn meetings twice per month.
Promote from Within
More Jobs at Agero + Swoop10 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Product
Project Mgmt
Sales
Project Mgmt
new
San Francisco
Product
new
San Francisco
Developer
new
San Francisco
Developer
new
San Francisco
Data + Analytics
new
San Francisco
Developer
new
San Francisco
Developer
new
San Francisco
Developer
new
San Francisco
Sales
new
San Francisco
Product
new
San Francisco
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Agero + Swoop's full profileSee more Agero + Swoop jobs