Senior Database developer (SQL)

About the role

A backend engineer at Peoplebox is a one who loves to look for patterns and extremely resourceful.

You will be exposed to different challenges right from building multi-source integration platform to working deeply in Kubernetes clusters. At the core, you should be great at building system design, great at SQL, breaking down broad-problems into smaller sub-problems and build clarity.

We also value self-drivenness. Have you done something that you did out of what was asked for you to be done? Did you do a hobby project? Did you host it somewhere? Did you try to get some users to it? Did you do something at work that was not really part of the sprint but it added value?

We are looking for a self-driven Senior Backend Engineer who can join us and take ownership of releases that they do.

Roles and Responsibilities

• Typical Day: Your typical day would be building data models and APIs that would be consumed by Frontend engineers.
• Teamwork: Your success is directly proportional to how well you collaborate with your Frontend Partner. We’d expect you to be pro-active and communicate well over Slack and Calls.
• Problem Solving: You’ll be solving hard problems in architecture and integrations that enable the business.
• Delivery: We really value timely delivery. Speed is what makes us different. You should be ready to move fast and release.
• Self-Driven: We’d like people who don’t like to be managed and want to be self-driven. You are not waiting for someone to tell you what to do.

Experience:

Hands-on experience creating web applications using Ruby on Rails

Knowledge of Rails-related tools and practices like RSpec, TDD/BDD

Good understanding of HTTP and how the web works.

Proficient with database schema design, indexing, query optimization

Good understanding of MVC design pattern

Experience using “git” is desired but not mandatory.

Basic knowledge of web technologies desired (HTML, CSS, JS and jQuery)

Good knowledge of automated deployment, monitoring and performance analysis

Hands-on DevOps experience is greatly desired

Knowledge of cloud and server infrastructure (AWS in particular) will be a huge plus

1.   7 to 12-14 years of experience as a Software Developer.

2.   Experience in .Net technologies - C#, ASP.net is must.

3.   Experience in developing REST based APIs.

4.   Experience in building web user interface.

5.   Good to have experience in developing single page apps using modern JS framework.

6.   Skills in cross browser development.

7.   Understanding of Agile methodology.

8.   Excellent trouble shooting and communication skills.

9.   Knowledge of Azure will be an added advantage.

JOB DESCRIPTION -

1. Developing and implementing web-based applications using .Net technology and MS-SQL.
2. Developing front end with highly responsive user interface concept using React concept.
3. Identifying web-based user interaction.
4. Participate in requirement analysis.
5. Collaborate with internal teams and positive mindset to help and seek help.
6. Documentation of application development changes and updates.

TECHNICAL SKILLS

1. Expert in C#, ASP.Net, Web API, MS SQL Server.
2. Good to have experience in React and workflows such as Redux or Flux, MongoDB.
3. Knowledge of HTML, CSS and JavaScript.
4. Familiar with source control system (GIT, SVN).

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred*
• Candidates will be selected based on logical/technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. Banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements

•  You should have deep understanding of NodeJS
•  You should be strong in Javascript and TypeScript
•  You should be capable of writing complex queries
•  ES6, Express, Apollo Server, Send Grid Email, Twilio SMS, Payment
• Gateway,
• Error Loggin, API Developement, API Security,
• PostGreSQL/MSSQL/MySQL, MongoDB/CouchDB
• Very good knowledge on REST API
• Good experience in Agile methodologies
• Ability to design and write code complying with coding standards
• and other factors like performance, scalability, reliability,
• reusability, modularity in mind
• You should have strong logical and problem solving skills
• Excellent communication and customer interfacing skills
• AWS certification is nice to have
• Strong proficiency with JavaScript and good to have
• ES6(Typescript) knowledge
• Knowledge of Node.js and frameworks such as Express, Restify
• Understanding the nature of asynchronous programming and its
• quirks and workarounds
• Understanding accessibility and security compliance
• User authentication and authorization between multiple systems,
• servers, and environments
• Integration of multiple data sources and databases into one
• system
• Understanding fundamental design principles behind a scalable
• application
• Competencies and Skills Required
• equires excellent analytical, problem solving, and good
• communications skills
• Must be able to work effectively with business stakeholders
• Strong passion for delivering technical solutions to business
• problems
• Understanding and mindset of Agile software delivery (Ability to
• adapt to continually changing priorities)
• Team player who understands the importance of teamwork and
• collaboration
• Passion for delivering new approaches and challenging the ‘statusquo’
• Hungry to learn and always in search of continuous improvement

Qualification & Experience

Primary Role

• As an SSRS Report Engineer, the primary job role is to develop a transactional data report using Microsoft SQL Service Reporting Service 2016 or above.
• This includes developing high performing Stored Procedures, Functions, and corresponding reporting formats.
• Required to design the required logics for the queries and collaboratively coordinate with the rest of the team.

Main Duties / Responsibilities

• Design & implement high performing T-SQL queries as per the functional specification.
• Create Technical Specification.
• Effective troubleshooting of technical issues and bugs.
• Package deployment and release management.
• Provides technical support to customers.
• Participate in Requirements discussions.
• Must be able to manage timelines and task priorities.
• Attention to detail and maintaining high-quality standards is a must.

TECHNICAL KNOWLEDGE

• Experience in Microsoft SQL Server 2016 (or above) and Microsoft SQL Service Reporting Service 2016 (or above).
• Knowledge of T-SQL including complex SQL queries, stored procedures, views and functions.
• Experience with usage of indexes and T-SQL performance tuning techniques.

QUALIFICATIONS

• Bachelor’s Degree or an equivalent qualification

Responsibilities:

• Thorough understanding of Reconciliation and hands on development experience on Intellimatch 9.2.7 or higher version
• Comprehensive understanding of SDLC in developing new Reconciliations in IntelliMatch. Involvement across all stages of Software Development life cycle (SDLC) including business requirement analysis, data mapping, validate data against requirement, build, unit testing, peer reviews, systems integration and user acceptance testing.
• Analyze & develop Test Strategies, design Test Plans, & generate and execute Test Cases.
• Should be able to perform enhancements, whereby need to analyze existing set-up and understand the requirement by performing proper impact analysis, provide estimate and deliver quality code.
• Independent player should be able to liaise with different team to re-solve/get dependencies on time. Should be able to for-see issue/risk and intimate the same to team lead / project manager.
• Should be able to guide support team.
• Deep knowledge on IntelliMatch Database linkage and functionalities is necessary for timely resolution of user queries.
• Propose improvements related to the development and support activity.
• Develop stored procedures to build reports for the end users using SQL 2016