Senior Database Developer - Data Modeling & DB Design Schema

Job Description

Build and maintain bots on Azure platform.  Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments

Qualifications

1. a) 5 years of experience in software development with clear understanding of the project life cycle
   b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework , LUIS and other Cognitive services offered by Azure
   c) Hands on experience with Machine Learning based chat bots
   d) Experience with Azure bot services like Text Analytics etc.
   e)Strong database skills and hands-on experience on databases like SQL Server/Oracle
2. f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
3. g) Strong experience designing and working with

with service-oriented architectures (SOA) and WebAPIs.

1. h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C# / VBNET
2. i) Knowledge of Python and NodeJS is a plus
3. j) Ability to design and optimize SQL Server 2008 stored procedures.
4. k) Experience with JQuery, CSS3, HTML5 or similar technologies.
5. l) Ability to adapt quickly to an existing, complex environment.

Job position: Analyst programmer 

Location: Mumbai - Andheri East

Salary: 12-13LPA (negotiable)

EXPERIENCE: 3+ years 

Experience in Winforms mandatory

Qualifications:

 Bachelor’s degree in Computer Science, Information Technology, or a related field.

 Proven experience as an Analyst Programmer or similar role.

 Proficiency in programming languages such as C#, Asp.net, Winform etc.

 Strong understanding of software development methodologies (e.g., Agile, Waterfall).

 Experience with database management systems SQL Server.

 Excellent analytical and problem-solving skills.

 Strong communication and interpersonal skills

Responsibilities

• Develop quality software and web applications
• Analyse and maintain existing software applications
• Create and maintain SQL databases, tables, views, stored procedures etc. (Microsoft SQL Server 2008+)
• Design highly scalable, testable code
• Discover and fix programming bugs
• Monitor and maintain application security and integrity
• Communicate project status and identify technical risks
• Evaluate and recommend appropriate technologies based on product needs and industry trends

Desired Skills:

• Develop quality software and web applications
• Excellent communication and organisational skills, must be a team player
• Excellent analytical skills
• Ability to work in a fast-paced environment
• Ability to stay focused and deliver on time and on budget
• An up-to-date, working knowledge of current, past, and projected trends in the industry
• Knowledge of AI Techniques such as Neural Network Programming would be an asset
• Knowledge of Steering Behaviors Programming Techniques would be an asset

Qualifications

• Strong knowledge in .NET platform (ASP .NET) and C#
• Strong knowledge of Microsoft SQL Server 2008+ and T-SQL language
• Proficient in MS Visual Studio and TFS, including application build/deployment
• Knowledge and experience with creating and consuming web services

Educational Requirements:

Bachelor's degree diploma in computer science or software engineering

RequiredSkills:

• Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models. • 2-3 years of experience inExtraction, Transformation and Loading ETLwork using data migration tools like Talend, Informatica, Datastage, etc. • 4-6 years of experience as a database developerinOracle, MS SQLor another enterprise database with a focus on building data integration process • Candidate should haveanyNoSqltechnology exposure preferably MongoDB. • Experience in processing large data volumes indicated by experience with BigDataplatforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.). • Understanding of data warehousing concepts and decision support systems.

• Ability to deal with sensitive and confidential material and adhere to worldwide data security and • Experience writing documentation for design and feature requirements. • Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure etc. • Excellent communication and collaboration skills.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

You will get while working with us

• Opportunity to work on highly distributed systems with micro-services architecture and big-data volumes
• Solve challenging real-world problems by leveraging OOP & functional programming concepts
• Opportunity to incubate an open source project
• Get to work with cutting edge technologies to name a few Kafka, Elasticsearch, Postgres, Scala
• Developing scalable, sustainable and reliable enterprise systems
• Hands-on experience of working with TDD and BDD
• Develop environment using practices such as Continuous Integration, Continuous Delivery
• Learning opportunity on how to turn complex business requirements into a working product

Roles & Responsibilities

• Requirement understanding & analysis by interacting with client
• Carry out architectural and design discussions with fellow team members and come up with right approach
• Understand system domain, user’s perspective of system and use-cases
• Understand patterns in existing code and effectively leverage and improvise it 
• Develop backend involving Java8 based functional programming and REST services
• Ensure best practices of code reviews, automated testing and CI
• Research new tools & technologies required for the projects
• Mentor fellow team members and bring their level up

Must have

• Strong hold on written/verbal communication
• Strong core Java fundamentals
• Strong Analytical & problem solving skills
• Proactive and inherent nature of working with ownership
• Passion of writing clean code
• Experience in designing relational data model from business requirements

Good to have

• Knowledge of functional programming (Scala or Java 8 lambda)
• Knowledge of NOSQL
• Working knowledge of linux & networking
• Performance optimisation - Optimise/refactor queries, code, stored procedures to take performance next level