Mongo DBA-Philadelphia, PA - Georgia IT Inc.
Philadelphia, PA
About the Job
Mongo DBA
Location: Philadelphia, PA
Duration: Contract
Rate: DOE
U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time
Technical Requirements and Certifications:
· MongoDB - CRUD operations, document-based data modeling, design of collections and documents
· Data replication and sharding in a distributed database
· Aggregation of data using MapReduce and other batch processing use cases
· Detecting performance problems using Mongo Profiler
· Defragmentation
· Schema design and query fine tuning
· Shell scripts for monitoring, like slow queries, replication lag, nodes fails, disk usage, etc.
· Backup and restores, and database health check
· Index rebuild, and upgrades (Java version, Mongo version, etc.)
· Maintenance (data center outages, etc.)
· Writing best practices documents for sharding, replication for Dev/App teams
· Disk usage, CPU, memory check alerting
· Database hardening
· Designing DR (Disaster Recovery)/COB (Continuity of Business) plans
· Database profiling, locks, memory usage, no of connections, page fault, etc.
· Export and import of data to and from MongoDB, runtime configuration of MongoDB
· Monitoring at server, database, collection level, and various monitoring tools related to MongoDB
· Capacity management
Education and Experience:
· A Bachelor's Degree in Computer Science, Information Systems or a related field, or equivalent work experience
· 10+ years of IT work experience in DBA, DBMS design and support and relevant computing environments
· 5+ years of MongoDB experience in a Linux environment
· 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
· Hands-on experience in server performance tuning and recommendations
· Hands-on experience in root cause analysis for business impacting issues
· Knowledge, Skills and Abilities:
· Excellent understanding of various MongoDB database design patterns and physical architectures for different use cases
· Strong team player with the ability to communicate with other teams and business users
· Strong oral and written communication skills, including technical documentation
· Solid organizational and prioritizing skills
· Ability to work in a high pressure environment with limited supervision
· Ability to work in a fast growing, high expectation environment
Job Responsibilities:
· Responsible for designing, modeling, developing and supporting Database Management Systems (DBMS)
· Analyze data requirements, application and processing architectures, data dictionaries, and database schema(s), and then design, develop, amend, optimize and certify database schema design to meet system(s) requirements
· Gather, analyze and normalize relevant information related to and from business processes, functions and operations
· Develop database and warehousing designs across multiple platforms and computing environments
· Develop an overall data architecture that supports the information needs of the business
Source : Georgia IT Inc.