Job Title: Senior Database Systems Engineer/Administrator (Redis/MongoDB/ Oracle RDS)
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:
- Document-based data modeling (BSON/JSON)
- Schema design and flexibility
- Sharding, replication, and clustering
- MongoDB Query Language (MQL)
- 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.