Database/Devops Engineer

Mumbai, India Full Time

Reporting Structure

The role is part of Research and Innovation vertical

Job Description

Are you someone who likes to use the right AND left side of the brain- Are you an amazing result-driven database / devops engineer who's not afraid to implement positive change- Are you both creative and analytical- Do you not like being micro-managed- Do you get a kick on being challenged- If you answered - positively- to above questions, continue reading!

The database/Devops engineer is a high-level individual contributor, and should have experience and comfort collaborating with C-level executives. This is a full-time employee position located in Vashi, Navi Mumbai.

Education

Bachelors Computer science or equivalent

Masters preferred

Industry

Information Technology

Experience

2-5 years of experience

Responsibility

  • Determining what data must be returned to the application and writing queries for it

  • Reviewing database design and making suggestions for better performance

  • Providing SQL statements tuning, optimizing ETL procedure and query performance bottleneck by using tools such as Explain path etc

  • Creating table indexes that optimize query speeds

  • Determining the right stored procedures, views, and functions for the application

  • Build database systems of high availability and quality depending on each end user’s specialized role

  • Define users and enable data distribution to the right user, in appropriate format and in a timely manner

  • Use high-speed transaction recovery techniques and backup data

  • Minimize database downtime and manage parameters to provide fast query responses

  • Determine, enforce and document database policies, procedures and standards

  • Perform tests and evaluations regularly to ensure data security, privacy and integrity

  • Plan and execute DDL and schema upgrades

  • Monitor database performance, implement changes and apply new patches and versions when required

  • Deploying, automating, maintaining and managing AWS cloud based / In house production system, to ensure the availability, performance, scalability and security of productions systems

  • Build, release and configuration management of applications

  • System troubleshooting and problem solving across platform and application domains

  • Collaborate with other team members and stakeholders

Skills and Qualifications

  • Key Skills:

    Strong proficiency with SQL and its variation among popular databases

  • Expertise in entity relationship modeling

  • Experience with some of the modern relational databases

  • Experience with No-SQL Databases

  • Experience with DR/Replication Models

  • Experience of ORM methodologies

  • Skilled at optimizing large complicated SQL statements

  • Knowledge of best practices when dealing with relational databases

  • Capable of configuring popular database engines and orchestrating clusters as necessary

  • Experience in designing and implementing database security measures like access control, authentication, authorization, and auditing

  • Experience of AWS / Cloud is a must

  • Experience of using and configuring Linux / Unix systems

  • Experience with Jenkins/Docker would be an added advantage

  • Experience of DevOps Tools like Chef, Puppet, Ansible, Nagios etc would be added advantage

  • Experience in using a version control system, preferably Git

  • Candidates who have a professional certification in Database / DevOps would be preferred

  • Should have can do attitude

  • Candidates whose notice period is more than 30 days, please do NOT apply