Senior PostgreSQL DBA-DevOps Engineer

Swoop

San Francisco

Full-time

Devops

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.