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
Similar jobs
Are you interested in creating outstanding, reliable and scalable software?
We at Lynkzo are creating a modern omni channel communication platform for companies to meet the changing requirements in the market.
We are looking for someone who:
- has hands-on experience with creating/working on scalable applications in Nodejs using various frameworks like Express, Hapi, Fastify, etc and can structure a fairly large codebase properly.
- has been working as a backend developer for 3+ years.
- has great experience working in both SQL and NoSQL databases.
- can extensively test the entirety of the application.
- can convert real-world business challenges into effective technical solutions.
- has experience working with an agile/scrum team.
- can work independently with limited supervision.
*Experience in AWS will be good to have.
· Knowledge of Appian architecture and its objects best practices
· Participate in analysis, design, and new development of Appian based applications
· Team leadership and provide technical leadership to Scrum teams
· Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced
by team
· Build applications: interfaces, process flows, expressions, data types, sites, integrations, etc.
· Proficient with SQL queries and with accessing data present in DB tables and views
· Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart
services, integration services and web services
· Experience working with different Appian Object types, query rules, constant rules and expression
rules
Qualifications
· At least 3 years of experience in Implementing BPM solutions using Appian 19.x or higher
· Over 8 years in Implementing IT solutions using BPM or integration technologies
· Certification Mandatory- L1 and L2 a
· Experience in Scrum/Agile methodologies with Enterprise level application development projects
· Good understanding of database concepts and strong working knowledge any one of the major
databases e g Oracle SQL Server MySQL
Additional information
Skills Required
· Appian BPM application development on version 19.x or higher
· Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
· Good leadership skills and the ability to lead a team of software engineers technically
· Experience working in Agile Scrum teams
· Good Communication skills
according to our company’s needs. You will be responsible for planning, developing,
testing, improving and maintaining new and existing databases to help users retrieve
data effectively. As part of our IT team, you will work closely with developers to ensure
system consistency. You will also collaborate with administrators and clients to
provide technical support and identify new requirements. Communication and
organization skills are keys for this position, along with a problem-solution attitude.
You get to work with some of the best minds in the industry at a place where
opportunity lurks everywhere and in everything.
Your responsibilities are as follows.
• Working cross functional teams to develop robust solutions aligned with the
business needs
• Maintaining communication, providing regular updates to the development
team ensuring solutions provided are fit for purpose
• Training other developers in the team on best practices and technologies
• Troubleshooting issues in the production environment understanding the root
cause and developing robust solutions
• Developing, implement, maintain and solutions that are both reliable and
scalable
• Capture data analysis requirements effectively and represent them formerly
and visually through our data models.
• Maintaining effective database performance by identifying and resolving
production and application development problems
• Optimise the integration and installation of new releases
• Monitoring system performance, test, troubleshoot and integrating new
features
• Proactively recommending solutions to improve new and existing database
systems
• Providing database support by coding utilities, resolving user questions and
problems
• Ensuring compliance to database implementation procedures
• Performing code and design reviews as per the code review process
• Installing and organising information systems to guarantee company
functionality
• Preparing accurate documentation and reports
• Migration of data from legacy systems to new solutions
• Stakeholders’ analysis of our current clients, company operations and
applications, and programming requirements
• Collaborate with functional teams across the business to deliver end-to-end
products, features enabling enhanced performance
Required Qualifications:
We are looking for individuals who are curious, excited about learning, and navigating
through the uncertainties and complexities that are associated with a growing
company. Some qualifications that we think would help you thrive in this role are:
• Minimum 8 Years of experience as a Database Administrator
• Strong knowledge of data structures and database systems
• In depth expertise and hands on experience with MySQL/MariaDB Database
Management System
• In depth expertise and hands on experience in database design, data
maintenance, database security, data analysis and mining
• Hands-on experience with at least one web-hosting platform such as Microsoft
Azure, AWS (Amazon Web Services) etc.
• Strong understanding of security principles and how they apply to web
applications
• Basic knowledge of networking, Desirable knowledge of business intelligence
• Desirable knowledge of data architectures related to data warehouse
implementations
• Strong interpersonal skills and a desire to work collaboratively to achieve
objectives
• Understanding of Agile methodologies
• Bachelor/Masters of CS/IT Engineering, BCA/MCA, B Sc/M Sc in CS/IT
Preferred Qualifications
• Sense of ownership and pride in your performance and its impact on company’s
success
• Critical thinker, Team player
• Excellent trouble-shooting and problem-solving skills
• Excellent analytical and Strong organisational skills
• Good time-management skills
• Great interpersonal and communication skills
- Hands-on Experience with PHP CodeIgniter Framework
- Proficient in PHP, HTML5, JavaScript, CSS, JQuery
- Excellent relational database skills with MySQL
- Understanding of responsive design frameworks such as bootstrap
- Utilize backend data services and contribute to increasing existing data services API
- Lead the entire web application development lifecycle right from concept stage to delivery and post-launch support
- Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
- Keep updated & use best practices in web development
Job Description:
We are looking for a passionate PHP Developer to join our backend team. The ideal candidate will be an enthusiastic developer eager to learn and grow his/her skills in the field.
- Actively Seek New Programming Knowledge.
- Build Products Using HTML/CSS/JS and Other Front-End Technologies using Frameworks.
- Working knowledge of frameworks like CakePHP, Laravel, etc. is a must.
- Must have knowledge of JS Frameworks like Node and React etc.
- Knowledge of HTML, CSS, MYSQL, and JavaScript.
- Knowledge of MYSQL, Core PHP, and PHP5 is a must.
- Knowledge of WordPress and CMS.
- AJAX, HTML, Payment Gateway.
- Excellent working knowledge of Web application development.
- Vast knowledge of PHP programming concepts.
- Experience in OOPs.
- Advanced to expert coding skills.
- Strong understanding of functionality.
- Knowledgeable of Web Application Development Frameworks.
- Minimum 5 years of Experience
Job Responsibilities:
- Work independently as well as part of a team to develop new functional features
- Debug existing code and continually look for ways to optimize performance.
- Lead a team of developers, managing and mentoring their work while ensuring project deadlines and quality standards are maintained.
- Interact with service providers, customers and other departments to identify and resolve issues, and develop working relationships with key customers.
Expectations / Cultural Traits:
- Good communication and relationship-building skills.
- Self-driven and motivated.
- Open to work in flexible hours and shifts.
- Ability to work under pressure.
- Willing to learn new technologies and tools
Developed in formal collaboration with the University of Cambridge in May 2000, HeyMath! is an Ed-Tech company whose mission is to Raise the Game in Maths for school systems around the world. We do this using technology to deliver engaging teaching methodologies and personalised learning paths for students. HeyMath! has been successfully adopted by CBSE schools since 2004, with positive outcomes for the entire ecosystem.
Check us out at www.heymath.com
We plan to work mainly from home in 2021 and the virtual office atmosphere is collegiate, informal and friendly, with small high-impact teams making a difference to customers.
What we are looking for:
Experience in building and re-engineering cloud based solutions on AWS.
Strong knowledge of Object Oriented Programming(OOPS) and design patterns is a must.
Hands-on development on Spring MVC framework.
Experience working on Java 8 or above.
Must have very good knowledge of RDBMS such as MySQL and performance tuning of the same.
Exposure to server-side and client-side caching mechanisms.
Ability to debug the applications and provide instant workable solutions.
Experience working on Elastic Search / Kafka / Kubernetes or all is a nice to have.
• Have strong experience in Go
• Have expertise in implementing microservices (using tools and technologies for messaging, GraphQL, GRPC, REST API, etc)
• Have implementation experience in data visualization (knowledge graph, for example), workflow or business process management
• Have expertise in design and development using PostresSQL
• Have experience with Containerization (Docker, Kubernetes, AWS)
• Experience of Cloud AWS based instances and services (e.g. EC2, S3, ELB, RDS, IAM, Route53, CloudFront, ElastiCache)
• Strong experience in enterprise application development, data structures, modern design patterns and microservices architecture
Responsibilities
- Work closely with the IT team in completing projects
- Troubleshoot and fix any issues relating to PHP programs
- Ensure smooth operations of web processes and infrastructure
- Create scripts to facilitate client systems to meet performance and objectives
- Test and develop software for client applications
- Create documentation for software created
- Utilize source debuggers and write or modify client software
- Produce results effectively and within the deadlines set
Qualifications
- Proven experience as a PHP developer in a competitive environment
- Strong knowledge of PHP coding and web-based applications
- Good understanding of website integration and software creation
- Excellent verbal and written communication skills
- Able to follow clear instructions according to client demands
- Strong analytical and problem-solving skills
- Creative ability to produce effective solutions to client problems
- Good team player that is enthusiastic about delivering results
- Able to work seated in front of a computer screen for long hours at a time