Aviso Wealth:

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 data base 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

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