Senior Database Developer - Data Modeling & DB Design Schema

Job Summary

• Candidate will be responsible for providing full life-cycle development (design, coding, and testing) and maintenance of web-based system on Azure
• Candidate should have experience in GitHub, knowledge of DevOps is a plus
• Experienced in designing and implementing web portals, experience with DNN is must
• Ability to work with multiple languages including C#, ASP.Net, MVC, Javascript and related libraries, HTML, Complex SQL queries, CSS, BootStrap, JSON.
• Experience in Agile project management methodology
• Developing and Delivering Excellent Web based solutions/portals/sites based on customer’s requirement within the stipulated timeline
• The candidate should be flexible to learn new technology and platform and should be creative, innovative for improvement ideas, detail oriented, diligent, and eager to learn and grow

Duties and Responsibilities

• Understand business requirements to apply logic to integrate functionalities
• Identify and understand any technical bugs on the server, site, log files or modules and work on resolving the bugs
• Understand how FTP server is setup for the site
• Understand system/site technical requirements and suggest enhancements if applicable
• Designing, coding, unit Testing, and integration with Database
• Handle site deployment
• Designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.

Qualifications

Education / Certification

• B.E. / B.Tech. /MSC in Computer Science or IT.
• MCAD/MCSD/MSITP/MCPD

Technical Expertise

• ASP/ASP.NET/VB.NET/MVC/C#/SQL Server 2012+
• HTML, Javascript, Jquery, CSS, Bootstrap
• GitHub/DevOps, Azure
• Web API/ Web Services, Email Services

Skills and Abilities

• Be able to work with diverse global teams and in an individual contributor role as needed
• Excellent English written and verbal communication skills (for local team and global stakeholders/team members)
• Strong task management skills including time management, and ability to manage multiple projects simultaneously
• Flexibility required to attend late evening meetings with global team members
• Attention to detail and delivering quality projects and knowledge assets

We are seeking applications for a Senior Technical Architect of .NET for our client, a leading Fintech in the lending domain.

As a strong tech leader, you will lead development activities across multiple enterprise projects.

Role & Responsibilities:

 Solve complex problems and produce the highest quality code.

 Work closely with both external clients and internal, cross-functional product and technical teams to support multiple projects.

 Maintain technical design documentation, communicating architectural and design changes to development teams

 Conduct regular design and code reviews, establishing and publishing quality and performance metrics

 Manage and foster a team-oriented environment, providing technical oversight to team members

Skills & Qualifications:

 10+ years of professional experience on .NET framework 4x

 Solid understanding and experience with Object-Oriented design & development

 Excellent hands-on C# coding skills

 Experience working with ASP.NET MVC, Entity Framework, LINQ, NoSQL, Message Queue, and building Reusable Libraries

 Should possess SQL Server database skills to design new or alter existing table structures as per the requirements

 Exposure in building web-based applications

 Should have worked on a complex enterprise business application in a product-based IT company and/or banking and financial services company

 Data-driven, analytical approach to problem-solving and project management

 Working experience with Agile methodologies.

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

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable