Job Description
Summary
Under limited supervision, the Senior Systems Analyst provides analysis, design, standardization, implementation, and maintenance of server and storage systems in support of all business units including publicly visible operations. This individual will also work with the core infrastructure teams to support and improve Aspen One’s portfolio of infrastructure systems with an enhanced focus on Database Administration. This would include working with teams across the organization such as Cybersecurity, Networking, Mountain Application Developers, and Ski & Snowboard Schools professionals.
The budgeted salary range for this position is $95,075 - $117,668. Actual pay will be dependent on budget and experience; all our salaried roles are eligible for bonus.
This position is open to employees based in Denver, CO with an in-office expectation of at least two days per week.
Job Posting Deadline
Applications for this position will be accepted until May 15, 2024.
Essential Job Functions
- Administration of Azure infrastructure including systems, Azure SQL, MSSQL, backup technologies, app services, etc...
- Recommend and implement emerging database technologies.
- Create and manage database reports, visualizations, and dashboards.
- Install and maintain the performance of infrastructure servers including database servers both on premises and cloud hosted systems.
- Set and maintain server and database standards.
- Administer and maintain system accounts through Active Directory and Azure AD
- Create and maintain comprehensive documentation for all implemented servers and systems for ease of operation, maintenance, identification, and handoff to other support departments.
- Spend time in front line operations to build relationships and understand system opportunities.
- Assist in the coordination of work with vendors
- Be able to develop solutions with SQL and Stored Procedures.
- Create solution prototypes, as needed, to prove out concepts and ideas.
- Performance tuning of database systems.
- Diagnose and troubleshoot incidents.
- Create automation for repeating database and systems tasks.
- Be available for on-call support.
- Other duties as assigned
Qualifications
- Bachelor’s degree in Information Systems or technology field preferred
- 3+ years of experience in database administration, information technology, database architecture, or a related field
- Strong command of SQL and SQL server tools
- Basic understanding of network fundamentals.
- PowerShell scripting skills preferred
- Familiarity with SSAS, SSIS, SSRS
- Knowledge of VMWare, Azure, SAN, and backup solutions.
- Excellent written and verbal communication skills
- Impeccable attention to detail
- Weight given to candidates with MCSE certifications, VCP, and other system certifications.
- Experience with Windows Server environments
- Extensive experience with database technologies (MS SQL)
- Experience with cloud services (Microsoft Azure) a plus
- Familiarity with RTP infrastructure a plus.
- Good verbal communication skills are essential.
See more jobs at Aspen Skiing Company
Apply for this job