Job Title

Join a ChallengerBeing a traditional bank just isnt our thing. We are big believers in innovating the banking experience because we believe Canadians deserve better options, and we challenge ourselves and our teams to creatively transform whats possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If youre not afraid of taking on big challenges and redefining the future, you belong with us. Youll get to work with people who will encourage you to reach new heights. We like to keep things fun, ask questions and learn together.We are a big (and growing!) family. Overall we serve more than 670,000 people across Canada through Equitable Bank, Canada's Challenger Bank, and have been around for more than 50 years. Equitable Bank's wholly-owned subsidiary, Concentra Bank, supports credit unions across Canada that serve more than six million members. Together we have over $125 billion in combined assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our customers have named our EQ Bank digital platform (eqbank.ca) one of the top banks in Canada on the Forbes World's Best Banks list since 2021.The workAs one of the Senior Data Platform Administrators, you will manage the companys databases and servers, and work with other administrators as part of the overall team. In addition, you will work with vendors and external service providers as well as companys physical and virtual servers, networks and security systemsThe core responsibilities:Database Administration and support (70%)Maintain the companys database systems (MS SQL Server, PostgreSQL and NoSQL etc.) including back-up, performance tuning, capacity planning, replication setup and maintenance, monitoring critical events, and documentation. Collaborate in projects on logical models and physical database design including rollout and upgrades. Work with BI tools including MS BI (SSIS, SSAS and SSRS) and IBM Cognos. Work with the Data Warehouse. Implements business rules via stored procedures, middleware, or other technologies. Occasionally some scripting and programming may be required to enable and support functions like data loading, data transformation, data cleansing, and data extraction. Support for very complex reports is also expectedProject Execution (20%)Perform tasks under the directions of the Project Manager and/or according to a project plan in a way such that the timeline of the project is observed, and the requirements of the tasks are satisfiedServer administration and troubleshooting (10%)Procure, setup, monitor, maintain, troubleshoot, and apply remedies for problems identified; work with infrastructure team and vendors to resolve issues; work with hot site vendors on hot site issuesLet's talk about you!A university degree in computer science or equivalent is required. Post graduate studies in computer science or a related subject is an asset6+ years of experience in an IT setting working with operating systems and database serversThe incumbent is expected to be on call 7x24Experience working in a banking or financial services environment is requiredMicrosoft Azure experience is required Ability to think out of the box for solutions to technical problems The incumbent is expected to interact with everyone including executives and thus good verbal and written skills are importantDatabase administration experience is a must:Strong knowledge of backups, restores, recovery models, database shrink operations, data migration Experience on database technologies on Azure and clusteringSQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)Experience with ETL tools Experience in using database management toolsFamiliar with configuration management and software version control conceptsExperience with scripting and Job scheduling experience in Powershell and Unix shellExperience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Transactional replication issues, log shipping issues, connectivity issues, security issues, windows server issues, MS SQL issues, etcExperience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting toolsStrong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectivelyDisaster recovery planning experienceExperience with Relational database running on a Unix platform will be a definite assetWhat we offer (For full-time permanent roles) Competitive discretionary bonus Market leading RRSP match program