Job Description & How to Apply Below
RQ11210 - Sr. Database Administrator
9-month contract (170 business days) - possible extension
Remote - Anywhere in Ontario
Must Have:
- 10+ years of hands-on experience as a DBA
- Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
- Experience migrating from end of life Oracle database to latest supported version in on-premise and cloud data centers.
Nice-to-have:
- Public sector experience
Description - 'APEX/ORDS Evergreening' - The goal of the APEX/ORDS evergreening initiative is to upgrade the full technical stack for 5 Ministry of Environment, Conservation and Parks business critical applications. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening .
Cloud hosting is targeted as part of this evergreening.
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.
- Experience in cloud and on-premise environments.
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Maintain and monitor a number of Oracle 10g,11g,12c,19c, 23 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, Java, 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 or higher
- 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
- Provide assistance in the implementing, TDE, Dataguard, RAC, OMS, OEM 13c
- 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
Experience Requirements:
- Minimum 10+ years experience as Database Analysis (other IT roles to be considered as part of years experience)
- Experience with one or more operating systems
- Experience with one or more database technologies
- Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages
- Experience in monitoring and enforcing database rules
- Experience in Incident, Change and Configuration Management procedures
- Experience with one or more communications protocols
- Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal…
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×