Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Service Sales Representative Sales Representative Part Time Sales Sales Representative Service Sales Representative Product Tester at Home Customer Service - Work from Home Service Product Tester at Home Service Product Tester at Home Bilingual Customer Service - French and In-Home Usage Tester Customer Service - Work from Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Customer Service - Work from Home Sales Representative In-Home Usage Tester Service Bilingual Customer Service - French and In-Home Usage Tester Line Cook Customer Service - Work from Home Customer Service - Work from Home Service client In-Home Usage Tester Customer Service - Work from Home Product Tester at Home Product Tester at Home Product Tester at Home Customer Service - Work from Home Product Tester at Home In-Home Usage Tester In-Home Usage Tester Product Tester at Home In-Home Usage Tester Product Tester at Home In-Home Usage Tester In-Home Usage Tester Service client Product Tester at Home Bilingual Customer Service - French and In-Home Usage Tester Product Tester at Home Product Tester at Home Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Clearbanc Two Sigma WeWork Aecom Exact Media Aerotek Jane Street First Convenience Bank Doordash AsteroidX AT&T Shopify Insight Global Creative Circle Hatchways Clickworker Borrowell Square Vector Marketing Amazon Flex LowCostWebDesignFirm.com Walgreens Recovhub Instacart American Income Life Scotiabank 51talk TD Bank Akira Microsoft Paylocity UnitedHealth Group Top Hat CI&T mappedin Desjardins Checkout 51 Mobeewave The Youth Connection GoParkr Peel Regional Police Hootsuite autoTRADER.ca Xiaomi ScribbleLive SnapTravel All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Oracle / SQL Administrator At BMO Financial Group

Location: Toronto, Ontario

Job Description

ACCOUNTABILITIES
  • Leads in design, development, testing, and implementation of enhancements to existing databases and/or creation of new databases in order to provide an optimum design that satisfies the business requirements.
  • Translates logical data models into effective and efficient database designs. Ensure database performance, security and availability requirements are met
  • Monitors capacity and performance for the databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality. Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
  • Performs database and application tuning and capacity planning in order to verify that the business requirements are met within the Service Level Agreement (SLA).
  • Develops and maintains database backup and recovery procedures. Ensures that databases are properly backed up and recovered when necessary.
  • Develops and maintains database security standard, setup database access and permissions accordingly .
  • Creates/maintains database and operational documentation according to accepted BMO and unit standards in order to capture current knowledge (e.g., new business data definitions, Design decisions, and Production procedures).
  • Leads/participates in project and team meetings, interacting and collaborating with team members and other departments, as appropriate, in order to capture project requirements
  • Provides technical support and backup to database team members in order to foster professional development.
  • Researches opportunities for implementing new Database Management System (DBMS) technology within the Enterprise in order to improve application development efficiency and database performance and availability.
  • Develops/improves database standards in order to provide optimum maintenance and consistency across applications.

Qualifications

KNOWLEDGE:

  • Bachelor of Science degree in a computer science or related field or equivalent work experience.
  • Hands-on experience with ORACLE AND MS SQL.
  • Understanding of database design and development methodology from both an industry and BMO perspective. Demonstrated ability to design, develop, and maintain large ORACLE AND MS SQL databases.
  • Good knowledge of the OS (Redhat Linux, Windows) and shell scripting.
  • Solid knowledge and practical experience of physical database design, backup recovery best practice/scenarios and security features
  • Practical experience with ORACLE AND MS SQL basic features like utilities, S
  • QL language, query explain plan, large objects (LOBs), triggers, stored procedures (native SQL and external), user-defined functions.
  • Solid understanding of the Software Development Life Cycle (SDLC)
  • Good understanding of business requirements and of relevant and emerging technologies.
  • Some experience in Maria and Mongo DB (nice to have).
  • Industry certification/professional accreditation (nice to have)
  • Experience with banking or other enterprise financial institution (nice to have)

SKILLS:
  • Solid analytical skills for complex problem solving.
  • Detail-oriented with good organizational skills.
  • Excellent communication skills, both written and verbal.

We’re here to help

At BMO we have a shared purpose; we put the customer at the centre of everything we do – helping people is in our DNA. For 200 years we have thought about the future—the future of our customers, our communities and our people. We help our customers and our communities by working together, innovating and pushing boundaries to bring them our very best every day. Together we’re changing the way people think about a bank.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://bmocareers.com .

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process.

Job

Information Technology

Primary Location

Canada-Ontario-Toronto

Organisation

Technology-X000068

Schedule

full-time

Job Posting

01/23/19

Unposting Date

02/07/19