
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.

About Colorgenics Marketing Services Pvt Ltd
About
Company social profiles
Similar jobs
- 5+ years of experience working with MySQL Databases, including the community edition
- Advanced understanding of Linux OS
- Can use SSH to connect to remote systems with password & public/private keys
- Deep understanding of systems performance
- Understand automation concept to speed up the work: Ansible
- Advanced knowledge on InnoDB internals
- Expert knowledge of Performance Schema
- Knows how to optimize queries/schemas
- Deep understanding of replication and clustering
- Knows backup solutions and strategies
- Knows HA solutions and strategies
- Knows proxy usage as it relates to MySQL
- Designs and executes overall database architecture strategy, standards and practices.
- Works closely with project teams to develop data models that support business processes.
- Works with application development to ensure database changes adhere to best practices and are properly prioritized and scheduled.
- Supports all areas of the enterprise - ensures that all databases run at optimal performance
- Proactively identifies and troubleshoots databases performance issues
- Ensures that industry wide security standards are properly implemented
Job Description
This is a remote position.
Requirements
- You need to be excited about the problem that we are trying to solve
- Should have excellent command over designing systems with a minimum experience of 4 years.
- Should have experience with various database flavors and writing complex queries. We work with Postgres, Redshift, ElasticSearch, TimescaleDB, and Redis.
- Additional knowledge in Golang will be an advantage
- Strong Data Structures and Algorithms knowledge
- Should have created APIs from scratch which is being used in Production
- Should be comfortable with creating systems handling up to 100k requests per minute, and have a mindset that understands scale
- Ability to give clarity and communicate well with the team, including Product, Backend and Dev-Ops (if and when needed)
- Ability to use profiling tools well, getting to root causes of bugs fast
- Ability to pick and work on adjacent technologies if and when required (Eg: If the best performance monitoring solution needs a basic firebase setup, that should not be a blocker for you to go ahead and do so)
- Knowledge of how to set up relevant test cases
- You need to be comfortable working in a remote environment (Good internet connection and availability on phone is required)
- App Development experience
- Experience in Test Driven Development
- Ability to tell Product what creates better User Experience, ability to tell frontend what API responses will help the user get a faster load time
- Inquisitiveness to understand the system as a whole, and not only be stuck to your domain of expertise (Eg: Figure out why excessive APIs calls are being made, brainstorm with Product and Frontend team to reduce the same without harming the UX )
- Experience in working on a Social Media Product
- Good knowledge of Graphs, and their applications
- Data-Driven Approach to monitoring
Benefits
- Work timings - You are the master of your time. However, with great freedom comes great responsibility. If you have committed something to the team, we expect that you will give it your best to make sure that commitment is done and is done on time.
- Leave policy - Take a leave whenever for whatever reason you want. You don't need to explain yourself to us
- Health insurance for you and your family
Hi,
We are looking for Self motivated, Passionate Technology enthusiasts seasoned PHP Developer (Laravel + Wordpress ) to join our team.
Job Description:
· Design, Develop, Implement, Test, Document and Maintain high quality Web Application Software.
· Understanding and implementing of project management practices.
· MVC compliant Development (Laravel/YII / CodeIgniter / Zend Framework) in at least any one of these frameworks.
· Experience with CMS framework i.e. Wordpress.
· Optimization of PHP Code and database queries and functions through Code Review and Project Review Sessions.
· Identify opportunities for process improvement and make constructive suggestions for change.
· Improve the technical competence of the team through training & development of existing and new team members.
· Provide accurate effort estimates for deliverable and be committed to the deadlines through follow-up of tasks with team members.
· Research and actively learn about new technologies and introduce them into the infrastructure.
Eligibility criteria :
· Minimum experience if 2 years in laravel and wordpress. both
· Excellent problem-solving skills and love technical challenges.
· Ability to work in a team-oriented, collaborative environment.
· Ability to manage priorities and work in a fast pace environment.
· Strong database skills, proven experience with MySQL 5 having knowledge of indexes, fulltext searches, usage of Regular Expressions in queries and more.
· Excellent knowledge of Applications Architecture and how to work with Frameworks with MVC architecture.
· Excellent Knowledge of HTML 5, CSS 3, Javascript, jQuery/Sencha etc.
· Key Skills Required : Wordpress, Laravel, CodeIgniter, Zend, Mysql, Jquery, API (Restful Service).
Interested candidates can share their updated resume at manpreet.kaur(at)chicmic.co.in
Thanks
We are looking for a Back-End Web Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. A basic understanding of front-end technologies is therefore necessary as well.
Responsibilities
- Actively participate in the overall application lifecycle.
- Focus on coding and debugging.
- Collaborate with front-end developers.
- Define and communicate technical and design requirements.
- Build a high-quality reusable code that can be used in the future.
- Create sustainable and functional web applications with clean codes.
- Learn about new technologies and stay up to date with current best practices.
- Conduct UI tests and optimize performance.
- Train, help, and support to other team members
Requirements
- Hands-on backend web development experience.
- Proficient knowledge of a backend programming language and an in-depth understanding of web development.
- Knowledgeable of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3.
- Proven experience creating user authentication and authorization between multiple systems, servers, and environments.
- Capability to integrate multiple data sources and databases into one system.
- Proven experience managing the hosting environment, including database administration and scaling an application to support load changes.
- Ability to set up and administer backups, data migration, transformation, and scripting.
Skills
- Coding (HTML/CSS3)
- Debugging
- Programming (JavaScript, PHP, Magento, OOPs,)
- PHP Framework
- Analytical Skills
- Web Development
- API
JD-Backend Intern (NodeJs)
Internship Span – 6 Months (Fulltime)
Ventura Securities is establishing its fintech team - a remote-first, work from anywhere team with highly talented individuals who come from diverse backgrounds and looking to solve real client problems at scale. Ventura has been in the stockbroking business for 20+ years and it is a robust and profitable franchise with 1000+ employees currently. We are looking for passionate techies with skills primarily around AWS and Node’s/JS who are aspiring for a fast-track career.
Your Key Responsibilities:
• Build out of the Ventura cloud-based backend platform from scratch
• Ownership and monitoring of our D2C backend
• Robust documentation skills and desire to share information with others
• Desire and ability to prototype ideas quickly, and be willing to experiment and learn
Basic Requirements:
• Very strong Nodejs, AWS Lambda, Postgres, ORM (Sequelize)
• Clean coding skills around Nodejs
• Hands-on experience around writing testable code, working with git, doing peer-level code review, daily standups, and generally championing software excellence.
• Should have concepts cleared around Nodejs and JS
• Strong proficiency with JavaScript
• Ability to use Async programming to improve performance & productivity
• Strong problem solving skills with understanding of Data Structures and Algorithms.
• What you get:
• Chance to build out a next-gen fintech product from ground 0
• Opportunity to influence the design of the product
• Flexible and work anywhere environment running out of Slack
• Flat org structure
• This internship is paid internship.
Responsibilities
- Writing clean and secure modular codes that have undergone strict testing and evaluation.
- Maintaining and designing databases effectively.
- Build efficient, testable, and reusable PHP modules
- Solve complex performance problems and architectural challenges
- Write quality code with robustness and re-usability for secured web applications and web services (REST and SOAP) for mobile apps.
- Ability to work in a team environment as well should be able to manage a team.
- Must meet the deadline.
Requirements
- Strong hands on experience with PHP Laravel framework
- Knowledge of object oriented PHP programming
- Must have strong experience with API (Web Services) development using JSON, RESTFUL.
- Understanding of MVC design patterns
- Should be best at writing and understanding complex queries using any of two from - MySQL, NoSQL, MongoDB, PostgreSQL, T-SQL.
- Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3
- Proficient understanding of code versioning tools, such as Git, SVN.
- Excellent communication and problem-solving skills.
Years of Experience:- 1.5+
Qualification:- BE Computer Engineering/MCA
Industry:- Software
Location:- Andheri
Candidate should have atleast 4 years of relative experience in PHP
Candidate should be able to explain the work done in the Past
Candidate should be good in logical implementations
Candidate should be good in Communication and work approach
Candidate should have good solution oriented approach
Candidate worked with premium Institution or premium product/app will be a great plus
Technical Skills
1.Proficient knowledge of language PHP and JavaScript - Must have
2.MVC Framework like codeigniter/laravel is mandate - Must have
3.Good understanding of advanced JavaScript libraries - Must have
4.Database: Mysql Database Design, DB Query Knowledge, Development and improvements - Must have
5.Candidate should be good in writing optimized DB Queries and should know how to write effective DB Queries. - Must have
6.Good experience on dealing with JSON/REST API and Web Services.
7.Good understanding and experience of code versioning tools such as Git.
8.Proficient in Linux OS and Candidate should be able to work independently
9.Caching : Redis(optional)
10.No-sql database :Mongodb(optional)
Other Norms
- Candidate should have good machines/laptop to work.
- Candidate should have good internet connection at their work place
JOB RESPONSIBILITIES :
Web Development / Programming
Magento module development (Back-End)
Realization of developments following a cycle in V (agility)
Elaboration of test scenarios and execution of tests
Application acceptance with referring users
Management of a development unit
Train level 1 support teams
TECHNICAL SKILLS REQUIRED :
Magento
Linux
PHP5
Mysql
Unit tests : PHPUnit / Mockery / GIT / Jenkins / Jira / Agile methodology
TECHNICAL SKILLS RECOMMENDED :
Vagrant
Laravel
Elasticsearch
Redis









