Job Description :
Responsibilities:
Understand and apply advanced database administration, management and performance tuning techniques specific to MongoDB & Cassandra.
Proactively identify trends in query performance and provide recommendation for efficient use of resources
Proactively identify resource requirements to ensure high availability of database systems
Provide technical advice and expertise to less senior staff members
Provide 24x7 on call support as part of a scheduled rotation with other team members
Provide advanced technical troubleshooting for applications and database systems with emphasis on root cause analysis
Ability to perform the following:
Participate in design and application review sessions, assist with definition of computing standards and recommend policies related to those standards
Research solutions to various business and technical problems, evaluate alternatives and be able to present recommendations and justifications to management
Configure and tune hardware and software to insure optimum performance and resource utilization
Develop advanced scripts in support of database operations
Enforce Security policies and procedures on databases
Write and maintain documentation describing changes and modifications to all systems and databases
Perform exports, backups, restores, refreshes and data extracts as required
Act as technical liaison in support for database related project activities
Develop strong working knowledge of key applications and their interaction with the database(s)
Qualifications
7-10 years as a database administrator working with MongoDB & Cassandra.
Experience in a large, 24x7 environment
Experience with multi-terabyte databases
Replication concepts and replica set administration
Experience with High Availability Technologies.
Setting up Multi-Datacenters for Cassandra.
Implement Disaster Recovery for Cassandra.
Patch/Upgrade Cassandra. Implement, maintain and tune Apache Spark.
Implement backup strategies for Apache Cassandra.
Implement monitoring solutions.
Experience in performing Mongo DBA operational routines
Mongodb DBA, MMS configuration experience
Configuring and monitoring replica sets
Optimizing database/query performance
Configuring Sharding , monitoring, and identify the proper shard key. Selection, inserting large amounts of data
Performing Security measures, backups and restore backups
Advanced knowledge of debugging and performance tuning stored procedures, UDFs and triggers.
Advanced installation and configuration experience
Advanced knowledge of hardware, including clusters, RAID, multi-processor architecture, etc.
Strong knowledge of high availability and Disaster Recovery architecture
Solid experience with the Windows operating system and command set as well as competence with PowerShell scripting
Thorough knowledge of physical and logical disk systems and their impact on database performance
Education/Vocational Training:
A four year degree in Computer Science or equivalent experience