PL/SQL Developer

Our Vision:

Vapronix web is a platform for constant interaction of technology and human creativity. We aim to create a digital environment that connects people from around the world, fulfilling their entertainment and mind simulation needs while co-creating happiness and generating value for all.

Job Summary:

As a Full Stack Developer at Vapronix Web, you will play a crucial role in developing and optimizing interactive and visually stunning games. You will work closely with our creative and technical teams to bring our game concepts to life and create memorable player experiences.

Roles and Responsibilities Include But Are Not Limited To:

• Manage and execute the full development lifecycle for various projects, from initial planning through deployment.
• Collaborate closely with team members to ensure alignment on project goals and efficient execution.
• Ensure timely delivery of project milestones and final releases.
• Apply best practices in development, following W3C standards when applicable.
• Work effectively within Linux environments, with experience in installing and configuring packages such as Apache, Docker, and virtual hosts.
• Translate business requirements into comprehensive technical designs and solutions.
• Utilize version control systems, particularly Git, for effective source code management.
• Regularly maintain, enhance, and iterate on existing systems to improve functionality and performance.

Required Skills:

• Bachelor's Degree in Computer Science, Software Engineering, Information Technology, or a related field.
• Minimum of 3 years of experience as a Full Stack Developer in a professional setting.
• Proficiency in front-end technologies, including HTML, CSS, jQuery, Bootstrap, JavaScript, and React or Angular.
• Back-end development experience in PHP (or Node/Python), along with database management skills in MySQL and PostgreSQL.
• Familiarity with AJAX, CodeIgniter, or any PHP framework.
• Strong analytical skills with a proactive approach to problem-solving.
• Ability to meet deadlines consistently while maintaining high-quality standards.
• Adaptability to changing project requirements and deadlines.
• Effective in both independent and collaborative team settings, with strong communication skills.
• Logical thinking and an ability to think critically to solve complex challenges.

KEY RESPONSIBILITIES

·      Develop high-quality database solutions.

·      Use T-SQL to develop and implement procedures and functions.

·      Review and interpret ongoing business report requirements.

·      Research required data.

·      Build appropriate and useful reporting deliverables.

·      Analyze existing SQL queries for performance improvements.

·      Suggest new queries.

·      Develop procedures and scripts for data migration.

·      Provide timely scheduled management reporting.

·      Investigate exceptions with regard to asset movements.

MUST-HAVES FOR THIS GIG

T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent

Backup and Maintenance plan ,Data Migration, Good Communication

NICE-TO-HAVES FOR THIS GIG:

• Working knowledge of mobile development activity.
• Working knowledge of web hosting solution on IIS7.

Experience working with an offshore –onsite development process 

About Merchandise Operation (Merch Ops): Merchandise Operations (Merch Ops) is a merchandise management system, it is positioned as a host system in the retail solutions, it has ability to maintain the Master/Foundation data, create and manage Purchase Orders, create, and manage Prices & Promotions, perform Replenishment, effective inventory control and financial management. Merc Ops provides Business users with consistent, accurate, and timely data across an enterprise by allowing them to get the:

Right Goods in the...

• Right Silhouettes, Sizes and Colors; at the...

• Right Price; at the...

• Right Location; for the...

• Right Consumer; at the...

• Right Time; at the...

• Right Quantity.

About Team:

• Proven, passionate bunch of disruptors providing solutions that solve real-time supply chain problems.

• Well mixed experienced team with young members and experienced in product, domain, and Industry knowledge.

• Gained Expertise in designing and deploying massively scalable cloud native SaaS products

• The team currently comprises of associates across the globe and is expected to grow rapidly.

Our current technical environment:

• Software: React JS, Node JS, Oracle PL/SQL, GIT, Rest API. Java script.

• Application Architecture: Scalable three tier web application.

• Cloud Architecture: Private cloud, MS Azure (ARM templates, AKS, HD insight, Application gateway, Virtue Networks, Event Hub, Azure AD) • Frameworks/Others: Tomcat Apache, RDBMS, Jenkins, Nginx, Oracle Type ORM, Express.

What you'll be doing:

