Join a Challenger Being 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 BankTM, 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 work As 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 systems The 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 expected Project 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 satisfied Server 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 issues Let''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 asset 6+ years of experience in an IT setting working with operating systems and database servers The incumbent is expected to be on call 7x24 Experience working in a banking or financial services environment is required Microsoft 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 important Database administration experience is a must: Strong knowledge of backups, restores, recovery models, database shrink operations, data migration Experience on database technologies on Azure and clustering SQL 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 tools Familiar with configuration management and software version control concepts Experience with scripting and Job scheduling experience in Powershell and Unix shell Experience 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, etc Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively Disaster recovery planning experience Experience with Relational database running on a Unix platform will be a definite asset What we offer [For full-time permanent roles] Competitive discretionary bonus Market leading RRSP match program Medical, dental, vision, life, and disability benefits Employee Share Purchase Plan Maternity/Parental top-up while you care for your little one Generous vacation policy and personal days Virtual events to connect with your fellow colleagues Annual professional development allowance and a comprehensive Career Development program A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience The incumbent will be working hybrid and in office time will be spent working from Equitable Banks additional office space located at 351 King Street East, Toronto, ON. Equitable Bank is deeply committed to inclusion. Our organization is stronger and our employees thrive when we honour and celebrate everyones diverse experiences and perspectives. In tandem with that commitment, we support and encourage our staff to grow not just in their career path, but personally as well. We commit to providing a barrier-free recruitment process and work environment for all applicants. Please let us know of any accommodations needed so that you can bring your best self to the application process and beyond. All candidates considered for hire must successfully pass a criminal background check and credit check to qualify for hire. While we appreciate your interest in applying, an Equitable recruiter will only contact leading candidates whose skills and qualifications closely match the requirements of the position. We cant wait to get to know you!
Job Title
Senior Database Administrator