Database Administrator

3 months 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

    1 day ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure, ensuring the efficient delivery of maintenance and improvement of our database systems.The successful...

  • Database Administrator

    1 day ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure, ensuring the efficient delivery of maintenance and improvement of our database systems.The successful...

  • Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure.Key Responsibilities:Design and implement database solutions to meet business needsMonitor and optimize...

  • Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job Title: Database AdministratorWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure.Key Responsibilities:Design and implement database solutions to meet business needsMonitor and optimize...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job DescriptionJob Title: Database AdministratorCompany: Nexus Systems Group Inc.Job Type: Full-timeLocation: Remote (with occasional on-site work)About the Role:We are seeking an experienced Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, implementing, and maintaining databases to support our...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job DescriptionJob Title: Database AdministratorCompany: Nexus Systems Group Inc.Job Type: Full-timeLocation: Remote (with occasional on-site work)About the Role:We are seeking an experienced Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, implementing, and maintaining databases to support our...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job DescriptionJob Title: Database AdministratorCompany: Nexus Systems Group Inc.Job Type: Full-timeLocation: Remote (hybrid 2-3 days a week in office)Job Summary:We are seeking an experienced Database Administrator to join our team. The successful candidate will be responsible for designing, implementing, and maintaining databases to support our business...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Nexus Systems Group Inc. Full time

    Job DescriptionJob Title: Database AdministratorCompany: Nexus Systems Group Inc.Job Type: Full-timeLocation: Remote (hybrid 2-3 days a week in office)Job Summary:We are seeking an experienced Database Administrator to join our team. The successful candidate will be responsible for designing, implementing, and maintaining databases to support our business...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure, ensuring the efficient delivery of technical services.Key ResponsibilitiesDatabase Management: Implement and maintain database...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Electricenergyonline Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at Electricenergyonline. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure, ensuring the efficient delivery of technical services.Key ResponsibilitiesDatabase Management: Implement and maintain database...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Accoravillage Full time

    About AccoravillageAccoravillage is a leading provider of innovative solutions in after-school mathematics education for high-performing students. With a strong presence across Canada, we are committed to changing the equation for inquisitive minds around the world.Job DescriptionWe are seeking a skilled and experienced Database Administrator to join our IT...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Accoravillage Full time

    About AccoravillageAccoravillage is a leading provider of innovative solutions in after-school mathematics education for high-performing students. With a strong presence across Canada, we are committed to changing the equation for inquisitive minds around the world.Job DescriptionWe are seeking a skilled and experienced Database Administrator to join our IT...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada S I Systems Full time

    Job Title: Database Administrator**Job Summary:**We are seeking a highly skilled Database Administrator to join our team at S I Systems. As a Database Administrator, you will be responsible for supporting application systems, databases, automated workflow processes, and integrations used in Capital Markets and Investments Operations & Applications.Key...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada S I Systems Full time

    Job Title: Database Administrator**Job Summary:**We are seeking a highly skilled Database Administrator to join our team at S I Systems. As a Database Administrator, you will be responsible for supporting application systems, databases, automated workflow processes, and integrations used in Capital Markets and Investments Operations & Applications.Key...

  • Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Toronto Hydro Full time

    Job Title: Database AdministratorAt Toronto Hydro, we are seeking a highly skilled Database Administrator to join our team. As a key member of our Infrastructure Operations department, you will be responsible for implementing processes, systems, and projects that contribute to the efficient technical delivery of maintenance and improvement of our Database...

  • Database Administrator

    1 week ago

    Old Toronto, Ontario, Canada Toronto Hydro Full time

    Job Title: Database AdministratorAt Toronto Hydro, we are seeking a highly skilled Database Administrator to join our team. As a key member of our Infrastructure Operations department, you will be responsible for implementing processes, systems, and projects that contribute to the efficient technical delivery of maintenance and improvement of our Database...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Toronto Hydro Corporation Full time

    Job SummaryToronto Hydro Corporation is seeking a highly skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure.Key ResponsibilitiesDesign, implement, and maintain database systems to ensure optimal performance and security.Develop and...

  • Database Administrator

    3 weeks ago

    Old Toronto, Ontario, Canada Toronto Hydro Corporation Full time

    Job SummaryToronto Hydro Corporation is seeking a highly skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for implementing and maintaining our database infrastructure.Key ResponsibilitiesDesign, implement, and maintain database systems to ensure optimal performance and security.Develop and...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Toronto Hydro Corporation Full time

    Job Title: IT Technical ConsultantAt Toronto Hydro Corporation, we are seeking a highly skilled IT Technical Consultant to join our team. As a key member of our infrastructure operations team, you will be responsible for implementing processes, systems, and projects that contribute to the efficient technical delivery of maintenance and improvement of our...

  • Database Administrator

    2 weeks ago

    Old Toronto, Ontario, Canada Toronto Hydro Corporation Full time

    Job Title: IT Technical ConsultantAt Toronto Hydro Corporation, we are seeking a highly skilled IT Technical Consultant to join our team. As a key member of our infrastructure operations team, you will be responsible for implementing processes, systems, and projects that contribute to the efficient technical delivery of maintenance and improvement of our...