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.
About the role
- Développeur(euse) DataOps Senior chez Upgrade, gérant les bases de données PostgreSQL pour les systèmes financiers. Axé sur l'excellence opérationnelle et la performance dans un environnement de production à haut débit.
Responsibilities
- Operate and maintain highly available PostgreSQL databases on AWS RDS supporting mission-critical financial systems
- Safely execute complex SQL operations in production environments with a zero-downtime approach
- Monitor database health and performance using CloudWatch, Grafana, and observability tools
- Analyze query performance and implement optimizations, including indexing, partitioning, and schema improvements
- Provide support and troubleshoot data replication and synchronization pipelines using tools such as AWS DMS and Fivetran
- Manage and prioritize database-related operational requests during Eastern Time business hours
- Participate in a shared on-call rotation to support critical production systems
- Collaborate with data engineering and platform teams to ensure the reliability of downstream data pipelines and analytics systems
- Contribute to operational standards and procedures to improve performance, scalability, security, and data integrity
Requirements
- More than 5 years of experience operating production PostgreSQL OLTP databases
- Strong experience administering PostgreSQL on AWS RDS
- Excellent proficiency in SQL query execution and optimization, indexing strategies, table partitioning, and schema design and evolution
- Experience with PostgreSQL replication and backup strategies
- Hands-on experience with database upgrades, patching, and restoration
- Strong troubleshooting and incident management skills in high-traffic production environments
- Excellent documentation and communication skills
- Ability to take a methodical, disciplined approach when working with production data
Benefits
- Competitive salary and stock option plan
- 100% coverage for medical, dental, and vision insurance
- Flexible paid time off
- Competitive 401(k) and RRSP plans
- Learning and professional development allowance
- Paid parental leave
- Health and 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 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.
Senior Data Engineer building Azure pipelines, data platforms, and ML workflows for Manulife’s retirement operations. Supporting trusted analytics across North American teams.