• As a Staff Engineer you will be responsible for the design of the features in the product roadmap

• Creating and encouraging good software development practices engineering-wide, driving strategic technical improvements, and mentoring other engineers.

• You will write code as we expect our technical leadership to be in the trenches alongside junior engineers, understanding root causes and leading by example

• You will mentor engineers

• You will own relationships with other engineering teams and collaborate with other functions within Blue Yonder

• Drive architecture and designs to become simpler, more robust, and more efficient.

• Lead designs discussion and come up with robust and more efficient designs to achieve features in product roadmap

• Take complete responsibility of the features developed right from coding till deployments

• Introduce new technology and tools for the betterment of the product

• Guides fellow engineers to look beyond the surface and fix the root causes rather than symptoms.

What we are looking for:

• Bachelor’s degree (B.E/B.Tech/M.Tech Computer science or related specialization) and minimum 7 to 10 years of experience in Software development, has been an Architect, within the last 1-2 years minimum. • Strong programming experience and background in Node JS and React JS.

• Hands-on development skills along with architecture/design experience.

• Hands-on experience on designing, building deploying and maintenance of enterprise cloud solutions.

• Demonstrable experience, thorough knowledge, and interests in Cloud native architecture, Distributed micro-services, Multi-tenant SaaS solution and Cloud Scalability, performance, and High availability

• Experience with API management platforms & providing / consuming RESTful APIs

• Experience with varied tools such as REST, Hibernate, RDBMS, Docker, Kubernetes, Kafka, React.

• Hands-on development experience on Oracle PL/SQL.

• Experience with DevOps and infrastructure automation.

Roles and Responsibilities:

• Understand and troubleshoot technology problems and offer solutions
• Understand the technology infrastructure and Application architecture end to end
• Code review for the source code delivered by team
• Understand the business requirements and deliver it through outsourced team
• Support/lead new technology initiatives and related technology deliveries
• Take part in evaluation of new products, POC, Time bound RND and solution deliveries
• Manage teams (both internal and external)/projects within given cost and time
• Plan, execute, track and report progress of initiatives taken up
• Adopt new processes/ improve existing processes to deliver better business solutions
• Adhere to quality / info-security guidelines and processes including maintain adequate documentation
• Attend review meetings, business user meetings, IT meetings etc

• Minimum qualification required is Graduation in computers / electronics with an experience of 2-6 years
• Require good written and spoken communication skills
• Require ability to lead a team and manage delivery with help of partners.
• Require hands on experience in developing applications with Angular, .Net Core, Asp.Net, MVC, SQL and Node JS.
• Require proven abilities to analyze, debug and find solution to technology issues
• Require process orientation, ability to adopt new processes and improve existing processes on ongoing basis
• Require experience in developing responsive web applications
• Require hands on experience in scaling/load balancing applications
• Require hands on experience in writing queries on SQL technologies
• Require knowledge of Windows operating systems
• Passion to learn and work on any technology

Development of Web based Applications using latest technologies like, AngularJS, Node.js, SQL Developer, MongoDb. Designing and developing user interfaces using AngularJS best practices. Adapting interface for modern internet applications using the latest front-end technologies, Writing JavaScript, CSS, and HTML, Developing product analysis tasks.

Must Have:

1. Strong proficiency with .Net Core API development
2. Experience with caching approaches for API
3. Hands on with SQL Server and its variation among popular databases
4. Well versed with stored procedures, query plans, altering the indexes, and troubleshooting the performance holdups
5. Skilled at performance optimization of .NET APIs
6. Experience & Knowledge on Open API specification & swagger documentation
7. Experience in building Cloud Native Applications
8. Experience in Microservices architecture
9. Has worked on the deployment of applications using Docker
10. Has Knowledge of Kubernetes
11. Has Experience with Cache systems like Redis.

Nice to Have:

1. Familiar with .NET design patterns
2. Performance tuning of SQL Stored Procedures

Note: We looking for immediate joiners. We expect the offered candidate should join within 15 days. Buyout reimbursement is available for 30 to 60 days notice period applicants who can ready join within 15 days.