Job Description :
Job Title
Oracle DBA w/ Mongo
Job Type
Contract
Job Location
Philadelphia
Looking for an Oracle DBA w/ some exposure or understanding of Mongo Clusters
On Oracle: RAC, Data-guard, Database migrations, Golden Gate replication, understanding of production scale implementations and maintenance is what we need.
We need extensive hands-on with Shell/Perl/Python scripting
Working knowledge on any of these: Terraform/Ansible/Chef/Puppet.
Education and Experience
5+ Years of MongoDB database experience in a Linux environment
Hands-on experience in server performance tuning and recommendations
Hands-on experience in root cause analysis for business impacting issues
Experience with physical collection creation, access pattern tuning, sharding implementation, index creation, and debugging query execution to obtain optimum database performance
Experience in MongoDB security
Knowledge, Skills and Abilities
Excellent understanding of various MongoDB database design patterns and physical architectures for different use cases
Job Responsibilities
Data replication and sharding in a distributed database
Aggregation of data using MapReduce and other batch processing use cases
Detect performance problems using Mongo Profiler
Automate routine tasks with your own scripts and open-source tools
Defragmentation
Schema Design – work with application/development team
Query fine tuning
Shell scripts for monitoring like slow queries, replication lag, nodes fails, disk usage, etc.
Backup and restores
Database health check
Index rebuild
Upgrades (Java version, Mongo version, etc
Maintenance (data center outages, etc)
Architecture design as per the application requirement
Write best practices documents for sharding, replication for Dev/App teams
Log rotation/maintenance
Disk usage, CPU, memory check alerting
Database hardening
Design disaster recovery/continuity of business plans as applicable
Database profiling, locks, memory usage, page fault, etc.
Export and import of data to and from MongoDB
Data management in MongoDB Capped Collections
Monitor various issues related with database
Database software installation and configuration i
Database migrations and updates
Application of database patches - capacity management