Database Administrator

$138,590 - $138,590/Yr

Unclassified - Austin, TX

posted 3 months ago

Full-time - Senior
Austin, TX

About the position

As a MongoDB Database Administrator at SDNA Global, you will play a crucial role in configuring and managing MongoDB databases to meet application requirements. Your primary responsibilities will include setting up MongoDB replica sets and sharded clusters, ensuring that they are optimized for performance and security. You will be tasked with enhancing MongoDB security by implementing X509 and TLS authentication to comply with industry standards, particularly those set by Apple. Additionally, you will automate backup, restore, and monitoring jobs using Python and shell scripting, which will streamline operations and improve efficiency. Your expertise will be essential in designing, installing, and configuring multi-node MongoDB sharded clusters and replica sets on Linux platforms. You will be responsible for adding and removing replica and shard nodes as needed, creating text indexes for efficient querying, and ensuring an even distribution of data across multiple shards. As data size grows, you will convert replica sets to sharded clusters to enhance query performance. You will also oversee the upgrade and migration of replica sets and sharded clusters, ensuring that all processes are executed smoothly and without data loss. In this role, you will utilize your in-depth knowledge of Ops Manager for monitoring and managing MongoDB instances, including performing upgrades and understanding group and project configurations. Your responsibilities will also include documenting MongoDB installations, operations, security measures, and auditing across multiple environments. You will need to have a strong grasp of query plan architecture and performance tuning at both the host and database levels, as well as knowledge of range-based and hash-based sharding and indexing. Migration of MongoDB clusters to AWS will also be part of your duties, requiring strong communication and collaboration skills to manage multiple tasks effectively.

Responsibilities

  • Configure MongoDB replica sets and sharded clusters as per application requirements.
  • Set up MongoDB BRS & Ops-Mgr and onboard replica sets & sharded clusters onto Ops-Mgr.
  • Enhance MongoDB security using X509 and TLS authentication to comply with Apple security standards.
  • Automate backup, restore, and monitoring jobs using Python and shell scripting.
  • Design, install, and configure multi-node MongoDB sharded clusters and replica sets on Linux platforms.
  • Add and remove replica and shard nodes in MongoDB clusters as needed.
  • Create text indexes for querying specific documents with string content.
  • Ensure even distribution of data across multiple shards by managing shard keys.
  • Convert replica sets to sharded clusters due to data size growth and better query rate planning.
  • Oversee upgrades and migrations of replica sets and sharded clusters from version 4.0 to 4.xx.
  • Deploy, migrate data, monitor, analyze, and tune MongoDB databases.
  • Document MongoDB installation, operations, security, and auditing across multiple environments.

Requirements

  • Senior level experience in MongoDB database administration.
  • Strong knowledge of authentication methods, including X509 and TLS.
  • Experience with performance tuning and query plan architecture.
  • Proficiency in Python and shell scripting for automation tasks.
  • In-depth knowledge of MongoDB replication architecture and change streams.
  • Experience with Ops Manager and its upgrade processes.
  • Familiarity with range-based and hash-based sharding and indexing.
  • Ability to document processes and maintain operational standards.

Nice-to-haves

  • Experience with AWS for MongoDB cluster migration.
  • Strong communication and team collaboration skills.
  • Ability to manage multiple tasks effectively.

Benefits

  • Health savings account
  • Relocation assistance
  • Health insurance
  • Dental insurance
  • 401(k)
  • Flexible spending account
  • Tuition reimbursement
  • Paid time off
  • Parental leave
  • Employee assistance program
  • Vision insurance
  • 401(k) matching
  • Employee discount
  • Professional development assistance
  • Flexible schedule
  • Life insurance
  • Referral program
  • Retirement plan
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service