Database Reliability Engineer (DBRE) - PostgreSQL at Cover Genius

Vancouver, British Columbia, Canada -

Full Time

Start Date

Immediate

Expiry Date

21 Aug, 26

Salary

175000.0

Posted On

23 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PostgreSQL, MySQL, AWS RDS, SRE Principles, Elasticsearch, Redis, S3, DynamoDB, Bigquery, RabbitMQ, SQL Performance Tuning, Bash, Python, Go, Terraform, Linux

Industry

technology;Information and Internet

Description

About the Company Cover Genius is a Series E Insurtech [https://covergenius.com/cover-genius-closes-80m-in-series-e-funding-as-investors-see-700-billion-opportunity-in-embedded-protection//] that protects the global customers of the world’s largest digital companies including Booking Holdings, owner of Priceline, Kayak and Booking.com [http://booking.com/], Intuit, Hopper [https://covergenius.com/hopper-demo/], Skyscanner [https://covergenius.com/skyscanner-demo/], Ryanair [https://covergenius.com/ryanair-demo/], Turkish Airlines, Descartes ShipRush, Zip and SeatGeek. We’re also available at Amazon [https://covergenius.com/available-at-amazon/], Flipkart [https://covergenius.com/flipkart-demo/], eBay [https://covergenius.com/global-online-retailer-513-growth/], Wayfair and SE Asia’s largest company, Shopee. Our partners integrate with XCover [https://covergenius.com/xcover/], our award-winning insurance distribution platform, to embed protection for millions of customers worldwide each year. Our team and products have been recognized sed with dozens of awards including by the Financial Times who ranked Cover Genius as the #1 fastest growing company in APAC [https://www.ft.com/content/1d5aabcc-5d44-11ea-ac5e-df00963c20e6] in 2020. Our diverse team across 20+ countries and many language groups commits itself to diverse cultural programs, in particular “CG Gives” [https://covergenius.com/cg-gives/] which makes social entrepreneurs out of us all and funds development initiatives in global communities. Our People are Bold, Authentic, Purposeful and Inspired Our People are not Perfect, Traditional, Complacent or Cautious About the Role As a Database Reliability Engineer (DBRE) on our Technology Team, your primary purpose will be to ensure the seamless and secure functioning of the datastores which support our platform. As a DBRE you will help design solutions for large scale engineering challenges such as how to support multi-regional scaling and data sovereignty requirements. To drive success in this role, you will have a strong background in site reliability engineering and database administration, with experience working with various data storage technologies in a public cloud environment. You should possess excellent problem-solving skills, a keen attention to detail, and a proactive approach to identifying and mitigating potential issues. As a specialist you will primarily work alongside the Site Reliability team as well as providing expertise to application and data teams on database architecture and performance optimization. DBREs work to improve the following aspects of Cover Genius databases and datastores: * Reliability * Availability * Performance * Disaster Recovery * Automation * Security Along with SREs, DBREs are responsible for writing and maintaining datastore related technical documentation such as tutorials, guides, runbooks and blameless post-mortems. Key Responsibilities: * Assist application teams to select and optimize datastore architectures and technologies * Assist application teams to optimize queries, migrations and perform other datastore performance tuning * Implement automation and reduce toil for datastore management * Deployment, upgrade and maintenance of datastores * Troubleshoot database related production incidents (On Call) * Develop, test and maintain disaster recovery procedures for datastores * Implement monitoring and alerting using key database metrics * Develop and maintain troubleshooting documentation /runbooks * Optimize and control costs of the company’s storage infrastructure * Creating and refining SLOs for datastores What you will bring: * At least 5 years experience running major database technologies in production, especially PostgreSQL and MySQL. Experienced running these technologies in cloud environments ideally AWS RDS. * Understanding of SRE Principles and best practices * Experience operating other NoSQL datastores and cache technologies especially Elasticsearch, Redis, S3, DynamoDB, Bigquery and RabbitMQ. * Excellent understanding of SQL and SQL database performance optimization * Comfortable scripting & developing internal tooling with Bash or at least one programming language (e.g. python, go) * Familiar with internals of PostgreSQL * Experience working with infrastructure & configuration as code tools especially Terraform * Experience working with Linux * Solid theoretical understanding of underlying data-storage technologies and tradeoffs * Good knowledge of AWS and/or GCP platforms and associated best practices * Bachelor Degree in Computer Science/Engineering or equivalent practical experience What you will have: * Strong communication and documentation skills * Curious and self motivated learner * Professional approach * Good team member * Organizational and time management skills * Excellent attention to detail * Positive approach to change Why Cover Genius? Cover Genius not only cares about being the best in our industry, we care about our team. We’re a business that understands life can be fluid and so we flex to ensure we provide the environment to suit that. What does that mean? • Flexible Work Environment - our teams are hybrid. We work from home on Wednesdays and Thursday and attend the office on Monday, Tuesday and Friday with flexibility around start/finish times. We also have the added bonus of a Wellness day a month. • Employee Stock Options - we want our people to share in our success, we reward them with ownership for their contribution in creating a world-class company. • Work with like-minded people who are passionate about both the work we're doing and giving back. Our CG Gives programs enables us to all become philanthropists through our peer recognition and rewards system. • Social Initiatives - pictures [https://www.instagram.com/p/B9qnOuUpDVx/] speak a thousand words! Sound interesting? If you think you have the best composition of the above, send us your resume and let's chat! * Cover Genius promotes diversity and inclusivity. We don't tolerate discrimination, demeaning treatment of anyone, or harassment due to race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or any other legally protected status. By submitting your application, you acknowledge that we may collect, store and process your personal data for recruitment purposes. To ensure a fair evaluation, we may use AI to assist in sorting applications, but all final decisions are made by our hiring team and no candidate dispositions are automated. We will keep your information on file for three years from the date of your application. For detailed information about how we handle your data and our use of AI, please review our full Privacy Policy. [https://covergenius.com/privacy-policy/] *This position offers a base salary range of C$135,000 to C$175,000 annually.

Responsibilities

Ensure the seamless and secure functioning of datastores by focusing on reliability, availability, performance, and disaster recovery. Collaborate with application teams to optimize database architectures, queries, and automate management tasks to reduce toil.