Database Administrator

Job Summary:

Microsoft SQL Server (T-SQL)

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

  .