Dot Net Engineer

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.

Key Responsibilities:

● Work closely with product managers, designers, frontend developers, and other

cross-functional teams to ensure the seamless integration and alignment of frontend and

backend technologies, driving cohesive and high-quality product delivery.

● Develop and implement coding standards and best practices for the backend team.

● Document technical specifications and procedures.

● Stay up-to-date with the latest backend technologies, trends, and best practices.

● Collaborate with other departments to identify and address backend-related issues.

● Conduct code reviews and ensure code quality and consistency across the backend team.

● Create technical documentation, ensuring clarity for future development and

maintenance.

Requirements;

● Experience: 4-6 years of hands-on experience in backend development, with a strong

background in product-based companies or startups.

● Education: Bachelor’s degree or above in Computer Science or a related field.

● Programming skills: Proficient in Python and software development principles, with a

focus on clean, maintainable code, and industry best practices. Experienced in unit

testing, AI-driven code reviews, version control with Git, CI/CD pipelines using GitHub

Actions, and integrating New Relic for logging and APM into backend systems.

● Database Development: Proficiency in developing and optimizing backend systems in

both relational and non-relational database environments, such as MySQL and NoSQL

databases.

● GraphQL: Proven experience in developing and managing robust GraphQL APIs,

preferably using Apollo Server. Ability to design type-safe GraphQL schemas and

resolvers, ensuring seamless integration and high performance.

● Cloud Platforms: Familiar with AWS and experienced in Docker containerization and

orchestrating containerized systems.

● System Architecture: Proficient in system design and architecture with experience in

developing multi-tenant platforms, including security implementation, user onboarding,

payment integration, and scalable architecture.

● Linux Systems: Familiarity with Linux systems is mandatory, including deployment and

management.

● Continuous Learning: Stay current with industry trends and emerging technologies to

influence architectural decisions and drive continuous improvement.

Benefits:

● Competitive salary.

● Health insurance.

● Casual dress code.

● Dynamic & Collaboration friendly office.

● Hybrid work schedule.

Industry

• IT Services and IT Consulting

Employment Type

Full-time

PinnacleWorks has an urgent opening for a Senior Laravel Developer having a rich experience in web development & strong knowledge of Object-Oriented Programming & Database concepts. You will be responsible for building high-performing, scalable,enterprise-grade applications.

What will you do?

• Build high-quality web applications from scratch using Laravel.
• Troubleshooting issues in the implementation and debug builds.
• Design, build and maintain efficient, reusable, and reliable code to ensure the applications' best possible performance, quality, and responsiveness.
• Contribute in all phases of the development lifecycle.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency.
• Prepare and maintain all applications utilizing standard development tools.
• Keep abreast of new trends and best practices in web development.
• Learn new Software/frameworks/ languages/ technology with ease.
• Finalizing back-end features and testing web applications.
• Refactor, optimize and improve the existing codebase for maintenance and scale.
• Solve complex performance problems and architectural challenges.
• Will be incharge of a small team of Developers.
• Will take ownership of one or more modules of a platform.

Skills Required

• Excellent working knowledge of PHP-based MVC framework Laravel
• Excellent knowledge of PHP, HTML, CSS & Javascript and understanding of Database concepts & working knowledge of MySQL
• Prior Experience of managing/handling a small team of developers would be an added advantage.
• Understanding the fully synchronous behavior of PHP
• Understanding of MVC design patterns
• A clear understanding of RESTful API development standards
• Passion for best design and coding practices and a desire to develop new bold ideas.
• Understanding fundamental design principles behind a scalable application
• Creating database schemas that represent and support business processes
• Proficient understanding of code versioning tools, such as Git
• Excellent problem-solving skills
• Understanding managing Linux servers & AWS/GCP
• Hands-on experience with Redis

• Mandatory skills -PHP Experience.
• Experience in web application development and web developer.
• Good Knowledge of PHP, MySQL, jQuery, Javascript, HTML5, CSS3, XML
• Good debugging skills .
• Expertise in MVC Frameworks and good technology exposure of CI/Larvel frameworks added advantage.

• Preferably 5+ years of experience in LAMP (Linux, Apache, MySQL, & PHP) development stack
• Proven software development experience in PHP and of developing REST (JSON) / SOAP (XML) based web services
• Experience in Cloud platform like AWS/Azure
• Experience with HTML5 / JavaScript (JQuery) / CSS / AJAX / Angular / Yii Framework is preferred
• Experience in caching solutions like Redis and Memcached
• Experience in tools like Ansible, Docker
• Knowledge of source control systems such as GIT is a plus

• Be able to work in cross-function teams
• Write high-quality code per industry standards and best practices
• Test the code for quality assurance, debug identified bugs and resolve issues
• Support in deploying and maintenance of product and services
• Documenting product services progress, status, and manuals
• Participate in team meetings and planning & review sessions

What are we looking for? :

- Experience of upto 3 years in PHP or other backend programming languages.

- Understanding of MVC structures, OOPs concepts and Frameworks.

- Experience working with Linux, Nginx or Apache and Git, REST APIs.

- Experience with Third party API integrations and using various vendor libraries.

- Have knowledge of Database schemas, structures and migrations.

- Experience in Laravel would be a huge plus.

What you will be doing?:

- Collaborate with team members and solve new challenges through tech and research.

- Take end-to-end ownership of delivering new modules - analyze customer usage & feedback, review business requirements, develop functionalities and test code.

- Write clean readable code and also follow best practices for efficiency and performance.

- Self learn and work independently, Also collaborate with the team when required.

- Communicate constructively and value user experience and feedback.

.
What can you expect to learn?:

- Exposure to latest web technologies and frameworks like Angular, Laravel, PHP, Magento, PWAs, REST APIs, Elastic search and Web services.

- Develop custom functionalities and modules in Laravel to implement business ideas and user requirements.

- Best coding practices and various methodologies to optimize performance and produce the best quality product. Various caching techniques and optimization standards.

- Microservices architecture and Scalability using cloud services, Automation of manual tasks using linux and shell scripting, Data migrations, SQL and Version control tools like bitbucket.

Perks : 

- Competitive salary

- Flexible work hours

- No dress code

- Group outings

- Supportive work culture

-Must have experience in core Php.

-Proficiency in Php and Php based MVC frameworks like laravel.

-Good knowledge of the OOPs concepts

-Development of Php based web application

-Development of Php based APIs

-Contribute to a backend web application with clean, portable, well-documented code

-Work closely with a team to ensure the successful front end

-Taking static HTML/CSS frontend code and integrating with custom Php website and web app

-On time delivery of the projects

-Able to work in a team as well as individually.

Job Type: Full-time