Database Administrator

Posted 9 hours ago

Job Details

Full Time

Location

Surrey, BC

Job Description

Location: Help Headquarters
Job Type: Full Time
myWork Options: Hybrid or Remote
Background Screening Requirement:

Enhanced Criminal Record Check (every 5 years)

Credit Check (every 5 years)

Identity Verification

Education Verification

Employment Verification

References

What's the job?

Are you looking to apply your expertise to drive the growth for one of the Canada's best managed and BC's top employer companies? Then you are in the right place. The Database Administrator (DBA) is responsible for the overall management and maintenance of information databases used to operate the infrastructure and technology platform. The DBA will collaborate with technical and business user groups to ensure that databases are performing optimally, and service level agreements set by the enterprise are adhered to.

What you'll get to do:

Identify and resolve all issues related to database systems to ensure that systems are online and without service interruption.

Collaborate with development, architecture, and infrastructure team to design, configure, and manage databases using Transact SQL-based MS SQL Server to ensure the integrity, security, and accessibility of the organization's data.

Design, enhance and implement approaches to improve database performance, capacity, and scalability according to business needs.

Define standards for physical data storage, maintenance, access, and security administration.

Configure database parameters and defines data repository requirements, data dictionaries, and warehousing requirements.

Ensure each user has access to an appropriate database instance with its unique collection of objects.

Responds to performance and database alerts coming in via email, ServiceNow incidents and requests, and PagerDuty alerts.

Prepare Data/Disaster Recovery Plan and follows database Backup and Restoration Strategy when needed. Ensures that systems are online and without service interruption.

Troubleshoot performance issues using a wide-variety of tools such as SQL Profiler, Extended Events, Query Store as well as third-party add-ins.

Generate reports using SSRS, create data warehouses using SSAS, and create data pipelines using SSIS and Visual Studio.

Rotational on-call is required to support a 24/7 Production environment.

Who are we looking for?

Minimum 5 years' experience in Database Administration and Database Development.

University degree, diploma or certificate in IT or a related field.

Proficient with relational and non-relational databases and in-depth knowledge of database coding for various platforms (e.g. MS SQL Server, MySQL, Mongo DB).

Experience in designing and implementing database structures and automating DBA tasks.

Experience with data modeling and schema design.

Strong analytical, problem solving and prioritization skills.

Strong attention to detail with an ability to anticipate risks and mitigate it.

Adept at managing multiple deadlines and shifting priorities.

Excellent communication skills with an ability to facilitate discussions and communicate technical concepts and recommendations to non-technical staff.

Equity, Diversity & Inclusion at Coast Capital
Don't meet every single requirement? At Coast Capital, we believe everyone has potential. We are committed to building better, brighter, more inclusive futures for everyone - including our employees. We see the potential in our employees to achieve amazing things and want to invest in your future. If you're excited about this career opportunity and your experience may not perfectly align with every qualification in this job posting, we still encourage you to apply. You may be just the right candidate for this or other opportunities at Coast Capital.

At Coast Capital, we are committed to equity, diversity and inclusion. We strongly encourage applications from Indigenous Peoples, Black, and racialized persons, persons with disabilities, people of diverse sexual and gender identities and women. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences and expertise benefit of our employees, our members, and our community.

We strive to provide an accessible candidate experience for our candidates with different abilities. If you require any accommodations, please contact accessibility@coastcapitalsavings.com or call 778-391-5836. We will work with you to meet your needs.

Why join Coast Capital Savings?

Purpose is our North Star. We look at everything through our purpose. It informs the advice we provide our members, the experiences and products we create, and the programs we build to support our employees and communities.

Committed to inclusion and engagement. We have an ongoing focus on equity, diversity, and inclusion and routinely track how we're doing, and what we need to do to keep improving. We foster a culture where everyone can feel safe to be who they really are and thrive.

A career that grows with you. We believe in developing our people and promoting from within. Many employees have spent decades, and sometimes their entire careers, with Coast Capital and have progressed from the frontlines to senior leadership.

Work where you're most effective. In 2020 the world changed, and that includes how we work. In response to COVID-19 we launched myWork, which gives employees flexibility in where they work based on the nature of their role.

Benefits that flex to the needs of you and your family. We offer comprehensive, customizable benefits for you and your family, so you can choose what fits best for you and your lifestyle.

Retirement options. We also take care of our employees once they retire. That's why we offer the choice of a defined contribution or defined benefit pension plan or RSP's.

Mortgage and auto financing benefits. Employees save thousands on their mortgages and auto loans with best-in-category benefits.

Real Recognition. We recognize excellence throughout the year, through an online community that lets employees give kudos and thanks throughout the year. We're human, which means we like to have fun with events, celebrations, and recognition throughout the year.

An award winning culture. We're a Platinum member of Canada's Best Managed Companies and are regularly recognized by Canada's Most Admired Corporate Cultures and the BC Top Employers Awards.

We reinvest 10% back into the community. When we do well, our communities do well. That's why since 2000 we've invested over $90 million into our member's communities.

Double your impact. Through our employee volunteer program, Coast Capital donates $10 for every hour you volunteer to a Canadian charity or non-profit of your choice.

D&I at Coast At Coast Capital, we value diversity, equity and inclusion. We're not all the same and we like it that way. We don't just accept differences - we celebrate, support, and we thrive on them for the benefit of our employees, our members, and our community. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills.

About Coast Capital Savings

Coast Capital Savings is Canada’s largest credit union by membership. An Imagine Canada Caring Company, the credit union invested $5.6 million into local communities in 2017, focusing on empowering and engaging youth. Coast Capital is one of Canada's Most Admired Corporate Cultures™, and is a winner of the Canada's Best Managed Companies Platinum Club designation. It has 52 branches serving its 555,000 members in the Metro Vancouver, Fraser Valley, Vancouver Island and Okanagan regions of British Columbia. Product innovations include Canada's first free chequing account from a full-service financial institution.