Job Description

Role: Oracle and MS SQL DBA

Location: Regina, SK-Hybrid

Duration: 06/02/2025 06/30/2027

Job Description:

SERVICE DETAILS

• Position and/or Project Description:

• Expertise in Oracle and MS SQL (3 to 5 years) is required.

RESOURCE QUALIFICATIONS

• Seniority: Senior

• Mandatory Education/Certifications:

• Microsoft Certified Professional or equivalent

• Oracle Certified Professional or equivalent

• Desired Education/Certifications:

• 2 to 4 years of formal education (technical school or university)

Mandatory Experience:

• Projects and support that include Microsoft Server, Azure and related products. This should be from a system admin perspective and include:

• 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.

Desired Experience:

• 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.

• Backup and Recovery: Expertise in implementing and managing backup and recovery strategies to ensure data integrity and availability. This includes configuring backup schedules, performing regular backups, and executing recovery procedures in case of data loss or corruption3.

• Security Management: Knowledge of database security best practices, including user authentication, authorization, and encryption. This involves configuring security settings, managing user roles and permissions, and ensuring compliance with security standards.

• Database Migration and Upgrades: Experience in planning and executing database migrations and upgrades. This includes migrating databases between different versions or platforms, as well as upgrading database software to newer versions while minimizing downtime and ensuring data integrity.

• High Availability and Disaster Recovery: Knowledge of high availability (HA) and disaster recovery (DR) solutions for Oracle and MS SQL databases. This includes configuring and managing technologies such as Oracle Data Guard, Oracle Real Application Clusters (RAC), SQL Server Always On Availability Groups, and SQL Server Failover Clustering.

• SCHEDULE FOR PERFORMANCE

Deliverables to include:

• 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.

Job Tags

Similar Jobs