Clovertex
Location
Hyderabad | India
Job description
Clovertex is a global information technology firm helping customers modernize their existing business systems by leveraging the best of the breed modern technologies, thus allowing them to maintain their leadership in their respective areas.
Born in the cloud and in times when speed and agility are key for our customers to innovate to meet the demand of constantly changing environment, Clovertex specializes in building repeatable solutions (products) that are easy to maintain and loosely coupled using today’s technologies along with automation. Job Description: We are seeking a skilled and motivated SQL/postgres DB developer with minimum 6 years of hands on /relevant experience to join our team and lead the conversion of our existing SQL database to a modern PostgreSQL database. You will be responsible for analyzing the existing SQL database schema, procedures, functions, and data types, and then rewriting them for optimal performance and functionality in PostgreSQL. This role requires strong expertise in both SQL and PostgreSQL, as well as a passion for database optimization and migration. Responsibilities: Analyze the existing SQL database schema, procedures, functions, and data types. Design and implement a comprehensive conversion plan to migrate the database to PostgreSQL. Develop efficient and equivalent SQL queries and PL/pgSQL functions in PostgreSQL. Adapt existing data types to their closest PostgreSQL equivalents, considering performance and storage implications. Optimize queries and procedures for efficient execution in PostgreSQL. Test and validate the converted database functionality thoroughly. Write clear and concise documentation for the conversion process and migrated code. Collaborate with database administrators and application developers to ensure a smooth transition. Stay up-to-date with the latest advancements in PostgreSQL and database migration best practices. Skills & qualification: 3+ years of experience in SQL development and query optimization. 2+ years of experience with PostgreSQL administration and development. Experience with database migration tools and methodologies is a plus. Strong understanding of database design principles and normalization techniques. Excellent understanding of relational algebra and query optimization techniques. Proficient in scripting languages like Python or Bash. Experience with version control systems like Git is a plus. Excellent communication, problem-solving, and analytical skills. Ability to work independently and as part of a team. Qualifications: Bachelor’s or master’s degree in computer science, Engineering . Strong problem-solving skills and attention to detail. Excellent communication and collaboration skills. Certifications (Desirable) 1. AWS Solution Architect Associate or Up 2. SQLServer, Postgres related certifications 3. AWS Certified Database - Specialty Certification If you are passionate about cloud technologies, have a solid software development background, and thrive in a collaborative environment, we encourage you to apply. Join us in building and maintaining cutting-edge cloud solutions that drive the success of our organization. Working Hours : One of the two shifts* 6.30 PM IST – 3.30 AM IST ( will Chage to 5.30 PM IST – 2.30 AM IST with day light savings in US) 9.30 PM IST – 6.30 AM IST ( will Chage to 8.30 PM IST – 5.30 AM IST with day light savings in US) Working hours are subjected to change as per work requirements. Clovertex is an equal opportunity employer and values diversity in the workplace. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We are committed to creating a positive and inclusive work environment for all employees.Job tags
Salary