Project Manager - Tech

Recruiting, Interpersonal Communication, Team Building, Microsoft Office, Presentation Skills, Human Resources (HR), Leadership,

Company Name: JNJ Technologies And Services LLP

Job Profile: HR Executive

Job Description

We're seeking a qualified HR Executive to recruit a sales executive in regard to selling annual car and bike subscription products

that our customers have grown to rely on. We are a growing platform and are required to target customers by hiring more

sales executives on a daily basis.

Experience: 0 - 2 years

Job Location: Work from home(Freelancer/Work from home)

Selection process:- Manager round

Qualification: Graduation

Working days: 6 working days (Sundays off)

Shifts: 10:00am -7:00pm

Mandatory language: English

Laptop: candidates are to use their own laptops.

Additional Compensation: If applicable, this will be decided on the basis of your designation.

Desired Skills and Experience

Recruiting, Interpersonal Communication, Team Building, Microsoft Office, Presentation Skills, Human Resources (HR), Leadership

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

About Us

Aakash is synonymous with trust in India's test preparation landscape, offering a blend of superior classroom and online learning experiences, granting students an invaluable edge. We specialize in preparing students for Medical and Engineering entrance exams such as the National Eligibility Cum Entrance Test (NEET) and the Joint Entrance Examination (JEE - Main & Advanced), alongside school/board examinations, including prestigious scholarship exams like NTSE and Olympiads.

AESL (Aakash Educational Services Limited) adopts a student-centric ethos in test preparation, acknowledging the uniqueness of each student and catering to their individual needs. Our team comprises highly qualified and experienced instructors deeply committed to nurturing students' aspirations. Our programs are meticulously crafted for flexibility, and our teaching methodologies are enriched by cutting-edge technologies, ensuring students are thoroughly equipped for their examinations.

Aakash Advantage:

35 Years of Excellence: Providing comprehensive and result-oriented test preparation for over three decades.

Nationwide Presence: With over 315 branches across India, we facilitate preparation in your city.

Expert Faculty: Our pool of 6000+ expert faculty members serve as mentors and guides, ensuring personalized attention.

Proven Success: In 2023 alone, 122,000+ Aakashians qualified in NEET & JEE examinations.

Digital Integration: Embracing the future, our classrooms are 100% digitized across all branches.

Hybrid Learning: Offering the best of both worlds, our hybrid classrooms seamlessly blend traditional and online learning experiences.

A Great Place to Work: We take immense pride in announcing that Aakash has been honoured with the prestigious Great Place to Work title for three consecutive years, a testament to our unwavering commitment to fostering a positive and enriching work environment.

Purpose of the Admission Officer role:

Admission officer is responsible for lead generation through variety of marketing activities resulting in counselling and enrolling the students.

As an Admission officer, you are expected to:

1.      Generate admissions by maintaining a continuous influx of data by conducting “Above The Line” (ATL) & “Below The Line” (BTL) marketing activities such as- seminars in schools, open seminars in town & residential spots within a specified territory.

2.      Contribute towards set targets by doing school visits for meeting principals, coordinators and management personals for business development.

3.      Ensure a delightful customer experience while going for home visits to counsel students and parents and close admissions resulting in enrolling the students.

4.      Capitalize on business opportunities by liaising with local tuition teachers.

5.      Ensure adherence to internal processes and compliances.

To be successful in the Admission Officer role you are required to have:

1.      Ability to handle customers in a calm, empathic & patient manner, along with strong sales persuasion skills.

2.      Excellent networking and presentation skills to conduct seminars.

3.      Proficiency in Microsoft Office and writing emails, & comfortable while working on software related to Sales & Services.

4.      Fluency in communication of English and Regional Language.

5.      Comfortable for traveling and public speaking.

Must Attitude:

1.      Customer Orientation

2.      Sense of Ownership and Accountability.

3.      Result orientation

4.      Emotional intelligence for working in a team.

Qualification:

1.      Must have bachelor’s degree.

2.      Preferred BTech / MBA /Masters in Psychology, Education etc.

Experience:

1.      Previous experience in counselling in education or careers counselling.

2.      

Previous experience of Business to Customer (B2C) Sales across industries.

Key Interactions:

·        External

o  Students, Parents & Schools.

o  Partners and Vendors for Above The line (ATL) and Below The line (BTL) activities.

·        Internal

o  Branch’s Academic & Non-Academic teams.

o  Regional Student Support Centre.

o  Regional Sales & Operations Team.

• Developing and maintaining all server-side network components.
• Ensuring optimal performance of the central database and responsiveness to front-end requests.
• Collaborating with front-end developers on the integration of elements.
• Designing customer-facing UI and back-end services for various business processes.
• Developing high-performance applications by writing testable, reusable, and efficient code.
• Implementing effective security protocols, data protection measures, and storage solutions.
• Running diagnostic tests, repairing defects, and providing technical support.
• Documenting Node.js processes, including database schemas, as well as preparing reports.
• Recommending and implementing improvements to processes and technologies.
• Keeping informed of advancements in the field of Node.js development.

• Bachelor's degree in computer science, information science, or similar.
• At least two years' experience as a Node.js developer.
• Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
• Knowledge of front-end technologies such as HTML5 and CSS3.
• Superb interpersonal, communication, and collaboration skills.
• Exceptional analytical and problem-solving aptitude.
• Great organizational and time management skills.
• Availability to resolve urgent web application issues outside of business hours.

• Job Description:

MySQL Database Administrator (DBA) who will be responsible for ensuring the

Performance, Database Tuning, Database Cleanup, Database Migration, Database Availability, and Security of Clusters of MySQL

Instances. The candidate will also be responsible for Orchestrating Upgrades,

Backups, and Provisioning of Database Instances. The candidate will also work in

tandem with the other teams, documentation, and specifications as required.

.

• Key Responsibilities:

✓ Provision MySQL instances, both in Clustered and Non-Clustered Configurations

✓ Ensuring the Performance, Database Tuning, Database Availability, and Security

of Clusters of MySQL Instances

✓ Development of Database Schema

✓ Development of ERD

✓ Find the Root Cause of Database related issues & Database Clean-up

✓ Migrating Data from Customer Database to Serosoft Product Database

✓ Prepare Documentation and Specifications

✓ Handle common database procedures, such as upgrade, backup, recovery,

migration, etc.

✓ Profile server resource usage, optimize and tweak as necessary

✓ Collaborate with other team members and stakeholders

• Skills and Qualifications:

✓ Strong proficiency in MySQL database management

✓ Decent experience with recent versions of MySQL

✓ Understanding of MySQL’s underlying storage engines, such as InnoDB and

MyISAM

✓ Experience with replication configuration in MySQL

✓ Proficient in Database Clean-up and Migrations

✓ Knowledge of De-Facto Standards and Best Practices in MySQL

✓ Proficient in Writing and Optimizing SQL statements

✓ Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.

✓ Should be able to decide when to create Views (Standard Views, Indexed views,

and Partitioned views)

✓ Knowledge of MySQL features, such as its Event Scheduler

✓ Ability to plan Resource requirements from High-Level Specifications

✓ Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.

✓ Knowledge of limitations in MySQL and their workarounds in contrast to other

popular relational databases

✓ Proficient understanding of code versioning tools such as SVN / Git

✓ DBA Certification would be added advantage

Key Responsibilities

We are looking for a full stack developer who shall be responsible for implementation of software related projects of the firm. This will involve:

–        Understanding existing services of the Company, the requirements of the project and be able to build the back-end coding structure along with front end dashboard, UI / UX for the full project. The person should be capable of building flexible coding to incorporate various user requirements, carry out user acceptance testing, fix bugs within agreed timelines.

–        Dashboard Development: Swiftly conceptualizing, designing, and developing visually engaging and functional dashboards tailored to meet the firm's specific requirements within stringent timelines.

–        Collaborative Approach: Work closely with stakeholders’ other team members, to understand dashboard requirements and ensure alignment with business objectives.

–        API Integration: Explore and integrate dashboard APIs where applicable to enhance functionalities or enable custom integrations for a more comprehensive dashboard experience.

Key Skills Required

–      Front-end Technologies: Proficiency in HTML, CSS, JavaScript, and expertise in UX/UI principles to enhance dashboard user interfaces and ensure responsiveness.

–      Strong Backend Development Skills: Proficient in at least one backend language and understanding of backend frameworks to facilitate data integration and backend functionalities for dashboards.

–      Strong SQL Skills: Ability to efficiently extract, manipulate, and analyze data using SQL queries from various databases to integrate into the dashboards.

–      Dashboard Development Experience: Prior experience in rapid dashboard development, including designing, developing, and deploying dashboards within accelerated timelines.

–      Being able to work independently, understand industry landscape and come up with innovative solutions to tackle various issues. 

• Bring in industry best practices around creating and maintaining robust data pipelines for complex data projects with/without AI component
  • programmatically ingesting data from several static and real-time sources (incl. web scraping)
  • rendering results through dynamic interfaces incl. web / mobile / dashboard with the ability to log usage and granular user feedbacks
  • performance tuning and optimal implementation of complex Python scripts (using SPARK), SQL (using stored procedures, HIVE), and NoSQL queries in a production environment

• Industrialize ML / DL solutions and deploy and manage production services; proactively handle data issues arising on live apps
• Perform ETL on large and complex datasets for AI applications - work closely with data scientists on performance optimization of large-scale ML/DL model training
• Build data tools to facilitate fast data cleaning and statistical analysis
• Ensure data architecture is secure and compliant
• Resolve issues escalated from Business and Functional areas on data quality, accuracy, and availability
• Work closely with APAC CDO and coordinate with a fully decentralized team across different locations in APAC and global HQ (Paris).

•  Expert in structured and unstructured data in traditional and Big data environments – Oracle / SQLserver, MongoDB, Hive / Pig, BigQuery, and Spark
• Have excellent knowledge of Python programming both in traditional and distributed models (PySpark)
• Expert in shell scripting and writing schedulers
• Hands-on experience with Cloud - deploying complex data solutions in hybrid cloud / on-premise environment both for data extraction/storage and computation
• Hands-on experience in deploying production apps using large volumes of data with state-of-the-art technologies like Dockers, Kubernetes, and Kafka
• Strong knowledge of data security best practices
• 5+ years experience in a data engineering role
• Science / Engineering graduate from a Tier-1 university in the country
• And most importantly, you must be a passionate coder who really cares about building apps that can help people do things better, smarter, and faster even when they sleep