Oracle and MS SQL Database Administrator – Digital Nova Scotia – Leading Digital Industry

Oracle and MS SQL Database Administrator

Compugen is seeking a Oracle and MS SQL Database Administrator for a 2 year contract. Working remotely is acceptable, but there may be periodic sessions required to be onsite.  All candidates must currently reside within Canada.

Key Responsibilities:

  • Backup and Recovery Plans: This includes creating and maintaining comprehensive backup and recovery strategies to ensure data integrity and availability. Regular backups are scheduled and monitored to prevent data loss and ensure quick recovery in case of failures.
  • Performance Tuning Reports: These reports involve analyzing and optimizing database performance. The DBA identifies bottlenecks, implements tuning techniques, and provides detailed reports on the performance improvements achieved.
  • Security Configuration Standards: DBAs are responsible for implementing and maintaining security measures to protect the database from unauthorized access and threats. This includes configuring user authentication, authorization, and encryption settings.
  • Database Health Checks and Monitoring: Regular health checks and monitoring are conducted to ensure the database is running smoothly. This includes checking for any issues, monitoring system performance, and generating reports on the overall health of the database.

Skills & Qualifications:

  • Database Installation and Configuration: Experience in installing and configuring Oracle and MS SQL databases on various operating systems. This includes setting up database instances, configuring network connectivity, and ensuring optimal performance through proper configuration settings.
  • Performance Tuning and Optimization: Proficiency in monitoring and optimizing database performance. This involves analyzing performance metrics, identifying bottlenecks, and implementing tuning techniques to enhance database efficiency.

Mandatory Experience:

  • Expertise in Oracle and MS SQL (3 to 5 years) is required.
  • Proficiency in VMware.
  • Proficiency in Azure and Windows Administration.
  • Technical Documentation: Ability to create technical documentation and user guides for new systems or updates.
  • Security Management: Ensuring the security of  systems by setting up and managing  permissions.