About the role
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
About Foilcon
At Foilcon, we are focused on delivering results to our clients. To be their go to partner for technical services, application developement, integration and training. This leads us to our goals of being a great partner and being the good guys.
With our global resources, we bring the rest of the world within reach to our customers.
Our nimble, experienced team moves from ideas to execution rapidly.
Our motto..There is always a way
About the role
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
About Foilcon
At Foilcon, we are focused on delivering results to our clients. To be their go to partner for technical services, application developement, integration and training. This leads us to our goals of being a great partner and being the good guys.
With our global resources, we bring the rest of the world within reach to our customers.
Our nimble, experienced team moves from ideas to execution rapidly.
Our motto..There is always a way