750 Empregos para Postgresql - Brasil

Local: São Paulo, SP

Áreas de Atuação Profissional: TI - Banco de Dados

Descrição: experiência prática em:
• modelagem de dados,
• análise e tuning de performance (query plans, índices, etc.),
• queries complexas,
• administração em ambiente gerenciado (backup, monitoramento, permissões, VNet, etc).

Habilidades: DBA Sênior – PostgreSQL / Azure DatabaseforPostgreSQL.
• modelagem de dados,
• análise e tuning de performance (query plans, índices, etc.),
• queries complexas,
• administração em ambiente gerenciado (backup, monitoramento, permissões, VNet, etc).

Para se candidatar a essa vaga, selecione como voce ficou sabendo da vaga e clique no botão "Enviar o seu currículo" abaixo.

Como você ficou sabendo sobre essa vaga?

Get AI-powered advice on this job and more exclusive features.

We are looking for a Data Engineer who will be responsible for designing a solution for a big retail company. The main focus is to support processing of big data volumes and integrate the solution into the current architecture.

• We are looking for a Data Engineer who will be responsible for designing a solution for a big retail company. The main focus is to support processing of big data volumes and integrate solution to current architecture.

• Strong, recent hands-on expertise with Azure Data Factory and Synapse (3+ years).
• Experience in leading a distributed team.
• Strong expertise in designing and implementing data models, including conceptual, logical, and physical data models, to support efficient data storage and retrieval.
• Strong knowledge of Microsoft Azure, including Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, and Azure Databricks, pySpark for building scalable and reliable data solutions.
• Extensive experience with building robust and scalable ETL/ELT pipelines to extract, transform, and load data from various sources into data lakes or data warehouses.
• Ability to integrate data from disparate sources, including databases, APIs, and external data providers, using appropriate techniques such as API integration or message queuing.
• Proficiency in designing and implementing data warehousing solutions (dimensional modeling, star schemas, Data Mesh, Data/Delta Lakehouse, Data Vault).
• Proficiency in SQL to perform complex queries, data transformations, and performance tuning on cloud-based data storages.
• Experience integrating metadata and governance processes into cloud-based data platforms.
• Certification in Azure, Databricks, or other relevant technologies is an added advantage.
• Experience with cloud-based analytical databases.
• Experience with Azure MI, Azure Database for Postgres, Azure Cosmos DB, Azure Analysis Services, and Informix.
• Experience with Python and Python-based ETL tools.
• Experience with shell scripting in Bash, Unix or Windows shell is preferable.

• Mid-Senior level

• Full-time

• IT Services and IT Consulting

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Overview

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.

Job Overview

We are seeking a Senior Data Developer with experience in database management, specifically with PostgreSQL and related technologies. The ideal candidate will have the skills to handle various database tasks while adhering to our design guidelines and collaborating effectively with our team. The client is American and the CI&T team is multicultural, so fluency in English is essential.

Required Experience:

• PostgreSQL and PostGIS
• PL/pgSQL and PL/v8
• Database DevOps
• PgCron
• Triggers and trigger functions
• Experience with testing frameworks

Additional Skills (Preferred):

• Skills in audit logging, change log implementation, diffing functions, and security
• Familiarity with database management tools such as Liquibase or Sqitch
• Knowledge of Python and Azure
• Geospatial expertise

• Build tables and verify data structures.
• Write tests to ensure data integrity and functionality.
• Follow established design guidelines for implementing new features or testing existing ones.
• Work with complex triggers, functions, policies, and session management within our architecture.

If you like it, just apply and good luck!

#LI-JM2

• Health and dental insurance
• Meal and food allowance
• 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

Inclusion and Accessibility

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.

Buscamos um profissional DBA que será responsável por gerenciar, manter e otimizar os ambientes de bancos de dados DB2 e PostgreSQL da empresa, garantindo a alta disponibilidade, performance e segurança dos sistemas. Atuando na resolução de problemas complexos, implementação de melhores práticas e no suporte a projetos estratégicos.

Se você se identifica com esses conceitos e deseja construir algo especial, mergulhe de cabeça nesta oportunidade.

Responsabilidades e Atividades Principais:

• Administrar, monitorar e otimizar bancos de dados DB2 for z/OS e PostgreSQL, garantindo a integridade e a performance.
• Desenvolver e implementar estratégias de backup, recuperação e disaster recovery.
• Realizar o tuning de consultas SQL, índices e configurações do banco de dados para garantir a eficiência operacional.
• Planejar e executar a migração e atualização de versões de banco de dados.
• Garantir a segurança dos dados por meio de políticas de acesso, criptografia e auditoria.
• Automatizar tarefas administrativas e criar scripts para manutenção proativa.
• Colaborar com as equipes de desenvolvimento e infraestrutura para solucionar incidentes e planejar novas arquiteturas.

Requisitos mínimos

Habilidades e Requisitos Mandatórios:

