07 Aug
|
Accion Labs
|
Hyderabad
07 Aug
Accion Labs
Hyderabad
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)
Robust 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 wait statistics 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.
📌 Immediate Opportunity For DBA (Hyderabad)
🏢 Accion Labs
📍 Hyderabad