Database Systems Specialist

4 weeks ago

Toronto, Ontario, Canada Interac Corp. Full time
Database Administrator Job Description

At Interac Corp., we're shaping the future of the digital economy in Canada. As a Database Administrator, you'll play a key role in designing and delivering products and solutions that give Canadians control over their money.

Key Responsibilities:
  • Implement and support production databases and associated technologies.
  • Perform tasks associated with database modeling, performance tuning, capacity planning, and operational activities.
  • Work with the DevOps, Enabling Tech, and Operations teams to ensure optimal service availability and application performance.
  • Participate in and influence the design, planning, and implementation of database system performance and administration.
  • Recommend and assist in providing a structured PL/SQL standard for performance, support, and maintenance of the data model.
  • Provide strategies and solutions for automated management and monitoring of the database and transaction processing environments.
  • Meet data security and compliance requirements.
  • Analyze Oracle AWR/ADDM/ASH reports and review SQL execution plans on critical application queries.
  • Communicate and manage critical support issues identified to Product Vendors.
  • Define and execute data purge/archive policy.
  • Suggest schedule/timings of database automatic jobs to avoid conflict with application processes.
  • Support the data operations group for problem analysis and resolution.
  • 24/7 On-call Database support based on a rotation schedule.
Requirements:
  • 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 modeling 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).
  • 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 able to communicate with business and technical stakeholders.
  • Strong team player and able to seamlessly interact with others in a team environment.

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada Canadian Systems Inc. Full time

    At Canadian Systems Inc., we are seeking a skilled Database Systems Specialist to join our team. As a key member of our database team, you will be responsible for designing and developing database systems, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada Canadian Systems Inc. Full time

    Job DescriptionCanadian Systems Inc. is seeking a skilled Database Systems Specialist to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    At SALES CANNER, we're seeking a skilled Database Systems Specialist to join our team. As a key member of our data management team, you will be responsible for designing and developing databases to support our business operations.Key ResponsibilitiesDesign and implement database systems to meet business requirementsDevelop and maintain database...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada KDigitalLabs INC Full time

    Job Title: Database Systems SpecialistJob Summary: We are seeking a skilled Database Systems Specialist to join our team at SALES CANNER. The ideal candidate will have a strong background in database administration and management, with experience in designing and developing database systems.Key Responsibilities:Design and develop database systems to meet...

  • Database Systems Specialist

    2 weeks ago

    Toronto, Ontario, Canada ISG Search Inc Full time

    Database Systems SpecialistWe are seeking a skilled Database Systems Specialist to support our various platforms. This role involves database administration, automation, and troubleshooting of various investment applications in a fast-paced, global environment.Key Responsibilities:Support and manage investment application systems, databases in OracleETL...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada ISG Search Inc Full time

    Database Systems SpecialistWe are seeking a skilled Database Systems Specialist to support our various platforms. This role involves database administration, automation, and troubleshooting of various investment applications in a fast-paced, global environment.Key Responsibilities:Support and manage investment application systems, databases in OracleETL...

  • Database Systems Specialist

    2 weeks ago

    Toronto, Ontario, Canada professional book fairs Full time

    We are seeking a skilled Database Systems Specialist to join our team at Professional Book Fairs. As a key member of our IT department, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure. Your expertise in testing data models and database management systems will be crucial in designing...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada professional book fairs Full time

    We are seeking a skilled Database Systems Specialist to join our team at Professional Book Fairs. In this role, you will be responsible for collecting data to identify areas for improvement within our IT infrastructure, testing data models and database management systems, and designing and developing databases. You will also operate database management...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job SummaryiTek Innovative Solutions Inc. is seeking a skilled Database Systems Specialist to join our team. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our database systems to ensure seamless data management and analysis.Key ResponsibilitiesDesign and develop database systems to meet business...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job SummaryiTek Innovative Solutions Inc. is seeking a skilled Database Systems Specialist to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our organization's database systems.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada professional book fairs Full time

    At Professional Book Fairs, we are seeking a skilled Database Systems Specialist to join our team. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our database systems to ensure seamless data management and analysis.The ideal candidate will have a strong background in database administration, with...

  • Database Systems Specialist

    2 weeks ago

    Toronto, Ontario, Canada professional book fairs Full time

    Job DescriptionWe are seeking a skilled Database Systems Specialist to join our team at Professional Book Fairs. As a key member of our IT department, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure. This involves testing data models and database management systems, designing and...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada professional book fairs Full time

    Job DescriptionWe are seeking a skilled Database Systems Specialist to join our team at Professional Book Fairs. The ideal candidate will have a strong background in database administration and a passion for data analysis.Key ResponsibilitiesCollect and analyze data to identify areas for improvement within our IT infrastructureDesign and develop databases to...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job SummaryWe are seeking a skilled Database Systems Specialist to join our team at iTek Innovative Solutions Inc. The successful candidate will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure, developing and implementing a strategic blueprint for database deployment, and maintaining computer...

  • Database Systems Specialist

    3 weeks ago

    Toronto, Ontario, Canada Broadridge Full time

    We're seeking a skilled Database Systems Specialist to join our team at Broadridge. As a key member of our data management team, you'll be responsible for designing, implementing, and maintaining our SQL Server databases. If you're passionate about developing your career in database administration and have a keen eye for detail, we'd love to hear from...

  • Database Systems Architect

    3 weeks ago

    Toronto, Ontario, Canada Canadian Systems Inc. Full time

    Job DescriptionCanadian Systems Inc. is seeking a skilled Database Systems Architect to join our team. As a key member of our data management team, you will be responsible for designing and developing database systems that meet the needs of our organization.Key ResponsibilitiesDesign and develop database systems that are scalable, secure, and...

  • Database Systems Administrator

    2 weeks ago

    Toronto, Ontario, Canada Canadian Systems Inc. Full time

    Job DescriptionCanadian Systems Inc. is seeking a highly skilled Database Systems Administrator to join our team. As a key member of our IT department, you will be responsible for designing, developing, and maintaining our database systems to ensure optimal performance and security.Key ResponsibilitiesDesign and develop database systems to meet business...

  • Database Systems Architect

    3 weeks ago

    Toronto, Ontario, Canada Canadian Systems Inc. Full time

    Job DescriptionCanadian Systems Inc. is seeking a skilled Database Administrator to join our team. The successful candidate will be responsible for designing and developing databases, operating database management systems, and developing data administration policies and standards.Key ResponsibilitiesDesign and develop databases to meet business...

  • Database Specialist

    4 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job Title: Database SpecialistWe are seeking a highly skilled Database Specialist to join our team at iTek Innovative Solutions Inc.Job Summary:The Database Specialist will be responsible for designing, developing, and implementing databases to support our organization's IT infrastructure. This role will involve collecting data to identify areas for...

  • Database Specialist

    4 weeks ago

    Toronto, Ontario, Canada iTek Innovative Solutions Inc. Full time

    Job Title: Database SpecialistWe are seeking a highly skilled Database Specialist to join our team at iTek Innovative Solutions Inc.Job Summary:The Database Specialist will be responsible for designing, developing, and implementing databases to support our organization's IT infrastructure. This role will involve collecting data to identify areas for...