DataArt Solutions, Inc
Senior Database Administrator (DBA)
DataArt Solutions, Inc, Snowflake, Arizona, United States, 85937
Client
Our client is a leading global travel agency network specializing in luxury and experiential journeys.
Position Overview This role requires a hands‑on technical leader with deep experience in SQL Server administration, automation, and Azure‑native migrations. The DBA will provide operational support while driving key strategic initiatives for 2026.
Responsibilities
Oversee the health, performance, and availability of all SQL Server and Snowflake databases.
Implement proactive monitoring for warehouse performance, resource consumption, and credit usage (Snowflake).
Configure, tune, and troubleshoot SQL Server Agent jobs, indexes, and partitions.
Manage and monitor backup integrity, recovery jobs, and log shipping.
Manage user accounts, roles, and permissions across SQL Server and Snowflake.
Ensure role‑based access control (RBAC) is enforced consistently.
Audit and maintain compliance for handling of sensitive/PII data.
Align database access policies with organizational security standards and ISO 27001 practices.
Manage and troubleshoot FiveTran connections and integrations.
Work closely with Data Engineering teams to optimize ingestion pipelines into SQL and Snowflake.
Support cross‑platform connectivity and reporting tools (Grafana, DataDog, Power BI).
Conduct in‑depth query performance analysis using execution plans and DMVs.
Optimize indexing strategies, partition schemes, and statistics maintenance.
Identify and resolve blocking, deadlocks, and high‑cost queries.
Develop automation scripts (PowerShell, T‑SQL, Python) to reduce manual intervention.
Standardize deployment of database schema, objects, and configurations using IaC principles.
Document repeatable processes and maintain runbooks for operational continuity.
Requirements
10+ years as a Database Administrator with deep expertise in SQL Server 2012–2019/2022.
Proven experience migrating large‑scale databases from IaaS SQL to Azure SQL Managed Instances / Azure SQL Database.
Hands‑on knowledge of high‑availability SQL configurations (AlwaysOn Availability Groups, Failover Clusters, Log Shipping, Replication).
Strong performance tuning skills: indexing strategies, query plan analysis & optimization, tempDB and transaction log management, deadlock detection/resolution.
Deep understanding of backup and disaster recovery strategies (full/differential/log backups, point‑in‑time recovery, geo‑redundant backups).
Scripting and automation expertise with T‑SQL, PowerShell, and IaC tooling (Bicep, ARM, Terraform preferred).
Familiarity with data pipeline tools (FiveTran, ETL/ELT platforms) and integration troubleshooting.
Excellent documentation skills for runbooks, migration plans, and incident reviews.
Nice to have
Experience with Azure Database Migration Service (DMS) and Azure‑native monitoring (Log Analytics, DataDog).
Background in BCDR planning and ISO 27001/SOC2 compliance alignment.
Prior experience in cloud‑native modernization efforts (legacy to PaaS migrations).
Strong collaboration skills to partner with Data Engineering, SRE, and Security teams.
Experience with Snowflake administration: warehouse management, RBAC implementation, monitoring and credit optimization, supporting data sharing and secure cleanroom use cases.
We offer Vacation: As per the laws of your country. We do ask you to take a proper rest.
Health insurance: We help you to take out an insurance policy for you and your loved ones.
Sick pay: According to the official calendar, regardless of the client’s schedule.
Pleasant environment: Two large corporate parties and many small get‑togethers for colleagues.
Comfort service: Solving technical and everyday problems at work.
The benefits package may vary depending on the region and the type of contract.
#J-18808-Ljbffr
Position Overview This role requires a hands‑on technical leader with deep experience in SQL Server administration, automation, and Azure‑native migrations. The DBA will provide operational support while driving key strategic initiatives for 2026.
Responsibilities
Oversee the health, performance, and availability of all SQL Server and Snowflake databases.
Implement proactive monitoring for warehouse performance, resource consumption, and credit usage (Snowflake).
Configure, tune, and troubleshoot SQL Server Agent jobs, indexes, and partitions.
Manage and monitor backup integrity, recovery jobs, and log shipping.
Manage user accounts, roles, and permissions across SQL Server and Snowflake.
Ensure role‑based access control (RBAC) is enforced consistently.
Audit and maintain compliance for handling of sensitive/PII data.
Align database access policies with organizational security standards and ISO 27001 practices.
Manage and troubleshoot FiveTran connections and integrations.
Work closely with Data Engineering teams to optimize ingestion pipelines into SQL and Snowflake.
Support cross‑platform connectivity and reporting tools (Grafana, DataDog, Power BI).
Conduct in‑depth query performance analysis using execution plans and DMVs.
Optimize indexing strategies, partition schemes, and statistics maintenance.
Identify and resolve blocking, deadlocks, and high‑cost queries.
Develop automation scripts (PowerShell, T‑SQL, Python) to reduce manual intervention.
Standardize deployment of database schema, objects, and configurations using IaC principles.
Document repeatable processes and maintain runbooks for operational continuity.
Requirements
10+ years as a Database Administrator with deep expertise in SQL Server 2012–2019/2022.
Proven experience migrating large‑scale databases from IaaS SQL to Azure SQL Managed Instances / Azure SQL Database.
Hands‑on knowledge of high‑availability SQL configurations (AlwaysOn Availability Groups, Failover Clusters, Log Shipping, Replication).
Strong performance tuning skills: indexing strategies, query plan analysis & optimization, tempDB and transaction log management, deadlock detection/resolution.
Deep understanding of backup and disaster recovery strategies (full/differential/log backups, point‑in‑time recovery, geo‑redundant backups).
Scripting and automation expertise with T‑SQL, PowerShell, and IaC tooling (Bicep, ARM, Terraform preferred).
Familiarity with data pipeline tools (FiveTran, ETL/ELT platforms) and integration troubleshooting.
Excellent documentation skills for runbooks, migration plans, and incident reviews.
Nice to have
Experience with Azure Database Migration Service (DMS) and Azure‑native monitoring (Log Analytics, DataDog).
Background in BCDR planning and ISO 27001/SOC2 compliance alignment.
Prior experience in cloud‑native modernization efforts (legacy to PaaS migrations).
Strong collaboration skills to partner with Data Engineering, SRE, and Security teams.
Experience with Snowflake administration: warehouse management, RBAC implementation, monitoring and credit optimization, supporting data sharing and secure cleanroom use cases.
We offer Vacation: As per the laws of your country. We do ask you to take a proper rest.
Health insurance: We help you to take out an insurance policy for you and your loved ones.
Sick pay: According to the official calendar, regardless of the client’s schedule.
Pleasant environment: Two large corporate parties and many small get‑togethers for colleagues.
Comfort service: Solving technical and everyday problems at work.
The benefits package may vary depending on the region and the type of contract.
#J-18808-Ljbffr