Senior Data Platform Engineer

New

SolaPayments technology

Source API remote eligibility restrictions: United States; Location: RemoteFull-TimeSenior

Salary165,000 - 200,000 USD per year

Apply NowOpens the employer's application page

Job Details

Experience: 7+ years of hands-on database administration experience across relational and NoSQL technologies; at least 2 years of production Amazon Redshift experience
Required Skills: AWSPostgreSQLPythonDynamoDBMicrosoft SQL ServerMySQLTerraform

Have 7+ years of hands-on database administration experience across relational and NoSQL technologies.
Have at least 2 years of production Amazon Redshift experience, including workload management, distribution and sort key design, maintenance, and performance troubleshooting.
Have strong MySQL and Microsoft SQL Server administration skills, including backup and restore, replication and CDC, upgrades, and troubleshooting.
Have working knowledge of PostgreSQL and the ability to lead schema design and administration.
Have experience in PCI DSS or SOC 2 regulated environments.
Have experience diagnosing query performance issues in high-throughput environments and designing database architecture for new applications.
Have working knowledge of DynamoDB data modeling and performance tuning.
Have experience administering ElastiCache (Redis or Memcached) or equivalent caching infrastructure.
Have solid AWS console and CLI proficiency, including IAM, CloudWatch, VPC, RDS, and S3.
Have scripting proficiency in Python, Bash, or similar, and enough familiarity with application code to collaborate with engineers.
Be able to participate in after-hours incident response, including a weekend and holiday backup rotation.
Preferred: experience with Cube.js or a comparable semantic layer, Terraform or other infrastructure-as-code tools, and AWS data pipeline or ETL tooling.

Own the performance, availability, and cost of the Amazon Redshift data warehouse.
Administer and tune Cube.js as the semantic and analytics layer.
Administer MySQL, Aurora MySQL, Microsoft SQL Server, and PostgreSQL databases, including backup, recovery, upgrades, replication, and failover.
Profile and tune queries, indexes, and execution plans across relational and NoSQL systems.
Design database schemas and select data stores in partnership with engineering teams.
Own warehouse ingestion pipelines using AWS DMS, CDC replication, Glue jobs, Step Functions, and EventBridge scheduled loads.
Design DynamoDB table structures, indexes, and capacity modes, and tune ElastiCache Redis and Memcached.
Maintain runbooks, backup and disaster recovery procedures, monitoring, and alerting.
Collaborate with Engineering and Security on architecture reviews, capacity planning, and incident response.

View Full Description & ApplyYou'll be redirected to the employer's site