Database Administrator

HM Note: This hybrid contract role is in office at the manager's discretion. Candidate resumes must include first and last name, email and telephone contact information.

Description

Responsibilities:

• 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 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 skills
• A team player with a track record for meeting deadlines

Desirable Skills:

• Experience with distributed data systems
• Experience with middleware and gateways
• Experience with researching and implementing cyber security vulnerability remediations
• Awareness of emerging IT trends and directions
• Experience with Computer Aided Software Engineering (CASE) tools
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience in Database Administration, Maintenance Optimization

Skills

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