Technical Architect

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.

CLIENT:MNC (WFO)

ROLE: PHP LARAVEL DEVELOPER

EXP: 3 TO 6 YEARS

LOCATION:BANGALORE.

NOTE:NOTE:Serving notice period (30days/immediate joiner.

Candidates from Bangalore location only apply.

Responsibilities:

 Discussing project aims with the client and development team.

 Designing and building web applications using Laravel.

 Troubleshooting issues in the implementation and debug builds.

 Working with front-end and back-end developers on projects.

 Testing functionality for users and the backend.

 Ensuring that integrations run smoothly.

 Scaling projects based on client feedback.

 Recording and reporting on work done in Laravel.

 Maintaining web-based applications.

 Presenting work in meetings with clients and management.

Requirements:

 A degree in programming, computer science, or a related field.

 4+ years of Experience working with PHP, and Laravel, performing unit testing, and

managing APIs such as REST.

 A solid understanding of application design using Laravel.

 Knowledge of database design and querying using SQL.

 Proficiency in HTML and JavaScript.

 Practical experience using the MVC architecture.

 A portfolio of applications and programs to your name.

 Problem-solving skills and critical mindset.

 Great communication skills.

 The desire and ability to learn.

JOB DESCRIPTION 

DYT - Do Your Thing, is an app, where all social media users can share brands they love with their followers and earn money while doing so! We believe everyone is an influencer. Our aim is to democratise social media and allow people to be rewarded for the content they post. How does DYT help you? It accelerates your career through collaboration opportunities with top brands and gives you access to a community full of experts in the influencer space. 

RESPONSIBILITIES 

• Expert in Python with knowledge of Python best practices (PEP8) 
• Strong knowledge of python web frameworks such as Django, Flask • Strong knowledge of building RESTful APIs using Django Rest Framework • Good Understanding of Django ORM Libraries 
• Able to integrate multiple data sources and databases into one system • Strong experience on Linux 
• Solid database skills in a relational database (i.e. PostgresSQL,MYSql) • Able to create database schemas that represent and support business processes • Strong unit test and debugging skills 
• Proficient understanding of code versioning tools (git) 
• Experience deploying on AWS is desirable 
• Experience with Docker,Test Drive Development will be a plus 
• Excellent interpersonal, leadership, influence and communication skills • Experience in designing scalable micro-services is desirable 

QUALIFICATIONS 

• 1-3 years of experience as a backend developer 
• At least one product build and published 
• SKILLS Contribute in all phases of the development lifecycle 
• Write well designed, testable, efficient code 
• Work well under pressure and meet deadlines without sacrificing quality • Work with distributed development teams 

• Minimum 2 years of experience in Core PHP , and hands on experience in any MVC Framework. 
• Should have hands on experience or knowledge in PHP Frameworks like Codeigniter/ Laravel/ CakePHP/ Yii . 
• Should have knowledge about OOPS Concept. 
• Good knowledge in HTML, AJAX, JQuery & MYSQL.
• Minimum 2 years of experience in Core PHP , and hands on experience in any MVC Framework. 
• Should have hands on experience or knowledge in PHP Frameworks like Codeigniter/ Laravel/ CakePHP/ Yii . 
• Should have knowledge about OOPS Concept. 
• Good knowledge in HTML, AJAX, JQuery & MYSQL.

• 3 + years expertise in Python 3.7, Django 2 (or Django 3).

• Familiarity with some ORM (Object Relational Mapper) libraries.

• Able to integrate multiple data sources and databases into one system.

• Integration of user-facing elements developed by front-end developers with server-side logic in Django (RESTful APIs).

• Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3

• Knowledge of user authentication and authorization between multiple systems, servers, and environments

• Understanding of the differences between multiple delivery platforms, such as mobile vs desktop, and optimizing output to match the specific platform

• Able to create database schemas that represent and support business processes

• Strong unit test and debugging skills.

• Proficient understanding of code versioning tools such as Git.

The desirablesoptionals

• Django Channels, Web Sockets, Asyncio.

• Experience working with AWS or similar Cloud services.

• Experience in containerization technologies such as Docker.

• Understanding of fundamental design principles behind a scalable application (caching, Redis)

• 6+ years of experience working with MongoDB or other NoSQL databases.
• Maintain and configure MongoDB (developer)
• Keep clear documentation of the database setup and architecture.
• Backup and Disaster Recovery management.
• Adept with all the best practices and design patterns in MongoDB for designing document schemas.
• Good grasp of MongoDB’s aggregation framework.
• Ensure that the databases achieve maximum performance and availability.
• Design indexing strategies.
• Configure, monitor, and deploy replica sets.
• Should have experience with MongoDB Atlas.
• Should have minimum experience with development and performance tuning.
• Create roles and users and set their permissions.
• Excellent written, verbal communication skills and critical thinking skills