Requisition ID: 228192

Tangerine is Canada's leading direct bank. We offer flexible and accessible banking options, innovative products, and award-winning Client service. The reason why Tangerine employees come to work each day is to help Canadians live better lives. We focus on making a difference in our communities, and that includes our own internal community. It's important to us that our employees feel empowered and enthusiastic about belonging to our Orange culture.

As Canada's leading digital bank, Tangerine technology is at the heart of everything we do. We have redefined what digital banking is and we continue to evolve on what it can be, using technology to create innovative, forward thinking banking solutions with our clients' needs in mind.
Are you ready to make the change and become part of an established disruptor with the backing of a highly engaged team? If so come join us and help redefine the Canadian banking landscape!

The Senior SQL DBA will be part of the Information Technology (IT) team that manages the technology and computer infrastructure that drives Tangerine's business systems. This team supports the organization in these critical areas: End-User Technical Support, Desktop Management, Network Management, Voice and Data Communications, Business and Web Applications and Strategic Technical Planning.

Is this role right for you?
• Assess and develop long-term strategic goals for databases in conjunction with data owners and department managers
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
• Configure and design database architecture to scale and adapt to changing Operational and platform technologies (e.g. automation, diverse platform, cloud, etc.)
• Ensure that existing and planned implementations are consistent and compliant with applicable security and regulatory policies and directives.
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
• Create models for new database development and/or changes to existing ones
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
• Monitor, optimize and allocate physical data storage for database systems
• Plan and coordinate data migrations between systems
• Create, or support creation of, required reports in response to business needs
• Establish appropriate end-user database access control levels
• Implement corporate compliance and audit policies, maintain and enforce standards and procedures
• Design, create, and maintain database structures; review application design and SQL code
• Manage development, test, and production environments; perform administrative functions; maintain documentation
• Promote changes via established IT change control procedures
• Create and manage service level agreements
• Design, test and implement backup/recovery strategies and contingency plans
• Monitor, analyze and report on availability, performance and resource consumption
• Assess capacity and make recommendations on disk and server sizing based on projected growth
• Plan, test and implement software upgrades; monitor alerts; interface with vendors
• Monitor daily operations; log issues and ensure resolution
• Troubleshoot problems and resolve database access and performance issues
• Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff and provide guidance to members of the team
• Participate in after-hours Production Support rotation

Do you have the skills that will enable you to succeed in this role?
• 7+ years of experience as a SQL Server DBA
• 3+ years of SQL coding experience
• Experience developing applications in a database environment is a strong asset.
• Proven experience designing, deploying, and administering highly available and resilient database systems including hands-on experience with Always On Availability Groups and Disaster Recovery administration
• Experience administering database servers in on-premise, hosted, cloud, and hybrid environments.
• SQL-Server administration in GCP is a strong asset.
• Expert technical experience with designing, building, installing, configuring and supporting database servers
• Strong understanding of database structures, theories, principles and practices
• Familiarity with client/server, operating system, storage and networking fundamentals
• In-depth understanding of Windows Operating System environments
• Demonstrated ability in performance tuning and capacity management
• Proven experience working with vendors and third-party providers
• Ability to conduct research into database issues, standards and products as required
• Ability to present ideas in user-friendly language
• Ability to effectively prioritize and execute tasks in a high-pressure environment
• Excellent interpersonal communication skills
• Highly self-motivated and proven analytical and problem-solving abilities
• Availability to carry a 24x7 production support pager on a scheduled basis and participate in periodic after-hours deployments
• University or College Degree or equivalent experience

What's in it for you?
• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s): Canada : Ontario : Toronto

At Tangerine we value the unique skills and experiences each individual brings to the team, and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process, please let our Recruitment team know.