24 Oct
|
CAE
|
Halifax Regional Municipality
24 Oct
CAE
Halifax Regional Municipality
## Application DBAApply: Halifax: Full time: Posted Today: ⠀ ## 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 troubleshooting across Oracle and SQL Server components.
* Prepare implementation plans, change records, rollback approaches, outage estimates, and post-change evidence for controlled releases and maintenance windows.
* Provide database support during planned releases and, when required, outside normal
working hours
. Participate in the program's on-call support arrangements.
* Coordinate with vendors and technical support organizations by providing diagnostic information and assessing recommendations for applicability within a controlled defence setting.
* Maintain accurate architecture, build, configuration, credential-location, lifecycle, and support documentation in approved repositories.
* Collaborate with team members to provide coverage, peer review, cross-training, and a consistent operating approach across database platforms and environments.
* Contribute database expertise to security, service-
📌 Application DBA (Halifax Regional Municipality)
🏢 CAE
📍 Halifax Regional Municipality