Brazil onlyWe 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!
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: https://ciandt.com/br/pt-br/carreiras
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.
