The Database Administrator reports into the Manager IT Infrastructure. This position is accountable for administering the Information Management platform for the organization including the creation, maintenance and management of all databases and environments supporting all enterprise applications and systems. Additionally, this role will also be responsible for designing database farms including SQL servers and serverless environment. This role will apply proven communication, analytical, and problem-solving skills to ensure client satisfaction with both operational and project related issues. Since RM has standardized on using Microsoft as the technology platform, this role will be focused on the use and application of the Microsoft BI and IM software stack including SQL Server and SQL Server Integration Services.
Here's how you will contribute to creating life changing experiences....
Install, administer and maintain all SQL Server instances including service packs.
Setup and administer all DB environments including Dev, Test, Staging and Production.
Create and manage all databases across environments including Azure SQL-as-a-Service
Create and manage users and assign permissions based on the level of access required.
Create linked servers to SQL Server and other enterprise databases.
Define database backup and restoration strategy.
Create database backups and setup automated backup schedules.
Restore database from backups in the event of data loss, DB failure or corruption or as per user requests.
Create, design, and maintain DB server farms and DB clusters for required enterprise applications to enable High-Availability as part of the IT Disaster Recovery Strategy.
Create and design migration plan to leverage Azure serverless SQL DB services
Define and maintain plans for monitoring and performance tuning: physical servers, virtual machines, database and query tuning including the creation and maintenance of indexes, monitoring CPU, memory and disk usage.
Define and implement Best Practices for database administration and data integration.
Troubleshoot database or IM related issues as part of day-to-day operational activities.
Provide DB administration and support on Capital and Operational IT projects.
Document all SQL Server environments, databases, processes and workflows. Ensure documentation is kept up to date based on any changes to environments or instances.
Here's what you'll bring to Rocky Mountaineer...
Working in an IT environment for 5 - 7 years in a Database Administration role
Expertise in Microsoft BI and IM technology stack including MS Visio
At least 5 years’ experience administering MS SQL Server 2008/2012/2016 enterprise environments
At least 2 years’ experience managing cloud-based database technologies, including Azure SQL as a service implementations
Understanding of Incident and Change Management and ability to follow RM’s process, procedure standards and methodologies
Understanding of Infrastructure, Business Applications, and Help Desk technology
Working knowledge of Active Directory and related user management tasks
Working in an environment requiring constant and clear communications both verbal and written
Working in a team environment and experience working cohesively with related IT teams
Understanding of the project management life cycle
Gathering information, analyzing and providing trending analysis
Proven writing skills with the ability to organize and present information in various forms such as textual, graphical and statistical
College Diploma in Computer Science, IT or MIS with emphasis on Database Administration and/or equivalent experience
Professional certifications such as MSCA or MSCE in Data Platform (SQL Server) or BI