Database Administrator
Cority is the global enterprise EHS software provider creating industry-leading technology to empower those who transform the way the world works. For over 35 years, Cority has been powered by the spirit of innovation, deep domain expertise, and a commitment to integrity that enables higher levels of operational and sustainable performance with the most comprehensive, human-centered, and secure SaaS platform to help workers and businesses thrive in 100 countries around the world. The company enjoys the industry’s highest levels of client satisfaction and has received many awards for its strong employee culture and outstanding business performance. To learn more, visit www.cority.com.
POSITION SUMMARY
The Database Administrator works within a team that is responsible for ensuring optimal performance, reliability, availability, and security of our company’s data and database systems. Together with Production Engineering, our DBAs are responsible for providing critical application platform services for our SaaS customers, following governance best practices, as well as consulting and coordinating with Cority’s technology teams to meet business requirementsKEY RESPONSIBILITIES:
- Proactively monitor database management systems to prevent and mitigate performance and availability issues
- Perform SQL analysis and evaluate database performance to maximize efficiencies and take advantage of tuning opportunities
- Develop and apply automation to increase reliability while reducing toil
- Install, configure, and manage new database systems in public cloud
- Analyze query efficiency and provide recommendations to application development teams to appropriately restructure data for maximum efficiency
- Research and participate in the implementation of new database features
- Demonstrate knowledge of database design; assist in troubleshooting and resolving complex, high-severity issues
- Through operational intelligence and automation, forecast and manage resource utilization requirements across multiple environments.
- Follow the standards and practices of the Cority Information Security Management System and contribute to the continuous improvement of the ISMS
QUALIFICATIONS:
- 2+ years of experience supporting MS SQL Server 2017, 2019, and newer, including clustering, mirroring, log shipping, and replication
- 1+ year of experience supporting Amazon RDS or Azure SQL Database
- Experience with developing automation scripts and internal tools to reduce operational toil
- Understanding of relational database structures, theories, principles, and practices
- Experience in Performance Tuning and Query Optimization
- Practical expertise with PowerShell or other scripting environments
- Knowledge of data management including backups, restores, recovery models, database shrink operations, integrity checks, and index management
- Experience with Oracle, MySQL, and PostgreSQL is an asset
- Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)
- Strong communication skills, both written and verbal
- Self-motivated, with the ability to work independently and within a team environment.
WHAT’S IN IT FOR YOU?
·An opportunity to work in a values-driven, performance oriented, dynamic and growth focused culture·We support a remote working environment with a one-time home office allowance and subsidized monthly internet allowance ·Competitive health benefits, dental plans, and retirement savings plan (RRSP, 401K plan etc.)·Annual fitness allowance ·Mental health support provided through access to Calm Premium meditation app and access to Talkspace ·Access to Udemy, internal training programs, annual training allowance and certifications, if applicable, and High Talent Programs Cority is committed to a diverse and inclusive work environment. Cority is an equal opportunity employer and does not discriminate based on race, nationality, gender, gender identity, sexual orientation, protected veteran status, age, disability or any other legally protected status. For applicants who would like to request for accommodation please send an email to [email protected].Originally posted on Himalayas
Apply To this Job