Job description
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 include:
- Premium Healthcare
- Meal voucher
- Maternity and Parental leaves
- Mobile services subsidy
- Sick pay-Life insurance
- CI&T University
- Colombian Holidays
- Paid Vacations
And many others.
Collaboration is our superpower, diversity unites us, and excellence is our standard.
We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment.
We encourage applications from diverse and underrepresented groups to our job positions.
Required Skill Profession
Other General