Oracle Database Administrator

Aviso; Toronto; On-site; CAD 110,000 - 120,000; Full time

Job summary

Aviso is seeking an Oracle Database Administrator to enhance its IT team. This role involves managing enterprise database systems, ensuring data integrity, and collaborating with various teams to optimize database architecture. The ideal candidate will have extensive experience with Oracle products and a strong commitment to service excellence.

Benefits

Competitive compensation package

Excellent health, dental and insurance benefits

Generous vacation time and fitness benefit

Matching contributions to retirement program

Commitment to continuous improvement and education assistance

Regular social events

Qualifications

• 5 years' experience in an IT role such as systems analyst, technical support or database administrator.
• Advanced level experience with Oracle product suites, including GoldenGate 19.
• Fluent communication skills in English; bilingual in French is an asset.

Responsibilities

• Design standards, implementation, maintenance and disaster recovery of enterprise database systems.
• Work with Data Management team to develop database architecture and coding standards.
• Troubleshoot database and server incidents, apply patches, and provide technical support.

Skills

Service

Execution

Collaboration

Communication

Technical Documentation

Education

College diploma or university degree in computer science, business, finance, information technology

Tools

Oracle product suites

SQL

Azure

Data Analytics Tools

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Aviso

At Aviso, we are dedicated to improving the financial well-being of Canadians. As a leading wealth management organization, we are committed to leadership, innovation, partnership, responsibility, and community. Working with talented and energetic professionals who exemplify our values every day, you will quickly notice that our people and dynamic ‘oneaviso' culture sets us apart. If you are looking for interesting and challenging work, at a company committed to its people, find out more about what Aviso has to offer at www.aviso.ca.

The Opportunity:

We're looking for an Oracle Database Administrator to join our IT team.

Reporting to the Director, IT Systems, the Database Administrator is responsible for the design standards, implementation, maintenance and disaster recovery of our enterprise database systems. This role will also be supporting other database platforms including SQL and Azure.

Who you are:

• Service - You consider both internal and external stakeholders and demonstrate intent of understanding and putting the clients' needs first. You advocate service excellence and work to deliver solutions that meet the needs. You proactively develop strategic partnerships that allow Aviso Wealth to become a trusted advisor and partner.
• Execution - You are committed to achieving your goals and to succeed. This includes focusing on "getting things done", as well as recognizing and taking advantage of opportunities as they arise. You are consistently looking for ways to improve your personal best and see value in continuous improvement. You take accountability for your actions and learn from mistakes.
• Collaboration - You work collaboratively with others with the common goal of driving positive results. Making meaningful contributions to your team to achieve organizational goals is a priority. You proactively encourage collaboration, build trust and inclusion, and work to establish effective relationships both inside and outside of the organization.

What your day looks like:

• Work with Data Management team to develop database architecture, coding standards, QA standards as well as service standards.
• Plan and coordinate system implementation and testing, identifying and resolving the more complex problems encountered.
• Research and remain current with industry trends in database, business intelligence and data warehousing tools, standards and processes.
• Assist with the design, development, implementation, maintenance and support of database and business intelligence systems.
• Assist in establishing appropriate end user database access controls and be knowledgeable in job compliance with all security controls.
• Assist with streamlining reporting to optimize efficiency and ensure data consistency across reports and reporting applications.
• Work with DB Architect to ensure effective and efficient reconciliation and audit mechanisms are in place to guarantee data integrity in databases, data warehouses and BI systems.
• Provide DBA support to development/implementation teams doing installs, database loading, conversions and testing as required.
• Troubleshoot database and server incidents, apply patches, assist in resolution of application database issues, provide technical support as necessary.
• Provide day-to-day support for production systems as required, which may involve weekend and after-hours support, as required.
• Troubleshoot BI tools, systems and software; optimize and performance-tune these applications as necessary.
• Manage daily database, data warehouse and BI system activities including problem logs, maintenance and change requests, and performance of routine maintenance including rebuilds, re-indexing, expansion and archiving.
• Assist data solution and decision support teams with service requests for extracts, reports and data feeds.
• Foster and encourage a team environment with the necessary depth of commitment to respond to dynamic and often unpredictable deadlines and priorities.

