Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Product Tester at Home In-Home Usage Tester Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home In-Home Usage Tester In-Home Usage Tester In-Home Usage Tester Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home In-Home Usage Tester In-Home Usage Tester In-Home Usage Tester In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home In-Home Usage Tester In-Home Usage Tester In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester In-Home Usage Tester In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester Product Tester at Home Brand Advocate - Quebec City In-Home Usage Tester Product Tester at Home Product Tester at Home Product Tester at Home In-Home Usage Tester In-Home Usage Tester Dog Sitters Wanted - Work From Home Dog Sitter - Flexible Hours Dog Sitter - Flexible Hours Newest Jobs
Companies
Yelp ContactMonkey CareGuide Sterling-Turner Two Sigma Aecom Clearbanc WeWork Aerotek Exact Media First Convenience Bank AsteroidX Jane Street Doordash AT&T Shopify Hatchways Vector Marketing Insight Global Creative Circle Amazon Flex Clickworker Square Borrowell LowCostWebDesignFirm.com Walgreens Recovhub American Income Life Instacart TD Bank 51talk Paylocity Scotiabank Microsoft Top Hat Desjardins Akira UnitedHealth Group CI&T Checkout 51 The Youth Connection mappedin Mobeewave GoParkr autoTRADER.ca Xiaomi Hootsuite ScribbleLive SnapTravel Unbounce 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