Oracle and MS SQL Database Administrator
Apply NowCompany: ETalentNetwork
Location: Regina, SK S4N 7R8
Description:
Offsite
Offsite work is acceptable. Candidate may be requested to attend periodic sessions onsite with at least 4 weeks warning. Candidate will have days between Christmas and New years off. The Monday after Easter is also a day off.
On call rotation not expected.
Overtime is limited and the candidate may be asked to change work hours to be outside of normal business hours, but not usually to exceed 40 hours in one week.
Seniority: Senior
Position and/or Project Description:
Expertise in Oracle and MS SQL (3 to 5 years) is required.
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:
1. Proficiency in VMware.
2. Proficiency in Azure and Windows Administration.
3. Technical Documentation: Ability to create technical documentation and user guides for new systems or updates.
4. 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.
Deliverables:
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.
Please confirm these questions also
Does the Proposed Resource Have working Status within Canada?
Is the resource available to work overtime?
Hours Available Per Week?
Can resource meet desired start date?
If not, what date can resource start?
How much notice is required to meet Start Date?
Offsite work is acceptable. Candidate may be requested to attend periodic sessions onsite with at least 4 weeks warning. Candidate will have days between Christmas and New years off. The Monday after Easter is also a day off.
On call rotation not expected.
Overtime is limited and the candidate may be asked to change work hours to be outside of normal business hours, but not usually to exceed 40 hours in one week.
Seniority: Senior
Position and/or Project Description:
Expertise in Oracle and MS SQL (3 to 5 years) is required.
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:
1. Proficiency in VMware.
2. Proficiency in Azure and Windows Administration.
3. Technical Documentation: Ability to create technical documentation and user guides for new systems or updates.
4. 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.
Deliverables:
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.
Please confirm these questions also
Does the Proposed Resource Have working Status within Canada?
Is the resource available to work overtime?
Hours Available Per Week?
Can resource meet desired start date?
If not, what date can resource start?
How much notice is required to meet Start Date?