Senior Associate - Data Base Administrator (Fabric)

Oaktree Capital Management, part of Brookfield’s $416 billion credit platform, is seeking an experienced SQL Server DBA/Microsoft Fabric Administrator to join our Data Platform team. This hybrid role involves managing the health, performance, and governance of our Microsoft SQL Server environment while also overseeing the design, deployment, and administration of our Microsoft Fabric data platform. The position requires collaboration with data engineering, analytics, and compliance teams to deliver secure, high-performance data services at an enterprise scale. The role includes rotational shifts with a two-week cycle, including night shifts.

Key Responsibilities

- Install, configure, patch, and upgrade SQL Server instances (2016–2022) across development, UAT, and production environments.
- Design and maintain high-availability solutions such as Always On Availability Groups and Failover Cluster Instances.
- Monitor and optimize query performance using execution plans, DMVs, Query Store, and Extended Events.
- Support backup and recovery strategies, ensuring compliance with RTO/RPO objectives and conducting disaster recovery drills.
- Implement and enforce database security measures including logins, roles, row-level security, Transparent Data Encryption (TDE), and audit policies.
- Administer SQL Server Agent jobs, SSIS packages, and linked servers.
- Collaborate with developers on schema changes, stored procedures, and deployment scripts.
- Participate in on-call rotation for production support.
- Manage Microsoft Fabric tenant settings, capacity provisioning, workspace governance, and security compliance.
- Oversee Fabric capacity (F-SKU) provisioning, auto-scaling, cost optimization, and monitor compute unit utilization.
- Enable and govern Copilot functionality within Fabric, including tenant settings, security group scoping, phased rollout, and cross-geo compliance.
- Provision and manage Fabric workspaces, lakehouses, warehouses, and data pipelines, enforcing naming conventions and role-based access control (RBAC).
- Administer Power BI Premium/Fabric capacity components such as semantic models, dataflows Gen2, gateways, and report deployment pipelines.
- Configure and manage Fabric Data Agents, AI Skills, and Real-Time Intelligence workloads.
- Integrate Fabric with Azure Data Lake Storage Gen2, Azure DevOps CI/CD pipelines, and Microsoft Purview for data cataloging and lineage.
- Maintain Fabric audit logs, sensitivity label compliance, and information protection policies.

Required Qualifications

- Extensive experience with SQL Server (2016, 2019, 2022), including SSMS, SSRS, SSIS, SQL Agent, and Azure SQL Databases.
- Hands-on experience with Power BI Service administration, including tenant settings and organizational policies.
- Familiarity with Microsoft Fabric and its core components such as OneLake, Data Factory, and Power BI.
- Proven ability to manage Fabric workspaces and deployment policies.
- Strong understanding of data governance principles, including data classification, security, access control, data quality, and compliance.
- In-depth knowledge of Power BI security models, including Row-Level Security (RLS) and Object-Level Security (OLS).
- Exposure to dbt, Apache Spark, or PySpark within Fabric notebooks.
- Experience with cloud migration and hybrid cloud environments involving SQL Server and Azure SQL.
- Familiarity with DevOps practices and CI/CD pipelines related to database and Power BI changes.
- Experience with high availability architectures, clustering, and disaster recovery planning.
- Comfortable using tools such as Confluence and Jira.

Preferred Qualifications and Benefits

- Knowledge of Azure SQL PaaS services, Managed Instances, and Azure SQL Hyperscale is preferred.
- Bachelor’s degree in computer science, information technology, business administration, finance, or a related field from a reputable institution.
- Oaktree fosters a collaborative, inclusive culture that values diversity of thought and offers career development opportunities. The company supports local communities through philanthropic initiatives and emphasizes a strong ethical work environment.
- The role offers a hybrid work model with flexibility and exposure to cutting-edge data platform technologies within a leading global investment firm.

Oaktree is an equal opportunity employer committed to diversity and inclusion. Employment decisions are made without regard to race, ethnicity, gender identity, sexual orientation, disability, veteran status, or any other protected classification under applicable laws. The firm also considers qualified applicants with a criminal history in compliance with local regulations where applicable.