Senior Database Administrator

HL002 Hamilton Lane Advisors, LLC; United States; On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Healthcare coverage

Tuition reimbursement

Volunteer time off

Employee stock purchase plan

Job summary

Hamilton Lane Advisors, LLC seeks an experienced Database Administrator to join our data platform team. You will own Snowflake and SQL Server environments, optimize queries, manage ELT/ETL processes, and ensure security and resilience across cloud platforms in a fast-paced private markets environment.

We value autonomy, collaboration, and mentoring, supporting cross-team initiatives and platform upgrades with minimal downtime.

Qualifications

• 5+ years as a Database Administrator with 3+ years of hands-on Snowflake and SQL Server experience.
• Expert knowledge of Snowflake architecture, clustering, data sharing, and security features.
• Strong SQL/T-SQL skills and query optimization experience.
• Understanding of cloud data warehouse design patterns and data governance.
• Experience with backup/recovery, disaster recovery planning, and CI/CD for database changes.
• Familiarity with enterprise job schedulers like Tidal and data pipeline management.

Responsibilities

• Serve as primary DBA for Snowflake, SQL Server, and Azure SQL Managed Instance.
• Monitor performance, query efficiency, and resource utilization; optimize slow queries and indexing.
• Manage user access, roles, and security policies.
• Establish backup, DR, high availability, and business continuity procedures.
• Oversee ELT/ETL loading and job scheduling; ensure data quality and integrity.
• Coordinate platform upgrades and apply patches with minimal downtime.
• Document schemas, configurations, standards, and procedures.
• Provide support to developers/analysts; mentor team on best practices.
• Monitor system alerts and incidents; maintain uptime SLAs.
• Partner with Cobalt team to support its data platform needs.

Skills

5+ years DBA experience

Snowflake architecture

T-SQL

Query optimization

Cloud infrastructure

Backup/DR planning

Security/compliance

Tools

Snowflake

SQL Server

Azure SQL Managed Instance

Tidal Scheduler

Job description

Join Hamilton Lane, a global leader in private markets, as we scale to meet the demands of our growing client base. Here, you’ll work with ambitious, high‑performing teams built on integrity, candor and collaboration, backed by our market‑leading data and technology. We invest heavily in our people and our partners, giving you the platform to enrich lives, safeguard futures and grow your career.

What We Do

As one of the largest private markets investment firms globally, we provide innovative solutions to institutional and private wealth investors around the world, specializing in flexibility and full‑ spectrum access. We currently employ approximately 800 professionals operating in offices throughout North America, Europe, Asia Pacific and the Middle East, and have $1.0 trillion in assets under management and supervision, composed of $146.1 billion in discretionary assets and $871.5 billion in non‑discretionary assets, as of December 31, 2025.

The Opportunity

This role will engage across a full featured data process where disparate data sources are collected, collated and controlled to deliver direct value to internal and external technology solutions. The primary product under development, Cobalt (www.cobaltlp.com) is an industry leading diligence and analytics platform for the private markets. This opportunity is a DBA focused role to join an entrepreneurial spirited team set within a successful, supportive and innovative market leader. At Hamilton Lane, we are dedicated to delivering technology‑driven solutions to our clients and your work will be directly and responsively visible. We hire with the anticipation that all team members contribute across our entire technology stack. We seek skill, aptitude, drive to learn and culture fit. Your energy and drive to tackle new challenges with autonomy in a collaborative team environment will foster foundations for strong tailwinds in this mid‑career position. Platform and architectural contributions, mentorship and best practice guidance, along with cross‑team collaboration and communication are keys to success in this role.

Responsibilities

• Serve as primary DBA for Snowflake and SQL Server (including Azure SQL Managed Instance and Managed Instance Pools), with capacity to extend support to other critical business systems (e.g., Tidal scheduler) as priorities evolve
• Monitor database performance, query efficiency, and resource utilization; optimize slow‑running queries, warehouse configurations, and SQL Server indexing, execution plans, and instance and pool resource utilization
• Manage user access, roles, and security policies in alignment 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 data loading processes (ELT/ETL) and job scheduling (including Tidal) and ensure data quality and integrity
• Manage cost optimization through warehouse sizing, clustering strategies, Managed Instance Pool and vCore sizing, licensing, and resource allocation
• Coordinate Snowflake, SQL Server, Managed Instance Pool, and other supported 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; mentor team on best practices
• Monitor and respond to system alerts and incidents across Snowflake, SQL Server, Managed Instance Pools, and supported systems; maintain uptime SLAs
• Partner with HL's Cobalt business unit to support its database, data platform, and operational needs as required

Must‑haves

• 5+ years as a Database Administrator with 3+ years of hands‑on experience each in 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/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 (e.g., Azure Database Administrator Associate)
• Knowledge of BI tools (Tableau, Looker, 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

Benefits

• Enhancing Your Physical and Emotional Health Employees have access to healthcare coverage, mental health resources, health & fitness reimbursement program, and Wellness Rewards Program.
• Developing Your Career Tuition and certification reimbursement programs are available, along with continual education and development trainings for you to grow with Hamilton Lane.
• Supporting Your Family & Community For our communities, Hamilton Lane provides paid time off to volunteer and compensates for referring qualified candidates that join our team. For growing family, we offer an adoption reimbursement program, paid time off for new parents and newlyweds, and provide travel support for nursing parents.
• Safeguarding Your Financial Wellbeing Hamilton Lane contributes to retirement programs and offers an employee stock purchasing plan.

Hamilton Lane is an affirmative action-equal opportunity employer. All qualified applicants will be considered for employment without regard to their race, color, creed, religion, sex, pregnancy, national origin, ancestry, citizenship status, age, marital or partnership status, sexual orientation, gender identity or expression, disability, genetic predisposition, veteran or military status, status as a victim of domestic violence, a sex offense or stalking, or any other classification prohibited by applicable law.

If you need a reasonable accommodation to complete your application, please contact Human Resources at [e-mail].

Hamilton Lane is not accepting unsolicited assistance from search firms for this employment opportunity. Please, no phone calls or emails. All resumes submitted by search firms to any employee at Hamilton Lane via-email, the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of Hamilton Lane. No fee shall be paid in the event the candidate is hired by Hamilton Lane as a result of the referral or through other means.

We're a firm that takes our responsibility of helping clients reach their investment objectives seriously. But we're also a group that appreciates a healthy dose of wit and sarcasm, as well as a company that recognizes the value of infusing joy into what we do every day. There's a genuine spirit of collaboration and camaraderie here, and an unwavering commitment to doing right by our clients and by one another. We believe we have some of the most committed, intelligent and innovative professionals in the industry. They also happen to be pretty nice people who genuinely enjoy working with one another. So we have that going for us, which is nice.

As an employer who participates in the federal E‑Verify program, Hamilton Lane will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each employee’s Form I-9 to confirm work authorization. If the Government cannot confirm that you are authorized to work, the Company is required to provide you written instructions and an opportunity to contact SSA and/or DHS, so that you can resolve any discrepancies directly with the federal agency.