Senior Cloud DBA

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.

Scope

• On-premises SQL Server and Azure SQL Managed Instance environments
• Cloud-native database platforms: PostgreSQL, Snowflake, Databricks
• Cloud migration planning, execution, and optimization
• Database security, access controls, auditing, and compliance
• DevOps practices: CI/CD pipelines, Infrastructure as Code, and automation
• High availability, disaster recovery, and database reliability engineering

ESSENTIAL DUTIES and RESPONSIBILITIES, includes the following responsibilities, but not limited to:

Cloud Migration & On-Premises MSSQL Administration

• 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

Cloud-Native Database Management

• 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

Security, High Availability & Disaster Recovery

• 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

DevOps, Automation & Deployment

• 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

REQUIRED QUALIFICATIONS:

• 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