The Government Services Integration Cluster (GSIC) is responsible for IT project management delivery and implementation of technologies in support of Service Ontario partner ministry projects and other cluster clients. The Shared Utility Service (SUS) environment provides a scaleable and secure IT infrastructure to meet J2EE hosting needs of I&IT clusters and by extension the application and the web owners in ministry program areas who are their customers. It is an ongoing service and environment that presently hosts multiple internal and publicfacing government applications. There are presently 200 hosted applications in SUS with over 30 being critical business applications.
General Skills:
- Experience in database administration at the specified experience level
- Experience of managing Oracle 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 problemsolving and decisionmaking 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
Required Skillsets
- More than 10 yrs Oracle DBA experience
- Approved experience of Oracle 12c & 19c using multitenant architecture
- Oracle 12c RAC Grid infrastructure/ASM
- RMAN backup and Restore
- Data Encryption using ASO/TDE
- Oracle Dataguard Physical/Logical Configuration & Administration
- Oracle Enterprise Manager configuration & Management for alerting & reporting
- UNIX shell scripting
- SQL optimization tuning and performance experience
- MS SQL Server installation Configuration and database management
Desirable Skill
- 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
Requirements
Must haves:
- More than 10 yrs Oracle DBA experience
- Approved experience of Oracle 12c & 19c using multitenant architecture
- Oracle 12c RAC Grid infrastructure/ASM
- RMAN backup and Restore
- Data Encryption using ASO/TDE
- Oracle Dataguard Physical/Logical Configuration & Administration
- Oracle Enterprise Manager configuration & Management for alerting & reporting
- UNIX shell scripting
- SQL optimization tuning and performance experience
- MS SQL Server installation Configuration and database management