Job Details
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.