
Cority
Data Analyst
@ Deel
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 https://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 requirements
KEY 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
To apply for this job please visit jobs.lever.co.