• Experiência comprovada como DBA Sênior com atuação sólida em ambientes DB2 for z/OS e/ou PostgreSQL.
• Domínio em SQL, tuning de queries e análise de planos de execução.
• Experiência com alta disponibilidade (HADR, Replicação, Clustering).
• Familiaridade com ambientes Linux/Unix e scripting (Shell Script, Python).
• Sólidos conhecimentos em estratégias de backup, restore e recovery.
• Capacidade de solucionar problemas complexos e de atuar proativamente na identificação de gargalos.

Pré-requisitos e Diferenciais

• Certificação em banco de dados (ex: IBM Certified Database Administrator) e/ou certificação em nuvem (ex: AWS, Azure, GCP).
• Experiência com bancos de dados em nuvem (DBaaS) e práticas de DevOps para banco de dados.
• Conhecimento em outras bases de dados (Oracle, SQL Server).
• Inglês avançado.

Se identificou com essa oportunidade? Então inscreva-se e #VemPraSauter

Contrato: Período Integral

Educação mínima: Superior

Nível profissional: Técnico/Especialista

Full time Contract position with competitive pay

We’re seeking a Data Architect to own the design and evolution of our relational data systems. You’ll define schemas, build models, and enforce standards that keep our data reliable, secure, and highly performant—both online and offline. This role is about depth over breadth: expert-level relational database design and optimization, with PostgreSQL at the core.

• Schema Design & Modeling: Build logical and physical data models that scale with complex, multi-tenant applications.
• Database Optimization: Tune queries, indexes, and partitioning strategies for maximum performance and reliability.
• Integration & Sync: Support ETL / ELT processes and ensure robust data synchronization across distributed environments.
• Governance & Security: Establish standards for data quality, retention, lineage, and compliance (SOC2, GDPR, etc.).
• Collaboration: Partner with developers and product teams to make sure the database architecture supports real-world use cases.
• Documentation & Standards: Define naming conventions, coding standards, and best practices to ensure long-term maintainability.

• Deep expertise in relational database design (PostgreSQL strongly preferred).
• Strong command of SQL, query optimization, and performance tuning.
• Experience with schema normalization / denormalization and partitioning strategies.
• Familiarity with backup, recovery, high availability, and disaster recovery planning.
• Solid understanding of security practices : encryption, access controls, and auditing.
• Background in designing for multi-tenant or large-scale transactional systems.

• Experience with replication, logical decoding, or offline-first synchronization patterns.
• Knowledge of PostgreSQL internals and extension ecosystem (e.g., PostGIS, pg_partman).
• Comfort working in cloud-native environments with CI / CD and containerized deployments.
• Familiarity with data warehousing concepts for reporting / analytics.

• Competitive salary and benefits.
• Full ownership of the database architecture in a mission-critical environment.
• Work with a team focused on building systems that are both rugged and future-proof.

Full time Contract position with competitive pay

We’re seeking a Data Architect to own the design and evolution of our relational data systems. You’ll define schemas, build models, and enforce standards that keep our data reliable, secure, and highly performant—both online and offline. This role is about depth over breadth : expert-level relational database design and optimization, with PostgreSQL at the core.

• Schema Design & Modeling: Build logical and physical data models that scale with complex, multi-tenant applications.
• Database Optimization: Tune queries, indexes, and partitioning strategies for maximum performance and reliability.
• Integration & Sync: Support ETL / ELT processes and ensure robust data synchronization across distributed environments.
• Governance & Security: Establish standards for data quality, retention, lineage, and compliance (SOC2, GDPR, etc.).
• Collaboration: Partner with developers and product teams to make sure the database architecture supports real-world use cases.
• Documentation & Standards: Define naming conventions, coding standards, and best practices to ensure long-term maintainability.

• Deep expertise in relational database design (PostgreSQL strongly preferred).
• Strong command of SQL, query optimization, and performance tuning.
• Experience with schema normalization / denormalization and partitioning strategies.
• Familiarity with backup, recovery, high availability, and disaster recovery planning.
• Solid understanding of security practices : encryption, access controls, and auditing.
• Background in designing for multi-tenant or large-scale transactional systems.

• Experience with replication, logical decoding, or offline-first synchronization patterns.
• Knowledge of PostgreSQL internals and extension ecosystem (e.g., PostGIS, pg_partman).
• Comfort working in cloud-native environments with CI / CD and containerized deployments.
• Familiarity with data warehousing concepts for reporting / analytics.

• Competitive salary and benefits.
• Full ownership of the database architecture in a mission-critical environment.
• Work with a team focused on building systems that are both rugged and future-proof.

Full time Contract position with competitive pay.

We’re seeking a Data Architect to own the design and evolution of our relational data systems. You’ll define schemas, build models, and enforce standards that keep our data reliable, secure, and highly performant—both online and offline. This role is about depth over breadth: expert-level relational database design and optimization, with PostgreSQL at the core.

