Job Description
Role Overview: NoSQL DB architect
DB architect role is a mix of database architecture designer and Web/REST service/API/Microservice developer where he is expected to design the DB schema/entities and relationships from the scratch for a product and will independently own the same for any future changes or developments. He will be a single point of contact for all DB related changes and updates and will act as expert for the database part of the products.
He will also own the DB security, robustness and scalability. He will act as the guardian of a highly sensitive and confidential data set and will devise and implement techniques to ensure the data safety.
Responsibilities:
· Understanding the business/technical requirements and come up with a robust database architecture design which meets the requirements.
· Getting involved in the product architecture & DB design discussions and ensure the designed architecture is in sync with the requirements after discussing with the concerned stakeholders.
· Conceptualize the requirements and convert it to a full proof DB design through data modelling.
· Closely work with application developers and guide them in terms of best practices while working with the database part, implement the application database requirements within specified timelines.
· Extensive working of such NoSQL systems like Cassandra and/or MongoDB in terms of performance, reliability and scalability. Schema based DBs like Postgres will also be used.
· Tune and optimize database system for optimal performance.
· Understand the scalability and reliability needs of the product and implement various methodologies to support it like clustering, sharding, replication etc. and maintain the same.
· Create and maintain a documentation of the database design/schema/architecture and update it time to time as per need basis.
· Take measures to ensure data security and safety and devise methods and technologies for that.
· Monitor DB usage in terms of storage & performance and constantly update the design & setup to achieve utmost optimization.
Requirement:
· BS/MS degree in Computer Science or a related technical field, or equivalent practical experience from a premier college.
· Total of at least 6-8 years of experience and a relevant experience of at least 2 years.
· Expert knowledge & experience on the NoSQL/Schema less/In memory database systems like Mongo dB, Cassandra, Dynamo DB etc. Experience in Schema based RDBMS like MSSQL, PostgreSQL etc. is expected by default.
· Hands-on experience is a must on Cassandra and/or Mongo dB of at least 2 years. The candidate must have an in-depth understanding of its design principles and mechanisms.
· Experience of at least 4 years with the database modelling, defining entities and relationships in sync with the business/product requirements in any reputed organization is needed. It would be nice if the candidate can share with us an example of the past work he has done in terms of database design which is industry accepted, running and has proved to be a success.
· Experience designing/architecting the database of a highly scalable application.
· Experience in DB clustering, replication etc. and defining architectures for high scalability and reliability.
· Expert level knowledge on database queries and query optimizations.
· Passion to explore new technologies, improvements, features.
