Database Administrator

Job Description

Job Summary: We are seeking an experienced and detail-oriented Database Administrator (DBA) with robust expertise in Microsoft SQL Server (T-SQL) , Azure SQL Database , and Microsoft Fabric (Power Platform) . The ideal candidate will be responsible for architecting, implementing, securing, and optimizing enterprise-grade, cloud-first data platforms that span on-premises and Azure environments. This role ensures seamless data flow across the organization, supports BI/reporting teams, and implements best-in-class practices for performance, compliance, and high availability. Expanded Key Responsibilities: Configure and maintain SQL Server (on-prem & Azure SQL) , Microsoft Fabric components (Data Factory, Data Lake, OneLake, Power BI). Develop and optimize complex T-SQL scripts , stored procedures, views, triggers, UDFs across hybrid environments. Build and maintain pipelines, semantic models, dataflows, and lakehouses within the Fabric workspace. Design and implement robust backup, failover, disaster recovery strategies using Azure-native tools like Azure Backup, Geo-replication, and Azure Site Recovery . Monitor and optimize database performance (I/O, indexing, execution plans) using Query Store, SQL Insights, Log Analytics , and Azure Monitor . Implement role-based access control (RBAC) and Azure AD integration for managing identities and permissions securely. Perform migrations from on-prem SQL Server to Azure SQL DB / Azure Managed Instance using tools like DMA, DMS . Ensure replication and synchronization across environments using tools like Azure Data Sync, PolyBase, or Fabric pipelines . Enable CI/CD for database deployments using Azure DevOps . Collaborate with cross-functional teams to build data integration solutions using Power Query, Data Factory (ADF), Synapse Pipelines, or Fabric pipelines . Document architecture, security policies, performance tuning techniques, and backup standards. Ensure compliance with enterprise data governance, data retention, and regulatory requirements . Required Qualifications: Bachelor's degree in Computer Science, Information Technology or related discipline. 5+ years of hands-on experience as a DBA, including significant exposure to T-SQL , SSMS , and SQL Server 2019 or later . Solid knowledge of Microsoft Fabric components and how they interoperate with the Power Platform ecosystem. Experience with Azure SQL Database , Azure Managed Instance , and Data Lake (Gen2/OneLake) . Deep understanding of RDBMS design , data normalization, and performance tuning techniques. Strong experience with HA/DR mechanisms such as Always On Availability Groups , Log Shipping , and Azure Failover Groups . Proficient in monitoring and diagnostics tools such as SQL Profiler, Extended Events, Azure Log Analytics , and Query Performance Insight . Experience in implementing data privacy, encryption (TDE, Always Encrypted), firewall rules, and security auditing . Preferred Skills and Tools Proficiency in Azure Data Factory (ADF) , Azure Synapse , or Power BI Dataflows . Familiarity with Microsoft Purview for data lineage and governance. Hands-on with CI/CD pipelines for SQL using Azure DevOps YAML . Understanding of Fabric workspace administration , capacity planning , and security roles . Knowledge of NoSQL/Azure Cosmos DB is a plus. Hands-on experience with monitoring solutions like Grafana or Prometheus (for hybrid setups) . Exposure to Python/PowerShell scripting for automation. Experience with ERP integrations and third-party data replication tools like Fivetran, BryteFlow, or Qlik Replicate .