Database Administrator Intermediate
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
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
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
