SQL Developer

Job description

• Database Design & Development:
• Design, implement, and maintain PostgreSQL databases.
• Develop efficient schemas, indexes, and stored procedures to optimize data performance.
• Backend Development:
• Develop RESTful APIs and backend services using Node.js.
• Integrate databases with backend applications for seamless data flow.
• Query Optimization & Performance Tuning:
• Optimize SQL queries for performance and scalability.
• Monitor database health and troubleshoot slow queries or deadlocks.
• Security & Compliance:
• Implement database security best practices, including role-based access control (RBAC) and encryption.
• Ensure compliance with industry standards like GDPR, HIPAA, etc.
• Data Migration & Backup:
• Develop and maintain data migration scripts between different PostgreSQL versions or other databases like mongodb.
• Set up and manage database backup and recovery strategies.
• Write efficient SQL queries and manage database schemas using PostgreSQL.
• Build RESTful APIs and integrate third-party APIs/services.
• Optimize application performance and troubleshoot production issues.
• Ensure data security and protection practices are followed.
• Write clean, maintainable code and participate in code reviews.

GaragePlug Inc

GaragePlug is one of the fastest-growing Automotive tech startups working towards revolutionising the automotive aftermarket industry with strong state-of-the-art technologies.

Role Overview

As we plan to grow, we have many challenges to solve. Some of the new features and products that are already in the pipeline include advanced analytics, search, reporting, etc., to name a few. Our present backend is based on the microservices architecture built using Spring Boot. With growing complexity, we are open to using other tools and technologies as needed. We are looking for a talented and motivated engineer to join our fleet and help us solve real-world problems in this exciting field. Join us and share the dream of building the next-generation online platform for the Auto industry.

What you'll do:

• Design and architect our core components
• End-to-end systems development
• Ownership of complete systems from development to production and maintenance
• Infrastructure management on AWS

Technologies you'll use:

• Microservices, AWS, Java, Spring-boot
• Gradle / Maven
• ElasticSearch
• Jenkins, CI/CD
• Containerization technologies like Docker, Kubernetes, etc.
• RDBMS (PostgreSQL) or NoSQL databases (MongoDB) & Enterprise Messaging Applications (Kafka/SQS)
• JUnit, TestNG, Cucumber, etc.
• Nginx
• Any cool piece of technology that you can bring onboard

What you are:

• You love technology and are always open to learning new tools
• You are proficient with server technologies: Spring / Spring Boot
• You have good experience in scaling, performance tuning & optimization at both API and storage layers
• You have an excellent grasp of OOPS concepts, data structures, algorithms, design patterns & REST APIs
• You are proficient in Java, SQL
• You have good knowledge of Databases: RDBMS/Document
• You have a good understanding of REST API design
• You have knowledge of DevOps
• Implement Coding Best Practices. Implement Code Quality gates as per the program norms
• Knowledge of Angular 2+ is a big plus

Job Title: Odoo Developer

Job Summary:

We are seeking an experienced Odoo Developer to join our dynamic team. The ideal candidate will be responsible for customizing, developing, and implementing Odoo ERP solutions. You will work closely with clients to understand their business needs and create tailored solutions to enhance business processes and improve efficiency.

Key Responsibilities:

• Odoo Customization & Development: Customize and develop Odoo modules based on client requirements.
• Module Creation: Design, implement, and maintain custom Odoo modules for various business functions (e.g., sales, inventory, accounting).
• Integration: Integrate Odoo with third-party applications and external systems through APIs.
• Database Management: Manage and optimize PostgreSQL databases associated with Odoo.
• Bug Fixing & Troubleshooting: Identify, diagnose, and resolve issues in Odoo systems to ensure smooth operations.
• Odoo Upgrades: Perform Odoo version upgrades and ensure compatibility of modules across different versions.
• User Support: Provide technical support to users and assist in troubleshooting issues.
• Documentation: Maintain proper documentation of all customizations and development work.
• Collaboration: Work closely with project managers, business analysts, and clients to deliver the best solutions.

Skills & Qualifications:

• Strong proficiency in Python and experience with the Odoo framework.
• Experience in developing and customizing Odoo modules and reports (Qweb).
• Solid understanding of SQL, PostgreSQL, and database management.
• Knowledge of JavaScript, XML, HTML, and CSS for front-end customization.
• Familiarity with API integration and third-party system integration.
• Strong problem-solving and debugging skills.
• Experience with version control systems like Git.
• Ability to work on multiple projects and meet deadlines in a fast-paced environment.
• Good communication skills and ability to collaborate with clients and team members.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Preferred Skills:

• Experience in Odoo eCommerce and Odoo Studio.
• Knowledge of project management methodologies (e.g., Agile).
• Familiarity with Odoo security best practices and performance optimization.

Why Join Us?

• Opportunity to work on exciting Odoo projects across different industries.
• Collaborative and supportive work environment.
• Competitive salary and benefits.

•  You should have deep understanding of NodeJS
•  You should be strong in Javascript and TypeScript
•  You should be capable of writing complex queries
•  ES6, Express, Apollo Server, Send Grid Email, Twilio SMS, Payment
• Gateway,
• Error Loggin, API Developement, API Security,
• PostGreSQL/MSSQL/MySQL, MongoDB/CouchDB
• Very good knowledge on REST API
• Good experience in Agile methodologies
• Ability to design and write code complying with coding standards
• and other factors like performance, scalability, reliability,
• reusability, modularity in mind
• You should have strong logical and problem solving skills
• Excellent communication and customer interfacing skills
• AWS certification is nice to have
• Strong proficiency with JavaScript and good to have
• ES6(Typescript) knowledge
• Knowledge of Node.js and frameworks such as Express, Restify
• Understanding the nature of asynchronous programming and its
• quirks and workarounds
• Understanding accessibility and security compliance
• User authentication and authorization between multiple systems,
• servers, and environments
• Integration of multiple data sources and databases into one
• system
• Understanding fundamental design principles behind a scalable
• application
• Competencies and Skills Required
• equires excellent analytical, problem solving, and good
• communications skills
• Must be able to work effectively with business stakeholders
• Strong passion for delivering technical solutions to business
• problems
• Understanding and mindset of Agile software delivery (Ability to
• adapt to continually changing priorities)
• Team player who understands the importance of teamwork and
• collaboration
• Passion for delivering new approaches and challenging the ‘statusquo’
• Hungry to learn and always in search of continuous improvement

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills

 Roles & Responsibilities -

• Build and maintain infrastructure for data retrieval, processing and storage
• Build strong working relationships with international teams
• Be willing and able to adapt to changes in priorities
• Ability to learn and apply new technologies to deliver added business value
• Maintain a strong focus on quality

• Proficient in Python / SQL
• Good understanding of data base management systems
• Experience developing and maintaining systems that handle large amounts of data
• Understanding of Electronic Trading Systems
• Attention to detail and code quality
• Excellent problem solving and analytical skills in a high-pressure environment
• Strong communication skills and an ability to convey ideas and concepts with clarity