Oracle Developer

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.

Mentoring teams to carry forward recognised and optimised solutions, building conducive environments for knowledge transfer and maintaining standards in terms of deliveries form a major part of responsibilities.

Responsibilities

• Design and develop robust scalable database systems
• Design, build and deploy internal applications to support our native technical ecosystem
• Collaborate with Subject-Matter experts to design data-driven modules for analysis

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering or equivalent
• 3-4 years of experience in Java

Skills

• Expertise in object-oriented programming concepts and data structures
• Strong knowledge of working with XMLs/Jsons
• Experience with large-scale distributed storage and database systems (MySQL, MongoDB, GraphDB)
• Good knowledge of indexing/search libraries like Lucene/Solr/Elasticsearch
• Exposure to Spring MVC architecture and RESTful APIs
• Well-versed with Agile methodology of SDLC
• Good to have: Knowledge of standard DevOps skills like Build tools (Maven/gradle), Continuous integration (Jenkins), Version Control (Github/Gitlab)

Must know MySQL & PostgreSQL

- Good Knowledge of HTML, PHP Frameworks (like CI, Laravel, YII), Core PHP, JavaScript and CSS coding.

- Knowledge of Bitbucket/GitHub.

- Strong hands-on Bootstrap.

- Knowledge of databases and database concepts.

- Strong knowledge of Laravel/ CodeIgniter and its extensive feature set.

- Working Knowledge of e-commerce frameworks like OpenCart, WordPress, cs-cart, and Magento.

- Working knowledge of API for Mobile Applications

- Experience in Cache, and search plugins in terms of optimization

- Developing plug-ins/add-ons in PHP for various CMS solutions.

• Designing and Developing web applications using Laravel 7 / 8
• Closely working front-end and back-end developers on projects.
• Hands on experience with handing MySQL queries
• Excellent logical and analytics skill
• Experience on handling and developing API end points
• Experience with Payment Gateway integrations and implementations
• Knowledge on any Frontend Framework - Bootstrap / Foundation / Backbone (Secondary skills, added advantage)

• Follow standard coding structure with Security first approach to avoid vulnerabilities such as SQL Injection and XSS
• Sound knowledge on integrating multiple payment gateway

Required Qualifications and Skills:

• 3-5 years of work experience in the development background, with at least 2 years experience in Java, Spring, Sprint Boot, Hibernate or JPA, MySQL, Oracle, Spring MVC.
• B.E. degree in Computer Science, Graduate in Software Engineering or equivalent
• Experience in Core JAVA, Spring, Spring Boot Frameworks.
• Experience with ORM's like Hibernate.
• Good knowledge of developing RESTful web services using Spring Boot, Java1.x,Servlet2.4, JSP2.0, JDBC3.0, Java Mail, Struts2.x, HTML, HTML5, Angular7+, JavaScript, JSF, Bootstrap2.x-3.x, JQuery & CSS 3.x, Maven 3.x, Apache Tomcat7
• Knowledge of Cloud AWS.
• Experience in any Messaging Queue e.g. Apache Kafka, ActiveMQ, etc.
• Experience on Web services with REST and SOAP.
• Experience working on tool set like Eclipse IDE, SQL clients.
• Experience using application server like Jboss, TomCat, Wildfly, glassfish.
• Experience in using tools like SOAP UI, POSTMAN
• Ability to write SQL queries to fetch data.
• Knowledge of Micro services, Redis Cache and Mongo DB (or any other NoSQL) is good to have