Logo of Huzzle

PosgreSQL

image

Cognizant

17d ago

  • Job
    Full-time
    Senior & Expert Level
  • Data
    IT & Cybersecurity
  • Bangalore

AI generated summary

  • You need 6-9 years of PostgreSQL experience, strong SQL skills, performance tuning, data migration, and familiarity with IDEs and GitHub. REST API knowledge is a plus.
  • You will develop and optimize PostgreSQL database solutions, enhance SQL queries, migrate data, and perform performance tuning while collaborating on business report requirements and using version control.

Requirements

  • Min years of experience: 6 to 9
  • Development of high quality database solutions, using PostgreSQL
  • Develop, implement and optimize stored procedures and functions using SQL & PL/pgSQL
  • Review and interpret ongoing business report requirements
  • Research required data
  • Analyze existing SQL queries for performance improvements
  • Develop procedures and scripts for data migration
  • Proven expertise in performance tuning such as indexes, partitions, clustering
  • Ability to write a complex SQL, given a requirement
  • Familiar with cross-database IDEs – Dbeaver, DBVisualizer, TOAD etc
  • Familiar with code version control in GitHub
  • Understanding of REST APIs will be an added advantage

Responsibilities

  • Development of high quality database solutions, using PostgreSQL
  • Develop, implement and optimize stored procedures and functions using SQL & PL/pgSQL
  • Review and interpret ongoing business report requirements
  • Research required data
  • Analyze existing SQL queries for performance improvements
  • Develop procedures and scripts for data migration
  • Proven expertise in performance tuning such as indexes, partitions, clustering
  • Ability to write a complex SQL, given a requirement
  • Familiar with cross-database IDEs – Dbeaver, DBVisualizer, TOAD etc
  • Familiar with code version control in GitHub
  • Understanding of REST APIs will be an added advantage

FAQs

What is the minimum years of experience required for this PostgreSQL developer position?

The minimum years of experience required is 6 to 9 years.

What are the primary responsibilities of a PostgreSQL developer in this role?

The primary responsibilities include developing high-quality database solutions using PostgreSQL, optimizing stored procedures and functions, analyzing existing SQL queries for performance improvements, and ensuring database stability and performance.

What type of queries and procedures will the developer need to work with?

The developer will need to develop, implement, and optimize SQL queries, stored procedures, and functions using SQL & PL/pgSQL.

Is experience with performance tuning important for this position?

Yes, proven expertise in performance tuning, including indexes, partitions, and clustering, is essential for this role.

What tools should the PostgreSQL developer be familiar with?

The developer should be familiar with cross-database IDEs such as DBeaver, DBVisualizer, and TOAD, as well as version control tools like GitHub.

Will having knowledge of REST APIs be beneficial for this role?

Yes, understanding of REST APIs will be considered an added advantage for candidates applying for this position.

What is the expectation regarding data migration in this role?

The developer is expected to develop procedures and scripts for data migration as part of their responsibilities.

Are there opportunities for professional development in this role?

Yes, contributing to the development and maintenance of software solutions provides opportunities for learning and professional growth.

Can you describe the team environment for this position?

The team environment is collaborative, focusing on high performance, responsiveness, and continuous improvement of database solutions.

What is the process for submitting an application for this position?

Interested candidates can submit their applications through the specified channels mentioned in the job listing.

Consulting
Industry
10,001+
Employees

Mission & Purpose

Cognizant is a multinational technology company that provides a wide range of IT services and solutions to organisations worldwide. Their primary focus is on helping businesses transform and thrive in the digital age. Cognizant's mission and purpose are centred around delivering innovative and cutting-edge technology solutions that drive client success. They offer services such as digital strategy, consulting, technology implementation, and IT outsourcing, enabling companies to adapt to evolving market dynamics, enhance operational efficiency, and deliver exceptional customer experiences. Cognizant's ultimate goal is to empower their clients with the tools, insights, and capabilities needed to navigate complex technological landscapes and achieve their business objectives in an increasingly digital world.