Intapp
Intapp
1,001 – 5,000 Employees
H1B Visa SponsorConsultingLegalSaaS
Intapp develops AI-powered, cloud-based software for professional and financial services firms worldwide. Its products support accounting, consulting, investment banking, legal, private capital, and real estate organizations with tools for client relationship management, operational efficiency, compliance, collaboration, and deal management. Solutions such as Intapp DealCloud and Intapp Compliance use data intelligence, automation, Microsoft Azure integration, and security-focused technology to help more than 2,600 client firms manage complex workflows and pursue growth.

Database Engineer – SQL Server and Snowflake

Operate Intapp’s Azure SQL Server and Snowflake platforms supporting cloud products. Manage availability, performance, security, automation, and incident response.

Description

  • Join the U.S. time zone on-call rotation and respond to database incidents
  • Mitigate incidents and lead investigations into their root causes
  • Keep operational runbooks up to date
  • Operate a multi-region SQL Server fleet on Azure virtual machines using Always On availability groups
  • Plan capacity and balance workloads
  • Administer Snowflake accounts, warehouses, role-based access, secure data sharing, and cost monitoring
  • Plan and deliver production changes through established change management
  • Carry out after-hours maintenance, including cumulative updates, major upgrades, failovers, and scaling
  • Diagnose performance problems using wait statistics, execution plans, and Query Store
  • Collaborate with product engineering on query and schema design
  • Coordinate with Microsoft and Snowflake support on database engine issues
  • Maintain high availability, disaster recovery, and security controls
  • Manage backup and restore, recovery exercises, transparent data encryption, key rotation, Microsoft Entra ID authentication, private endpoints, and least-privilege access
  • Automate provisioning and operations with Terraform, PowerShell, and Python in CI/CD pipelines
  • Create SQL Server and Snowflake monitoring with Grafana and OpenTelemetry
  • Use AI tools in daily work and help develop database operations tooling, including MCP servers

Requirements

  • At least five years of hands-on production experience as a SQL Server DBA or database engineer
  • Experience providing on-call support for systems operating around the clock
  • In-depth understanding of Always On availability groups and Windows Server Failover Clustering
  • Knowledge of synchronization modes, failover behavior, and troubleshooting
  • Strong understanding of backup, restore, and recovery models
  • Experience designing and testing disaster recovery
  • SQL Server performance tuning skills, including wait statistics, execution plans, Query Store, indexing, and blocking analysis
  • A methodical, evidence-based approach to troubleshooting and root cause analysis
  • Experience operating SQL Server on Azure, including virtual machines, storage, virtual networks, private endpoints, Azure Key Vault, and Microsoft Entra ID
  • Availability during U.S. business hours, for an on-call rotation, and during after-hours maintenance windows
  • Clear spoken and written English
  • Snowflake administration experience is preferred
  • Terraform and PowerShell or Python scripting experience is preferred
  • Experience with recent SQL Server versions and features is preferred
  • Experience with Azure DevOps, Grafana, OpenTelemetry, and PagerDuty is preferred
  • Experience with AI engineering tools or MCP servers is preferred
  • Microsoft Certified: Azure Database Administrator Associate (DP-300) or Snowflake SnowPro certification is preferred
  • Experience supporting compliance requirements in highly regulated industries is preferred

Benefits

  • Professional development opportunities
  • Reimbursement for training and continuing education
  • Complimentary lunches
  • Fully stocked kitchens
  • Wellness programs
  • Flexible time off programs
  • Family formation benefits
  • Paid volunteer time off
  • Donation matching program
  • Modern, open work environment
  • Flexible work environment
  • Positive, open, collaborative culture

Related Jobs