Concepts of RDBMS, Normalization techniques
Entity Relationship diagram/ ER-Model
Transaction, commit, rollback, ACID properties
Transaction log
Difference in behavior of the column if it is nullable
SQL Statements
Join Operations
DDL, DML, Data Modelling
Optimal Query writing - with Aggregate fn, Group By, having clause, Order by etc. Should be
hands on for scenario-based query Writing
Query optimizing technique, Indexing in depth
Understanding query plan
Batching
Locking schemes
Isolation levels
Concept of stored procedure, Cursor, trigger, View
Beginner level - PL/SQL - Procedure Function writing skill.
Spring JPA and Spring Data basics
Hibernate mappings
UNIX
Basic Concepts on Unix
Commonly used Unix Commands with their options
Combining Unix commands using Pipe Filter etc.
Vi Editor & its different modes
Basic level Scripting and basic knowledge on how to execute jar files from host
Files and directory permissions
Application based scenarios.
Similar jobs
Please Apply - https://zrec.in/L51Qf?source=CareerSite
About Us
Infra360 Solutions is a services company specializing in Cloud, DevSecOps, Security, and Observability solutions. We help technology companies adapt DevOps culture in their organization by focusing on long-term DevOps roadmap. We focus on identifying technical and cultural issues in the journey of successfully implementing the DevOps practices in the organization and work with respective teams to fix issues to increase overall productivity. We also do training sessions for the developers and make them realize the importance of DevOps. We provide these services - DevOps, DevSecOps, FinOps, Cost Optimizations, CI/CD, Observability, Cloud Security, Containerization, Cloud Migration, Site Reliability, Performance Optimizations, SIEM and SecOps, Serverless automation, Well-Architected Review, MLOps, Governance, Risk & Compliance. We do assessments of technology architecture, security, governance, compliance, and DevOps maturity model for any technology company and help them optimize their cloud cost, streamline their technology architecture, and set up processes to improve the availability and reliability of their website and applications. We set up tools for monitoring, logging, and observability. We focus on bringing the DevOps culture to the organization to improve its efficiency and delivery.
Job Description
Job Title: Senior DevOps Engineer (Infrastructure/SRE)
Department: Technology
Location: Gurgaon
Work Mode: On-site
Working Hours: 10 AM - 7 PM
Terms: Permanent
Experience: 4-6 years
Education: B.Tech/MCA
Notice Period: Immediately
About Us
At Infra360.io, we are a next-generation cloud consulting and services company committed to delivering comprehensive, 360-degree solutions for cloud, infrastructure, DevOps, and security. We partner with clients to transform and optimize their technology landscape, ensuring resilience, scalability, cost efficiency and innovation.
Our core services include Cloud Strategy, Site Reliability Engineering (SRE), DevOps, Cloud Security Posture Management (CSPM), and related Managed Services. We specialize in driving operational excellence across multi-cloud environments, helping businesses achieve their goals with agility and reliability.
We thrive on ownership, collaboration, problem-solving, and excellence, fostering an environment where innovation and continuous learning are at the forefront. Join us as we expand and redefine what’s possible in cloud technology and infrastructure.
Role Summary
We are looking for a Senior DevOps Engineer (Infrastructure) to design, automate, and manage cloud-based and datacentre infrastructure for diverse projects. The ideal candidate will have deep expertise in a public cloud platform (AWS, GCP, or Azure), with a strong focus on cost optimization, security best practices, and infrastructure automation using tools like Terraform and CI/CD pipelines.
This role involves designing scalable architectures (containers, serverless, and VMs), managing databases, and ensuring system observability with tools like Prometheus and Grafana. Strong leadership, client communication, and team mentoring skills are essential. Experience with VPN technologies and configuration management tools (Ansible, Helm) is also critical. Multi-cloud experience and familiarity with APM tools are a plus.
Ideal Candidate Profile
- Solid 4-6 years of experience as a DevOps engineer with a proven track record of architecting and automating solutions on Cloud
- Experience in troubleshooting production incidents and handling high-pressure situations.
- Strong leadership skills and the ability to mentor team members and provide guidance on best practices.
- Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
- Extensive experience with Kubernetes, Terraform, ArgoCD, and Helm.
- Strong with at least one public cloud AWS/GCP/Azure
- Strong with Cost Optimization and Security Best practices
- Strong with Infrastructure automation using Terraform and CI/CD automation
- Strong with Configuration Management using Ansible, Helm etc
- Good with designing architectures (Containers, Serverless, VMs etc)
- Hands-on Experience working on Multiple Projects
- Strong with Client communication and requirements gathering
- Databases management experience
- Good experience with Prometheus, Grafana & Alert Manager
- Able to manage multiple clients and take ownership of client issues.
- Experience with Git and coding best practices
- Proficiency in cloud networking, including VPCs, DNS, VPNs (OpenVPN, OpenSwan, Pritunl, Site-to-Site VPNs), load balancers, and firewalls, ensuring secure and efficient connectivity.
- Strong understanding of cloud security best practices, identity and access management (IAM), and compliance requirements for modern infrastructure.
Good to have
- Multi-cloud experience with AWS, GCP & Azure
- Experience with APM & Observability tools like - Newrelic, Datadog, and OpenTelemetry
- Proficiency in scripting languages (Python, Go) for automation and tooling to improve infrastructure and application reliability.
Key Responsibilities
- Design and Development:
- Architect, design, and develop high-quality, scalable, and secure cloud-based software solutions.
- Collaborate with product and engineering teams to translate business requirements into technical specifications.
- Write clean, maintainable, and efficient code, following best practices and coding standards.
- Cloud Infrastructure:
- Develop and optimise cloud-native applications, leveraging cloud services like AWS, Azure, or Google Cloud Platform (GCP).
- Implement and manage CI/CD pipelines for automated deployment and testing.
- Ensure the security, reliability, and performance of cloud infrastructure.
- Technical Leadership:
- Mentor and guide junior engineers, providing technical leadership and fostering a collaborative team environment.
- Participate in code reviews, ensuring adherence to best practices and high-quality code delivery.
- Lead technical discussions and contribute to architectural decisions.
- Problem Solving and Troubleshooting:
- Identify, diagnose, and resolve complex software and infrastructure issues.
- Perform root cause analysis for production incidents and implement preventative measures.
- Continuous Improvement:
- Stay up-to-date with the latest industry trends, tools, and technologies in cloud computing and software engineering.
- Contribute to the continuous improvement of development processes, tools, and methodologies.
- Drive innovation by experimenting with new technologies and solutions to enhance the platform.
- Collaboration:
- Work closely with DevOps, QA, and other teams to ensure smooth integration and delivery of software releases.
- Communicate effectively with stakeholders, including technical and non-technical team members.
- Client Interaction & Management:
- Will serve as a direct point of contact for multiple clients.
- Able to handle the unique technical needs and challenges of two or more clients concurrently.
- Involve both direct interaction with clients and internal team coordination.
- Production Systems Management:
- Must have extensive experience in managing, monitoring, and debugging production environments.
- Will work on troubleshooting complex issues and ensure that production systems are running smoothly with minimal downtime.
At Advisor360°, we hire people with all kinds of awesome experiences, backgrounds, and perspectives. We like it that way. So even if you don’t meet every single requirement, please consider applying if you like what you see.
As a Full stack Software Engineer, you’ll be part of a team that’s responsible for developing several of Advisor360°’s most visible and critical web applications, including our public-facing application, Investor360°. These products are at the heart of what we offer to our advisors and their clients. In addition to having an Agile mindset and a desire to produce great software, you’ll need a positive attitude and excellent communication skills.
Key responsibilities
- Plan and implement mid- to large-scale projects from conception to completion
- Understand how to adapt theory and best practices to fit the needs of the project
- Deep knowledge and understanding of technology software design patterns and code concepts
- Demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, code comments, and clear code
- Troubleshoot, debug, and upgrade existing systems
- Deploy programs and evaluate user feedback
- Document and maintain software functionality
- Show an appetite and aptitude for taking responsibility for technical decisions
- Assist with the direction for the team
- Collaborate with team members on effective development practices and communicate with tact, professionalism, and an eye toward team progression
Requirements
- 5+ years of programming experience in ASP.NET (C# or VB.NET), including MVC and Web API
- Experience serving as technical lead throughout the full software development lifecycle: conception, architecture definition, detailed design, scoping, planning, implementation, testing, documentation, delivery, and maintenance is preferred
- Knowledge of professional software engineering and best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
- Knowledge of Angular 5/npm/Swagger/TypeScript/.NET Core, or related technologies, along with client-side frameworks and languages, such as jQuery
- Proficiency in SQL/relational databases and TFS including building and release definitions within a CI and CD environment
Additional skills and knowledge
- Knowledge of Microsoft Azure platform a plus
- Ability to work in a fast-paced, Agile/Scrum environment
- A positive attitude and excellent communication skills
- An Agile mindset and a desire to produce great software
Marketing Coordinator
Company description
Lightomated is a premium System Integration Company. We provide best in class solutions for system integration. We primarily work in two verticals.
Lightomated Residential - Premium Home Automation System Integration company, dedicated to easing your life by getting your entire residential space being controlled by one simple touch. Lightomated collaborates with reputed brands to provide the clients with perfect design, installation and integration with help of the expertise of our dedicated team.
Lightomated Commercial - Leading Audio-visuals consultancy as well as system Integration company delivering a wide scope of installations from high-end Audio / Visual Integrations, Lighting control, video collaborations and end-to-end automation systems.
Role overview:
- Capture the sites or projects that we have completed or in progress
- Feed the important points from the project engineer with regards to the site/projects completed or in -progress both
- Help in case studies, Blogs, Research, etc
- Conducting research to analyse competitive landscape, market trends and customer behaviour and preparing reports by collecting, summarizing and analysing data
- Supporting the Marketing Head in establishing and evaluating a marketing strategy and plan by organizing and planning promotional presentations.
- Understanding industry trends, latest events
- Collect the customers reviews, testimonial, etc
Requirements:
- Bachelor’s degree in any field is mandatory
- Minimum 1 year experience in Marketing field is required
- Good photography and video editing skills is required.
- Willingness to travel
- Solid computer skills, including MS Office
- Knowledge of digital marketing ( SEO, SMO, Google adwords)
Job Location- New Delhi
Role: ETL Datastage developer.
Eperience: 5 years
Location: Bangalore (WFH as of now).
Roles:
Design, develop, and schedule DataStage ETL jobs to extract data from disparate source systems, transform, and load data into EDW for data mart consumption, self-service analytics, and data visualization tools.
Provides hands-on technical solutions to business challenges & translates them into process/technical solutions.
Conduct code reviews to communicate high-level design approaches with team members to validate strategic business needs and architectural guidelines are met.
Evaluate and recommend technical feasibility and effort estimates of proposed technology solutions. Provide operational instructions for dev, QA, and production code deployments while adhering to internal Change Management processes.
Coordinate Control-M scheduler jobs and dependencies Recommend and implement ETL process performance tuning strategies and methodologies. Conducts and supports data validation, unit testing, and QA integration activities.
Compose and update technical documentation to ensure compliance to department policies and standards. Create transformation queries, stored procedures for ETL processes, and development automations.
Interested candidates can forward your profiles.
We are seeking a Full Stack developer in Bangalore, India to join our development team. These roles represent a great opportunity for the right candidate.
Requirements:
- B. E/B. Tech/ M. Tech from a top-tier college.
- 3 to 5 years of experience in a product development environment.
- Good understanding of one or more topics such as React, Redux, JWT, and REST APIs.
- Experieence with Node and NPM (and the Node ecosystem in general).
- Comfortable working with Git/SVN and a good understanding of version control.
- Knowledge of SaaS/Microservices-based environments.
- Ability to understand business requirements/ workflows and come up with technical designs and implementations.
- Good communication skills (written as well as verbal/spoken).
- Understanding cloud environments would be a plus.
- Work with stakeholders and fellow developers.
- Design and implement Python code using the Django framework.
- Identify and fix bottlenecks that may arise from inefficient code.
- Identify and fix software bugs.
- Create a wide variety of unit tests to verify the functionality of software.
- Manage the security of the platform.
- Write detailed documentation around the code.
- Knowledge of front end languages.
Requirement:
- 5+ years of experience in Quality Assurance
- Knowledge of Casino Gaming Domain
- Experience in Kiosk Application testing
- Experience in Assets Testing
- Configuration of Screens, Promotions and Drawings
- Experience in Azure DevOps bug tracking tool
- Experience of regression testing, integration testing.
- Debugging skills
- Good communication skills and ability to interact with clients.
- Good problem solving skills.
- Bug raising and retesting.