Sun Life · 6 hours ago
Intermediate Snowflake and Redshift DBA
Wellesley, MA
Full-time
Hybrid
Entry, Mid Level
$65K/yr - $105K/yr
2+ years expSun Life is a company that values diversity and inclusion, encouraging employees to be their best selves. They are seeking an Intermediate Snowflake and Redshift DBA who will be responsible for maintaining and optimizing Snowflake and Redshift environments, collaborating with stakeholders, and ensuring compliance with data governance policies.
FinanceFinancial ServicesInsurance
Responsibilities
Maintain and optimize Snowflake and Redshift environments across dev, test, stage and production Participate in projects throughout the entire project lifecycle
Manage infrastructure, permissions, resource monitors, warehouses, and network setting in Snowflake
Collaborate with stakeholders to implement best practices
Monitor usage and performance; troubleshoot issues and optimize queries
Monitor Snowflake usage and spending trends, provide recommendations for cost optimization and efficient resource utilizations
Ensure compliance with internal and external data governance policies
Refine existing data pipelines by improving query efficiency, indexing strategies, and automating repetitive tasks to reduce processing times and optimize resource utilization
Proactively monitors database and data pipeline performance, identifying and addressing inefficiencies, query bottlenecks, and latency issues. Use advanced diagnostic tools to analyze execution plans, optimize SQL queries, and ensure high database availability
Troubleshoot complex connectivity, replication, and system performance issues, working closely with infrastructure and DevOps teams to maintain database health and stability
Enforce database security best practices by managing user roles, permissions, and encryption protocols to protect sensitive data
Automate reporting processes and build scalable data visualization tools that improve accessibility and decision-making across teams
Qualification
Required
University degree in Computer Science or related information technology degree/diploma
2+ years of hands-on Snowflake administration/development experience
2+ years of experience in cloud native database technologies, i.e. AWS Redshift, Oracle ADW etc
2+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.)
Preferred
Understanding of schema design (relational and data warehouse), index design, operation optimization, query (or explain) plans
Proficient in writing and optimizing SQL queries, stored procedures, and indexing strategies to improve efficiency
Direct experience with cloud-based database environments such as AWS RDS, Azure SQL, or Snowflake. Understand cloud-native database services, storage solutions, and cost optimization strategies
Proactive professional who thrives on the fast-paced release cycles of Snowflake and Redshift, transforming new features into operational value
Benefits
Wellness programs that support the three pillars of your health – mental, physical, and financial
The opportunity to move along a variety of career paths with amazing networking potential.
Company
Sun Life
Sun Life is a leading financial services organization dedicated to helping people achieve lifetime financial security and live healthier lives.
10001+ employees
H1B Sponsorship
Sun Life has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (22)
2024 (27)
2023 (18)
2022 (18)
2021 (12)
2020 (13)
Funding
Current Stage
Public CompanyTotal Funding
$1.05B2024-05-13Post Ipo Debt· $548.79M
2023-07-04Post Ipo Debt· $500M
2000-03-24IPO
Leadership Team
Kevin Strain
President & CEO
Luc Nhon Ly
Chief Executive Officer
Recent News
Globe and Mail
2026-02-07
2025-12-02
MarketScreener
2025-12-02
Company data provided by crunchbase