Senior Database Systems Engineer/Administrator (MongoDB)

Key Responsibilities

• Administer, maintain, and support MongoDB (NoSQL) and SQL databases in production environments.
• Design and manage clustered and distributed database architectures, including replica sets, sharding, and partitioning.
• Deploy and support databases across on-premises, cloud, and MongoDB Atlas environments.
• Perform database performance tuning and query optimization to improve throughput, latency, and reliability.
• Analyze and optimize queries, indexes, schemas, rows, columns, and partitions.
• Manage stored procedures, database objects, and schema changes.
• Ensure data integrity, availability, backup, recovery, and disaster recovery strategies.
• Monitor database health, capacity, and performance using industry-standard tools.
• Implement and enforce security best practices, access controls, encryption, and compliance standards.
• Collaborate with application, DevOps, and infrastructure teams to align database design with application needs.
• Troubleshoot and resolve database-related issues in high-availability environments.
• Automate database provisioning, configuration, and maintenance tasks.

Required Technical Skills & Expertise

• Database Technologies: MongoDB / NoSQL, Document-based data modeling (BSON/JSON), Schema design and flexibility, Sharding, replication, and clustering, MongoDB Query Language (MQL), SQL Databases, Relational data modeling (tables, rows, columns), Strong knowledge of SQL, stored procedures, and transactions, Performance tuning for complex joins and queries, Understanding of ACID vs BASE, CAP theorem, and data consistency models, Experience with HQL, HBase, or similar big data query/storage systems (plus).
• Performance & Optimization: Query optimization and execution plan analysis, Indexing strategies, Database performance tuning, Partitioning and data distribution strategies.
• Infrastructure & DevOps: Strong knowledge of AWS cloud, preferably EKS, Kubernetes (as we are migrating from EC2 instances of Mongo to EKS), Scripting & Automation (Bash, Python, or similar), Infrastructure as Code (IaC) using Terraform, Experience deploying databases in Kubernetes environments, CI/CD pipelines and automation, Version control using GitHub and GitHub Actions.

Other Qualifications

• Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
• 5+ years of experience as a Database Administrator / Database Systems Administrator.
• Proven experience supporting production, high-traffic database environments.
• Strong troubleshooting, documentation, and communication skills.