Send me more jobs like this

Database Administrator – Safe & Smart City Platform

Keywords / Skills : rdbms, mysql, Nosql, MongoDB, database administrator, Hadoop, mongodb administration, BE/Btech, Top university, iit, nit, vit, Hyderabad

8 - 12 years
Posted: 2019-11-19

Industry
IT/Computers - Software
Function
IT
Role
Database Administrator (DBA)
Posted On
19th Nov 2019
Job Description
Database Administrator – Safe & Smart City Platform
Location: Hyderabad

Reports to: Head – Data Sciences

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.



Qualifications/Skills

● Experience:

○ B. Tech / B.E in computer science or any other allied fields from premier institutions.

○ 8-10 years of total experience as database administrator with 3-4 years as MongoDB administrator in high performing scalable environment.

● Preferable:

○ Experience and understanding of government services, Safety & Mobility domains

○ Work experience as MongoDB developer

● Must have skills:

○ Extensive exposure to RBBMS databases like MySQL and NoSQL database like MongoDB

○ Must have implemented at least two large MongoDB eco-systems

○ Must have worked at least 5 years as RBBMS administrator

○ In-depth knowledge of modeling / architecture patterns, governance methodologies and potential limitations of MongoDB

○ Knowledge of limitations in MySQL / MongoDB and their workarounds in contrast to other popular databases

○ Experience in data compression & back-up mechanisms

○ Experience in creating the Database schemas & Maintenance of the same

○ Experience in data Masking techniques

○ Experience in scheduling the jobs to continuously refresh the data in real-time and near real-time

○ Knowledge of de-facto standards and best practices in MySQL & MongoDB

○ Proficient in writing and optimizing SQL statements

○ Knowledge of MySQL/Enterprise DB features, such as its event scheduler

○ Expert in operating systems like Linux, Ubuntu etc., including scripting & file systems

○ Must 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 platforms

○ Experience in working on large volumes of data like Multi Peta bytes and variety of data

○ Strong problem solving and logical skills & A Go-getter kind of attitude



About Company

bhn ltd
Similar Jobs
View All Similar Jobs


Walkin for you