Datbase platforms developer

Technical Skill Set:

1. ASP. NET Development – Strong expertise in C#, ASP.NET, WPF, and solid understanding of SOLID principles, API development, and databases.

2. Cloud Technologies – Hands-on experience with AWS, Azure, or Google Cloud.

3. Software Development & Architecture – Proficiency in SDLC, Agile, Scrum, and DevOps frameworks.

4. Project Planning & Management – Experience in task allocation, tracking, estimations, and deliverables management.

5. Repository & Version Control – Familiarity with Git, SVN, or similar tools, along with basic networking concepts.

6. Product Lifecycle Management – Knowledge of requirement analysis, documentation, testing, and release management.

7. Project Planning Tools – Experience with tools like Microsoft Project Plan, JIRA, Redmine, or HP ALM/Quality Centre.

Leadership & Soft Skills:

1. Team Leadership – Ability to guide, mentor, and manage a team while ensuring high-quality deliverables within tight deadlines.

2. Client Engagement & Requirement Gathering – Skilled in collaborating with stakeholders to enhance and refine project requirements.

3. Strong Communication & Problem-Solving – Effective at handling challenges, making decisions, and ensuring smooth project execution.

Role Summary:

We are looking for a hands-on Java Solution Architect to design and lead scalable, secure, event-driven platforms. The ideal candidate has deep expertise in Java/Spring Boot microservices, Kafka, Redis/KeyDB, and open-source databases (Cassandra, PostgreSQL), with experience building high-throughput, low-latency systems.

Experience- 10+yrs

Key Responsibilities

• Architecture & Design
• Define service boundaries using DDD; create service contracts and API specifications.
• Design Kafka-based event flows (topics, partitions, retention, DLQs, idempotency).
• Choose fit-for-purpose storage (Cassandra vs PostgreSQL) for workloads:
• Cassandra for time-series, high write throughput, and horizontal scaling.
• PostgreSQL for transactional integrity, complex joins, and reporting.
• Engineer caching strategies using Redis/KeyDB (read-through/write-through, TTL, eviction).
• Establish NFRs (performance, availability, RPO/RTO) and capacity planning.
• Security & Compliance
• Implement OAuth2/OIDC, mTLS, token-based auth, key rotation, encryption at rest/in transit.
• Work with InfoSec/AppSec for threat modeling, VAPT, secure SDLC integration.
• DevOps & Observability
• Drive CI/CD pipelines (blue/green/canary), container orchestration (Kubernetes).
• Define SLOs/SLIs; implement metrics, logs, traces; promote proactive alerting.
• Governance & Standards
• Publish architecture guidelines, coding standards, and API governance (versioning, deprecation).
• Champion documentation (ADR, sequence diagrams, data flow, runbooks).
• Mentoring & Leadership
• Coach engineers; conduct design/code reviews; lead PoCs and migrations.
• Collaborate with Product/Delivery to align scope, timelines, and risk mitigation.

Required Technical Skills (Deep Expertise)

• Java: Java 17+, Spring Boot, Spring Cloud, reactive programming (WebFlux).
• Microservices: API Gateway, service mesh (Istio/Linkerd), resilience (Resilience4j).
• Kafka: Kafka Connect, Streams, consumer lag management, schema registry (Avro/JSON).
• Redis/KeyDB: Cluster configuration, HA, persistence (AOF/RDB), pub/sub and streams.
• Databases:
• Cassandra: Data modeling (partition keys, clustering), consistency levels, compaction strategies.
• PostgreSQL: Indexing strategies, partitioning, query planning, isolation levels, VACUUM.
• Cloud & Infra: Docker, Kubernetes, Helm/Terraform; AWS/Azure/GCP (EKS/AKS/GKE).
• Observability: Prometheus, Grafana, ELK/EFK, OpenTelemetry.
• Security: JWT, mTLS, secrets management (Vault/KMS), OWASP Top 10, compliance-aware design.

Soft Skills

• Strong stakeholder communication; ability to simplify complex technical decisions.
• Ownership mindset; risk identification and mitigation.
• Mentorship; collaborative leadership across cross-functional teams.

Qualifications:

- Bachelor's degree in Computer Science Engineering, or a related field (or equivalent experience).

- At least 7 years of experience in back-end development, specifically with Node.js.

- Strong understanding of JavaScript and TypeScript would be a plus.

- Experience with asynchronous programming and event-driven architecture.

- Familiarity with RESTful APIs and/or GraphQL.

- Proficient in working with databases (e.g., PostgreSQL).

- Knowledge of version control systems, particularly Git.

- Experience with cloud services (e.g., Azure Cloud) and containerization tools (e.g., Docker).

- Strong problem-solving skills and the ability to work independently as well as part of a team.

- Excellent communication and collaboration skills.

• Should have knowledge in Core PHP and object-oriented programming.
• You will be responsible in developing applications using Laravel/ wordpress/ Codeignitor - preffered (Laravel)
• Responsible for Developing High-Quality Web Applications, Admin dashboards and PHP Scripts, APIs.
• Should be able to Develop, record and maintain cutting edge web-based php applications on portal plus permiium service platforms
• Need to Identify and fix bugs that are found within code.
• Strong knowledge to Interact with SQL databases.
• Must be Creative problem-solving skills with a focus on delivering business value quickly
• Knowledge of MySQL and ability to write/ Maintain complex queries.
• Understanding of object-oriented PHP programming, Jquery and Javascript
• Should have good communication skills

• 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.

• Experienced in automated deployment tools such Continuous Integration (Azure DevOps/Git).
• Excellent debugging skills; able to debug complex technical issues involving multiple system components. Good to have knowledge on online & offline sync capabilities in Progressive Web Application (PWA) implementation.
• Knowledge on Azure DevOps is optional.
• Knowledge on INFORM, WARN and ERROR logging in Azure Application Insights, error handling, access authorization, data connectivity in C# is mandatory.
• Knowledge on publisher/subscriber queueing such as RabbitMQ.
• All C# code must contain descriptive comments to functions, or complex/nested loops, if, or case statements.
• Knowledge on NetSuite is an advantage.
• Knowledge on Azure Active Directory is an advantage. Knowledge on OAuth 2.0 & JWT Tokens is mandatory. Writing high-level design and technical analysis documents.
• Should have worked on Agile framework

1. Strong Experience on. NET Core, . NET Microservices, C# 5.0 Xunit - Unit Test Framework - C#, Entity Framework/Entity Framework and RESTful Design, Redis
2. Experience with SQL Server 2012 & above
3. Should be well versed with RabbitMQ
4. Knowledge on Azure Active Directory, Application Insights, Azure Devops/Git/Bitbucket Pipeline, Serverless / Azure functions, Azure Service Fabric / Functions
5. Hands-on JWT Tokens, API Authorization, OAuth 2.0 JSON or XML
6. Exposure to NetSuite, Workato will be an added advantage