RQ09755 - Int. Database Administrator
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
Original job description
RQ09755 - Int. Database Administrator
Toronto (Jarvis St.)
Hybrid: 3 Days onsite / 2 days remote
- From October 20, 2025, the candidate is required to work onsite 4 days a week and 1 day from home
- From January 5, 2026, the candidate is required to work onsite 5 days a week fully
Contract 6+ months, possible extension
Security Level: CRJMC
Creates 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
General Skills:
- Experience in database administration at the specified experience level
- Experience of managing Oracle 12c/19c ETL/Data warehouse Experience with UNIX operating system Experience with Oracle database technologies
- Experience in one or more programming language
- Experience in the use of information retrieval packages and proficiency with query language Experience with one or more communications protocol
- Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skill
- A team player with a track record for meeting deadline
- Experience in monitoring and enforcing database rule
- Experience in Incident, Change and Configuration Management procedures
Must Have:
- 10+ yrs Oracle DBA experience
- Approved experience of Oracle 19c using multi-tenant architecture
- RMAN backup and restore
- Data Encryption using ASO/TDE
- Oracle Dataguard Physical/Logical Configuration & Administration
Desirable SkillS:
- Oracle certification - OCP
- Oracle Partitioning
- Oracle Advanced Compression
- Oracle Golden Gate Experience with distributed data system
- Experience with DB2 database technologies
- Data Conversion from DB2 to Oracle
- Building of Oracle RAC on conventional Solaris server
- Oracle Engineered solution
- Experience of DB web search service
- Oracle DB data integration and evaluation
- Experience with middleware and gateways
- Awareness of emerging IT trends and direction
- Experience with infrastructure services within the Ontario government (e.g. Internal Infrastructure Hosting policies and Provisioning practices)
- Knowledge of the GSIC support organization and ITSM processes adopted in OPS including
More about this job
Responsibilities
The Database Administrator at Source Code will design physical databases and run the database management system, handling optimization, capacity planning, installation, migration, performance tuning, and backup and recovery. The role also monitors and enforces database rules under Incident, Change and Configuration Management procedures.
Requirements
Candidates need 10+ years of Oracle DBA experience, approved Oracle 19c multi-tenant experience, RMAN backup and restore, TDE/ASO data encryption, and Oracle Data Guard administration. Strong UNIX, query language, analytical and communication skills are also needed.
Skills
- Oracle Database 19c
- Oracle 12c
- RMAN backup and restore
- Oracle Data Guard (physical and logical)
- TDE and ASO data encryption
- Oracle ETL
- Data warehousing
- UNIX
- Solaris
- SQL query language
- Performance tuning
- Capacity planning
- Database migration
- Database installation
- Database design
- Backup and recovery
- Oracle Partitioning
- Oracle Advanced Compression
- Oracle GoldenGate
- Oracle RAC
- DB2
- Data conversion from DB2 to Oracle
- Oracle Engineered Systems
- Middleware and gateways
Categories
- Technology
- Data & Analytics
- Software
- Government & Public Sector
Keywords
- Oracle DBA
- Oracle 19c
- Oracle 12c
- multi-tenant architecture
- RMAN
- Data Guard
- TDE
- ASO
- data encryption
- ETL
- data warehouse
- UNIX
- Solaris
- database administration
- DBMS
- performance tuning
- backup and recovery
- capacity planning
- database migration
- Oracle RAC
Seniority
Senior
Licences and certifications
- OCP
Tools
- Oracle Database 19c
- Oracle 12c
- RMAN
- Oracle Data Guard
- UNIX
- Solaris
- DB2
Languages
- English