Database Administrator

Database Administrator -Hybrid SQL
Server, Azure SQL PaaS & Databricks

Key Responsibilities
- Administer, monitor, and maintain on-premises SQL Server instances, including
installation, patching, configuration, security, backup/restore, and disaster recovery.
- Manage Azure SQL PaaS environments (Azure SQL Database and Azure SQL Managed
Instance), including provisioning, scaling, geo-replication, failover groups, and cost
optimization.
- Support and administer Azure Databricks workspaces, including cluster configuration,
access control (Unity Catalog), job scheduling, and integration with data sources.
- Develop, troubleshoot, and optimize Azure Data Factory (ADF) pipelines, including
linked services, datasets, integration runtimes, and triggers.
- Maintain and troubleshoot SQL Server Integration Services (SSIS) packages, including
those deployed to the SSIS Integration Runtime in Azure.
- Perform performance tuning across all platforms - query optimization, indexing
strategy, execution plan analysis, and resource governance.
- Implement and enforce database security, encryption, auditing, and compliance
standards across on-prem and cloud environments.
- Establish and maintain high availability and disaster recovery solutions (Always On
Availability Groups, log shipping, geo-replication).
- Monitor data pipelines and database health, set up alerting, and respond to incidents to
meet SLAs.
- Collaborate with data engineers, developers, and analysts to support data integration,
migration, and modernization initiatives.
- Automate routine administrative tasks using PowerShell, T-SQL, and Azure automation
tooling.
- Document architecture, processes, runbooks, and standards.

Required Technical Skills
SQL Server (On-Premises)
- Strong administration experience with SQL Server 2016 and later (installation,
upgrades, patching, configuration).
- Backup and recovery strategies, point-in-time restore, and DR planning.
- High availability: Always On Availability Groups, failover clustering, and log shipping.
- Performance tuning: query optimization, indexing, statistics, execution plans, and waitstatistics analysis.
- Security administration: logins, roles, permissions, TDE, and auditing.
- Proficiency in T-SQL development and scripting.
Azure SQL PaaS
- Hands-on experience with Azure SQL Database and Azure SQL Managed Instance.
- Provisioning, scaling (DTU and vCore models), and serverless/elastic pool
configuration.
- Geo-replication, auto-failover groups, and PaaS backup/restore.
- Cost monitoring and optimization for cloud database workloads.
- Azure networking fundamentals: VNets, private endpoints, and firewall rules.
- Familiarity with Azure Monitor, Log Analytics, and database advisors.
Azure Databricks
- Administration of Databricks workspaces, clusters, and pools.
- Access governance with Unity Catalog, and integration with Azure Active Directory
(Entra ID).
- Job and workflow scheduling, and monitoring of Spark workloads.
- Working knowledge of Spark SQL, Python (PySpark), and Delta Lake concepts.
- Integration of Databricks with Azure Data Lake Storage and other data sources.
Azure Data Factory (ADF) & SSIS
- Development experience building and modifying ADF pipelines - linked services,
datasets, activities, parameters, and triggers.
- Troubleshooting pipeline failures: monitoring runs, debugging activities, analyzing error
output, and reviewing integration runtime health.
- Configuring and managing self-hosted and Azure integration runtimes.
- Developing, deploying, and troubleshooting SSIS packages, including the SSIS
Integration Runtime in Azure (lift-and-shift).
- Data Flow / Mapping Data Flow development and incremental/CDC load patterns.
- CI/CD for ADF using ARM templates or Git integration.
General & Automation
- Scripting and automation with PowerShell and Azure CLI.
- Infrastructure-as-code familiarity (ARM templates, Bicep, or Terraform) is a plus.
- Source control with Git/Azure DevOps and basic CI/CD pipeline concepts.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.