Job Title: Database Administrator Location: Calgary, Alberta Duration: 12 Months Introduction We are seeking a skilled Database Administrator to join our team in Calgary, AB.
This role requires a dedicated qualified with a strong background in database management and optimization, primarily focusing on MS SQL Server and Oracle databases.
The successful candidate will work onsite 5 days per week, with the potential for 1 day remote.
Required Skills & Qualifications 8-10 years of experience in Database Administration.
Proficiency in MS SQL Server and Oracle Database Administration.
Strong troubleshooting skills and experience in SQL database optimization and problem-solving.
Experience with Relational Database Management Systems and concepts.
Experience with High Availability Failover clusters, Always-on availability groups, and replication.
Experience with SSRS and SSIS packages.
Knowledge of Windows Server Cluster Services in Azure and On-Premises environments, including basic Power
Shell scripting.
Experience with Azure SQL PaaS and MS SQL and Oracle Databases in Azure Cloud.
Experience in MSSQL Server Performance - CPU, Memory, High usage, and database maintenance, Query Performance.
Knowledge of Backup and restore operations on the databases, Azure Blob Storage.
Experience in database migration, installation, and upgrades.
Ability to deploy and troubleshoot SQL Server Failover Cluster Instances and SQL High Availability Instances.
In-depth knowledge of Oracle (12c, 19c) and high availability architectures.
Working knowledge of disaster recovery architectures, specifically Dataguard, building and maintaining environments.
Working knowledge of Database monitoring methodologies, RMAN Backup and Recovery, Golden
Gate replication.
Strong understanding of performance tuning methodologies.
Knowledge of Unix/Linux platforms and operating systems including scripting and editors.
Working knowledge of database security implementations and data privacy.
Experience in SQL Server and Oracle databases related vulnerability management.
Prior work experience at client or in client''s industry.
Preferred Skills & Qualifications Additional certifications in database management or related fields.
Experience with other database management systems.
Familiarity with the latest database technologies and trends.
Day-to-Day Responsibilities Manage and maintain MS SQL Server and Oracle databases.
Ensure high availability and performance of databases through proactive monitoring and optimization.
Implement and manage database security measures to protect sensitive information.
Collaborate with IT teams to ensure seamless integration and operation of database systems.
Perform regular backups, disaster recovery planning, and data migration as needed.