Job Description :
MongoDB(Must have -Oracle 4-5 years of experience)/F2F required after telephonic
6+ Months
Philadelphia, PA
new update below:
The manager is willing to move away from the top skills in Mongo and lean towards someone with more Oracle, they must be willing to learn more MongoDB once in the role.
So:
Mongo DB (gage their experience)
Must have -Oracle 4-5 years of experience:
Data guard w/ golden gate
table and index partitioning
Config mgt. tools (hands on) using either Ansible or Chef or terraform (must have deployment knowledge of these tools)
Must: Shell scripting
Job description:
Responsible for designing, modeling, developing and supporting Database Management Systems (DBMS Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment. Bachelor''s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience. Typically has at least 10 years of IT work experience in DBA, DBMS design and support and relevant computing environments.
This is a highly visible team in the Cloud Database Operations team. Phone interview and face to face required. No Skype! 24x7 shop so we need candidates who are flexible.
5+ Years of mongoDB Database Experience in a Linux Environment –
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 centre 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