Designation: Mongo DBA
Location: New York City NY
Detailed JD
- 8 -10 years Experienced DBA (any database)
- MongoDB DBA (2 years plus)
- Scripting and programming experience
- Production deployment experience
- Migration experience from RDBMS to MongoDB.
- Exposure to public cloud would be an added advantage
Responsibilities:
- MongoDB - CRUD Operations, Document based Data Modeling, Design of Collections and Documents
- Experience with physical collection creation, access pattern tuning, sharding implementation, index creation, and debugging query execution to obtain optimum database performance
- Excellent understanding of various MongoDB database design patterns and physical architectures for different use cases
- Data replication and sharding in a distributed database
- Aggregation of data using MapReduce and other batch processing use cases
- Experienced in MongoDB Security
- Detecting performance problems using Mongo Profiler
- Automate routine tasks with your own scripts and open-source tools
- Defragmentation
- Schema Design working with Application/Development team
- Query fine tuning
- Shell scripts for Monitoring like 'slow queries', replication lag, nodes fails, disk usage etc.
- Backup and restores ( Backups should be automated with shell scripts/Ops Manager)
- Database Health check (Complete review of Database slow queries, fragmentation, index usage...etc. )
- Index rebuild
- Upgrades (Java version, Mongo version,etc)
- Maintenance ( Data center outages, etc)
- Architecture design as per the Application requirement
- Writing best practices documents for sharding, replication for Dev/App teams
- Log rotation/ maintenance ( mongos, mongod, config . etc)
- Segregation of duties ( User Management designing User roles and responsibilities )
- Disk usage, CPU, Memory check Alerting
- Database Hardening
- Designing DR (Disaster Recovery)/COB ( Continuity of Business) plans as applicable
- Database Profiling, Locks, Memory Usage, No of connections, page fault etc.,
- Export and Import of Data to and From MongoDB, Run time configuration of MongoDB,
- Data Managements in MongoDB Capped Collections Expired data from TTL,
- Monitoring of Various issues related with Database,
- Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB,
- Database software Installation and Configuration in accordance with Client defined standards
- Database Migrations and Updates
- Application of database patches
- Capacity management
- Hands on experience in Server Performance tuning and Recommendations
- High availability solutions and recommendations
- Hands on experience in Root cause analysis for business impacting issues