Senior Data Platform Engineer

🕒 October 20

🇺🇸 United States – Remote

💵 $165k - $200k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 3%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Sola

WebsiteLinkedInAll Job Openings

51 - 200 employees

💳 Fintech

🤝 B2B

☁️ SaaS

💰 Private equity on 2022-08

Fintech • B2B • SaaS

Sola is a payments platform and PayFac-as-a-Service provider that helps software platforms and merchants accept and manage payments across online, in-person, and omnichannel channels. The company offers billing and invoicing, POS solutions, security and fraud protection, transaction optimization, data and insights, developer tools (APIs, documentation, sandbox) and in-house support teams to simplify integrations, reduce liability, and help businesses monetize payments. Sola operates as a registered trade name of Fidelity Payment Services and focuses on enabling platforms and merchants across North America to integrate payments and grow revenue.

📋 Description

• Serve as Sola's primary database administrator and data platform engineer within the DevSecOps team • Own production databases supporting analytics, transactional, and caching layers, including Amazon Redshift, MySQL, Microsoft SQL Server, and PostgreSQL • Administer and tune Cube.js as the semantic and analytics layer built on Redshift • Own the performance, availability, and cost of the Amazon Redshift data warehouse • Administer production relational databases, including backup and recovery, patching, upgrades, CDC, replication, high availability, and failover • Lead PostgreSQL schema design, administration, and standards for newer services • Profile and tune queries, indexes, and execution plans across relational and NoSQL systems • Implement monitoring and alerting for performance regressions • Partner with engineering teams on schemas, data-store selection, scalability, normalization, and data integrity • Own warehouse ingestion pipelines using AWS DMS, CDC replication, Glue jobs, Step Functions, and EventBridge scheduled loads • Design DynamoDB table structures, key strategies, indexes, and capacity modes • Administer and tune ElastiCache Redis and Memcached platforms • Develop runbooks, backup and disaster recovery procedures, monitoring, and alerting • Participate in the on-call rotation • Collaborate with Engineering and Security on architecture reviews, capacity planning, and incident response • Maintain PCI DSS and SOC 2 audit readiness

🎯 Requirements

• 7+ years of hands-on database administration experience across relational and NoSQL technologies • At least 2 years of production Amazon Redshift experience, including workload management, distribution and sort key design, vacuum and analyze operations, and diagnosing complex performance issues • Strong MySQL and Microsoft SQL Server administration skills, including backup and restore, replication and CDC, upgrades, and troubleshooting • Working knowledge of PostgreSQL, with the ability to lead schema design and administration for new services • Experience in PCI DSS or SOC 2 regulated environments • Demonstrated success diagnosing and resolving query performance issues in high throughput environments • Experience designing database architecture for new applications • Working knowledge of DynamoDB data modeling and performance tuning • Experience administering ElastiCache (Redis or Memcached) or equivalent caching infrastructure • Solid AWS proficiency across the console and CLI, including IAM, CloudWatch, VPC, RDS, and S3 • Scripting proficiency in Python, Bash, or similar • Familiarity with application code to collaborate effectively with engineers • Experience using AI assisted tools for query development, troubleshooting, documentation, and scripting • Ability to work independently, prioritize competing demands, and deliver projects with minimal oversight • Strong written and verbal communication skills • Ability to take part in after-hours incident response coverage, including a weekend and holiday backup rotation • Preferred: Cube.js or comparable semantic layer experience • Preferred: Infrastructure as code, preferably Terraform; CloudFormation or CDK also relevant • Preferred: AWS DMS, Glue, or Step Functions experience • Preferred: CI/CD pipelines and database change management tools such as Flyway or Liquibase • Preferred: Relevant AWS certifications

🏖️ Benefits

• Fully remote work • Participation in after-hours incident response coverage, including a weekend and holiday backup rotation

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume