Data Engineering Developer building scalable Azure data pipelines for an agile tech development firm. Advising clients, implementing governance, and improving cloud data engineering standards.
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.
Ingénieur(e) données concevant des pipelines et architectures analytiques Azure. Collaboration client et amélioration des standards de gouvernance, qualité et performance des données.
Junior Data Engineer building reliable ETL pipelines and data solutions for PLATO, Canada’s Indigenous - owned technology services company. Improving data quality, accessibility, governance, and pipeline performance.
Senior Data Engineer building scalable, AI - powered data infrastructure for CloudBlue, HostPapa’s cloud commerce platform. Developing real - time pipelines, APIs, and production analytics systems.
Senior Fabric Data Engineer modernizing enterprise data for Canadian IT consulting clients. Building Microsoft Fabric pipelines, curated datasets, security controls, and analytics - ready models.
Staff Data Engineer building scalable pipelines and lakehouse architecture for Sonatype, a software supply chain security company. Driving trusted analytics, ML, and business intelligence data with Databricks, Spark, and modern cloud technologies.
Senior Fabric Data Engineer modernizing learning - platform data for Cornerstone Galaxy. Building Microsoft Fabric pipelines, curated datasets, governance, and analytics - ready integrations.
GCP Data Platform Engineer maintaining and optimizing production data platforms for Innodata, a global data engineering and AI services company. Supporting Airflow pipelines, GCP infrastructure, reliability, and troubleshooting.
Senior Data Engineer building finance data pipelines and models for Instacart’s grocery delivery platform. Owning financial data infrastructure supporting accounting, billing, invoicing, and reporting.
Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.