NoSQL DBA - Jobs in Toronto, ON

Job Description

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. Youll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, youll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.About the RoleThe candidate will be a member of a team within Data Management Services (DMS) called NoSQL Database Services. The NoSQL Database Services team is responsible for database infrastructure architecture and operation support to teams using various cloud based and on-premise database platforms. The successful candidate will have a passion for database related technologies and will need to be able to pick up, understand and become proficient in a wide range of software products in a short period of time. This is an opportunity for someone to work with multiple database platforms and architectures, NoSQL and SQL, OLTP, and OLAP. A minimum of 3 to 5 year of experience in Information Technology is required as well as experience in relational and non-relational database technologies such as MongoDB, PostgreSQL, Redshift, MySQL, DynamoDB, InfluxDB, Graph DBs and Time series.What will you do

• Key Responsibilities include: Provision MongoDB instances; Ensure performance, security, and availability of databases; Configure encryption at rest and in transit; Prepare documentations and specifications; Handle common database procedures, such as upgrade, backup, recovery, migration, etc.; Collaborate with other team members and stakeholders; Perform upgrades to MongoDB environments; Automate repeatable installation and maintenance tasks
• Manage small to medium size infrastructure projects
• Participate in projects throughout the entire project lifecycle, and define, manage, and track project deliverables using defined technologies
• Maintain up-to-date documentation and procedures for MongoDB and other supported database platforms
• Keep up to date on current and upcoming technology innovations for use within Sunlife
• Develop scripts to support the database operations on Linux, Unix or cloud-based platforms
• Support project development following documented standards, policies and procedures (Change Management Process)
• Work closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
• Define, document and implement consistent standards and procedures
• Evaluate functionality and features within related database products
• Contribute ideas for best practice improvements, process improvement, and innovative solutions

What you need to succeed

• University degree in Computer Science or related information technology degree/diploma
• 3+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.)
• Demonstrated understanding of the NoSQL or SQL query and command functionality, e.g. CRUD operations, Aggregation framework, etc.
• Experience/familiarity with the operations and maintenance of production database systems
• Understanding of schema design (relational and NoSQL), index design, operation optimization, query (or explain) plans
• Experience with identifying and correcting slow operations, using log analysis (experience using mtools a plus)
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, db optimization with the help of explain plan.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.
• Problem solving, technical and conceptual skills
• Ability to lead technical discussions and self manage workloads
• Excellent interpersonal and communication skills
• Strong organizational skills with the ability to multitask efficiently

What would you be nice to have:

• Holding a certification of MongoDB certified DBA or developer
• Knowledge or experience of Mongo Atlas or MongoDB Ops Manager
• Understanding of interpreting Ops manager / Cloud Manager operation metrics
• Strong understanding of both WiredTiger and MMAPv1 storage engines
• A developer background or experience working with development teams closely
• Experiences in any of the NoSQL (DynamoDB, Neptune or other), Redshift, MySQL, Oracle, Sybase or SQL Server
• Understanding or experience working with Cloudwatch, Cloudtrail, AWS Config, AWS Backup and/or AWS DMS
• Cloudformation, Glue and/or Lambda scripting experience
• Python, shell, and Perl scripting, as well as experience with Object oriented programming.
• Understanding or experience with DevOps or Agile methodologies
• Experience with Security Architecture(s)
• Knowledge of database backup and recovery strategies (including DR strategies)
• Experience working in the AWS cloud environment is strongly desired

What’s in it for you:

• Great Place to Work® Certified in Canada and the US - 2022
• Great Place to Work® award for Best Workplaces for #HybridWork
• 2022 Named “Best Places to Work” by Glassdoor - 2021
• Canada Award for Excellence for Mental Health at Work
• 2021 Flexible hybrid work model including in-country work-from-home if you prefer.
• Pension, stock and savings programs to help build and enhance your future financial security

Note:This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada].#LI-Remote#LI-HybridThe Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to thebrightside@sunlife.com.At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.Sun Life is committed to the health and safety of all those in our workplaces and our communities. In accordance with Sun Life’s Vaccination Policy (Canada):

• Employees permitted to work remotely are required to be fully vaccinated against COVID-19 in order to attend a Sun Life office, Financial Centre or offsite location where activity related to Sun Life business occurs.
• Employees whose job duties require them to attend a Sun Life office, Financial Centre or offsite location for Sun Life business must be fully vaccinated against COVID-19 effective May 1st.
• Employees whose regular workplace is a Financial Centre and SLFD field leaders must be fully vaccinated against COVID-19 or participate in Sun Life’s Rapid Screening Program to attend a Financial Centre or an offsite event.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.Salary Range:56,300/56 300 - 92,900/92 900Job Category:IT - Technology ServicesPosting End Date:10/06/2022Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected