Education Counsellor

Job Title : Lead Database Engineer

Location : Gurgaon Sector-43

Experience Required : 4+ Years

Employment Type : Full-Time

Summary :

We are seeking a highly skilled Lead Database Engineer with expertise in managing and optimizing database systems, primarily focusing on Amazon Aurora PostgreSQL, MySQL, and NoSQL databases. The ideal candidate will have in-depth knowledge of AWS services, database architecture, performance tuning, and security practices.

Key Responsibilities :

1. Database Administration :

• Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL database systems to ensure high availability, performance, and security.
• Implement robust backup and recovery procedures to maintain data integrity.

2. Optimization and Performance:

• Develop and execute optimization strategies at the database, query, collection, and table levels.
• Proactively monitor performance and fine-tune RDS parameter groups for optimal database operations.
• Conduct root cause analysis and resolve complex database performance issues.

3. AWS Services and Architecture :

• Leverage AWS services such as RDS, Aurora, and DMS to ensure seamless database operations.
• Perform database version upgrades for PostgreSQL and MySQL, integrating new features and performance enhancements.

4. Replication and Scalability:

• Implement and manage various replication strategies, including master-master and master-slave replication, ensuring data consistency and scalability.

5. Security and Access Control:

• Manage user permissions and roles, maintaining strict security protocols and access controls.

6. Collaboration:

• Work closely with development teams to optimize database design and queries, aligning database performance with application requirements.

Required Skills :

• Strong Expertise: Amazon Aurora PostgreSQL, MySQL, and NoSQL databases.
• AWS Services: Experience with RDS, Aurora, and DMS.
• Optimization: Hands-on experience in query optimization, database tuning, and performance monitoring.
• Replication Strategies: Knowledge of master-master and master-slave replication setups.
• Problem Solving: Proven ability to troubleshoot and resolve complex database issues, including root cause analysis.
• Security: Strong understanding of data security and access control practices.
• Collaboration: Ability to work with cross-functional teams and provide database-related guidance.

Preferred Qualifications :

• Certification in AWS or database management tools.
• Experience with other NoSQL databases like MongoDB or Cassandra.
• Familiarity with Agile and DevOps methodologies.

Greetings!!!!

We are looking for a data engineer for one of our premium clients for their Chennai and Tirunelveli location

Required Education/Experience

● Bachelor’s degree in computer Science or related field

● 5-7 years’ experience in the following:

● Snowflake, Databricks management,

● Python and AWS Lambda

● Scala and/or Java

● Data integration service, SQL and Extract Transform Load (ELT)

● Azure or AWS for development and deployment

● Jira or similar tool during SDLC

● Experience managing codebase using Code repository in Git/GitHub or Bitbucket

● Experience working with a data warehouse.

● Familiarity with structured and semi-structured data formats including JSON, Avro, ORC, Parquet, or XML

● Exposure to working in an agile work environment

Greetings from Sapper Software Pvt Ltd

Sapper.ai is a cloud native integration platform. Businesses use us to connect their applications, automate and optimize their processes and data connections. Sapper.ai is unique in our ability to connect and move data using any method (APIs, integrations, batch and streaming). We embed AI throughout the platform to proactively recommend integrations and process automations to business users freeing them up from mundane and time consuming tasks.

Website: https://www.sapper.ai/

Senior Java Developer : 3 to 7 years

Work Location: Work in the office at Baner, Pune

Job Requirements:

• Relevant experience in Java 1.7 or higher / J2EE Java development.

. Have experience of agile systems development methodologies such as SCRUM

• Experience in designing the solution and implementation.
• Is a communicative, positive, outgoing and driven team player.
• Solution-oriented, see opportunities and proactively proposing new solutions, speak and write fluently in English.

Skill Set Required:

• Experience in Java 8.
• Experience in Spring Boot and other spring framework like Spring data, AOP etc.
• Experience in MongoDB/ Kafka / RabbitMQ etc.
• Experience in REST API
• Have worked on microservices
• Should have worked on minimum 2- 3 projects
• Experience in writing effective Unit test case for better coverage.
• Experience in writing good quality code by following code quality tools likes SonarQube etc.

Roles and Responsibilities

- Relevant work experience in Java 1.7 or higher / J2EE Java development.

. Have experience of agile systems development methodologies such as SCRUM

- Experience in designing the solution and implementation.

