CI&T

Senior Oracle Developer

CI&T

full-time

Posted on:

Location Type: Remote

Location: Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

MySQLOracleSQL

About the role

  • Modify Procedures and Functions: Modify existing stored procedures and functions to implement the necessary logic to convert the CNPJ to the new alphanumeric format.
  • Update Tables and Data Structures: Adjust table definitions, including changing data types, adding new columns, and updating constraints to support the CNPJ's new format.
  • Manage Other Database Objects: Work on objects such as indexes, triggers, and views to ensure all CNPJ dependencies are correctly adapted and functionally integrated into the system.
  • Use Artificial Intelligence: Apply AI techniques to identify points of change and optimize the data migration process.
  • Work Independently: Understand business flows and stakeholder needs, ensuring proposed solutions meet all requirements.
  • Create and Execute Unit Tests: Validate the quality and functionality of the changes made, ensuring the system continues to operate correctly after modifications.
  • Perform Impact Analysis: Assess how changes will affect other parts of the system and produce necessary documentation to mitigate risks.
  • Collaborate with Cross-functional Teams: Work with developers, business analysts, and other stakeholders to understand requirements and translate them into effective technical solutions.
  • Document Processes and Procedures: Maintain clear and up-to-date records of changes made, including database scripts and associated business logic.

Requirements

  • Strong experience in PL/SQL development and deploying changes to Oracle databases.
  • Knowledge of data design and modeling, including creating and modifying tables, indexes, and procedures.
  • Familiarity with migration and data transformation techniques.
  • Knowledge of agile methodologies (Scrum, Kanban) and the ability to work in a collaborative environment.
  • Ability to solve complex problems and think critically about software solutions.
  • Some experience with MySQL.
Benefits
  • Health and dental insurance;
  • Meal and food allowance;
  • Childcare assistance;
  • Extended parental leave;
  • Partnerships with gyms and health & wellness professionals via Wellhub (Gympass) TotalPass;
  • Profit Sharing (PLR);
  • Life insurance;
  • Continuous learning platform (CI&T University);
  • Discount club;
  • Free online platform dedicated to promoting physical and mental health and well-being;
  • Pregnancy and responsible parenting course;
  • Partnerships with online course platforms;
  • Language learning platform;
  • And many others

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PL/SQLOracle databasesdata designdata modelingmigration techniquesdata transformationMySQLunit testingimpact analysisdatabase scripting
Soft skills
problem solvingcritical thinkingcollaborationindependencestakeholder management