Ministry of Public and Business Service Delivery (former MGCS)
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 public-facing 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,?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
Required?Skillsets?
- More?than?10?yrs?Oracle?DBA?experience
- Approved?experience?of?Oracle?12c?&?19c?using?multi-tenant?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?
- Deployment & Operations / Database Administrator / Level 3 Price – 30%
- Dataguard – 20%
- Experience designing, installing, configuring, and maintaining an Oracle Dataguard environment Oracle Database Configuration – 10%
- Experience planning and designing a new database deployment. Experience installing and configuring an Oracle 19c RAC Database Oracle 19c Enterprise Manager – 10%
- Experience with designing, building, Installing, configuring, and administering OEM 19c Alerting and Reporting – 10%
- Experience installing, configuring and administering OEM 19c Alerting and Reporting Oracle Unified Auditing – 10%
- Experience installing, configuring and administering Oracle 19c Unified Auditing DB performance Tuning (5-7+ years experience perform ongoing monitoring and tuning of database ) – 5%
- OPS Experience – 5%
- Closing Date/Time
- 2024-08-06, 12:45 p.m.
Max no of submission- 1(one)
3 days onsite per week is required
Must haves:
- More?than?10?yrs?Oracle?DBA?experience
- Approved?experience?of?Oracle?12c?&?19c?using?multi-tenant?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
