Senior Data Infrastructure Engineer

Summary

Join iSpot as a Senior Data Infrastructure Engineer and lead the management of our MySQL and Snowflake database platforms, providing support for Amazon Redshift. You will maintain, administer, upgrade, and migrate databases to ensure high-performance, scalable, and secure data solutions. This role demands a strategic and hands-on approach to scaling data infrastructure, optimizing performance, and guaranteeing the reliability and security of mission-critical systems. Collaboration with cross-functional teams is crucial to meet organizational needs and maintain optimal performance and reliability. The position offers competitive compensation, including salary and equity, along with standard benefits and a stimulating work environment. iSpot is committed to providing a hybrid and flexible workplace.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field
• Minimum 7+ years of experience managing databases, with at least 3 years specializing in MySQL, Snowflake and Redshift Spectrum
• Proficiency in database administration, including replication, clustering, and high availability
• Expertise in MySQL, Snowflake, Amazon Redshift and Redshift Spectrum, including query tuning, partitioning, and data lake integration
• Strong 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.)

Responsibilities

• Develop and enforce database standards, best practices, and security protocols
• Monitor and analyze database performance, identifying bottlenecks and implementing solutions to improve efficiency
• Perform query optimization and tuning for complex workloads
• Manage database caching, indexing, and resource allocation
• Collaborate with data engineering teams to ensure seamless integration between data sources, warehouses, and applications
• Manage data lifecycle policies, including archiving and purging
• Administer and optimize environments including user access, roles, resource monitors, and cost controls
• Implement and manage backup and recovery strategies wherever needed and applicable
• Implement robust backup and disaster recovery strategies
• 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
• Manage access controls, encryption, and auditing for database environments
• 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 support ELT/ETL pipelines
• Monitor usage and implement cost governance policies for Snowflake workloads

Preferred Qualifications

• 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
• Ability to work in a fast-paced, dynamic environment and manage multiple priorities

Benefits

• Salary and equity in one of Seattle’s hottest start-ups
• Other standard benefits
• Hybrid & Flexible Workplace Policy
• Depending on location and work responsibilities, employees may be designated as full-time or part-time office-based or a fully remote employee
• Those local or living in surrounding areas to one of our offices (Bellevue, WA; El Segundo, CA; New York, NY) will work a hybrid schedule, coming into their local office 1-3 days a week
• While those in a role, not office-based and located further away from our offices, will work a fully remote schedule