SQL DB Dev Analyst

Responsibilities

• Build reusable code and libraries for future use.
• Writing reusable, testable, and efficient code
• Own & build new modules/features end-to-end independently.
• Collaborate with other team members and stakeholders.
• Work in an agile environment to rapidly build high-quality and robust features.
• Participate in DevOps.
• Implementation of security and data protection.

Required Skills

• Master in Node.js and frameworks available for it. (Nest.js / Loopback / AdonisJS)
• Excellent understanding of ES6 and OOP.
• Good understanding of SQL & No-SQL Databases. (MySQL / PostgreSQL)
• Understanding the nature of asynchronous programming and its quirks and workarounds.
• Open Source and DevOps enthusiast.
• Comfortable with Test Driven Development.
• Can learn and adapt fast, as well as identify and solve problems.

Bonus Skills

• Hands-on with TypeScript

Job Perks

• Get to work with a highly passionate team of engineers.
• Open and embracing culture towards the latest hot technologies.
• A high level of freedom & responsibility.

• Implement best practices for the engineering team across code hygiene, overall architecture design, testing, and deployment activities
• Drive technical decisions for building data pipelines, data lakes, and analyst access.
• Act as a leader within the engineering team, providing support and mentorship for teammates across functions
• Bachelor’s Degree in Computer Science or equivalent job experience
• Experienced developer in large data environments
• Experience using Git productively in a team environment
• Experience with Docker
• Experience with Amazon Web Services
• Ability to sit with business or technical SMEs to listen, learn and propose technical solutions to business problems

·       Experience using and adapting to new technologies

·       Take and understand business requirements and goals

·       Work collaboratively with project managers and stakeholders to make sure that all aspects of the project are delivered as planned

·       Strong SQL skills with MySQL or PostgreSQL

• Experience with non-relational databases and their role in web architectures desired

 Knowledge and Experience:

• Good experience with Elixir and functional programming a plus

• Several years of python experience
• Excellent analytical and problem-solving skills
• Excellent organizational skills

Proven verbal and written cross-department and customer communication skills

The key aspects of this role: 

• Candidate with exceptional programming skills, problem-solving abilities and strong work  ethic. 
• The candidate has to work on custom programming and web application development for  Drupal. 
• Testing, maintenance and troubleshooting of existing company sites and resolving issues if  any. 
• Contributing ideas and efforts towards internal projects and working as part of a team to  find solutions on various problems. 
• Communicate technical ideas to business users and other teams (design, QA). • Collaborate with team members and to work independently when needed. • Eager to embrace current and emerging web technologies. 

To be the right fit, you'll need: 

• Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years  in Drupal 8) 
• Strong knowledge of MySQL, jQuery, HTML5, CSS 
• Experience with Drupal architecture, best practices and coding standards 
• Knowledge on Views, Services etc. 
• Experience in custom module and theme creation 
• Familiar with sub version control systems such as Git or SVN 
• Basic knowledge of environment setup for Linux distribution

Minimum of 4+ years of experience in Java development

• Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
• Experience developing and deploying Java solutions to cloud
• Experience in Spring Boot and components of Spring framework
• Experience in a JavaScript framework such as Angular or React
• Experience in TDD using Junit or similar frameworks

·       Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.

·       Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.

·       Experience in SQL, Unix skills.

·       Good communication Skill

• Experience in Microsoft ASP, C#, SQL server, and github.
• Experience with software design and development in a test-driven environment.
• Experience with databases.
• Ability to learn new languages and technologies.
• Good communication skills.

1. 1.5+ Years of experience in .net, asp.net and C#, WCF/API and REST services.
2. Hands on experience with CSS, Javascript and JQuery.
3. Strong knowledge in OOPS concepts.
4. Knowledge of T SQL with Sql server 2008 R2/2012 including Stored Procedures, Triggers & User Defined Functions.
5. Good to have CSS3 and HTML5 knowledge.
6. Good communication Skills are required.

• Build data pipelines for structured/unstructured, real-time/batch, events/synchronous/asynchronous using MQ, Kafka, Steam processing using Java / Python
• Design the Data stores for Big Data systems with expertise in Cassandra, HBase
• Implementation of Indexing and Search using Elasticsearch
• Setup and Deployment of Cassandra, Elasticsearch clusters

• Strong hands-on experience with Cassandra, data modeling, data replication, clustering, indexing for handling for large data sets
• Experience with SQL, NoSQL, relational database design, and methods for efficiently retrieving data for Time Series Analytics
• Strong understanding of CQL, Data Modeling in-order to achieve highly performant data access
• Strong experience in data modeling in Cassandra to design efficient storage model to meet variety of business needs
• Should have Elasticsearch skill with significant experience working with large Elasticsearch clusters, cluster performance optimisation, capacity planning, enhancing monitoring capabilities for early issue detection, driving operational readiness and ongoing maintenance
• Strong hands-on experience of programming with Java / Python
• Ability to troubleshoot and investigate stability, performance issues