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
At Hamilton Lane, our benefits philosophy is simple: to provide our employees with a competitive suite of benefits and services to help navigate through the complexities and challenges of working, living, raising a family, and eventually retiring. To do this, Hamilton Lane offers the following 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 humanresources@hamiltonlane.com.
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.