Senior Data Platform Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Act as the main database administrator and data platform engineer for Sola within the DevSecOps team.

• Manage production databases that support analytics, transactional, and caching layers, including Amazon Redshift, MySQL, Microsoft SQL Server, and PostgreSQL.

• Oversee and optimize Cube.js, which serves as the semantic and analytics layer built on Redshift.

• Take responsibility for the performance, availability, and cost management of the Amazon Redshift data warehouse.

• Administer production relational databases, focusing on backup and recovery, patching, upgrades, CDC, replication, high availability, and failover.

• Lead the schema design, administration, and standards for PostgreSQL in newer services.

• Analyze and optimize queries, indexes, and execution plans across relational and NoSQL systems.

• Set up monitoring and alerting systems to catch performance regressions.

• Collaborate with engineering teams on schema design, data-store selection, scalability, normalization, and data integrity.

• Manage warehouse ingestion pipelines using AWS DMS, CDC replication, Glue jobs, Step Functions, and EventBridge scheduled loads.

• Design table structures, key strategies, indexes, and capacity modes for DynamoDB.

• Administer and optimize ElastiCache Redis and Memcached platforms.

• Create runbooks, backup and disaster recovery procedures, as well as monitoring and alerting systems.

• Participate in the on-call rotation.

• Work with Engineering and Security teams on architecture reviews, capacity planning, and incident response.

• Ensure readiness for PCI DSS and SOC 2 audits.

⛳️ Requirements

• A minimum of 7 years of hands-on experience in database administration across relational and NoSQL technologies.

• At least 2 years of experience working with production Amazon Redshift, including workload management, distribution and sort key design, vacuum and analyze operations, and troubleshooting complex performance issues.

• Strong skills in MySQL and Microsoft SQL Server administration, covering backup and restore, replication and CDC, upgrades, and troubleshooting.

• Familiarity with PostgreSQL, with the capability to lead schema design and administration for new services.

• Experience in environments regulated by PCI DSS or SOC 2.

• Proven ability to diagnose and resolve query performance issues in high throughput settings.

• Background in designing database architecture for new applications.

• Basic knowledge of DynamoDB data modeling and performance tuning.

• Experience in administering ElastiCache (Redis or Memcached) or similar caching infrastructure.

• Strong AWS skills including the use of the console and CLI, covering IAM, CloudWatch, VPC, RDS, and S3.

• Proficiency in scripting languages such as Python, Bash, or similar.

• Ability to effectively collaborate with engineers by understanding application code.

• Experience with AI-assisted tools for query development, troubleshooting, documentation, and scripting.

• Capability to work independently, manage competing priorities, and deliver projects with minimal supervision.

• Excellent written and verbal communication skills.

• Willingness to participate in after-hours incident response coverage, including a weekend and holiday backup rotation.

• Preferred: Experience with Cube.js or similar semantic layer technologies.

• Preferred: Familiarity with infrastructure as code, especially Terraform; CloudFormation or CDK are also relevant.

• Preferred: Experience with AWS DMS, Glue, or Step Functions.

• Preferred: Knowledge of CI/CD pipelines and database change management tools like Flyway or Liquibase.

• Preferred: Relevant AWS certifications.

🏝️ Benefits

• Fully remote work opportunity.

• Involvement in after-hours incident response coverage, including a weekend and holiday backup rotation.