Sr NoSQL Database Analyst

Your newpany

Our client is a Canadian financial servicespany. It is primarily known as a life insurancepany. Our client has a presence in investment management with over CAD$1.

3 trillion in assets under management operating in a number of countries.

Your new role

The candidate will be a member of a team within Data Management Services (DMS) called Alternative Database Technologies. Alternative Database Technologies 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 be proficient in a wide range of software products in a short period of time.

This is an opportunity for someone who is an expert in MongoDB to also work with multiple database platforms and architectures;

NoSQL and SQL, OLTP, and OLAP. A minimum 5 year of experience in Information Technology is required as well as experience in non-relational database technologies or AWS database services, such as MongoDB, Redshift, DynamoDB, DocumentDB and Time series.

Key Responsibilities include Provision MongoDB instances; Ensure performance, security, and availability of databases; Configure encryption at rest and in transit;

Prepare documentations and specifications; Handlemon 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 medium to large size infrastructure projects, such as MongoDB7.0 upgrade, MongoDB Atlas migration or etc.
• 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 uing technology innovations for use within our client’spanies
• Sound knowledge of DevSecOps and database automation and scripting (e.g. AWS CDK, Github Action, Ansible, shell scripting, python, SQL).
• 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'll need to succeed

• University degree inputer Science or related information technology degree / diploma.
• 5+ years advanced administration experience in MongoDB.
• 5+ years of experience working with multiple platforms and types of data repositories (Relational, NOSQL, Datawarehouse, OLAP, OLTP etc.).
• In depth Analytical and problem-solving skills.
• Understanding of the MongoDB query andmand 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 MongoDB), index design, operation optimization, query (or explain) plans.
• Experience with identifying and correcting slow operations, using log analysis (experience using mtools a plus).
• Understanding of interpreting Ops manager / Cloud Manager operation metrics.
• 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.
• Expert of Object oriented programming in order to write robust and re-usable code.
• Involved in designing, developing, testing and rolling out ofplex enterprise applications topletion in terms of Database as well as frontend.

With different project development model like SDLC, Agile, SCRUM etc.

• Expert of writing shell scripting, Perl script for Linux / Unix.
• Ability to lead technical discussions and self manage workloads
• Excellent interpersonal,munication skills, organizational skills with the ability to multitask.
• What would you be nice to have :
• A certification of MongoDB certified DBA or developer.
• Knowledge or experience of Mongo Atlas or MongoDB Ops Manager.
• A developer background or experience working with development teams.
• 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 scripting.
• 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 a nice to have.

What you'll get in return

You will be working with smart, passionate, and dedicated new team members,petitivepensation, and career development opportunities.

If you’re available and interested in this role, please reply to

sakina.suterwala@hays with your updated word resume and salary requirement.

LI-DNI #1113072 - Resham Singh