Cloud Database Engineer

Engineering
Austin, TX / Remote
Full-Time
Posted on: 
Oct 12, 2021

Job requirements

About Loop

LOOP sells car insurance that is fair for everyone. We do this by using data about how and where you drive to make better decisions (rather than relying on credit score and other demographic factors), while delivering a delightful customer experience focused on building community and trust in financial services. 

Responsibilities

The Cloud Database Engineer is responsible for designing, implementing, enhancing, and maintaining our cloud databases and data storages. This position requires extensive SQL knowledge as well as extensive database design patterns. In addition, you will be constantly optimizing current databases, stored procedures, and data models, as well as architecting new databases and data models. Securing our data and keeping an up-to-date knowledge of new technological advances are also very important. This role is part of LOOP's Engineering team.

  • Design a universal data models based on the business and technical requirements of the backend and Customer Facing Tech teams
  • Work with the backend team to design and implement multiple persistent data storage solutions to serve our microservices. This will include relational databases (e.g., MySQL, PostgreSQL, etc.) NoSQL document databases (e.g., Firestore), in-memory storage (Redis, Google MemoryStore), and others
  • Work with data science and engineering teams to enable daily data replication into our data warehouse
  • Assist the backend team by writing and maintaining stored procedures and functions to retrieve, manipulate, store, modify, and delete data
  • Maintain and enhance the performance of newly created and existing database programs
  • Monitor databases and related systems to ensure optimized performance
  • Adhere to best practices in securely storing, backing up, and archiving data
  • Document processes related to database design, configuration, and performance
  • Keep abreast of developments and best practices in database engineering and administration
  • Protect the database against threats or unauthorized access
  • Report metrics regarding usage and performance
  • Suggest changes and improvements for database maintenance and protection
  • Design databases with both front-end and back-end users in mind

Qualifications

  • 3 - 7 years of experience
  • Extensive experience designing and implementing secure, scalable, and maintainable relational and document-based databases (MySQL, PostgreSQL, GCP Firestore..)
  • Strong and in-depth knowledge of Structured Query Language (SQL)
  • Experience with NoSQL databases (e.g., document databases, key-value stores, etc.)
  • Familiarity with in-memory storage solutions like Redis or Google’s MemoryStore
  • Demonstrable previous experience delivering and managing high availability production databases for live customer facing applications
  • In-depth knowledge of stored procedures and functions
Cloud Database Engineer
Full-Time
Austin, TX / Remote
This is some text inside of a div block.

About Loop

LOOP sells car insurance that is fair for everyone. We do this by using data about how and where you drive to make better decisions (rather than relying on credit score and other demographic factors), while delivering a delightful customer experience focused on building community and trust in financial services. 

Responsibilities

The Cloud Database Engineer is responsible for designing, implementing, enhancing, and maintaining our cloud databases and data storages. This position requires extensive SQL knowledge as well as extensive database design patterns. In addition, you will be constantly optimizing current databases, stored procedures, and data models, as well as architecting new databases and data models. Securing our data and keeping an up-to-date knowledge of new technological advances are also very important. This role is part of LOOP's Engineering team.

  • Design a universal data models based on the business and technical requirements of the backend and Customer Facing Tech teams
  • Work with the backend team to design and implement multiple persistent data storage solutions to serve our microservices. This will include relational databases (e.g., MySQL, PostgreSQL, etc.) NoSQL document databases (e.g., Firestore), in-memory storage (Redis, Google MemoryStore), and others
  • Work with data science and engineering teams to enable daily data replication into our data warehouse
  • Assist the backend team by writing and maintaining stored procedures and functions to retrieve, manipulate, store, modify, and delete data
  • Maintain and enhance the performance of newly created and existing database programs
  • Monitor databases and related systems to ensure optimized performance
  • Adhere to best practices in securely storing, backing up, and archiving data
  • Document processes related to database design, configuration, and performance
  • Keep abreast of developments and best practices in database engineering and administration
  • Protect the database against threats or unauthorized access
  • Report metrics regarding usage and performance
  • Suggest changes and improvements for database maintenance and protection
  • Design databases with both front-end and back-end users in mind

Qualifications

  • 3 - 7 years of experience
  • Extensive experience designing and implementing secure, scalable, and maintainable relational and document-based databases (MySQL, PostgreSQL, GCP Firestore..)
  • Strong and in-depth knowledge of Structured Query Language (SQL)
  • Experience with NoSQL databases (e.g., document databases, key-value stores, etc.)
  • Familiarity with in-memory storage solutions like Redis or Google’s MemoryStore
  • Demonstrable previous experience delivering and managing high availability production databases for live customer facing applications
  • In-depth knowledge of stored procedures and functions

Search