17 Sep
|
FetchJobs.co
|
India
17 Sep
FetchJobs.co
India
About The Company
EazyML, (www.EazyML.com) recognized by Gartner, specializes in Responsible AI. Our solutions enable proactive compliance and sustainable automation for enterprises adopting AI at scale. We're also associated with breakthrough startups like Amelia.ai, giving our team exposure to cutting-edge AI products at enterprise scale.
At EazyML, we are committed to delivering innovative AI-driven solutions that prioritize ethical standards and compliance. Our focus on Responsible AI ensures that our clients can deploy intelligent systems confidently, with transparency and accountability at the forefront. We foster a cooperative and forward-thinking environment where technical excellence and ethical considerations go hand in hand.
Our team is dedicated to pushing the boundaries of AI technology, making a meaningful impact across various industries.
About The Role
We are seeking an experienced SQL Developer to join our dynamic team. The successful candidate will be instrumental in designing, optimizing, and maintaining robust database solutions that support our applications and analytics platforms. This role requires a deep understanding of PostgreSQL and a strong foundation in SQL fundamentals applicable across relational databases and modern data warehouses.
The ideal candidate will be responsible for writing efficient, scalable queries, diagnosing performance issues, and collaborating with cross-functional teams to ensure database excellence.
This position offers an opportunity to work on challenging projects that influence critical business decisions and product development. You will play a key role in enhancing our data infrastructure, ensuring high performance, reliability, and scalability of our database systems. The role demands a proactive problem-solver with excellent analytical skills and a passion for optimizing data workflows.
Qualifications
- Minimum of 4+ years of professional experience as a SQL Developer or in a similar role involving database design and optimization.
- Extensive expertise in PostgreSQL, with practical knowledge of SQL as applied to other RDBMSs and data warehouses such as MySQL, SQL Server, Snowflake, Redshift, or BigQuery.
- Deep understanding of query performance factors including indexing strategies, execution plans, query planning, and optimizer behavior.
- Proven ability to analyze, rewrite, and optimize nested queries and subqueries for improved performance.
- Solid grasp of core database concepts such as normalization, indexing techniques (B-tree, composite, partial, covering indexes), locking mechanisms, transactions, and isolation levels.
- Experience using EXPLAIN/EXPLAIN ANALYZE or equivalent tools to diagnose and resolve slow queries.
- Familiarity with database monitoring and query profiling tools to maintain optimal database performance.
Responsibilities
- Design, develop, and optimize complex SQL queries, stored procedures, and functions to support various applications and analytics needs.
- Analyze query performance, identify bottlenecks, and implement improvements to enhance efficiency and scalability.
- Evaluate and recommend appropriate indexing strategies based on query patterns, including usage of WHERE and JOIN clauses.
- Review and refactor nested queries and subqueries, employing alternatives such as CTEs,
joins, or window functions to improve maintainability and performance.
- Collaborate closely with backend engineers and data teams to design efficient database schemas that align with application requirements.
- Monitor production database performance, troubleshoot slow-running queries, and implement solutions to mitigate issues.
- Maintain comprehensive documentation of database design decisions, query optimization techniques, and best practices to ensure knowledge sharing and consistency across the team.
Benefits EazyML offers a competitive compensation package aligned with industry standards, along with comprehensive health benefits, including medical, dental, and vision coverage. Our employees enjoy flexible working arrangements and a collaborative work environment that encourages innovation and continuous learning. We provide opportunities for professional growth through training programs, conferences, and participation in cutting-edge projects. Additionally, our team members benefit from a vibrant company culture that values diversity, inclusion, and work-life balance.
We believe in investing in our employees' well-being and career development, fostering an environment where talent can thrive and make a significant impact in the AI and data science landscape.
Equal Opportunity
EazyML is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on race, ethnicity, gender, age, sexual orientation, disability, or any other protected characteristic. Our hiring practices are designed to ensure fairness and equal opportunity for all qualified candidates, and we strive to foster a workplace where everyone can succeed and grow.
📌 SQL Developer (India)
🏢 FetchJobs.co
📍 India