DB2 Database Specialist

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: Bachelors 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 d atabase backup tools and managing data retention policies. Insurance and/or Financial Industry experience. Whats 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 I nclusion 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.

Location: Mississauga, CA

Posted Date: 11/2/2024