• Schema Design & Modeling: Build logical and physical data models that scale with complex, multi-tenant applications.
• Database Optimization: Tune queries, indexes, and partitioning strategies for maximum performance and reliability.
• Integration & Sync: Support ETL / ELT processes and ensure robust data synchronization across distributed environments.
• Governance & Security: Establish standards for data quality, retention, lineage, and compliance (SOC2, GDPR, etc.).
• Collaboration: Partner with developers and product teams to make sure the database architecture supports real-world use cases.
• Documentation & Standards: Define naming conventions, coding standards, and best practices to ensure long-term maintainability.

• Deep expertise in relational database design (PostgreSQL strongly preferred).
• Strong command of SQL, query optimization, and performance tuning.
• Experience with schema normalization / denormalization and partitioning strategies.
• Familiarity with backup, recovery, high availability, and disaster recovery planning.
• Solid understanding of security practices: encryption, access controls, and auditing.
• Background in designing for multi-tenant or large-scale transactional systems.

• Experience with replication, logical decoding, or offline-first synchronization patterns.
• Knowledge of PostgreSQL internals and extension ecosystem (e.g., PostGIS, pg_partman).
• Comfort working in cloud-native environments with CI / CD and containerized deployments.
• Familiarity with data warehousing concepts for reporting / analytics.

• Competitive salary and benefits.
• Full ownership of the database architecture in a mission-critical environment.
• Work with a team focused on building systems that are both rugged and future-proof.

Full time Contract position with competitive pay

We’re seeking a Data Architect to own the design and evolution of our relational data systems. You’ll define schemas, build models, and enforce standards that keep our data reliable, secure, and highly performant—both online and offline. This role is about depth over breadth : expert-level relational database design and optimization, with PostgreSQL at the core.

• Schema Design & Modeling : Build logical and physical data models that scale with complex, multi-tenant applications.
• Database Optimization : Tune queries, indexes, and partitioning strategies for maximum performance and reliability.
• Integration & Sync : Support ETL / ELT processes and ensure robust data synchronization across distributed environments.
• Governance & Security : Establish standards for data quality, retention, lineage, and compliance (SOC2, GDPR, etc.).
• Collaboration : Partner with developers and product teams to make sure the database architecture supports real-world use cases.
• Documentation & Standards : Define naming conventions, coding standards, and best practices to ensure long-term maintainability.

• Deep expertise in relational database design (PostgreSQL strongly preferred).
• Strong command of SQL, query optimization, and performance tuning.
• Experience with schema normalization / denormalization and partitioning strategies.
• Familiarity with backup, recovery, high availability, and disaster recovery planning.
• Solid understanding of security practices : encryption, access controls, and auditing.
• Background in designing for multi-tenant or large-scale transactional systems.

• Experience with replication, logical decoding, or offline-first synchronization patterns.
• Knowledge of PostgreSQL internals and extension ecosystem (e.g., PostGIS, pg_partman).
• Comfort working in cloud-native environments with CI / CD and containerized deployments.
• Familiarity with data warehousing concepts for reporting / analytics.

• Competitive salary and benefits.
• Full ownership of the database architecture in a mission-critical environment.
• Work with a team focused on building systems that are both rugged and future-proof.

Overview

Full time Contract position with competitive pay

We’re seeking a Data Architect to own the design and evolution of our relational data systems. You’ll define schemas, build models, and enforce standards that keep our data reliable, secure, and highly performant—both online and offline. This role is about depth over breadth : expert-level relational database design and optimization, with PostgreSQL at the core.

• Schema Design & Modeling: Build logical and physical data models that scale with complex, multi-tenant applications.
• Database Optimization: Tune queries, indexes, and partitioning strategies for maximum performance and reliability.
• Integration & Sync: Support ETL / ELT processes and ensure robust data synchronization across distributed environments.
• Governance & Security: Establish standards for data quality, retention, lineage, and compliance (SOC2, GDPR, etc.).
• Collaboration: Partner with developers and product teams to make sure the database architecture supports real-world use cases.
• Documentation & Standards: Define naming conventions, coding standards, and best practices to ensure long-term maintainability.

• Deep expertise in relational database design (PostgreSQL strongly preferred).
• Strong command of SQL, query optimization, and performance tuning.
• Experience with schema normalization / denormalization and partitioning strategies.
• Familiarity with backup, recovery, high availability, and disaster recovery planning.
• Solid understanding of security practices: encryption, access controls, and auditing.
• Background in designing for multi-tenant or large-scale transactional systems.

• Experience with replication, logical decoding, or offline-first synchronization patterns.
• Knowledge of PostgreSQL internals and extension ecosystem (e.g., PostGIS, pg_partman).
• Comfort working in cloud-native environments with CI / CD and containerized deployments.
• Familiarity with data warehousing concepts for reporting / analytics.

• Competitive salary and benefits.
• Full ownership of the database architecture in a mission-critical environment.
• Work with a team focused on building systems that are both rugged and future-proof.