[Job - 28692] Engenheiro de Dados Pleno (DB2)

1 day, 6 hours ago
Full-time
Senior
Data Science and Analytics
CI&T

CI&T

CI&T is a global digital technology agency empowering agile growth for leading companies through advanced technologies with a team of 2000 experts worldwide.

Internet Software & Services
5K-10K
Founded 1995

Description

  • Develop and maintain complex database logic, including scripts, stored procedures, functions, and triggers using SQL and SQL Procedural Language.
  • Optimize database performance by analyzing access paths and join methods with tools such as db2exfmt and Visual Explain.
  • Execute and automate maintenance routines such as RUNSTATS and REORG to keep statistics current and storage efficient.
  • Design, create, and modify tables, indexes, views, and tablespaces, including physical and logical data modeling considerations.
  • Diagnose production performance issues such as locks, deadlocks, and timeouts, and propose structural or code-level improvements.
  • Monitor and troubleshoot DB2 behavior using administrative and diagnostic utilities.
  • Optimize data flows integrated with ETL/ELT pipelines handling large volumes of information.
  • Manage bulk data movement processes using EXPORT, IMPORT, LOAD, and INGEST utilities.

Requirements

  • Experience with DB2 LUW specifically.
  • Advanced SQL knowledge with procedural development inside the database.
  • Hands-on experience with ERwin Data Modeler.
  • Experience with index creation and management, table partitioning, and data compression.
  • Familiarity with DB2 monitoring and diagnostic tools such as db2pd, db2top, and db2advis.
  • Understanding of how databases integrate with ETL/ELT pipelines and large-scale data flows.
  • Experience with bulk data movement utilities such as EXPORT, IMPORT, LOAD, and INGEST.
  • IBM DB2 Administrator or Database Specialist certification is a plus.
  • Knowledge of data integration tools such as InfoSphere DataStage or IBM MQ is a plus.
  • Experience with Bash shell scripting for server task automation is a plus.
  • Basic knowledge of infrastructure components such as storage, CPU, and RAM that affect DB2 behavior is a plus.

Benefits

  • Health and dental insurance.
  • Food and meal allowance.
  • Childcare assistance.
  • Extended parental leave.
  • Wellhub (Gympass) and TotalPass partnerships for fitness and wellness.
  • Profit sharing (PLR).
  • Life insurance.
  • Continuous learning platform (CI&T University) and access to online learning resources.
  • Discount club and free online platform for physical, mental, and wellness support.
  • Courses on pregnancy and responsible parenting.
  • Language learning platform.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Principal Software Engineer - Postgres

ClickHouse 51-250 IT Services

ClickHouse is hiring a Principal Engineer to help build next-generation Postgres-based database infrastructure that improves performance, scalability, reliability, and developer experience for large-scale cloud data workloads.

Go Microservices PostgreSQL Rust
5 hours, 11 minutes ago

Database/Application Administrator

Blueprint Technologies 251-1K Internet Software & Services

Blueprint is hiring a Database/Application Administrator to support enterprise databases and analytics applications across cloud and hybrid environments, with the goal of maintaining high availability, performance, scalability, and operational reliability.

AWS Linux Oracle PostgreSQL SQL Server
5 hours, 11 minutes ago

Database Administrator - Cloud Platform / Infrastructure

3Cloud 251-1K Internet Software & Services

3Cloud is seeking an experienced Database Administrator to support multiple customer database migration and Azure data services projects across development, test, and production environments.

Azure Oracle SQL Server Terraform
8 hours, 24 minutes ago

Manager, Veeva Vault Administration (Contract)

Alimentiv 251-1K Professional Services

Alimentiv is hiring a Manager, Veeva Vault Administration to oversee the administration, compliance, and operational delivery of its Veeva Vault Clinical platform in support of clinical operations.

15 hours, 20 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers