Senior Database Administrator

This is a fully remote position, open to applicants in Pennsylvania.

📋 Description

• Act as the primary Database Administrator for Snowflake and SQL Server, which includes Azure SQL Managed Instance and Managed Instance Pools.

• Provide database administration support to other essential business systems, such as Tidal scheduler, as priorities change.

• Monitor the performance of databases, query efficiency, and resource usage.

• Optimize slow-performing queries, warehouse configurations, SQL Server indexing, execution plans, and resource utilization for instances and pools.

• Manage user access, roles, and security policies in accordance with organizational compliance requirements.

• Develop and implement backup, disaster recovery, high availability, and business continuity procedures.

• Supervise ELT/ETL data loading processes and job scheduling, including Tidal.

• Ensure the quality and integrity of data.

• Manage cost optimization 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.

• Offer technical support to developers, analysts, and end users.

• Guide the team on best practices for database administration.

• Monitor and respond to system alerts and incidents while maintaining uptime SLAs.

• Collaborate with HL's Cobalt business unit to meet database, data platform, and operational requirements.

⛳️ Requirements

• More than 5 years of experience as a Database Administrator.

• At least 3 years of hands-on experience with both Snowflake and SQL Server.

• In-depth knowledge of Snowflake architecture, clustering, data sharing, and security features.

• Strong understanding of SQL Server and Azure SQL Managed Instance administration, including Managed Instance Pools: provisioning, sizing, networking, high availability, and security.

• Proficient in SQL and T-SQL with query optimization experience.

• Solid understanding of cloud infrastructure and data warehouse design patterns.

• Experience in backup/recovery and disaster recovery planning.

• Familiarity with ETL/ELT tools, enterprise job schedulers, and data pipeline management.

• Knowledge of version control and CI/CD practices for database changes.

• Experience with Azure SQL Database and migrating on-premises SQL Server workloads to Managed Instance Pools.

• Experience with Tidal Scheduler or similar enterprise workload automation tools.

• Snowflake certification (SnowPro Core or Administrator) and/or Microsoft certification (e.g., 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.

🏝️ Benefits

• Healthcare coverage.

• Mental health resources.

• Health & fitness reimbursement program.

• Wellness Rewards Program.

• Tuition and certification reimbursement programs.

• Ongoing education and development training opportunities.

• Paid time off for volunteering.

• Compensation for referring qualified candidates who join the team.

• Adoption reimbursement program.

• Paid time off for new parents and newlyweds.

• Travel support for nursing parents.

• Retirement programs.

• Employee stock purchasing plan.