- Is a communicative, positive, outgoing and driven team player.

- Solution-oriented, see opportunities and proactively propose new solutions, speak and write fluently in English.

Desired Candidate Profile

- Experience in Java 8.

- Experience in Spring Boot and other spring frameworks like Spring data, AOP, etc.

- Experience in MongoDB/ Kafka / RabbitMQ etc.

- Experience in REST API

- Have worked on microservices

- Should have worked on a minimum of 2- 3 projects

- Experience in writing effective Unit test cases for better coverage.

- Experience in writing good quality code by following code quality tools likes SonarQube etc.

Mandatory - Core Java / Java 8 & Spring Boot,

Good to have - MongoDB/Kafka / RabbitMQ / Micro Services

If you are interested and matching as per requirements, kindly share your updated CV and below details on hemant dot hingmire at sapper dot ai 

Total Experience?

Relevant Experience?

Core Java?

Java 8?

MongoDB/Kafka / RabbitMQ?

Springboot?

Microservices?

Current Company?

Current CTC?

Expected CTC?

Notice Period (Max 30 days)?

Tentative Date to Join Us?

Reason for Change?

Offer in Hand (Yes/ No) Annual CTC?

Living in Pune Yes / No?

• 5+ years of object-oriented software development of web applications
• 5+ years of C# in a .NET environment
• Preferable Experience in Cloud Technologies (AWS, AZURE)
• Experience with MS SQL stored procedures, database design and optimization
• Experience developing and utilizing web services
• Experience with high volume consumer oriented web sites
• Experience working in an Agile Scrum environment
• Experience with formal test procedures, release management
• Preferable Travel industry experience preferred, especially programming associated with GDS’s - SABRE, Farelogix, and Travelport
• Ability to distill complex business needs into functional requirements
• Excellent follow-up, verbal and written communication skills
• Excellent problem solving skills and an ability to make good decisions
• Team player with a professional attitude
• Ability to manage multiple tasks and maintain tight schedules
• Ability to work effectively with a geographically dispersed team in India

Strategic and Development Responsibilities

• Ability to "think outside the box"
• Ability to provide accurate and timely project estimates.

Pluses:

• Experience with Angular JS frameworks and Mobile Development.
• Experience with developing machine learning algorithms.
• Experience on projects that required localization/globalization
• Experience with MS SQL Reporting Services
• Knowledge of web farm configuration and best practices

Software Tools/Languages

Required:        MS Visual Studio, MS SQL Server Management Studio, IIS, AWS

C#, Web Services, MS SQL (stored procedures), Jenkins, DevOps Tools.

Education

 Job is based out of Gandhinagar.
FE will work as a decision maker for the trucker side, where he will be entitled to take decisions regarding truck on-boarding, trip finalization, ongoing trip issues or payment related issues, etc. FE will make decisions regarding trucker side operations with taking the Admin team in confidence.

✔ During trucker on-boarding, if any of the truck owners are having more than ten numbers of trucks with the same owner; FE will have to notify the accounts department about it for taxation purposes.

✔ Any kind of internal communication from the trucker side such as communication with material side, admin team, accounts department, or any other department of the organization will be done only through FE.

✔ The same way any communications from the trucker side with individuals who are not part of an organization such as truck owners, transporters, and other stakeholders will be done under direct monitoring of FE.

✔ FE will also have to guide the executives to upload dummy truck-ads to keep the consignors engaged on our platform, but this task shall be done under strict monitoring of FE.

✔ FE will also have to guide and support the executives to finalize the trips.

✔ All the advance payments for finalized trips will be firstly verified by FE, then only he/she will communicate it to the accounts department.

✔ During the loading the process if there is any damage by the driver within the premises of the consignor, FE will have to communicate with the truck driver/owner and SME/CP to make the settlements. In such cases, the final decision will be taken by FE and SME mutually with the admin team in confidence.

✔ In the same way, if there is any damage to the material while unloading, FE will communicate regarding these with truck driver/owner and SME/CP to make settlements. In such cases, the final decision will be taken by FE and SME mutually with the admin team in confidence.

✔ In case of Payment delay or no payment conditions, FE will coordinate with SME and take decisions for trip continuity.

✔ In case of any major breakdown, accident, material/vehicle damage or seizure of vehicle/material by any authority FE will have to communicate with the truck driver/owner to continue the trip.