Sr Database Engineer at Porch Group

Job description

Porch Group is a leading vertical software and insurance platform and is positioned to be the best partner to help homebuyers move, maintain, and fully protect their homes. We offer differentiated products and services, with homeowners insurance at the center of this relationship. We differentiate and look to win in the massive and growing homeowners insurance opportunity by 1) providing the best services for homebuyers 2) led by advantaged underwriting in insurance 3) to protect the whole home As a leader in the home services software-as-a-service (“SaaS”) space, we’ve built deep relationships with approximately 30 thousand companies that are key to the home-buying transaction, such as home inspectors, mortgage companies, and title companies. In 2020, Porch Group rang the Nasdaq bell and began trading under the ticker symbol PRCH. We are looking to build a truly great company and are JUST GETTING STARTED. Job Title: Senior Database Engineer Location: India Workplace Type: Remote Job Summary The future is bright for the Porch Group, and we'd love for you to be a part of it as our Senior Database Engineer with the Data team . Porch Group is looking for an experienced Senior Database Engineer/ Senior Database Architect to design, implement, and manage our data architectures and database platforms across GCP and Azure. You will collaborate with software, systems, and DevOps engineers, in partnership with business, analytics, software, and data science teams, to influence the architecture of our key data platforms while balancing operational excellence, security, reliability, performance efficiency, and cost optimization. In this role, you will contribute to our technology roadmap and architectural improvements to our InfoSec, data platform, and disaster recovery/business continuity plans, support strategic data migration and modernization initiatives, and own the day-to-day operations, tuning, and optimization of our production database systems. What You Will Do As A Senior Database Engineer Collaborate with software, systems, and DevOps engineers in designing and implementing data architectures and data computing platforms in partnership with business, analytics, software, and data science teams. Influence the architecture of our key data platforms while balancing operational excellence, security, reliability, performance efficiency, and cost optimization. Contribute to our technology roadmap and implement architectural improvements to our InfoSec, data platform, and disaster recovery/business continuity plans. Contribute to strategic projects by migrating or transforming data stores in support of new project requirements. Support day-to-day operations of our data systems and information security initiatives and projects; define, sustain, and implement data engineering processes and best practices; tune, maintain, and optimize production systems. Build and maintain a self-healing database platform using AI-based observability and monitoring tools (e.g., native cloud-provider monitoring, or equivalent). Support our initiatives for modernizing/centralizing our database footprint in partnership with business, analytics, software, InfoSec, and data science teams. Provide support to the engineering team on database operations (SQL Server, PostgreSQL), including writing and tuning SQL scripts, creating database objects, and troubleshooting performance and connectivity issues. Manage, patch, upgrade and monitor PostgreSQL and SQL Server databases running on GCP (Cloud SQL) and Azure (Azure Database for PostgreSQL and Azure SQL Database / SQL Server on Azure VMs), including backup, recovery, and high-availability/disaster-recovery configuration. Design, manage, and monitor our BigQuery data warehouse in GCP, including schema design, query optimization, and cost/slot management. Implement Infrastructure as Code (IaC) using Terraform. Support CI/CD workflows for database changes, ADF pipelines, and infrastructure deployments (e.g., Git, A