The customer is the focus of everything we do, and millions of end users rely on our products daily. We believe in the value of empowering our employees with the resources to solve critical problems for the future of our business, which is why we need you.
The Senior SQL Database Administrator will provide Level 2 SQL Database Administration and Application support to business unit.
What motivates you?
You obsess about customers, listen, engage, and act for their benefit
You think big, with curiosity to discover ways to use your agile mindset and enable business outcomes
You thrive in teams, and enjoy getting things done together
You take ownership and build solutions, focusing on what matters
You do what is right, work with integrity and speak up
You share your humanity, helping us build a diverse and inclusive work environment for everyone
We are looking for someone with :
Degree in Computer Science, Information Technology, or other relevant post-secondary education preferred
At least 5 years tenure as regular SQL Server Database Administrator.
Understanding of Relational Database Management System Concept.
Intermediate skills in one of the following SQL Scripting, PowerShell & DOS Scripting.
Administration and Database Management background.
Experience in Disaster Recovery Planning & High Availability Setup.
SQL Server / Database Troubleshooting.
Must pass current job expectations and meet performance metrics.
Must not have any attendance issues and have not received any disciplinary action.
Amenable to work on a shifting / fixed night shift and on-call schedule
Technical Skills :
5 years IT operation with strong understanding of database structures, theories, principles, and practices.
5 years Microsoft SQL Server experience.
Understanding of, and experience with SQL Server High Availability, monitoring, performance tune-up, Backup and Restore, Installation, Upgrade and Database Migration.
Understanding of, and experience with Disaster and Recovery processes and execution.
Understanding of, and experience with, server-client computing, ETL and relational database environments.
Experience maintaining Windows 2008R2 / 2012 / 2016 / 2017 / 2019 Enterprise Server.
Strong PC skills, with experience in using Microsoft Office, especially Excel (Intermediate knowledge preferred)
Experience in Microsoft Azure
Knowledge of CyberArk or ComVault are a plus.
Familiarity with ITIL practices.
Tools Specific Knowledge :
Required SQL Server 2008R2, 2012, 2014, 2016, 2017 and 2019
Oracle 10g, 11g and 12c are a plus
Microsoft Office O365 (Excel, Word, Outlook, Access)
Microsoft SQL Server Management Studio (SSMS)
DOS / PowerShell Shell Scripting
Windows Enterprise Servers
Service Now, SM7 and ISM
FTP / SFTP
SSIS, SQL Profiler
Performance Monitoring Tools (SentryOne, Precise, Idera)
Product Specific Knowledge :
MS SQL Server 2008R2, 2012, 2014, 2016, 2017 and 2019
Windows Server 2008R2, 2012, 2016 and 2019
Process Specific Knowledge :
Request, Incident and Change Management Process.
System and Application Monitoring.
System and Database troubleshooting.
On the job you will :
Performs periodic backups and perform restore procedures if needed or requested.
Perform database tuning and performance monitoring.
Perform SQL Server installation, upgrade, patches and troubleshooting.
Develop maintenance plan for SQL Servers and Application Servers.
Takes immediate actions when database and applications performance issues arise.
Execute database and application implementations.
Maintain documentation procedure and standards.
Attend to team, client and vendors meetings to discuss plans, growth, changes and issues.
Respond to Level 1 and Level 3 Support team concerns / questions.
Participate in off-hour on-call list.
Perform weekend duties as required.
Our commitment to you :
Our mission; to be a part of making Decisions Easier and Lives Better
A leadership team dedicated to your growth and success
A bold ambition and set of goals to be a leader in driving transformation in our industry
Our best. Every day.
Learn more about opportunities with us at jobs.manulife.com