Job Description

Experience and Skill Set Requirements

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

• Dataguard, Installation - 20%
• Experience designing, installing, configuring, and maintaining an Oracle Dataguard environment Oracle Database Configuration - 30%
• Experience planning and designing a new database deployment. Experience installing and configuring an Oracle 12c RAC Database Oracle 12c Enterprise Manager - 20%
• Experience with designing, building, Installing, configuring, and administering OEM 12c Alerting and Reporting - 10%
• Experience installing, configuring and administering OEM 12c Alerting and Reporting Oracle Unified Auditing - 10%
• Experience installing, configuring and administering Oracle 12c Unified Auditing DB performance Tuning (5-7+ years experience perform ongoing monitoring and tuning of database ) - 5%
• OPS Experience - 5%

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

Must Have:

• More than 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

Job Tags

Similar Jobs