Database Administrator

Found in: Talent CA C2 - 6 days ago

Toronto, Canada Interac Corp. Full time

Database Administrator

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.

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)

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.

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

  • Database Administrator

    6 days ago

    Toronto, Canada iPartner Staffing Full time

    3 days per week in the office Expert Oracle and Microsoft SQL Database administration experience Demonstrated experience with DACPAC Experience with Azure build automation using Ansible, Terraform, Packer and VSTS Description The Services and Deliverables to be provided by the Vendor will include the following: - Participate in the review of...

  • Database Administrator

    8 hours ago

    Toronto, Canada iPartner Staffing Full time

    Role: RQ04307 - Database Administrator - Intermediate Must haves: - Microsoft SQL Database Administration - Minimum 5 years' experience - Microsoft Database migration experience to new hardware - Database tuning and optimization - Strong documentation skills **Job Type**: Fixed term contract **Salary**: $300.00-$700.00 per day Schedule: - 8 hour...

  • Database Administrator

    1 week ago

    Toronto, Canada Cloud Vital Full time

    Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database· Demonstrated...

  • Database Administrator

    6 days ago

    Toronto, Canada iPartner Staffing Full time

    Expert Oracle and Microsoft SQL Database administration experience - Experience with Azure build automation using Ansible, Terraform, Packer and VSTS - Expert experience with Oracle GoldenGate - Expert Oracle and Microsoft SQL Database administration experience; - Expert experience with planning, configuring, maintenance, administration, performance tuning...

  • Database Administrator

    7 days ago

    Toronto, Canada Institutional Shareholder Services Full time

    Let's be Brilliant Together! - Advance your career with the leading provider of corporate governance and responsible investment solutions. Institutional Shareholder Services (ISS) empowers investors and companies to build sustainable financial and social value by providing high quality data, analytics, and insight. Our clients rely on ISS’ expertise and...

  • Database Administrator

    Found in: Appcast CA A2 P - 2 weeks ago

    Toronto, Canada Cloud Vital Full time

    Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database· Demonstrated...

  • Database Administrator

    Found in: Appcast CA C2 Glassdoor - 1 week ago

    Toronto, Canada Cloud Vital Full time

    Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database· Demonstrated...

  • Database Administrator

    Found in: Whatjobs CA C2 - 1 week ago

    Toronto, Canada Cloud Vital Full time

    Job Role: Database Administrator Job Type: Full -Time/Contract Location: Toronto, Canada (Hybrid working Model) Skills Required: · Expert Oracle and Microsoft SQL Database administration experience; · Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database ·...

  • Database Administrator

    2 days ago

    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...

  • Database Administrator

    Found in: Appcast CA C2 Glassdoor - 3 days ago

    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...

  • Database Administrator

    Found in: Whatjobs CA C2 - 3 days ago

    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies! Job Role: Database Administrator Job Type: Full -Time/Contract Location: Toronto, Canada (Hybrid working Model) Skills Required: · Expert Oracle and Microsoft SQL Database administration experience; ·...

  • Database Administrator

    Found in: Appcast CA A2 P - 4 days ago

    Toronto, Canada Cloud Vital Full time

    We are looking for an experienced IT professional with knowledge and advanced skills around in Database Administration for one of the dynamic companies!Job Role: Database AdministratorJob Type: Full -Time/ContractLocation: Toronto, Canada (Hybrid working Model)Skills Required:· Expert Oracle and Microsoft SQL Database administration experience;· Expert...

  • Database Administrator

    7 days ago

    Toronto, Canada Information Services Corporation Full time

    Company Name: Information Services Corporation Location: Toronto, Ontario Requisition ID: JR0000349 Status: Full-time Permanent Job Close Date: November 30, 2023 We are ESC, an experienced provider that delivers solutions uniting public records data, customer authentication, corporate services, collateral management, asset recovery, and accounts...

  • Database Administrator

    6 days ago

    Toronto, Canada Canadian Institute for Health Information Full time

    **Category** - Data Governance **City** - Toronto, Ottawa, Ontario, Canada - Database Administrator - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we...

  • Oracle Database Administrator

    Found in: beBee jobs CA - 1 week ago

    Toronto, Ontario, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionOracle Installation, Database creations and upgrades from lower Database versions to higher versions.Troubleshooting connectivity and addressing any system concernsPerform...

  • Database Administrator

    8 hours ago

    Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of **Database...

  • Database Administrator

    7 days ago

    Toronto, Canada SickKids Full time

    **About SickKids**: Dedicated exclusively to children and their families, The Hospital for Sick Children (SickKids) is one of the largest and most respected paediatric healthcare centres in the world. As innovators in child health, we lead and partner to improve the health of children through the integration of healthcare, leading-edge research and...

  • SQL Database Administrator

    8 hours ago

    Toronto, Canada iPartner Staffing Full time

    3 days a week in the office 10+ years of experience in database administration, maintenance, optimization, and fine tuning of databases 5+ years of experience in database development using SQL, SQL Plus, Stored Procedures, transitional databases Working knowledge of MS SQL Server 2008 to 2019 and maintenance, setup, configuration, deployment,...

  • database administrator

    Found in: Talent CA 2 C2 - 6 days ago

    Toronto, Canada KDigitalLabs INC Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and...

  • database administrator

    Found in: Talent CA 2 C2 - 3 hours ago

    Toronto, Canada KDigitalLabs INC Full time

    Education: Expérience: EducationCollege/CEGEPTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database...