DB2 Database Specialist

1 month ago

Mississauga, Canada Royal Bank of Canada> Full time

Job Summary

Job Description

What is the opportunity?

As DB2 Database Specialist in Insurance Data Engineering Services team within Insurance Technology, you will lead DB2 LUW projects and initiatives in multiple Agile Labs.  We are looking for a passionate DBA with strong database architecture skills and leadership, effective written and verbal communication skills, a strong work ethic and a demonstrated capability to multi-task effectively.  This role requires a positive attitude and a willingness to take accountability for results achieved.

What will you do?

  • Create and maintain DB2 database & transaction processing environments for application testing, pre-production verification and production operation.

  • Work closely with agile teams and other stakeholders to understand their database requirements and assist in building database solutions that cater to their needs.

  • Provide DBA technical support to a list of critical Insurance applications that use DB2 LUW.

  • Ensure DB2 databases are optimally designed so that applications meet their defined SLAs, maximize reuse of existing database structures, and minimize operational costs.

  • Assist RBC infrastructure teams with DB2 LUW version upgrades, maintenance, and enhancement of database products.

  • Ensure enterprise database standards are followed and aligned to overall RBC guidelines.

What do you need to succeed?

Must Have:

  • 5+ years’ experience as DBA supporting critical applications that use DB2 LUW in standalone and HADR/Cluster environments. 

  • Strong technical knowledge of IBM DB2 database including data modeling, stored procedures, views and optimization.

  • High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning

  • Good knowledge on Unix shell scripting and database backup tools such as Networker

  • Good knowledge on mainframe JCL, Jira, Service Now, GITHub, OnDemand and Zeke

  • Excellent collaboration skills and proven ability to adapt to challenges, coaching and mentoring.

  • Strong communication, analytical and negotiation skills, including conceptual, requirements interpretation, solution creation and problem-solving abilities.

  • Quick learner on areas you never worked on.

Nice to have:

  • Bachelor’s degree in Computer Science, Engineering or equivalent.

  • Knowledge/experience administering IBM Integrated Analytics System appliance.

  • Knowledge/experience with Microsoft SQL Server, MongoDB, MySQL.

  • Knowledge/experience using database backup tools and managing data retention policies.

  • Insurance and/or Financial Industry experience.

What’s In For You?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

  • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.

  • Leaders who support your development through coaching and managing opportunities

  • Ability to make a difference and lasting impact.

  • Work in a dynamic, collaborative, progressive, and high-performing team.

  • Flexible work/life balance options

  • Opportunities to take on progressively greater accountabilities.  

  • Access to a variety of job opportunities across business and geographies

#Ll-Hybrid
#Ll-POST
#TECHPJ

Job Skills

Agile Methodology, Analytical Thinking, Big Data Management, Database Architecture, Database Development, Database Structures, Data Mining, Data Modeling, Data Warehousing (DW), GitHub, IBM Db2, IBM DB2 Database, Physical Database Design, Quality Management, Requirements Analysis, Software Development, Unix Shell Scripting

Additional Job Details

Address:

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA

City:

MISSISSAUGA

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2024-10-24

Application Deadline:

2024-11-29

Inclusion and Equal Opportunity Employment

