The role of Database Administrator is to manage the deploying and operating of primarily Linux-based databases (primarily MySQL) located in both internally and IAAS cloud-based environments.
Responsibilities
Manage MySQL databases servicing both internal and externally facing applications
Develop repeatable deployment, back-up and replication processes
Monitor database health with ability to independently troubleshoot configuration and performance issues
Facilitate working sessions with development team to improve database performance
Develop disaster high availability and disaster recovery procedures
Manage users and permissions with goal of providing necessary access while operating under best-practices (e.g., granting least privilege)
Coordinate patching, upgrade and maintenance schedules
Initiate and coordinate data obfuscation when dealing with PII
Requirements
3-5 years of database administration, preferably in a MySQL environment
Experience with both cloud (AWS) and on-prem database administration
Strong knowledge of least-privilege practices for database access/user management
Strong understanding of back-up and replication strategies
Ability to implement database-specific performance monitoring
Experience executing patching, upgrading and migration procedures
Experience scripting automated processes
Nice-to-haves
Linux Shell, Power Shell
Ability to serve as an escalation point for all database performance concerns
Understanding that occasional after-hours and weekend support will be expected
Benefits
Generous Paid Time Off (PTO) including paid holidays, vacation, personal and sick days, plus an extra day off for your birthday
Comprehensive health benefits with minimal cost for medical, dental and vision coverage
Access to Employee Assistance Program (EAP) for mental, physical, and financial health
Comprehensive Childcare Leave for primary and non-primary caregivers
Participation in the NHL's Savings Plan which includes a 401K with employer contributions
Hybrid work schedule available for a majority of roles
Pre-tax commuter benefit plan to offset commuting costs
Exclusive pricing from NHL Partners for travel and consumer goods
Opportunities to engage in workplace culture activities such as hockey games and Employee Resource Groups