Job Description
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
- Proficiency in database security, encryption, auditing, and performance tuning
Preferred Qualifications
- 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
Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru