Senior Data Engineer scaling blockchain, product analytics, and experimentation infrastructure for Phantom’s global open - markets trading app. Driving data quality and architecture across a remote team.
About the role
- Senior DataOps Developer operating high-availability PostgreSQL databases on AWS for Upgrade's core financial systems. Involves complex SQL operations and collaboration with engineering teams.
Responsibilities
- Operate and maintain high-availability PostgreSQL databases on AWS RDS supporting core financial systems
- Execute complex SQL operations safely in production environments with a zero-downtime mindset
- Monitor database health and performance using CloudWatch, Grafana, and observability tooling
- Analyze query performance and implement optimizations including indexing, partitioning, and schema improvements
- Support and troubleshoot data replication and synchronization pipelines using tools such as AWS DMS and Fivetran
- Manage and triage operational database requests during East Coast business hours
- Participate in a shared on-call rotation to support mission-critical production systems
- Collaborate with data engineering and platform teams to ensure reliable data pipelines and downstream analytics systems
- Contribute to operational standards and procedures that improve performance, scalability, security, and data integrity
Requirements
- 5+ years of experience operating production OLTP PostgresQL databases
- Strong experience administering PostgreSQL on AWS RDS
- Deep knowledge of: SQL query execution and optimization, indexing strategies, table partitioning, schema design and evolution
- Experience with PostgreSQL replication and backup strategies
- Hands-on experience performing database upgrades, patching, and recovery
- Strong troubleshooting and incident response skills in high-traffic production environments
- Excellent documentation and communication skills
- Ability to think systematically and carefully when working with production data
- Work from Canada East Coast (EST/EDT) to support business operations
Benefits
- 100% paid coverage of medical, dental and vision insurance
- Flexible PTO
- Competitive 401(k) and RRSP program
- Opportunities for professional growth and development
- Paid parental leave
- Health & wellness initiatives
Job title
Job type
Experience level
Salary
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Data engineering intern supporting ETL, data quality, and transformation projects at Canadian asset manager PICTON Investments. Collaborating across business teams using SQL, Python, databases, and cloud platforms.
Data engineering student building Azure, SQL, Python, and Power BI solutions for CMHA Peel Dufferin’s mental health services. Supporting reporting, ETL pipelines, dashboards, automation, and data - driven decisions.
Senior Product Architect guiding AWS, SaaS, data and financial technology at FCC, a Canadian agriculture lender. Shaping secure enterprise roadmaps and integrations across financial applications.
Data Engineer designing warehouse models, Python pipelines, and Power BI reporting for Silk & Snow’s sleep products. Transforming raw data into actionable business insights.
Senior Data Engineer building SQL, dbt, and Airflow data pipelines for Penn Interactive’s online gaming and sports platforms. Delivering trusted analytics and recommendations to business stakeholders.
Data Architect governing World Vision Canada's nonprofit enterprise data architecture. Defining cloud data standards, governance, security and reusable platforms remotely within Canada.
Senior software engineer building backend data services, APIs, microservices, and pipelines for Akamai’s distributed cloud platform. Optimizing databases and reliability across high - scale workloads.
Principal Data Architect defining scalable, governed data platforms for Robots & Pencils’ enterprise AI systems. Setting architecture direction, supporting clients, and mentoring senior technical teams.
Principal Architect leading scalable data platform architecture, solution sales, and client workshops for Long View, a North American IT provider. Mentoring data teams and driving outcomes across Databricks, Microsoft Fabric, and Snowflake.