SQL Database Administrator(Intermediate Experienced)

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:

• Provide expertise in the various database platforms hosting our applications.  You will be a Microsoft SQL Server DBA but willing to ramp up and learn Azure SQL, RDS for SQL Server, MySQL, MongoDB and other database platforms.
• Develop an understanding of our business applications architecture, and provide architectural guidance to improve database and systems operations and integration
• 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.  3-4 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/17.
• 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 team-oriented 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.
• Learn and absorb responsibilities related to the application product lines.

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 database-related 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.

OpenText's efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please contact us at hr@opentext.com.