Senior Site Reliability Engineer

### Who you are
- 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.)
- AWS certifications (e.g., AWS Certified Solutions Architect, AWS Certified Database Specialty)
- Experience with big data technologies such as Hadoop, Hive, or Spark
- Familiarity with DevOps practices, including both infrastructure as code (Terraform) and CI/CD pipelines for database deployments and managing users
- Familiarity with Clickhouse database
- 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!

### What the job involves
- 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

### Benefits
- Healthcare: iSport offers two medical and dental plans for employees and their dependents as well as vision insurance. Employees may elect comprehensive individual coverage for medial, dental and vision for only $35/month
- Equity: Stock options are awarded upon hire. Additional grants may be rewarded during the compensation planning cycles
- Financial Wellbeing: iSport offers 401(k) and Roth 401(k) with a discretionary employer annual match. A tax advising benefit is offered via Carta. Short and long-term disability coverage and Life and AD&D insurance are also offered
- Health & Wellbeing: Virtual wellness classes, company wide wellness challenges, onsite health fair, as well as employee assistance program (EAP) are all offered as a way of supporting your health and wellbeing
- Tuition Reimbursement: Unlimited access to a comprehensive learning platform and tuition reimbursement to help advance your career at iSpot