Experience 1 Yr Number Of Position 2 Location Jaipur Rajasthan We are looking for an experienced Database Administrator for MySQL role who shall be responsible to work Maintenance Security Upgrades Performance Tuning etc and to handle a wide range of activities from leading mid to large-size projects You ll be part of a team of problem solvers who are passionate about working in a highly dynamic client-centric technology company The candidate must possess the ability to think quickly provide creative and effective solutions for clients through analytical and logical acumen Must Have Skills Experience in logical and physical data modeling MongoDB - Must have Experience in crafting indexes SQL queries and resultant explanation of access paths for optimizing the SQL Experience in Linux Unix operating systems Expertise in upgrading and migrating databases to the Cloud Experience in troubleshooting Oracle instance SQL performance issues Proficiency in database administration management data imports and exports and developing reports Positive to Have Skills Excellent written and verbal communication skills with a demonstrated ability to make difficult concepts easy to understand Intermediate knowledge in hardware and networking Experience managing databases Ability to adapt to varied roles and problem-solving skills Good scripting coding experience with any of the following Unix Shell Python and Ruby Experience with 24 7 support backup and recovery practices Experience with MongoDB is a plus Job Responsibilities Server and Database Security Administration Builds and provides support for entire database schemas Develops database utilities and automated reporting Analyses and sustains capacity and performance requirements Monitors systems and platforms for availability Oversees backup clustering mirroring replication and failover and ensures all jobs complete successfully Designs and documents database architecture Performs maintenance operations daily weekly and monthly on MySQL database Implements and maintains database security permissions and encryption Disaster recovery high availability Failover Clustering Performs any necessary restorations database recovery and troubleshooting for any critical problems