SQL Server 2016, MSBI, Power BI

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

Exp: 4-8yrs

Notice period: Max 30 days

Location: Andheri East

Working Days- 6 Days with Sunday off (2nd Saturday off as well)

Key Responsibilities:

 Design, develop, and maintain WinForms applications.

 Knowledge of .NET languages including C#, & Winforms is Mandatory.

 Collaborate with cross-functional teams to define, design, and implement new

features.

 Write clean, scalable, and efficient code using C# and ASP.NET.

 Develop and maintain SQL Server databases, including writing complex

queries and stored procedures.

 Troubleshoot, debug, and optimize existing applications.

 Participate in code reviews and contribute to team knowledge sharing.

 Ensure application security, performance, and reliability.

Qualifications:

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

field.

 Minimum of 3 years of experience in .NET development.

Roles and Responsibilities:

• Own development, design, scaling, and maintenance of application and messaging engines that power the central platform of Capillary's Cloud CRM product.

• Work on the development of AI and data science products for various use cases. Implement PoCs in Python, and Spark-Scala and productize the implementations.

• Contribute to overall design and roadmap.

• Mentor Junior team members.

Required Skills:

• Innovative and self-motivated with a passion to develop complex and scalable applications.

• 3+years of experience in software development with a strong focus on algorithms and data structures.

• Strong coding and design skills with prior experience in developing scalable & high-availability applications. Expertise in using Core Java/J2EE or Node.js

• Work experience with Relational databases and Non-Relational is required (Primarily MySQL, MongoDB, and Redis)

• Familiarity with big data platforms (like Spark-Scala) is an added plus.

• Strong Analytical and Problem Solving Skills.

• BTech from IIT or BE in computer science from a top REC/NIT.

Job Perks

• Competitive Salary as per market standards

• Flexible working hours

• Chance to work with a world class engineering team.

Why Join Us:

Be part of a fast-moving tech team building impactful, user-friendly apps with modern development practices and a collaborative work culture.

Capillary is an Equal Opportunity Employer and will not discriminate against any applicant for employment on the basis of race, age, religion, sex, veterans, individuals with disabilities, sexual orientation, or gender identity.

Disclaimer:

It has been brought to our attention that there have recently been instances of fraudulent job offers, purporting to be from Capillary Technologies. The individuals or organizations sending these false employment offers may pose as a Capillary Technologies recruiter or representative and request personal information, purchasing of equipment or funds to further the recruitment process or offer paid training. Be advised that Capillary Technologies does not extend unsolicited employment offers. Furthermore, Capillary Technologies does not charge prospective employees with fees or make requests for funding as a part of the recruitment process.

We commit to an inclusive recruitment process and equality of opportunity for all our job applicants.

• Write clean, scalable code using .NET programming languages.
• Developing the web based software using computer programming languages such as Asp.net, Sql Server, MVC, C# & Entity framework.
• Revise, update, re-factor and debug code.
• Participate as a team member in all phases of S/W lifecycle, including the analysis and design of S/W systems.
• Participate in integrated testing of product/ package.
• Deploying applications on client server.
• Making changes to existing web applications according to the feedback received from the end users or clients.
• Design and develop REST API’s using ASP.NET/C#.

Around 4 years of experience in creating and implementing Web-based applications using

C#, ASP.net, Web API, MVC, Micro Services, JavaScript and SQL Server.

Familiarity or exposure to CI / CD, Dev Ops such as Dockers, containers, Azure, Pipeline is

highly recommended

Ability to work in an Agile, fast-paced environment, and learn rapidly.

Bachelor degree in computer science, computer engineering or similar.

Familiar with object-oriented development, design patterns and specifically in .NET

Framework (C#) with a strong background in web-based development and service-oriented

Architecture.

Expert in HTML, CSS, JavaScript, JQuery, JSON.

Writing clean, readable, and easily maintainable code.

Must have knowledge of project/task management tools like Jira,

Familiarity with Version Control like Bitbucket, Git etc.

Understanding of UI, cross-browser compatibility and web standards.

Build features and applications with responsive design

Good English communication skills, written and spoken.

Able to work with minimum supervision as well as perform under pressure and meet

Deadlines.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

Must-Have Technology Skills:

• OOP Concept, Java 8+, Spring Boot, API development, Agile Scrum knowledge, Strong Databases design concepts of RDBMS, and capable of writing and optimizing complex queries.
  Good understanding of any Database tool e.g. Postgres, MySQL, etc.,
• DevOps basic knowledge e.g. implementation of logging in the code, Application Performance Management.
• Basic API & Application security, and Basics of tuning application performance.
• Basic Understanding of DevOps concepts e.g. CI & CD, Deployment lifecycle, Basic understanding of unit testing concepts e.g. TDD (test-driven development).
• A basic understanding of Microservices patterns
• A basic understanding of Java scripting.
• Good understanding of UI Frameworks like Angular 8+

Must-Have Soft Skills:

• Verbal & Written English communication, Good Problem-solving skills,
• Good Planning skills,
• Team Player,
• Good leadership skills
• Good written and verbal communication

Job Description

• Good experience as a full-stack developer in DB-centric applications and should be able to write and optimize complex database queries
• Requirement gathering & understanding, effort estimation, technical design, project planning, and monitoring in an Agile environment.
• Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
• Providing expertise in technical analysis and solving technical issues during project delivery.
• Customer interfacing - understand customer requirements, and propose technical solutions.
• Full Software Development Lifecycle (Agile).
• Code reviews, test case reviews and ensure code developed meets the requirements.
• Component Design/ Coding/ Unit Testing/ Debugging / Test Driven Development / Continuous Integration.
• Carry out adaptive changes necessitated by changes in Business Requirements and Technology

JOB DUTIES & RESPONSIBILITIES:

• Lead and mentor developers thru coaching and sharing of knowledge
• Architecture design and Develop new functionality and critical business logic of software products
• Enhance existing applications and software products and design new product

SKILLS:

• Strong knowledge on software implementation best practices
• Strong knowledge of SQL Server and/or Oracle database including store procedure, trigger etc.
• Knowledge of security and vulnerability best practices to design secure web application
• Knowledge of web application architecture with horizontal and vertical scalability
• Experience of working with application with large dataset of millions or billions of row in database table
• Ability to adapt quickly to an existing, complex environment
• Ability to complete all phases of software development life cycle including analysis, design, development, testing and support
• Ability to develop large scale web/database applications
• Ability to work on multiple projects with multiple deadlines
• Ability to communicate clearly with business users and project manager
• Ability to innovate and provide functional applications with intuitive interfaces