Application DBA
CAE — Halifax
Posted 2026-10-21
⠀ Duties & Responsibilities Administer and support Oracle and Microsoft SQL Server databases used by commercial off-the-shelf and custom applications on Windows-based infrastructure. Monitor database health, capacity, availability, and performance; investigate abnormal conditions and take preventive or corrective action before service is affected. Plan and execute database patching, upgrades, migrations, and technical refresh activities in coordination with application, infrastructure, testing, and operations teams. Install and configure database software, listeners, instances, and related components, including support for Oracle multitenant container and pluggable database environments as they are introduced. Perform and validate backup, restore, recovery, data migration, and environment refresh activities, with particular attention to operational continuity and data integrity. Diagnose complex database and application-data issues using SQL, logs, traces, and vendor guidance. Document findings, decisions, and repeatable resolution procedures. Support application queries, stored procedures, integrations, reporting workloads, and data movement, including performance tuning and troub