Jesta I.S. — Oracle Database Administrator
Montreal, QC · Jan 2026 – Present
- Author and maintain Oracle database change scripts to a strict internal standard covering idempotency, rollback safety, version-control headers, and trigger handling.
- Manage cross-schema access, grants, and synonyms across the Jesta product suite, supporting both new feature work and ongoing client deployments.
- Build and operate an AI-assisted change-script generator and validator (Anthropic Claude) that drafts compliant scripts from ticket text and scores them against internal DBA conventions; every script is reviewed by a DBA before deployment.
- Reduce manual effort on routine database change tickets by routing them through the generator and validator pipeline.
- Configure Oracle Instant Client integration with Node.js to allow modern applications to connect to legacy database environments.
- Build tooling to track patch and version drift across Oracle environments, generate snapshot records, and validate schema state.
- Serve as backup Configuration Manager — prepare full backend and frontend build artifacts for on-prem deployment or SFTP delivery to clients via the Azure artifact pipeline.