Client / Sector: Insurance company

Challenge: Need to consolidate a database-oriented DevOps strategy,
involving several teams working in a decoupled manner, resulting in
frequent errors in deliveries and a lack of visibility into changes.

Solution:

• In-house implementation of Release Management for Oracle databases.
• Database as Code approach.
• Integration of multiple development teams into a single workflow.
• Execution of automatic pre-checks before the first deployment.

Results / Benefits:

• Significant reduction in production errors.
• Standardization of the deployment process.
• Complete traceability of changes.
• Greater collaboration between teams.

Technologies used: Oracle Database, Git, SQLcl, Jenkins, Flyway, Shell scripts.