Senior Database Engineer

Position Summary

We are seeking a Senior Database Engineer with specialized expertise in NoSQL database technologies to join our data team. This role focuses on the efficient and secure management of NoSQL databases, ensuring that data is stored effectively and can be retrieved quickly and securely when needed. The ideal candidate will have deep experience with document, key-value, and graph databases in cloud environments.

Role Focus

A Senior Database Engineer at Effectual is a data professional responsible for managing and maintaining complex NoSQL database environments. As a Cloud DBA in Delivery, you will be assessing NoSQL database solutions for deploying, migrating, and tuning optimal database solutions in cloud environments, with particular emphasis on MongoDB, DynamoDB, DocumentDB, and Neptune.

Essential Duties and Responsibilities

Core Database Management

• Design, install, configure, and maintain cloud-based NoSQL database environments including MongoDB, DynamoDB, DocumentDB, and Neptune
• Monitor NoSQL database performance and proactively identify and address performance issues specific to document stores and key-value databases
• Ensure the security of NoSQL database environments, including access control, data encryption, and proper authentication mechanisms
• Develop and implement backup and recovery procedures tailored to NoSQL database architectures
• Plan and execute NoSQL database upgrades and migrations between different NoSQL platforms
• Provide technical support to end-users and troubleshoot issues with NoSQL databases

Advanced NoSQL Responsibilities

• Design and implement optimal document schemas and data models for MongoDB environments
• Configure and optimize DynamoDB partition keys, sort keys, and global secondary indexes
• Implement and maintain MongoDB replica sets and sharded clusters
• Design and manage DynamoDB auto-scaling policies and on-demand capacity configurations
• Handle NoSQL-specific procedures such as data modeling optimization, index management, and aggregation pipeline tuning
• Profile and optimize query performance for document-based and key-value operations

Cloud and DevOps Integration

• Automate NoSQL database maintenance and management tasks using Infrastructure as Code (IaC)
• Create comprehensive documentation for NoSQL database service configurations and options
• Stay current with emerging trends and technologies in cloud-based NoSQL database solutions
• Maintain expertise with CI/CD pipelines for NoSQL database deployments
• Collaborate with development teams to optimize application-database interactions for NoSQL architectures

Team Collaboration and Project Management

• Collaborate with team members and stakeholders to ensure NoSQL database architecture design meets performance and scalability requirements
• Support rigorous project governance through daily progress reviews and time tracking
• Operate with transparency and responsiveness to team member requests
• Communicate working preferences to develop high-performing, respectful teams

Skills and Experience

Required Experience

• 7+ years of experience in the database field with significant NoSQL specialization
• Bachelor's degree in Computer Science, Information Technology, or related field
• Experience in three or more NoSQL platforms including MongoDB and DynamoDB
• Strong proficiency in NoSQL database management and data modeling principles
• Experience with recent versions of MongoDB (5.0+) and current DynamoDB features
• Understanding of NoSQL database underlying storage engines and configuration options
• Experience with NoSQL database replication, high availability, and disaster recovery strategies

Technical Proficiencies

• MongoDB expertise: Document modeling, aggregation framewo