Database Engineer

INTEGRATION APPLIANCE, INC.; Illinois; Hybrid; USD 120.000 - 190.000; Vollzeit

Zusammenfassung

Intapp's Database Engineering team runs the database platforms behind Intapp cloud products and owns their health, performance, security, and availability across multiple Microsoft Azure regions. In this role, you'll work with SQL Server and Snowflake database engines, and you'll be a core part of the team's coverage in U.S.

time zones, including incident response and on-call. It's a hands-on engineering role: you'll investigate problems to root cause, automate repeatable work, and make

Qualifikationen

• 5+ years of hands-on production experience with SQL Server as a DBA or database engineer.
• Deep knowledge of Always On availability groups and Windows Server Failover Clustering.
• Backup, restore and disaster recovery experience.
• Evidence-based performance troubleshooting using wait statistics, execution plans, and Query Store.
• Experience running SQL Server on Azure (VMs, storage, VNet, Entra ID, Key Vault).
• Strong written and spoken English; able to coordinate across US/EU teams.

Aufgaben

• Take part in the U.S. time zone on-call rotation: respond to incidents and lead root cause analysis.
• Operate a multi-region SQL Server fleet on Azure VMs with Always On, and administer Snowflake accounts, warehouses, RBAC, secure data sharing, and cost monitoring.
• Plan and execute production changes through change management, including after-hours maintenance windows.
• Investigate performance problems to root cause using wait statistics, execution plans, and Query Store; collaborate with product engineering.
• Maintain high availability, disaster recovery, security controls including backup/restore, encryption, and key rotation.
• Automate provisioning and operations with Terraform, PowerShell, Python; build monitoring with Grafana and OpenTelemetry.

Kenntnisse

SQL Server DBA

On-call experience

Always On AG

Performance tuning

Snowflake admin

Terraform

PowerShell

Python

Grafana

OpenTelemetry

PagerDuty

Tools

Snowflake

Terraform

PowerShell

Python

Grafana

OpenTelemetry

PagerDuty

Jobbeschreibung

Intapp's Database Engineering team runs the database platforms behind Intapp cloud products and owns their health, performance, security, and availability across multiple Microsoft Azure regions. In this role, you'll work with SQL Server and Snowflake database engines, and you'll be a core part of the team's coverage in U.S. time zones, including incident response and on-call. It's a hands-on engineering role: you'll investigate problems to root cause, automate repeatable work, and make production changes safely.

What you will do

• Take part in the U.S. time zone on-call rotation: respond to incidents, drive mitigation, lead root cause analysis, and keep runbooks current
• Operate a multi-region SQL Server fleet on Azure virtual machines with Always On availability groups, including capacity planning and workload balancing, and administer Snowflake accounts, warehouses, role-based access, secure data sharing, and cost monitoring
• Plan and execute production changes through change management, including after-hours maintenance windows for cumulative updates, major version upgrades, failovers, and scaling
• Investigate performance problems to root cause using wait statistics, execution plans, and Query Store, partner with product engineering on query and schema design, and work with Microsoft and Snowflake support on engine-level issues
• Maintain high availability, disaster recovery, and security controls, including backup and restore, regular 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 through CI/CD pipelines, build SQL Server and Snowflake monitoring with Grafana and OpenTelemetry, and use AI tools daily while helping build AI tooling for database operations, such as Model Context Protocol (MCP) servers

What you will need

• 5+ years of hands-on production experience with SQL Server as a DBA or database engineer, including on-call support for systems that run around the clock
• Deep knowledge of Always On availability groups and Windows Server Failover Clustering, including synchronization modes, failover behavior, and troubleshooting
• Strong knowledge of backup, restore, and recovery models, with experience designing and testing disaster recovery
• Proven performance tuning skills (wait statistics, execution plans, Query Store, indexing, and blocking analysis) and an evidence-based approach to troubleshooting: forming hypotheses, proving them with data, and explaining root cause clearly
• Experience running SQL Server on Azure, including virtual machines and storage, virtual networks and private endpoints, Azure Key Vault, and Microsoft Entra ID
• Ability to work independently and make sound decisions during incidents when most of the team is offline, and to know when to elevate; availability for U.S. business hours, on-call rotation, and after-hours maintenance windows; and clear written and spoken English with a collaborative style across a team distributed over Europe and North America

Nice to have

• Hands-on Snowflake administration, including warehouses, role-based access control, secure data sharing, and cost monitoring
• Hands-on experience with Terraform and scripting in PowerShell or Python, and a habit of automating repeatable work
• Experience with recent SQL Server versions and features such as optimized locking, accelerated database recovery, and intelligent query processing
• Experience building CI/CD pipelines in Azure DevOps and working with Grafana, OpenTelemetry, and PagerDuty
• Experience using AI tools in engineering work, or building internal tooling such as MCP servers
• Microsoft Certified: Azure Database Administrator Associate (DP-300) or a Snowflake SnowPro certification, and experience supporting compliance requirements in highly regulated industries

What you will gain

At Intapp, you'll get the opportunity to bring your talents and intellectual curiosity to create better outcomes for our people and our clients. You'll be part of a growing public company, with a modern work environment that’s connected yet flexible and where your professional growth and well-being are top priorities. We'll collaborate and grow together, supporting each other in a positive, open atmosphere that fosters creativity, innovation, and teamwork. Here, you will have the opportunity to: Expand Your Skills: Unlock your potential with professional development opportunities supported by a community of experienced professionals. We offer reimbursement for training and continuing education to help you stay ahead in your career. Enjoy Where You Work: Thrive in our modern, open offices designed to inspire creativity and collaboration. Our complimentary lunches and fully stocked kitchens ensure you have everything you need to stay energized throughout the day. Support What Matters Most: Our comprehensive wellness and flexible time off programs and our benefits are designed to care for you and your family. Our family-formation benefits and support during your family-building journey ensure you have the resources you need when it matters most. We believe in giving back and supporting our communities with paid volunteer time off and a donation matching program for the causes you care about. Join us and be a part of a collaborative and welcoming culture where your contributions are valued, and your professional growth is a priority. Together, we are building a company of long-term value that we can all be proud of.

Company information

Intapp builds AI software to power the world’s top investment, legal, and consulting firms. Our clients face unique challenges: they must track and manage complex client relationships, navigate strict regulatory requirements, and manage sensitive deal information. We develop software specifically for these needs, helping firms find and win business, onboard clients safely and manage risk, deliver exceptional work, and capture full value. Intapp created Celeste, an agentic AI platform for professional firms that combines firm-specific context, workflow automation, and built-in compliance. Using prebuilt or custom agents, Celeste helps professionals execute critical workflows faster and more consistently while respecting proprietary knowledge, access controls, and regulatory requirements. It is designed to work within a firm's data, terminology, playbooks, and governance framework. Today, more than 2,700 firms worldwide rely on Intapp, including 95 of the Am Law 100, 16 of the top 20 accounting firms, and more than 1,700 private capital, investment banking, and real assets firms. Intapp has helped firms achieve measurable impact - from 25% more pitch opportunities to 55% faster client onboarding - turning intelligence into competitive advantage. Founded in 2000 and headquartered in Palo Alto, California, Intapp completed a successful IPO on June 30, 2021 (NASDAQ: INTA). Alongside a global ecosystem of partners, Intapp accelerates innovation and integration, ensuring our clients are always at the forefront of transformation.

Intapp provides equal employment opportunities to all qualified applicants and will make hiring decisions without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, political affiliation, or any other characteristic protected by federal, state or local laws.