Senior PostgreSQL Database Developer

We are tech transformation specialists, uniting human expertise with AI to create scalable tech solutions.

With over 7.400 CI&Ters around the world, we've built partnerships with more than 1,000 clients during our 30 years of history. Artificial Intelligence is our reality.

Overview:

We are seeking a highly skilled PostgreSQL Database Developer with direct experience developing within the PostgreSQL database environment. This is not a traditional backend role—our client is building logic directly inside the database, so we need someone who is comfortable treating PostgreSQL as a development platform, not just a data store.

The ideal candidate will have deep experience with PL/pgSQL, PL/v8, database-side logic such as triggers, functions, cron jobs, and data policies, and will have worked on schema evolution using tools like Liquibase or Sqitch. Familiarity with PostGIS is a plus but not required.

Key Responsibilities:

Develop and maintain complex stored procedures, triggers, and functions using PL/pgSQL and PL/v8

Implement and manage PgCron jobs and other scheduled operations within the database

Design and evolve PostgreSQL schemas following established patterns and performance best practices

Build database-side logic to support session management, auditing, changelog generation, and security policies

Collaborate with engineering teams to write automated tests for database logic

Assist in maintaining schema version control with tools such as Liquibase or Sqitch

Contribute to documentation and ramp-up guides to support consistent design practices

Must-Have Qualifications:

3–5 years hands-on experience developing directly in PostgreSQL

Proficiency in PL/pgSQL, and experience with PL/v8 or willingness to learn quickly

Strong understanding of triggers, trigger functions, views, policies, and session-level logic

Experience writing tests for database logic

Familiarity with PgCron or similar PostgreSQL-native job schedulers

Hands-on experience with schema migrations and tools like Liquibase or Sqitch

Comfort working with complex, custom database architectures

Fluent English skills (multicultural team and American client)

Nice-to-Have:

Experience with PostGIS or other geospatial extensions

Knowledge of Python scripting for auxiliary tooling or automation

Exposure to Azure database hosting environments

Soft Skills:

Ability to ramp up quickly on unique architectures

Comfortable starting with targeted tasks (e.g., writing tests, building tables) while learning broader system patterns

Proactive communicator who can collaborate with distributed teams

If you like it, just apply and good luck

#LI-JM2

Our benefits:

-Health and dental insurance

-Meal and food allowance

-Childcare assistance

-Extended paternity leave

-Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass;

-Profit Sharing and Results Participation (PLR);

-Life insurance

-Continuous learning platform (CI&T University);

-Discount club

-Free online platform dedicated to physical, mental, and overall well-being

-Pregnancy and responsible parenting course

-Partnerships with online learning platforms

-Language learning platform

And many more

More details about our benefits here:

At CI&T, inclusion starts at the first contact. If you are a person with a disability, it is important to present your assessment during the selection process. This way, we can ensure the support and accommodations that you deserve. If you do not yet have the assessment, don't worry: we can support you in obtaining it.

We have a dedicated Health and Well-being team, inclusion specialists, and affinity groups who will be with you at every stage. Count on us to make this journey side by side.