Sr Oracle DBA for a public sector end client.

Our consulting client is seeking a Sr Oracle DBA for a public sector end client.

Initial contract goes till mid-Apr 2026. 40 hours/week (PST 9:00 am - 5:00 pm (+ afterhours per preset schedule)). Candidates must be residing in the Lower Mainland / BC area - might need to come to the office once a month to once a week to Burnaby, BC.

Must Have:

• 5+ years Oracle DBA skills on UNIX/Linux platform
• 5+ years Oracle and MS SQL Developer skills
• Expertise with building High-Availability (HA) solutions

Responsibilities:

• Create Database architecture - Oracle and SQL Server Design and Build databases from business requirements
• Develop innovation, strategies, processes, and best practices Work with development team on database design to meet business requirements
• Write and troubleshoot complex stored procedures Develop Oracle/SQL Server Replication solution
• Develop Oracle/SQL Server DR solution Develop Oracle/SQL Server Backup and Recovery solution Oracle/SQL Server
• Database configuration management (Memory, CPU, storage)
• Oracle/SQL Server Performance Tuning
• Oracle/SQL Server Perforce Testing with Applications
• Create Oracle/SQL Server Maintenance plans
• Create and maintain Oracle/SQL Server Build documentation
• Create and maintain Oracle/SQL Server maintenance and sustainment documentation
• Create escalation process and documentation Manage Oracle/SQL Server operations for all Client-Based Application in all environments
• Create and maintain Oracle/SQL Server reporting - Daily, Health, and Exception requirements (project)Installing, configuration and upgrading of database servers
• Planning storage requirements for the database system
• Modifying the database structure, as necessary, from information given by application developers
• Reviewing PL/SQL and T-SQL code done by developers and proposes improvements Reviewing system and programming designs to ensure efficient use of database resources
• Controlling and monitoring user access to the database Monitoring and optimizing the performance of the database
• Backing up and restoring databases
• Contacting database vendor for technical support
• Developing and testing database backup procedures Identifying improvements to existing databases by determining users' information requirements and system performance and functional requirements
• Performing daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups Writing complex scripts for data manipulation and management as well as report generation
• Following all established procedures Writing technical documentation and deliverables
• Understanding of business processes supported by these systems