JOBSEARCHER

Senior Database Architect

Job Title: Senior Database Systems Administrator (MongoDB)
Location: Walnut Creek, CA (Hybrid)
Duration: Long term Contract, with potential extensions. (There could be potential conversion to FTE as well, based on contract delivery, value addition you provide during your tenure as a contingent staff, and business needs.)
Job Summary: Our Customer is seeking an experienced Database Systems Administrator to design, manage, optimize, and secure enterprise database platforms across MongoDB (NoSQL) and relational SQL databases. Primary requirements are skills as a DBA and reliability/platform Engineer, with MongoDB, Redis, Oracle and Hbase, though Hbase and Oracle is not an absolute requirement as the client is migrating off of them. Primary database being MongoDB both on-prem and Atlas. The ideal candidate will have strong hands-on experience with clustered database environments, on-premises and cloud deployments (including MongoDB Atlas), Strong working knowledge of AWS environment including EKS, Kubernetes (as the client is migrating from EC2 instances of Mongo to EKS), Terraform and Grafana. Must have hands-on experience in installing, upgrading and patching database environments on AWS cloud deployments and on-premises, and performance tuning in high-availability, large-scale systems. This role also requires automation and Infrastructure as Code (IaC) expertise to support modern CI/CD-driven environments.
Key Responsibilities:
  • Administer, maintain, and support MongoDB (NoSQL), Redis (Mem cached) and SQL databases in production environments. Must independently drive the project to its conclusion
  • 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.
  • Technical Skills & Expertise (Required):Database Technologies:
  • MongoDB / NoSQL (Required, absolute)
  • Document-based data modeling (BSON/JSON)
  • Schema design and flexibility
  • Sharding, replication, and clustering
  • MongoDB Query Language (MQL)SQL Databases (Oracle):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 is a plus.)(Experience with HQL, HBase, or similar big data query/storage systems is a plus.)Performance & Optimization:
  • Query optimization and execution plan analysis.
  • Indexing strategies
  • Database performance tuning
  • Partitioning and data distribution strategies
  • Infrastructure & DevOps (Bonus):Strong knowledge of AWS cloud, preferably EKS, Kubernetes (as the client is 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.
Preferred Qualifications: Experience with Redis , Oracle, MongoDB (Enterprise & Atlas) in production environments. Cloud experience (AWS).Exposure to large-scale distributed systems and data platforms.