Senior Cloud DBA

CMG Financial

4d•Remote

About The Position

CMG Financial is hiring a Senior Cloud DBA who leads the lifecycle management of enterprise database platforms spanning on-premises SQL Server, Azure SQL, and cloud-native services including PostgreSQL, Snowflake, and Databricks. This role owns database availability, security, and performance across hybrid and multi-cloud environments, balancing operational excellence with strategic cloud migration and DevOps-driven automation.

Requirements

5+ years in database administration with strong SQL Server and Azure SQL expertise
Proven experience migrating databases from on-premises to cloud environments
Hands-on with Always On Availability Groups, DAGs, and SQL Server HA features
Working knowledge of at least one cloud-native platform: Snowflake, Databricks, or PostgreSQL
Experience building CI/CD pipelines and managing Infrastructure as Code (Terraform, ARM, Bicep)
Strong scripting skills in Python, PowerShell, or Bash
Proficiency in database security, encryption, auditing, and performance tuning

Nice To Haves

Experience in regulated industries (financial services, healthcare, or similar)
Deep Snowflake administration: warehouse management, data sharing, cost optimization
Databricks experience: Unity Catalog, Delta Lake, Lakehouse architecture, Spark tuning
PostgreSQL expertise: streaming/logical replication, partitioning, concurrency optimization
Familiarity with monitoring platforms (Grafana, Datadog, ELK) and Microsoft Fabric
Relevant certifications: DP-300, SnowPro, Databricks Certified, or equivalent

Responsibilities

Migrate on-premises SQL Server databases to Azure SQL Managed Instance with minimal downtime and optimized configurations
Evaluate and recommend target platforms (Azure SQL, PostgreSQL, Snowflake, Databricks) based on workload characteristics
Perform routine maintenance on SQL Server instances including index optimization, statistics updates, integrity checks, and performance tuning
Manage Byte database upgrades and lower environment refreshes with production data
Conduct query optimization, execution plan analysis, and workload profiling
Administer Azure SQL databases including elastic pools, serverless tiers, and geo-replication
Manage PostgreSQL deployments including replication (logical/streaming), backup/recovery, partitioning, and index strategies
Administer Snowflake platform: roles, permissions, security policies, warehouse sizing, query optimization, and clustering
Support Databricks environments: cluster administration, Unity Catalog, Delta Lake/Lakehouse architecture, and Spark tuning
Implement Azure security measures including access controls, firewalls, Transparent Data Encryption, and auditing
Manage on-prem SQL Server security: user provisioning, role-based access, and vulnerability assessments
Enforce security policies and data governance across Snowflake, Databricks, and PostgreSQL
Configure and manage Distributed Availability Groups (DAGs) and Always On AGs with read-only intent for reporting
Design backup/recovery strategies and conduct DR testing across all platforms
Build and maintain CI/CD pipelines for database deployments using Azure DevOps, GitHub Actions, or Jenkins
Develop Infrastructure as Code (Terraform, ARM templates, Bicep) for provisioning database resources
Automate schema migrations, data refreshes, and validation workflows using Python, PowerShell, or Bash
Implement monitoring and alerting (Azure Monitor, Grafana, Datadog) for database health and performance
Manage version control of database schemas and migration scripts using Git
Provide DBA support for Byte DB Archive and address ad-hoc database requests