Senior Database Architect

Job Title: Senior Database Systems Engineer/Administrator (Redis/MongoDB/ Oracle RDS)

Location: Walnut Creek, CA (Hybrid // 3 days per week Onsite, 2 days Remote--job)

Duration: 12+ months with potential extensions

Job Summary:

We are seeking an experienced Database Systems Platform Engineer/Administrator to design, manage, optimize, and secure enterprise database platforms across Redis , Oracle Relational databases , Goldengate replication and MongoDB. The ideal candidate will have working knowledge of AWS environment including EKS, Kubernetes, Terraform, Grafana . Must have hands-on experience on 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 Redis (Mem cached) , MongoDB (NoSQL) and Oracle 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.

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)

Oracle & golden gate Databases

• Installation and configuring Oracle on RAC/RDS .
• Creating goldengate extracts, replicats between oracle databases on RDS/RAC

Performance & Optimization:

• Query optimization and execution plan analysis.
• Indexing strategies
• Database performance tuning
• Partitioning and data distribution strategies

Infrastructure & DevOps (Bonus):

• 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.