Trupanion is a leading provider of medical insurance for cats and dogs in North America. Our mission is to help the pets we all love receive the veterinary care they need. At Trupanion, we offer a collaborative, casual, and pet-friendly environment where everyone is encouraged to be themselves.
Trupanion is looking for an experienced Database Administrator/Developer to manage our database infrastructure! The role requires experience administrating various database technologies, as well as experience implanting on and integrating with various cloud providers.
Key Responsibilities Include:
Manage our existing SQL Server environments hosted in Azure, including infrastructure, disaster recovery/high availability, backup/restore, performance tuning, maintenance, and security.
Work with Development, Program Management, and Operations to integrate industry-standard security practices for database development, testing, and deployment across multiple teams.
Lead development work to design/implement new databases and schema.
Guide database infrastructure/implementation/integration across various cloud providers.
Use performance monitoring tools and reporting results.
Education, Registration & Certification:
Bachelor's level degree in Computer Science, Engineering, or equivalent work experience
4+ years of experience designing, building, configuring, administrating, maintaining database environments and tools.
2+ years of experience designing, implementing and integrating database solutions in the cloud.
2+ years of experience with source control systems, build systems, and release management tools.
Experience working with Azure and/or AWS cloud provider (infrastructure/networking/resource provisioning/sizing/scaling/monitoring/tuning).
Experience with Azure SQL Database/Azure SQL Managed Instance/Azure Synapse Analytics.
Experience with SQL Server (clustering/configuration/administration/maintenance/patching/fail-over/backup/recovery/tuning/monitoring/security).
Experience with database modeling (design/tables/views/integrity/indexing/stored procedures/functions/partitioning/triggers/tuning/security).
Experience with Agile software development methodology.
Preferred Skills, Knowledge & Abilities:
Experience with Litespeed backup/recovery software.
Experience with Azure Synapse.
Experience with Batch Scripts/Powershell/Python/C#.
Benefits and Perks:
Full medical, dental, and vision benefits at no cost to the employee
Four weeks paid time off
Five-week sabbatical after five years of employment
Restricted Stock Units
Open, casual, pet-friendly, and fun office environment
Free dog walking services for office pets during business hours
Free medical health insurance for your pet (1 dog or cat)
Paid time off to volunteer at nonprofit organizations
Free on-site gym
We're all about helping pets. We promote a cohesive and nimble team environment, and we hire, develop and promote team members. We trust each other. We are transparent and honest. We care about one another and want to see our team members succeed, personally and professionally. We strive to promote from within and reduce bureaucracy to allow creative thinking. We're focused on providing continuous training and support to all team members to encourage long-term happiness and success.
Take a look inside our office and see for yourself:
At Trupanion, we achieve great things together when we are:
Caring: We are kind to each other and assume positive intent.
Collaborative: We work together to achieve company goals (we not me).
Courageous: We are determined, take risks, and make bold moves.
Curious: We seek new information to continually better ourselves and our work.
Honest: We believe candid communication leads to successful teamwork.
Inclusive: We welcome and value all people and perspectives.
Nimble: We readily adapt and evolve in pursuit of progress and innovation.
For more information about Trupanion, visithttp://trupanion.com/about
Trupanion is an equal opportunity employer and embraces diversity. We are committed to building a team that represents a variety of backgrounds, abilities, perspectives, and skills.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.