Database Administrator -Senior

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.

This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location".

Responsibilities:

• Creates and implements physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Maintain and monitor a number of Oracle 12c and above databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
• Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
• Ensure existing databases meet performance requirements including but not limited to SIEBEL, ARCGIS, APEX databases on Oracle
• Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
• Provide database administration technical expertise during design and architecture phases of new solutions
• Lead and design solutions for enterprise Oracle migration project to migrate to 19c
• Plan, manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non-production environment
• Provide regular support to resolve complex and unique database management issues
• Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases
• Provide support and maintenance of databases in GoCloud and on premise-based environments
• Carry out complex/specialized systems analysis and design for success of Oracle migration
• Implement and Configure TDE, Dataguard, RAC, OMS, OEM 13c and Oracle Golden Gate
• Provide assistance with replicated database management and migration
• Documentation of your technical work such that knowledge can be transferred to you colleagues
• Identifies, analyses, prioritizes and communicates technical risks for decision makers
• Provides recommendations and mitigation strategies based on a detailed evaluation of technical risks and issues
• Communicates effectively to identify needs and evaluate solutions to complex business and technical issues
• Work with Siebel Application developers collaboratively and deploy SIEBEL solution patches and upgrades.
• Develop, Maintain and Support ETL process to facilitate transfer of data from SIEBEL database to other staging databases for consumption.