Site Reliability Engineer, iSpot

• Education: Bachelor's degree in Computer Science, Information Technology, or related field. Equivalent experience will also be considered
• Experience: Minimum 7+ years of experience managing databases, with at least 3 years specializing in MySQL, Snowflake and Redshift Spectrum
• Skills and Knowledge:
• Proficiency in database administration, including replication, clustering, and high availability
• Demonstrated experience running complex database migrations that may have included multiple teams, across accounts, and/or across regions
• Expertise in MySQL, Snowflake, Amazon Redshift and Redshift Spectrum, including data lake integration
• Understanding of SQL and database internals, including storage engines and query execution plans
• Experience with data pipeline tools (e.g., Apache Airflow, AWS Glue)
• Knowledge of monitoring tools (e.g., CloudWatch, Prometheus) and scripting languages (e.g., Python, Bash)
• Familiarity with cloud infrastructure, particularly AWS (S3, Lambda, IAM, etc.)
• Excellent problem-solving and analytical skills
• Strong communication and collaboration abilities
• Ability to work in a fast-paced, dynamic environment and manage multiple priorities
• If you don't feel you met every single requirement for the role, don't rule yourself out. Please apply anyway!

Desirable

• We are seeking an experienced and highly skilled Senior Site Reliability Engineer with infrastructure-focused skills including - scaling, availability, performance, backup/recovery, and cost optimization - but with additional database expertise to manage our MySQL, Amazon Redshift, and Snowflake database platforms
• In this role, you will be responsible for the maintenance, administration, upgrades and migration of the databases to support high-performance, scalable, and secure data solutions
• You will play a strategic and hands-on role in scaling our data infrastructure, optimizing performance, and ensuring the reliability and security of our mission-critical systems
• You will collaborate with cross-functional teams to ensure database systems meet the needs of the organization and maintain optimal performance and reliability
• Develop and enforce database standards, best practices, and security protocols
• Migrate databases across accounts/regions prioritizing availability and latency
• Monitor and analyze database performance, identifying bottlenecks and implementing solutions to improve efficiency
• Assist with database caching, indexing, and resource allocation
• Administer and optimize environments including user access, roles, and cost controls
• Implement and manage backup and recovery strategies wherever needed and applicable
• Ensure database systems are highly available and resilient, including configuring replication and clustering as needed
• Perform routine maintenance tasks such as patching, upgrades, and storage management
• Automate database operations using scripts and tools
• Implement monitoring solutions to proactively detect and resolve database issues
• Ensure compliance with data security policies and regulatory requirements
• Track cost/usage by team
• Provide guidance and mentorship to junior team members
• Collaborate with software developers, data engineers, and analysts to align database solutions with business needs
• Participate in capacity planning, budgeting, and strategic decision-making for database technologies
• Collaborate with data engineers and analytics teams to assist with ELT/ETL pipelines
• Migrate the data from a Redshift cluster to Snowflake
• Monitor usage and implement cost governance policies for Snowflake workloads