AppOps Tech Lead - Database
At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like verification and open banking, we are playing a key role in shaping the future of the digital economy in Canada.
Want to make a lasting impact amongst a community of creative thinkers, problem solvers, technical gurus and high-performance application developers? We want to hear from you.
We are looking for dynamic Technical Lead specializing in Database migrations with expertise in open-source database platforms (Aurora PostgreSQL/MySQL) and Oracle infrastructure.
You will play a key Database engineering and technical lead role in developing and operationalizing the next generation of Interac on-prem and cloud solutions using innovation-led design thinking, agile development methodologies predictive analytics, and intelligent automation.
The ideal candidate will have deep technical expertise in relational databases and implementing database automation, along-with strong communications, leadership and collaboration skills, working closely with Technical and Operational teams to ensure the 24/7/365 operational integrity, security, performance and availability of Interac’s critical database platforms.
You'll be responsible for:
Leading Database design, development and workload cloud migrations from Oracle on prem to Oracle Cloud, AWS PostgreSQL. (i.e. Finalize Migration approach, schemas, data migration strategy and execution, performance, observability, logical and physical database operationalization and management etc)
Implementing best practices and standards for cloud migrations, ensuring high multi region/zone availability and scalability, reliability, security, and compliance.
Analyzing complex distributed production deployments and optimizing performance through automation and resiliency.
SQL tuning and performance optimization: Strong expertise in analyzing execution plans, proactively identifying potential performance bottlenecks, and optimizing SQL queries.
Planning, creating, resizing, and monitoring tablespaces for optimized performance, and implement efficient data and space utilization strategies.
Strong command over SQL and PL/SQL, with the ability to analyze source-target mappings, develop automated scripts, and validate data accuracy post-migration
Working closely with the application and product teams to support development, testing and ongoing automation.
You bring:
8-10+ years of related experience including previous expertise developing, leading, implementing on prem to cloud database migrations and managing on prem and hybrid cloud workload.
A university degree in Computer Science Engineering or equivalent combination of education and experience.
Strong expertise with AWS services like EC2, S3, RDS, Aurora, and AWS Database Migration Service (DMS), AWS Schema Conversion tool (SCT).
Previous hands-on experience leading and maintaining Oracle/Aurora PostgreSQL databases on AWS
Previous experience implementing and managing backups, restoration, replications, and snapshots
Experience implementing AWS services in a variety of distributed computing environments
A strong understanding of database architecture, performance tuning, and PL/SQL is essential.
Experience and technical expertise (design and implementation) in cloud computing technologies
Experience working with container technologies including Kubernetes and Docker
Expert understanding of DevOps principles and Infrastructure as a Code concept and techniques
Hands-on experience with advanced database troubleshooting, leading and mentoring technical teams.
Proficient in creating technical Database documentations and providing knowledge transfer.
You have strong written and verbal communication skills and are able to communicate with business and technical stakeholders.
You are a strong team player and are able to seamlessly interact with others in a team environment.
Ability to work occasional after hours as an technical escalation when required.
You have strong written and verbal communication skills and are able to communicate with business and technical stakeholders.
Eligibility to work for Interac Corp. in Canada in a full-time capacity.
Nice to have:
AWS Certified Database - Specialty certification
AWS Certified Data Engineer
AWS Certified Solutions Architect
Interac requires employees to complete a background check that is completed by one of our service providers. We use this service to complete the following checks:
- Canadian criminal record check;
- Public safety verification;
- Canadian ID cross-check;
- 5-year employment verification;
- Education verification; and
- If applicable, Credit Inquiry and Social Media Check
How we work
We know that exceptional people have great ideas and are passionate about their work. Our culture encourages excellence and actively rewards contributions with:
Connection: You’re surrounded by talented people every day who are driven by their passion of a common goal.
Core Values: They define us. Living them helps us be the best at what we do.
Compensation & Benefits: Pay is driven by individual and corporate performance and we provide a multitude of benefits and perks.
Education: To ensure you are the best at what you do we invest in you
Please be aware of certain individuals fraudulently using Interac Corp.’s name and logo to offer fictitious employment opportunities. Interac Corp. will never ask, solicit, nor accept any monies in exchange for employment opportunities. Any such offers of employment are fraudulent and invalid, and you are strongly advised to exercise great caution and disregard such offers and invitations.
Please note that under no circumstances shall Interac Corp. be held liable or responsible for any claims, losses, damages, expenses, or other inconveniences resulting from or in any way connected to the actions of individuals performing such fraud. Further, such fraudulent communication shall not be treated as any kind of offer or representation by Interac Corp. or its subsidiaries and affiliates.