Requirements

Your experience and skills:

• College diploma or university degree in computer science, business, finance, information technology or equivalent combination of experience.
• 5 years' experience in an IT role such as systems analyst, technical support or database administrator.
• Advanced level experience with Oracle product suites, including GoldenGate 19.
• Strong knowledge of reporting and query tools and practices.
• Direct, hands-on experience with data analytics tools.
• Experience necessary in understanding of reconciliations and audits in ETL process to ensure accuracy of processes.
• Experience with data processing flowcharting techniques.
• Securities & Mutual Funds Related: Understanding of investment sales and dealer operations an asset.
• Excellent communication skills both written and oral and strong technical documentation ability.
• Ability to establish and maintain effective working relationships with various levels of management, staff and external client.
• Fluent communication skills in English are required and bilingual skills in French are an asset.

Benefits

Why Aviso Wealth?

At Aviso Wealth, you will find a dynamic and inclusive culture that rewards innovation and celebrates success. Here are a few things that set us apart:

• Competitive compensation package that rewards and recognizes individual contributions.
• Excellent health, dental and insurance benefits to meet the diverse needs of our employees.
• Generous vacation time, fitness benefit, parental leave top-up options.
• Matching contributions to our retirement program.
• Commitment to the continuous improvement of our staff through learning & development and an education assistance program.
• Regular social events to foster teamwork.

Equal Employment Opportunity

Aviso Wealth welcomes and encourages applications from all qualified individuals including persons with disabilities. If you require an accommodation, we will work with you to meet your needs in all stages of the hiring process.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

No recruiters or agencies, please.

Company Overview:

Aviso is a leading wealth management and investment services provider for the Canadian financial industry, with over $130 billion in total assets under administration and management, and over 1,000 employees. We're building a comprehensive, technology-enabled, client-centric wealth services ecosystem. Our clients include our partners, advisors, and investors. We're a trusted partner for nearly all credit unions across Canada, in addition to a wide range of portfolio managers, investment dealers, insurance and trust companies, and introducing brokers. Our partners depend on Aviso for specific solutions that give them a competitive edge in a rapidly evolving, highly competitive industry. Our investment dealer and mutual fund dealer and our insurance services support thousands of investment advisors. Our asset manager, NEI Investments, specializes in investing responsibly. Our online brokerage, Qtrade Direct Investing, empowers self-directed investors, and our fully automated investing service, Qtrade Guided Portfolios, serves investors who prefer a hands-off approach. Aviso Correspondent Partners provides custodial and carrying broker services to a wide range of firms. We have offices in Toronto, Vancouver, Montreal, and Winnipeg. Aviso is backed by the collective strength of our owners: the credit union Centrals, Co-operators/CUMIS, and Desjardins. We’re proud to power businesses that empower investors.

A career with Aviso means being part of a group of talented, energetic professionals who live their values every day, and belonging to an organization dedicated to your success and career development. If you're looking for interesting and challenging work, at a company committed to its people, apply to join our team.

Salary

This position is posted with an expected salary range of $110,000 - $120,000 CAD annually. Individual compensation packages are based on various factors unique to each candidate and the requirements of the position.

Seniority level

• Associate

Employment type

• Full-time

Job function

• Information Technology

Referrals increase your chances of interviewing at Aviso by 2x

Get notified about new Oracle Database Administrator jobs in Toronto, Ontario, Canada.

Richmond Hill, Ontario, Canada 2 hours ago

Database Administrator, Oracle E-Business Suite

SQL Server Database Administrator Specialist

Markham, Ontario, Canada CA$140,000.00-CA$150,000.00 6 days ago

Junior Application and Database Developer

Oracle Database PL/SQL Developer, Property & Recording

Mississauga, Ontario, Canada CA$70,000.00-CA$85,000.00 2 weeks ago

Mississauga, Ontario, Canada CA$120,000.00-$130,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.