MongoDB Database Administrator
- 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
Do
- Provide adequate support in architecture planning, migration & installation for new projects in own tower (platform/dbase/ middleware/ backup)
- Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution
- Conduct technology capacity planning by reviewing the current and future requirements
- Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable
- Strategize & implement disaster recovery plans and create and implement backup and recovery plans
- Manage the day-to-day operations of the tower
- Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues.
- Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower
- Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges
- Develop shift roster for the team to ensure no disruption in the tower
- Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc.
- Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps
- Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness
Team Management
- Resourcing
- Forecast talent requirements as per the current and future business needs
- Hire adequate and right resources for the team
- Train direct reportees to make right recruitment and selection decisions
- Talent Management
- Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness
- Build an internal talent pool of HiPos and ensure their career progression within the organization
- Promote diversity in leadership positions
- Performance Management
- Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
- Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
- Employee Satisfaction and Engagement
- Lead and drive engagement initiatives for the team
- Track team satisfaction scores and identify initiatives to build engagement within the team
- Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team
- Exercise employee recognition and appreciation
Deliver
No Performance ParameterMeasure
1Operations of the tower SLA adherence
Knowledge managementCSAT/ Customer ExperienceIdentification of risk issues and mitigation plansKnowledge management
2New projectsTimely delivery
Avoid unauthorised changesNo formal escalations
Mandatory Skills: MongoDB Admin.
