Database Engineer

This is a fully remote position, open to applicants in North Carolina.

📋 Description

• Engage in the U.S. time zone on-call rotation and address incidents as they arise.

• Lead incident resolution efforts and conduct root cause analyses.

• Keep runbooks updated and relevant.

• Manage a multi-region SQL Server fleet hosted on Azure virtual machines utilizing Always On availability groups.

• Execute capacity planning and workload distribution.

• Oversee Snowflake accounts, warehouses, role-based access, secure data sharing, and monitor costs.

• Organize and implement production changes through a structured change management process.

• Carry out after-hours maintenance for cumulative updates, major version upgrades, failovers, and scaling activities.

• Analyze performance issues using wait statistics, execution plans, and Query Store data.

• Collaborate with product engineering on query and schema design.

• Liaise with Microsoft and Snowflake support regarding engine-level challenges.

• Ensure high availability, disaster recovery, and security protocols are maintained.

• Administer backup and restore processes, conduct recovery exercises, manage transparent data encryption, oversee key rotation, implement Microsoft Entra ID authentication, manage private endpoints, and enforce least-privilege access.

• Automate provisioning and operations using Terraform, PowerShell, and Python via CI/CD pipelines.

• Develop SQL Server and Snowflake monitoring solutions with Grafana and OpenTelemetry.

• Utilize AI tools on a daily basis and contribute to the development of AI tools for database operations, including MCP servers.

⛳️ Requirements

• Minimum of 5 years of hands-on experience in a production environment as a DBA or database engineer with SQL Server.

• Provide on-call support for systems operating continuously.

• In-depth understanding of Always On availability groups and Windows Server Failover Clustering.

• Familiarity with synchronization modes, failover behavior, and troubleshooting techniques.

• Profound knowledge of backup, restore, and recovery methodologies.

• Experience in designing and testing disaster recovery plans.

• Skills in performance tuning, encompassing wait statistics, execution plans, Query Store, indexing, and blocking analysis.

• Ability to perform evidence-based troubleshooting and root cause analysis.

• Experience running 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, participation in on-call rotation, and willingness to work during after-hours maintenance windows.

• Proficient in written and spoken English.

• Preferred experience in Snowflake administration.

• Preferred scripting experience with Terraform and PowerShell or Python.

• Preferred familiarity with recent SQL Server versions and features.

• Preferred experience with Azure DevOps, Grafana, OpenTelemetry, and PagerDuty.

• Preferred experience with AI engineering tools or MCP server.

• Preferred certification as Microsoft Certified: Azure Database Administrator Associate (DP-300) or Snowflake SnowPro.

• Preferred experience in supporting compliance requirements within highly regulated industries.

🏝️ Benefits

• Opportunities for professional development.

• Reimbursement for training and continuing education.

• Complimentary lunches provided.

• Fully stocked kitchens available.

• Wellness program offerings.

• Flexible time off policies.

• Family-formation support benefits.

• Paid time off for volunteer work.

• Donation matching initiatives.

• A modern, open workspace.

• Flexible work arrangements.

• A positive, open, and collaborative workplace culture.