Senior Database Administrator

Hamilton Lane•Conshohocken, PA

About The Position

Hamilton Lane is seeking a Senior Database Administrator to support its Cobalt private markets diligence and analytics platform and broader technology environment. The role works across data sources and processes, helping collect, control, and deliver data to internal and external technology solutions. The DBA will serve as the primary administrator for Snowflake and SQL Server, including Azure SQL Managed Instance and Managed Instance Pools, and may extend support to other critical systems as priorities evolve. The position contributes to platform and architectural work, mentors colleagues, promotes best practices, and collaborates across teams. It requires autonomy, a willingness to learn, and strong communication in a collaborative environment. The role partners with HL’s Cobalt business unit to meet its database, data platform, and operational needs.

Requirements

At least 5 years of experience as a Database Administrator.
At least 3 years of hands-on experience each with Snowflake and SQL Server.
Expert knowledge of Snowflake architecture, clustering, data sharing, and security features.
Strong working knowledge of SQL Server and Azure SQL Managed Instance administration, including Managed Instance Pools provisioning, sizing, networking, high availability, and security.
Strong SQL and T-SQL skills and query optimization experience.
Understanding of cloud infrastructure and data warehouse design patterns.
Experience with backup and recovery and disaster recovery planning.
Knowledge of ETL/ELT tools, enterprise job schedulers, and data pipeline management.
Familiarity with version control and CI/CD practices for database changes.

Nice To Haves

Experience with Azure SQL Database and migrating on-premises SQL Server workloads to Managed Instance Pools.
Experience with Tidal Scheduler or comparable enterprise workload automation tools.
Snowflake certification (SnowPro Core or Administrator) and/or Microsoft certification, such as Azure Database Administrator Associate.
Knowledge of BI tools such as Tableau, Looker, or Power BI.
Experience with Python or other scripting languages for automation.
Familiarity with data governance and metadata management tools.
Exposure to financial services or private markets data environments, including HL’s Cobalt business.

Responsibilities

Serve as the primary DBA for Snowflake and SQL Server, including Azure SQL Managed Instance and Managed Instance Pools, and extend support to other critical business systems as priorities evolve.
Monitor database performance, query efficiency, and resource utilization; optimize queries, Snowflake warehouse configurations, SQL Server indexes and execution plans, and instance and pool resources.
Manage user access, roles, and security policies in accordance with organizational compliance requirements.
Establish and execute backup, disaster recovery, high availability, and business continuity procedures for Snowflake, SQL Server, and Managed Instance Pools.
Oversee ELT/ETL data loading processes and job scheduling, including Tidal, and ensure data quality and integrity.
Optimize costs through warehouse sizing, clustering strategies, Managed Instance Pool and vCore sizing, licensing, and resource allocation.
Coordinate platform upgrades and apply patches while minimizing downtime.
Document database schemas, configurations, standards, and operational procedures.
Provide technical support to developers, analysts, and end users, and mentor the team on best practices.
Monitor and respond to system alerts and incidents and maintain uptime SLAs.
Partner with HL’s Cobalt business unit to support its database, data platform, and operational needs.