Under the direct supervision of the Data & Analytics Platforms Director, the Senior Database Administrator manages and maintains the Firm's enterprise Microsoft SQL Server environment and Azure Data storage including Fabric, Cosmos, Azure SQL and Postgres SQL. Ensuring secure, reliable, and high-performing data systems that support core firm operations, reporting and AI initiatives.
Principal Duties and Responsibilities:
- Administer, monitor, and tune the Firm's enterprise Microsoft SQL Server environment (on-premises and/or Azure), including performance tuning, indexing, and query optimization.
- Design, implement, and maintain high availability and disaster recovery solutions (Always On Availability Groups, replication, log shipping) for mission-critical, 24/7 production systems.
- Administer and right-size Microsoft Fabric capacity (F-SKU), monitoring utilization and cost, and recommending capacity tier changes based on actual usage data.
- Own the Lakehouse (Bronze, Silver, Gold layers), Warehouse, and OneLake storage, including Delta table maintenance, schema evolution, and Lakehouse, Warehouse shortcut configuration.
- Administer Azure AI Search indexes and Azure OpenAI/Microsoft Foundry configuration supporting the Firm's knowledge search and agentic AI platform.
- Implement and audit row-level security, iManage ACL ingestion, and ethical-wall enforcement across firm data and knowledge platforms.
- Manage database security, including logins, roles, encryption (TDE), and audit compliance aligned to Firm and legal-industry data governance standards.
- Monitor Azure consumption against budget and recommend cost optimization strategies (reserved vs. pay-as-you-go, pausing idle capacity, right-sizing).
- Act as the Firm's internal technical point of contact during vendor-led implementation phases, validating deliverables against agreed architecture and security requirements.
- Collaborate with Practice Systems, Knowledge Management, and Information Security teams to ensure compliance with data governance, security, privacy, and data quality standards.
- Maintain documentation of data architecture, ingestion patterns, and release processes to support knowledge transfer and audit readiness.
Under the direct supervision of the Data & Analytics Platforms Director, the Senior Database Administrator manages and maintains the Firm's enterprise Microsoft SQL Server environment and Azure Data storage including Fabric, Cosmos, Azure SQL and Postgres SQL. Ensuring secure, reliable, and high-performing data systems that support core firm operations, reporting and AI initiatives.
Principal Duties and Responsibilities:
- Administer, monitor, and tune the Firm's enterprise Microsoft SQL Server environment (on-premises and/or Azure), including performance tuning, indexing, and query optimization.
- Design, implement, and maintain high availability and disaster recovery solutions (Always On Availability Groups, replication, log shipping) for mission-critical, 24/7 production systems.
- Administer and right-size Microsoft Fabric capacity (F-SKU), monitoring utilization and cost, and recommending capacity tier changes based on actual usage data.
- Own the Lakehouse (Bronze, Silver, Gold layers), Warehouse, and OneLake storage, including Delta table maintenance, schema evolution, and Lakehouse, Warehouse shortcut configuration.
- Administer Azure AI Search indexes and Azure OpenAI/Microsoft Foundry configuration supporting the Firm's knowledge search and agentic AI platform.
- Implement and audit row-level security, iManage ACL ingestion, and ethical-wall enforcement across firm data and knowledge platforms.
- Manage database security, including logins, roles, encryption (TDE), and audit compliance aligned to Firm and legal-industry data governance standards.
- Monitor Azure consumption against budget and recommend cost optimization strategies (reserved vs. pay-as-you-go, pausing idle capacity, right-sizing).
- Act as the Firm's internal technical point of contact during vendor-led implementation phases, validating deliverables against agreed architecture and security requirements.
- Collaborate with Practice Systems, Knowledge Management, and Information Security teams to ensure compliance with data governance, security, privacy, and data quality standards.
- Maintain documentation of data architecture, ingestion patterns, and release processes to support knowledge transfer and audit readiness.
Job Specifications:
- 6 - 8 years of progressive database administration experience, including strong hands-on Microsoft SQL Server expertise (installation, configuration, patching, upgrades, T-SQL, indexing, query tuning).
- Proven experience with HA/DR design (Always On Availability Groups, replication) and backup/recovery strategy for mission-critical production systems.
- Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, OneLake, Data Factory/Dataflows Gen2) or equivalent modern platforms (Databricks, Synapse, Snowflake).
- Experience with Azure Data platforms, infrastructure, and cloud cost/capacity management.
- Solid understanding of data security relevant to sensitive and privileged content, including row-level security, ACL-based access control, and encryption at rest and in transit.
- Experience with Infrastructure as Code (Terraform preferred) for Azure environment provisioning.
- Familiarity with Azure AI Search, Azure OpenAI/Microsoft Foundry, or other RAG/agentic AI implementations preferred.
- Excellent written and verbal communication skills; comfortable acting as the technical point of contact with external vendors, IT leadership, and attorney stakeholders.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- Legal industry experience preferred; direct experience with iManage and/or Aderant strongly preferred.
Attendance Requirements: On site during normal working hours and available as necessary before or after normal working hours.
Job Specifications:
- 6 - 8 years of progressive database administration experience, including strong hands-on Microsoft SQL Server expertise (installation, configuration, patching, upgrades, T-SQL, indexing, query tuning).
- Proven experience with HA/DR design (Always On Availability Groups, replication) and backup/recovery strategy for mission-critical production systems.
- Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, OneLake, Data Factory/Dataflows Gen2) or equivalent modern platforms (Databricks, Synapse, Snowflake).
- Experience with Azure Data platforms, infrastructure, and cloud cost/capacity management.
- Solid understanding of data security relevant to sensitive and privileged content, including row-level security, ACL-based access control, and encryption at rest and in transit.
- Experience with Infrastructure as Code (Terraform preferred) for Azure environment provisioning.
- Familiarity with Azure AI Search, Azure OpenAI/Microsoft Foundry, or other RAG/agentic AI implementations preferred.
- Excellent written and verbal communication skills; comfortable acting as the technical point of contact with external vendors, IT leadership, and attorney stakeholders.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- Legal industry experience preferred; direct experience with iManage and/or Aderant strongly preferred.
Attendance Requirements: On site during normal working hours and available as necessary before or after normal working hours.