Database Administrator

1 week ago

Old Toronto, Canada Interac Corp. Full time

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 virtuosos and high-performance application developers? We want to hear from you.

You’ll be responsible for the implementation and technical support of the company's production databases and associated technologies. You’ll perform tasks associated with database modelling, performance tuning, capacity planning, and operational activities. You’ll work with the DevOps, Enabling Tech and Operations team to ensure optimal service availability and application performance.

You’ll need profound knowledge of relational database management systems in general and Oracle DB in particular performance tuning and administration practice.

You’ll be responsible for:

Participating in and influencing the design, planning, and implementations regarding database system performance and administration.

Must be eligible to work for Interac Corp. in Canada in a Full Time Capacity

Participating with development teams to design, build and manage the data model.

Recommend and assist in providing a structured PL/SQL standard for performance, support and maintenance of the data model.

Providing strategies and solutions for automated management and monitoring of the database and transaction processing environments.

Providing solutions to meet data security and compliance requirements.

Analyzing Oracle AWR/ADDM/ASH reports (proactive troubleshooting) daily.

Reviewing SQL execution plans on critical application queries and building SQL profiles if needed.

Communicating and managing critical support issues identified to Product Vendors.

Defining and executing data purge/archive policy.

Suggesting schedule/timings of database automatic jobs to avoid conflict with application processes.

Working closely with the application development team to support development and ongoing automation.

Supporting the data operations group for problem analysis and resolution.

24/7 On call Database support based on a rotation schedule required.

You bring:

University Degree in Computer Science Engineering or equivalent combination of education and experience.

5-7 years’ experience in a similar role.

Good understanding of SQL database modelling and Normal Forms.

Experience with performance tuning of Oracle databases, highly available payment and transactional systems, data replication, and database clusters.

Experience with data warehousing, operational data stores and large-scale implementations.

Software development experience (Java with Spring framework, AngularJS)

You have 3-4+ years developing and supporting PostgreSQL databases, advanced knowledge of PostgreSQL internals  including hands-on experience with Ansible to optimize and automate tasks

Expert knowledge of SQL tuning and database performance optimization.

Experience driving database design working closely with Application development teams.

Experience with reviewing, testing, implementing and executing database changes as submitted by the development team.

Strong knowledge of different types of Oracle database objects including indexes, partitioning, materialized views, keys etc.

Solid knowledge of Oracle replication/Oracle RAC/Oracle Golden Gate implementations.

Solid knowledge of SQL, PL/SQL, Unix/Linux and Shell scripting.

Solid experience with OCI- ATP, Oracle Exadata, AWS RDS, RedShift.

Experience working in an Agile environment collaborating with Dev, QA, Testing, Operations teams.

Self-motivated and able to learn quickly.

Well versed in analyzing data, identifying and proactively mitigating risk to production systems.

Strong written and verbal communication skills and are able to communicate with business and technical stakeholders.

Strong team player and are able to seamlessly interact with others in a team environment.

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;
  • Education verification;
  • Canadian ID cross-check;
  • Public safety verification; and
  • Credit inquiry

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

Interac is one of Canada’s original FinTechs. We launched Interac e-Transfer years before other countries offered similar services and continue to innovate to improve the lives of Canadians. Every day, we enable millions of transactions – we see our work in action each time someone taps their debit card to buy coffee, orders from a local business online, or sends money via Interac e-Transfer to a friend. Our work shapes Canada’s digital future – whether it’s building a new e-Commerce solution, launching digital verification services, enabling real-time payments, or building on our resilient networks that enable coast-to-coast transactions. Visit Interac.ca to learn more.

#InteracLife

Interac empowers our employees to live their best lives – that means exploring what-ifs, finding balance, and doing work we’re passionate about. We’re a GTA Top Employer with best in class benefits including:

  • Competitive compensation and bonuses
  • Extra-long weekends, shortened ‘Summer Hours’ Fridays and Personal Days
  • 100% company paid benefits and RRSP, with no matching required
  • Development opportunities and tuition assistance

Accommodations

Interac Corp. believes in providing an inclusive workplace where all individuals have the opportunity to succeed. We are committed to doing so by providing accessible employment practices. Contact a member of the Human Resources department if you need accommodation at any point in the application process or want more information about our Accessibility Policy, which is also available online here .

#J-18808-Ljbffr

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to cash...

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to cash...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    1 month ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    4 weeks ago

    Old Toronto, Canada CareRx Integrated Pharmacy Full time

    CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We require a multifaceted professional who is...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Tundra Technical Solutions Inc. Full time

    Story Behind The NeedThe Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Flywheel Digital Full time

    OpportunityAs a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel's exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to own...

  • Database Administrator

    3 weeks ago

    Old Toronto, Canada Flywheel Digital Full time

    Opportunity As a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel’s exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to...

  • Database Administrator

    3 weeks ago

    Old Toronto, Canada Flywheel Digital Full time

    Opportunity As a Database Administrator on our team you will be responsible for maintaining Flywheel's data ingestion, transformation, transactional and data warehousing needs. This role is essential to help support Flywheel’s exponential growth. Responsiveness and willingness to solution new ideas is a key to the success of this position. Willingness to...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    1 month ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Cloud Database Administrator

    4 weeks ago

    Old Toronto, Canada Workathome-Jobboard Full time

    This is a fantastic opportunity to become a Member of our CGI-Halifax team providing leading information technology services to our clients. We are seeking a skilled Cloud Database Administrator with a minimum 6 years experience, to join our team and oversee the management and optimization of our cloud-based database systems. The ideal candidate will have...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Alcohol and Gaming Commission of Ontario Full time

    Apply By: Friday, May 24, :59 pm EDT Alcohol and Gaming Commission of Ontario Division: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch The Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating...

  • Database Administrator – Oracle

    2 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...

  • Database Administrator – Oracle

    2 weeks ago

    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...