Find jobs in Canada today!

To post a job, login or create an account |  Post a Job


Senior Database Administrator (SQL Server)

Scotiabank

This is a Contract position in Toronto, ON posted July 13, 2021.

Requisition ID : 103947 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?

In this role, you will: 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 Do you have the skills that will enable you to succeed in this role?

– We’d love to work with you if you have: 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 24×7 production support pager on a scheduled basis and participate in periodic after-hours deployments o University or College Degree or equivalent experience What’s in it for you?

• 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.