SQL - Database Developer

Job Overview:

We are looking for a skilled and experienced Java Lead Developer with a strong background in Java Spring Boot, Microservices, and containerization tools like Kubernetes and Docker. The ideal candidate should also have working knowledge of at least one front-end technology such as Vue.js, Angular, or React.

Roles and Responsibilities:

• Lead experience is mandatory.
• 8+ years’ experience in Java-J2EE Development.
• Extensive technical experience and development expertise in Core Java, J2EE, JSP, Servlets, Struts, Webservices, Spring, Hibernate, JavaScript, Docker, Kubernetes, JQuery, and AJAX.
• Possess advanced knowledge of object-oriented design and development and the J2EE framework and data architectures.
• Experience working with and applying Design Patterns to solve problems.
• Demonstrate strong written and oral communication skills.
• Hands-on experience in Tomcat and Weblogic/Websphere servers.

• Key Skills:
• Expert Proficiency in anyone the below programming language - Node JS, PHP or GoLang
• Expert Computer Science fundamentals like Data Structures, Algorithms, Time Complexity, and others
• Strong Microservices, REST API, Git source control, CI/CD, and other latest technology trends
• Strong System Design, DB Design proficiency
• Strong knowledge in Design Patterns, best software development practices
• Good exposure to working in Open Source stack, E-Commerce, or Fintech domain.

About the role:

You will own a functional area - from product conception to its delivery to customers. You are expected to design and code independently in multiple tech components related to your functional area. You must also develop a deep understanding of non-functional requirements, such as reliability and availability, scale, horizontal scalability, etc. over time to make tech stack decisions accordingly. You are expected to actively mentor junior engineers. You own

the codebase quality.

We are looking for seasoned engineers who are quality-conscious, product thinkers, business cognizant and smart. Engineers get to significantly amplify the impact of their work or creations with scale. The scale also demands that engineers to produce super-efficient solutions.

What you’ll do

• Strong experience with Java 8, Spring and Spring Boot, Spring MVC, Spring Data,
• Working experience in Microservices
• Version Control: Git
• Strong understanding of functional/reactive programming, OOP, design
• Experience with Docker and Kubernetes.
• SDLC: Working experience in Agile methodology
• Strong interpersonal skills and time management skills

What you’ll need

• B.Tech or M.Tech equivalent with at least 3 years of experience
• Deep expertise in at least one programming language & tech stack.
• Strong object-oriented design skills, ability to apply design patterns, and an uncanny ability to design intuitive module and class-level interfaces
• Experience in building data-driven web application design and development is a plus
• Good understanding of multiple tech solutions and ability to pick the correct one for the given situation
• Prior work experience in an agile environment or continuous integration and continuous delivery (CI or CD)
• Ability and experience in designing high-level software designs of the scalable system, taking NFR (non-functional requirement) into consideration

Job Description:

• Very good Core Java programming skills, with 7+ years of experience, of which 3 - 4 in core
• development programs.
• Expertise on Agile and Build (Jenkins/GIT/Continuous Integration)
• Rich experience in software development SDLC - Requirements, Analysis,
• coding, review process, build and test.
• Fair understanding Linux fundamentals
• Solid understanding of object-oriented programming
• Good English comprehension and communication skills, both oral and written,
• Ability to write routine business correspondence, and technical notes
• Strong customer service orientation, proactive in updates/blockers

As an SSE, you will play a crucial role in designing, developing, and maintaining our backend systems

that power our platform. The ideal candidate will have a solid background in Python Django and a

strong understanding of databases, caching, and distributed systems.

● Design, develop, and maintain robust, scalable, and high-performance backend systems using

Python Django.

● Collaborate with cross-functional teams to understand business requirements and translate

them into technical solutions.

● Optimize application performance and scalability by implementing caching strategies, load

balancing, and distributed computing techniques.

● Ensure data integrity and security by implementing best practices for data storage, retrieval,

and access control.

● Develop and maintain integrations with external APIs and services to support seamless

interactions with third-party systems.

● Identify and address performance bottlenecks and other system issues to improve overall

system efficiency.

● Write clean, maintainable, and testable code following industry-standard coding practices.

● Conduct code reviews and provide constructive feedback to peers to ensure code quality and

adherence to best practices.

● Mentor junior team members and assist in their professional growth.

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

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

Roles & Responsibilities:

• Write well-designed, testable, efficient, and high-quality code.
• Design (LLD & HLD) and architect technical solutions for the business problems of a large-scale system.
• Prepare and produce releases of software components.
• Support continuous improvement by investigating alternatives and technologies.
• Contribute to all phases of the development lifecycle.
• Lead the backend engineering team with examples.

Requirements:

• 5+ years’ experience under your belt developing performance-critical applications that run in a production environment using Node.Js
• Expertise in Database modeling, preferably relational DB, spotting DB bottlenecks, and writing optimized DB queries.
• Expertise in common Cloud technologies, AWS/GCP Knowledge of CI/CD tools and workflows.
• Knowledge in one or more of the following: NoSQL (especially, but not only Redis), Queueing system experience (Kafka, RabbitMQ, ActiveMQ, MSMQ)
• Good stakeholder management skills, with an ability to build trust and rapport with internal and external stakeholders
• It is good to have knowledge of Kubernetes and Docker and related deployment technologies.