Senior Database Administrator (SQL Server)

Title : Senior Database Administrator (SQL Server)

Requisition ID : 103947

Tangerine is Canadas 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.

Its important to us that our employees feel empowered and enthusiastic about belonging to our Orange culture.

The Senior SQL DBA will be part of the Information Technology (IT) team that manages the technology and computer infrastructure that drives Tangerines 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.

Strategy and Planning

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

Operational Management

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

o 7+ years of experience as a SQL Server DBA

o 3+ years of SQL coding experience

o Experience developing applications in a database environment is a strong asset.

o 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

o Experience administering database servers in on-premise, hosted, cloud, and hybrid environments.

o SQL-Server administration in GCP is a strong asset.

o Expert technical experience with designing, building, installing, configuring and supporting database servers

o Strong understanding of database structures, theories, principles and practices

o Familiarity with client / server, operating system, storage and networking fundamentals

o In-depth understanding of Windows Operating System environments

o Demonstrated ability in performance tuning and capacity management

o Proven experience working with vendors and third-party providers

o Ability to conduct research into database issues, standards and products as required

o Ability to present ideas in user-friendly language

o Ability to effectively prioritize and execute tasks in a high-pressure environment

o Excellent interpersonal communication skills

o Highly self-motivated and proven analytical and problem-solving abilities

o Availability to carry a 24x7 production support pager on a scheduled basis and participate in periodic after-hours deployments

o University or College Degree or equivalent experience

We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!

We provide you with the tools and technology needed to create beautiful customer experiences

You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world

Dress codes don't apply here, being comfortable does

Flexible work environment including remote and from-home where applicable

Onsite subsidized cafeteria with a chef!

Access to thousands of online and in person courses so you can brush up on skills or learn new ones

Career progression opportunities. We hire you for your talent and not just for the job. We want to see you succeed not just in your role but in your career as a whole

We offer a competitive total rewards package that includes a base salary, a performance bonus, company matching programs (on pension & profit sharing), vacation, personal & sick days, paternity / maternity leave, medical, vision and dental benefits and much more

Location(s) : Canada : Ontario : North York

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.