SQL Database Administrator(Intermediate Experienced) - Waterloo, Canada - opentext

opentext

Verified Company

Waterloo, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

OPENTEXT - THE INFORMATION COMPANY

As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital.

Be part of a winning team that leads the way in Enterprise Information Management.

The Opportunity:

As a Database Administrator, you will:

Assure proactive monitoring, maintenance, and production support of a broad array of databases supporting several business brands
Build capabilities to quickly and effectively incorporate the management of databases of newly acquired companies
Provide effective communication, interaction and reporting to all stakeholders, including Operations, Engineering, Finance, Marketing and IT teams.

What It Takes:

Expert in database technologies, especially SQL Server. 34 years of DBA experience with at least 3 years of hands on SQL Server experience.
Skilled with SQL Server Availability Groups, replication, and high availability, tuning and scalability
Experience with backup and disaster recovery solutions for databases.
Experience with MySQL database server on Linux platform.
Troubleshooting with Service broker.
Performance testing, SQL Security, SSIS with SQL server 2016/1
Support SQL Databases, Reporting Services and Integration Services.
Able to write complex SQL, stored procedures and database triggers.
Knowledgeable of SQL Server data structures and architecture.
Knowledgeable of database utilities and tools.
Eager to contribute to a teamoriented environment.
Excellent in communication (written and oral) and interpersonal skills
Able to quickly grasp complex technologies
Experience with DevOps environments and automation desired including familiarity with scripting and other languages such as PowerShell, Bash and Python.
Eager to grow with an exciting company

Specific Objectives and Responsibilities

Your First Six Months:

Assume production DBA responsibilities across all product lines; the initial focus will be to provide Microsoft SQL Server expertise.
Design, build and operate database environments. Be a key extended member of the development team.
Develop solutions for monitoring, availability and reliability, performance, analytics, and security.
Document and provide training to peers relating to the database environments.

Six to Twelve Months and Beyond:

Gain and share expertise in database technologies other than SQL Server including MySQL, MongoDB, Azure SQL and RDS for SQL Server.
Participate in various product development tasks.
Take greater responsibilities to deliver on databaserelated initiatives including:
Server consolidations
Performance optimizations
Enhancements to our existing monitoring and notification infrastructure
Security enhancements
Automation of repeated, manual steps
Insuring our 24 X 7 X 365 availability and recovery capabilities
Become an expert relating to the database systems supporting various Carbonite productions including Carbonite Safe, Carbonite Endpoint, Carbonite Recover, Carbonite Server Backup, Webroot SecureAnywhere and others.
Involvement in the adoption of more DevOps approaches to a database platform release process.
Begin to provide database consulting services to the development organization relating to best practices when dealing with our database platform.