At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
​​​​​​​
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.

  • DB2 Database Specialist

    4 weeks ago

    mississauga, Canada RBC Full time

    Job SummaryJob DescriptionWhat is the opportunity?As DB2 Database Specialist in Insurance Data Engineering Services team within Insurance Technology, you will lead DB2 LUW projects and initiatives in multiple Agile Labs. We are looking for a passionate DBA with strong database architecture skills an

  • DB2 Database Specialist

    1 month ago

    Mississauga, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryJob DescriptionWhat is the opportunity?We are seeking a skilled DB2 Database Specialist to lead DB2 LUW projects and initiatives in multiple Agile Labs within our Insurance Data Engineering Services team. As a DBA with strong database architecture skills and leadership, you will work closely with agile teams and other stakeholders to understand...

  • DB2 Database Architect

    1 week ago

    Mississauga, Ontario, Canada Royal Bank of Canada> Full time

    About the RoleWe are seeking a highly skilled DB2 Database Specialist to join our Insurance Data Engineering Services team within Insurance Technology at Royal Bank of Canada. As a key member of our team, you will be responsible for leading DB2 LUW projects and initiatives in multiple Agile Labs.The ideal candidate will have strong database architecture...

  • Db2 System Admin

    6 months ago

    Mississauga, Canada International Talent Resources INC. Full time

    Upgrade/Migrate DB2 Versions to newer versions - Manage DB2 IVS Products and upgrade to supported versions if required. - Managing system catalogs - Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc. - Database and related object security - manage user ids, rights and privileges - DB2 administration on z/OS, SQL creation, DB2 command line creation and...

  • Database Administrator

    4 weeks ago

    Mississauga, Ontario, Canada ROSS Full time

    Job SummaryROSS is seeking a highly skilled Database Administrator to join our team. As a key member of our database development team, you will be responsible for designing, implementing, and maintaining our database systems.Key Responsibilities1. Develop and maintain database models that meet business requirements and are flexible enough to cater to current...

  • Database Administrator

    1 month ago

    Mississauga, Ontario, Canada https:www.pcrecruiter.netsitemap Full time

    Key ResponsibilitiesDevelop and maintain data models that meet business requirements, ensuring flexibility for current and future needs.Establish and enforce policies and standards for database development activities.Provide development support for database applications, including performance tuning, to ensure efficient code execution.Collaborate with data...

  • Database Specialist

    4 weeks ago

    Mississauga, Ontario, Canada Technology Solutions Full time

    Job Title: Database SpecialistAbout the Role:We are seeking a skilled Database Specialist to join our team at Technology Solutions. As a Database Specialist, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and...

  • Database Specialist

    1 month ago

    Mississauga, Ontario, Canada Technology Solutions Full time

    Job Title: Database SpecialistAbout the Role:We are seeking a skilled Database Specialist to join our team at Technology Solutions. As a Database Specialist, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and...

  • Database Specialist

    4 weeks ago

    Mississauga, Ontario, Canada Exioms Canada Full time

    Job Title: Database SpecialistAbout the Role:We are seeking a skilled Database Specialist to join our team at Exioms Canada. As a Database Specialist, you will be responsible for designing and developing databases, operating database management systems to analyze data, and researching and documenting data requirements, data collection and administration...

  • Database Systems Specialist

    4 weeks ago

    Mississauga, Ontario, Canada AG Marketing & Development Group Inc Full time

    Job Title: Database Systems SpecialistAbout the Role:We are seeking a highly skilled Database Systems Specialist to join our team at AG Marketing & Development Group Inc. As a key member of our IT department, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business...

  • Senior Database Specialist

    3 weeks ago

    Mississauga, Ontario, Canada A.P.H INTERNATIONAL LTD. Full time

    Job Title: Senior Database SpecialistAt A.P.H INTERNATIONAL LTD., we are seeking a skilled Senior Database Specialist to join our team. As a key member of our database administration team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions....

  • Database Systems Specialist

    3 weeks ago

    Mississauga, Ontario, Canada Six side Logistics Full time

    Job Title: Database Systems Specialist At Six Side Logistics, we are seeking a highly skilled Database Systems Specialist to join our team. The successful candidate will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy and standards. Key...

  • Database Systems Specialist

    4 weeks ago

    Mississauga, Ontario, Canada Six side Logistics Full time

    Job Title: Database Systems SpecialistJob Summary: We are seeking a highly skilled Database Systems Specialist to join our team at Six side Logistics. The successful candidate will be responsible for designing and developing databases, operating database management systems, and analyzing data to support business decisions.Key Responsibilities:Design and...

  • Database Systems Specialist

    1 week ago

    Mississauga, Ontario, Canada A.P.H INTERNATIONAL LTD. Full time

    Job DescriptionWe are seeking a skilled Database Systems Specialist to join our team at A.P.H INTERNATIONAL LTD.About the RoleThis is a full-time, permanent position requiring 35-40 hours of work per week.The successful candidate will have a bachelor's degree and approximately one year of experience in database administration.ResponsibilitiesAs a Database...

  • Database Systems Specialist

    4 weeks ago

    Mississauga, Ontario, Canada EPIC - Educational Program Innovations Center Full time

    Job SummaryWe are seeking an experienced Database Systems Specialist to join our team at EPIC - Educational Program Innovations Center. 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...

  • Database Systems Specialist

    2 weeks ago

    Mississauga, Ontario, Canada EPIC - Educational Program Innovations Center Full time

    We are looking for a highly skilled Database Systems Specialist to join our team at EPIC - Educational Program Innovations Center.About the RoleThis is a permanent position with an estimated salary of $60,000 per year. As a Database Systems Specialist, you will work under pressure and be responsible for designing and developing databases, operating database...

  • Database Systems Specialist

    4 weeks ago

    Mississauga, Ontario, Canada FLAMINKO INC. Full time

    Job Title: Database Systems SpecialistAbout the Role:We are seeking a skilled Database Systems Specialist to join our team at FLAMINKO INC. As a key member of our data management team, you will be responsible for designing, developing, and maintaining computer databases to support our business operations.Key Responsibilities:Develop and maintain computer...

  • Database Engineer

    1 month ago

    Mississauga, Ontario, Canada beBee Professionals Full time

    Job Title: MySQL Database SpecialistAt beBee Professionals, we are seeking a skilled MySQL Database Specialist to join our team in Mississauga. The successful candidate will be responsible for developing and maintaining MySQL databases, as well as designing and implementing database solutions. The MySQL Database Specialist will also be responsible for...

  • Database Systems Specialist

    4 weeks ago

    Mississauga, Ontario, Canada FLAMINKO INC. Full time

    Job Title: Database Systems SpecialistAbout the Role:We are seeking a skilled Database Systems Specialist to join our team at FLAMINKO INC. As a key member of our data infrastructure team, you will be responsible for designing, developing, and maintaining our computer databases.Key Responsibilities:Develop and maintain computer databases to ensure data...

  • Database Systems Specialist

    2 weeks ago

    Mississauga, Ontario, Canada EPIC - Educational Program Innovations Center Full time

    About the RoleWe are seeking a highly skilled Database Systems Specialist to join our team at EPIC - Educational Program Innovations Center. The successful candidate will have a strong educational background and relevant work experience.The role involves designing, developing, and implementing database systems to meet the needs of our organization.