Sr NoSQL Database Analyst - 5320

Sr NoSQL Database Analyst - 5320

Duration: 4 months to start

Location: Remote

*ERC Required

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

Must Have Skills:

• 5+ years of database administration experience leading medium to large size MongoDB projects

• Experiences in any of the NoSQL (DynamoDB, Neptune or other), Redshift, MySQL, Oracle, Sybase or SQL Server.

• Experience with shell scripting

• Experience working in the AWS cloud environment

• 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 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 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 of complex enterprise applications to completion 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, communication skills, organizational skills with the ability to multitask.

Nice To Have Skills:

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

• University degree in Computer Science or related information technology degree/diploma.

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 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 upcoming technology innovations for use within Sunlife.

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