Senior DB Administrator - Snowflake/SQL Server (Remote PA)

Hamilton Lane; Conshohocken (Montgomery County); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Paid time off

Retirement plan

Employee stock purchasing plan

Job summary

Hamilton Lane in Conshohocken, PA seeks a Senior Database Administrator to own Snowflake and SQL Server environments, including Azure SQL Managed Instance and Managed Instance Pools. You will optimize performance, manage security, and ensure data integrity across ELT/ETL processes and scheduling systems like Tidal.

Ideal candidates have 5+ years DBA experience with strong Snowflake and SQL Server expertise, cloud data warehousing knowledge, and experience with DR planning and CI/CD for

Qualifications

• 5+ years as a Database Administrator.
• 3+ years hands-on Snowflake experience.
• 3+ years SQL Server administration including Azure SQL Managed Instance.
• Knowledge of ETL/ELT tools and data pipeline management.
• Experience with backup/recovery, disaster recovery, and DR planning.
• Familiarity with CI/CD practices for database changes.

Responsibilities

• Serve as primary DBA for Snowflake and SQL Server environments.
• Monitor performance, tune queries, optimize warehouse configurations.
• Manage user access, roles, and security policies.
• Establish backup, DR, and high-availability procedures.
• Oversee ELT/ETL data loads and scheduling (Tidal).
• Coordinate upgrades and patches across platforms with minimal downtime.
• Document schemas, configurations, and operational procedures.
• Provide support to developers and analysts and mentor peers.

Skills

Snowflake

SQL Server

Azure SQL Managed Instance

T-SQL

Data warehousing

ETL/ELT

Query optimization

Cloud infrastructure

Job description

Hamilton Lane in Conshohocken, PA seeks a Senior Database Administrator to own Snowflake and SQL Server environments, including Azure SQL Managed Instance and Managed Instance Pools. You will optimize performance, manage security, and ensure data integrity across ELT/ETL processes and scheduling systems like Tidal.

Ideal candidates have 5+ years DBA experience with strong Snowflake and SQL Server expertise, cloud data warehousing knowledge, and experience with DR planning and CI/CD for