SME | Database Administration

Responsibilities
• Strong proficiency in both RDBMS (MySQL) and NoSQL database (MongoDB) management
• Ever greening the database / servers with latest upgrades and patches in both MySQL and MongoDB
• Setup and maintain database schemas both on MySQL and MongoDB
• Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
• Design and development experience in building reusable REST API model / framework to consume data from and / or push data into MongoDB
• Data loading from various databases and various formats
• Maintain User identity and access to various components of Database
• Maintain data integrity across database(s)
• Develop and maintain strong product knowledge.
• Stay abreast with new innovations and the latest technology trends and explore ways of leveraging these for improving the product in alignment with the business

Technical Skills
• Preferable:Minimum 3-4 years in MongoDB / PostgreSQL Development / administration in high performing scalable environment. Experience and understanding of government services, Safety & Mobility domains
• Must have skills:Extensive exposure to RDBMS databases like MySQL and NoSQL database like MongoDBMust have implemented at least two large MongoDB eco-systemsMust have worked at least 5 years as RBBMSIn-depth knowledge of modeling / architecture patterns, governance methodologies and potential limitations of MongoDBKnowledge of limitations in MySQL / MongoDB and their workarounds in contrast to other popular databasesExperience in data compression & back-up mechanismsExperience in creating the Database schemas & Maintenance of the sameExperience in data Masking techniquesExperience in scheduling the jobs to continuously refresh the data in real-time and near real-timeKnowledge of de-facto standards and best practices in MySQL & MongoDBProficient in writing and optimizing SQL statementsKnowledge of MySQL/Enterprise DB features, such as its event schedulerExpert in operating systems like Linux, Ubuntu etc., including scripting & file systemsMust have worked on MongoDB administration in Hadoop environment Experience in setting-up MongoDB based Data Lake and Data warehouse solutions Experience in integrating MongoDB with other OLTP, OLAP databases / systems along with user systems like Mobile and Web applications Exposure working in Physical Data Center and Cloud platformsExperience in working on large volumes of data like Multi Peta bytes and variety of dataStrong problem solving and logical skills & A Go-getter kind of attitude

Additional Skills
• Shall have thorough working knowledge to translate RFP's technical, functional & SLA requirements to BoQ
• Excellent oral and written communication, presentation, and analytical skills
• Excellent problem solving and programming skills
• Proven technical leadership and strong interpersonal communication skills
• Understanding of Smart Communication Infra, Security and Surveillance – will be added advantage
• Ability to work under demanding project implementations.

Strong understanding and experience with DB replication strategies, tech, tools and implementation.

DB administration experience with user management, Data Migration, Performance Management, backup and Data recovery etc.

Good understanding and experience with Cloud infrastructure, for DB hosting, Managing and performance optimization for storage, transaction and network economics etc.
Hope we use MongoDB a lot, b/c everywhere it is stressed upon.

Good communication skills and team player to collaborate and deliver tasks, interacting with tech / non-tech stakeholders