[Job-24505] Senior PostgreSQL Database Developer (PL/pgSQL / PL/v8 Focus), Brazil

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/v8Implement and manage PgCron jobs and other scheduled operations within the databaseDesign and evolve PostgreSQL schemas following established patterns and performance best practicesBuild database-side logic to support session management, auditing, changelog generation, and security policiesCollaborate with engineering teams to write automated tests for database logicAssist in maintaining schema version control with tools such as Liquibase or SqitchContribute to documentation and ramp-up guides to support consistent design practices
🧠 Must-Have Qualifications:3–5+ years hands-on experience developing directly in PostgreSQLProficiency in PL/pgSQL, and experience with PL/v8 or willingness to learn quicklyStrong understanding of triggers, trigger functions, views, policies, and session-level logicExperience writing tests for database logicFamiliarity with PgCron or similar PostgreSQL-native job schedulersHands-on experience with schema migrations and tools like Liquibase or SqitchComfort working with complex, custom database architecturesFluent English skills (multicultural team and American client)
➕ Nice-to-Have:Experience with PostGIS or other geospatial extensionsKnowledge of Python scripting for auxiliary tooling or automationExposure to Azure database hosting environments
🎯 Soft Skills:Ability to ramp up quickly on unique architecturesComfortable starting with targeted tasks (e.g., writing tests, building tables) while learning broader system patternsProactive 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 platformAnd 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.