Mongo Database Administrator

About the position

The position requires extensive experience in the design, installation, and configuration of multi-node MongoDB sharded clusters and replica sets on Linux platforms. The candidate will be responsible for adding and removing replica and shard nodes in the MongoDB cluster as needed, ensuring even distribution of data across multiple shards, and converting replica sets to sharded clusters due to data size growth and improved query rate planning. The role also involves knowledge of upgrade and migration processes for replica sets and sharded clusters, as well as deploying, migrating data, monitoring, analyzing, and tuning MongoDB systems. In-depth knowledge of Ops Manager, including its upgrade processes, is essential, along with understanding groups and projects within Ops Manager. Security measures such as configuring SSL key files for all mongod instances and knowledge of authentication and authorization, including X509 authentication, are also required. The candidate should document MongoDB installations, operations, security, and auditing across multiple environments, and possess knowledge of query plan architecture and performance tuning at both the host and database levels. Familiarity with range-based and hash-based sharding/indexing, migration of Mongo clusters to AWS, and building replica sets/sharded clusters is necessary. The role includes experience in upgrading Mongo clusters, scaling MongoDB across data centers, and understanding high availability strategies, including replica sets and sharded clusters. The candidate should have worked on initial sync of replica sets, oplog resizing, and addressing issues related to slow secondary sync and WiredTiger cache management. Knowledge of arbiter for high availability, high oplog generation, tuning oplog size, MongoDump, and MongoRestore, as well as read/write concerns, is also required.

Responsibilities

• Design, install, and configure multi-node MongoDB sharded clusters and replica sets on Linux platforms.
• Add and remove replica and shard nodes in MongoDB cluster as needed.
• Ensure even distribution of data across multiple shards.
• Convert replica sets to sharded clusters due to data size growth.
• Manage upgrade and migration processes for replica sets and sharded clusters.
• Deploy, migrate data, monitor, analyze, and tune MongoDB.
• Utilize Ops Manager and manage its upgrades.
• Configure SSL key files for security across all mongod instances.
• Document MongoDB installation, operations, security, and auditing.
• Tune query plan architecture and performance at host and DB level.
• Migrate Mongo cluster to AWS.
• Build and upgrade MongoDB clusters.
• Scale MongoDB across data centers and implement high availability strategies.
• Work on initial sync of replica sets and oplog resizing.
• Address issues related to slow secondary sync and WiredTiger cache management.
• Manage read/write concerns.

Requirements

• Experience in design, installation, and configuration of multi-node MongoDB sharded clusters and replica sets.
• Good knowledge of shard keys and data distribution across shards.
• Experience in converting replica sets to sharded clusters.
• Knowledge of upgrade and migration processes for MongoDB.
• In-depth knowledge of Ops Manager and its upgrade processes.
• Understanding of authentication and authorization, including X509 authentication.
• Experience in configuring SSL for security.
• Extensive knowledge of MongoDB replication architecture and change streams.
• Ability to document MongoDB operations and security measures.
• Knowledge of query plan architecture and performance tuning.
• Experience with range-based and hash-based sharding/indexing.
• Experience in migrating Mongo clusters to AWS.
• Knowledge of MongoDB scaling and high availability strategies.

Nice-to-haves

• Experience with MongoDump and MongoRestore.
• Knowledge of read/write concerns.
• Experience with high oplog generation and tuning.

Benefits

• Salary Range: $62,500 - $130,000 a year