Sr. Data Infrastructure Engineer

Position Overview:
We are seeking an experienced and highly skilled Senior Data Infrastructure Engineer to lead and manage our MySQL and Snowflake database platforms, with additional support for Amazon Redshift. 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.

Key Responsibilities:

1. Database Design and Architecture:.
• Develop and enforce database standards, best practices, and security protocols.
2. Performance Tuning and Optimization:
• 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.
3. Data Management and Integration:
• Collaborate with data engineering teams to ensure seamless integration between data sources, warehouses, and applications.
• Manage data lifecycle policies, including archiving and purging.
4. Access, Maintenance and Operations:
• 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
5. Monitoring and Security:
• 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.
6. Collaboration and Leadership:
• 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.
7. Snowflake specific responsibilities:
• Collaborate with data engineers and analytics teams to support ELT/ETL pipelines
• Monitor usage and implement cost governance policies for Snowflake workloads.

Required Qualifications:

• 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.
• 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.).

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

Soft Skills:

• 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.

Target cash compensation range: $136,100.00 - $174,210.00 USD Annually

We are committed to providing competitive, market-informed compensation. The cash compensation above includes base salary, variable commission for employees in eligible roles, and annual bonus targets for eligible roles. In addition to cash compensation, all full time iSpotters are eligible to participate in iSpot’s equity plan to receive stock options. Non-exempt roles will also be eligible for (pre-approved) overtime pay. Individual compensation packages are influenced by different factors unique to each candidate, including their skills, experience, qualifications and other job-related reasons.

For more information on total rewards package, go HERE

Hybrid & Flexible Workplace Policy

iSpot supports a hybrid and flexible workplace. Depending on location and work responsibilities, employees may be designated as full-time or part-time office-based or a fully remote employee. A hybrid work schedule indicates that you work in the office some days and work from home other days. The best hybrid workplaces allow for flexibility while also encouraging consistency. 

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. If you have questions regarding exact details of our hybrid & flexible workplace policy, please let your recruiter know and they will discuss with you further.

#LI-Remote