Sr Database Engineer
Porch Group
IndiaremotePosted 1 month ago
Skill Required
Senior-Database-EngineerDatabase-EngineerDatabase-AdministratorData-EngineerDatabase-ArchitectSenior-Database-EngineeringSenior-Database-ArchitectSenior-Database-Reliability-EngineerSenior-Database-DeveloperSQL-Database-EngineerSenior-Database-AdministratorQuery OptimizationBackup and Recoverydata engineeringData StructurestroubleshootingObservabilityAzurePostgreSQLSQL ServerEngineeringTerraformdesigninganalyticsBigQuerysecuritywrittenCybersecuritydesignDevOpsCI/CDAgileCloudjQueryInformaticaLinuxFulltime
Key highlights
- Salary range: ₹2,475,000 – ₹3,465,000 INR annually
- Level Required: 8+ years in data engineering and/or database administration
- Key benefit: Medical insurance, accident insurance and retirement benefits
- Notable requirement: Bachelor's degree in Computer Science, Information Systems, or Systems Engineering (or equivalent experience)
Role overview
Porch Group, a leading vertical software and insurance platform, is seeking a Senior Database Engineer to design, implement, and manage its data architectures and database platforms across Google Cloud Platform and Microsoft Azure. The role involves collaborating with cross‑functional teams to improve security, reliability, performance, and cost efficiency while driving strategic initiatives such as disaster recovery, data migration, and AI‑enabled data solutions.
Responsibilities
- 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 key data platforms while balancing operational excellence, security, reliability, performance efficiency, and cost optimization.
- Contribute to the technology roadmap and implement architectural improvements to InfoSec, data platform, and disaster recovery/business continuity plans.
- Contribute to strategic projects by migrating or transforming data stores to meet new project requirements.
- Support day‑to‑day operations of data systems and information security initiatives; 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.
- Support initiatives for modernizing and centralizing the database footprint 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 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 the BigQuery data warehouse in GCP, covering 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, Azure DevOps).
Requirements
- Bachelor's degree in Computer Science, Information Systems, or Systems Engineering (or equivalent experience)
- 8+ years of experience in data engineering and/or database administration with hands‑on ownership of production database platforms
- Demonstrated proficiency in creating data structures and a strong understanding of technical design principles
- Hands‑on experience with BigQuery, Compute Engine, and Cloud SQL (PostgreSQL and SQL Server) in GCP
- Hands‑on experience with Azure Database for PostgreSQL, Azure SQL Database, and/or SQL Server on Azure VMs
- Experience with database high availability, disaster recovery, backup/restore, and performance tuning (e.g., Always On Availability Groups, point‑in‑time recovery, replication)
- Working knowledge of version control and CI/CD tooling (Git, Azure DevOps, Cloud Build)
- Working knowledge of Azure Data Factory, SSIS/SSRS in Azure, and Dataflow/Dataproc in GCP
- Ability to effectively communicate with various stakeholders and partners
- Proven experience working with US‑based business teams
- Excellent written and verbal communication skills in English
- Ability to work within core US business hours/timezone expectations (Eastern Standard Time overlap)
- Quiet, dedicated workspace and reliable internet connection with a minimum speed of 50 Mbps
Nice to have
- Experience supporting AI/ML platforms and integrating AI‑powered data tools
- Preference for a Bachelor's degree in Computer Science, Information Systems, or Systems Engineering (or equivalent experience)
- Proven experience working with US‑based business teams
Benefits
- Medical insurance, accident insurance, and retirement benefits
- 12 company‑paid holidays
- 2 flexible holidays plus earned leave
- Casual/sick leave and paid maternity and paternity leaves
- Weekly wellness events
- Comprehensive coverage for health, life, and financial wellbeing
Additional details
- Undefined line after "Support CI/CD workflows..." appears to be extraneous and omitted
- Original posting location: Himalayas