Database Administrator, Ii

West Fraser is a leading diversified North American forest products company. We are listed on the TSX, NYSE and recognized as one of Canada's Top 100 Employers. Are you ready to build your career in a company that thrives on growth, rewarding work, challenge, and opportunity? Discover a future with West Fraser. We take pride in what we do and in who we hire. With multiple locations, we are larger than many startups! We are implementing new technology and the successful candidate should be a self-motivated achiever who gains satisfaction from providing excellent support services and thrives in a team-based environment. Our IT group in Quesnel, BC has an opportunity for a:

Database Administrator - SQL Server

Responsibilities:

• Installing, configuring and upgrading the database
• Modifying the database structure, as needed
• Backing up and restoring databases
• Liaising with database vendors for technical support
• Monitor and optimize the performance of database queries including preparation of periodical metrics
• Maintaining appropriate memory and disk space to ensure system performance
• Troubleshooting live database issues
• Maintaining the indexes
• Maintaining established statistics
• Checking database integrity
• Assessing database integrity issues
• Patching Database Server for security flaws
• Conducting established security check protocol
• Considering and granting security access requests
• Reviewing availability groups and assessing for high availability
• Ensuring adherence to our disaster recovery plan
• Liaising with application support and developers on demand
• Perform scheduled maintenance and support release deployment activities
• Follow Change Management processes to implement database configuration changes
• Trouble shoot and resolve database connectivity issues
• Plan, deploy upgrades or modifications to improve performance and availability of SQL servers/ Oracle databases
• Build, maintain overall systems architecture concerning databases back-end servers and computing environment
• Oversee database policies and procedures to ensure the integrity and availability of databases
• Develop, enhance tools and procedures used for automated checks and monitoring the status of databases
• Enforce and maintain compliance of Microsoft SQL Server database environments with internal database security standards

Position Requirements:

• University degree in Computer Science or related information technology degree/diploma
• 3 – 5 years’ experience with Microsoft database platforms and Azure SQL
• Driven and able to learn new technologies in short timeframes
• Moderate knowledge of T-SQL Languages
• Windows batch scripting and PowerShell
• Critical thinker and have adept problem-solving skills
• Basic knowledge of Microsoft data migration and ETL tools

• Some experience with Monitoring & Diagnostic tools
• Some knowledge working with Windows servers
• Some knowledge of storage systems as it applies to hosting databases
• Knowledge of SQL Clustering, High Availability (HA) and (DR) options for SQL Server is an asset
• Implementing operational automation using scripts (PowerShell, T-SQL, VB Scripts, etc.)
• Experience performance tuning and troubleshooting of queries, stored procedures, and SSIS packages.
• Experience Indexing for performance (index maintenance and statistics, index usage analysis, etc.).
• Experienced with Database cloud services: Azure SQL
• Experience with On-premises, Cloud, and Hybrid database environments design, development, and support
• DR strategies design, implementation, and testing experience.
• Understanding of Database security and implementation of best practices in database access
• Experienced with Source Code repository such as (Subversion) to support software development life cycle
• Strong written and verbal communication skills in both technical and non-technical scenarios
• Positive and people-oriented personality that is action-oriented.
• Microsoft SQL Server Certification is an asset
• Experience with SQL Server 2016 and higher is an asset
• Experience working with Windows Server 2016 and higher is an asset
• Experience with Middleware such as IIS is an asset

West Fraser is currently looking for individuals who are interested in a full time, long-term career.

Our highly competitive compensation package includes:

• Competitive base salary with annual bonus opportunity
• Outstanding benefits package including medical, dental, pension, life insurance, disability, accident insurance, vacation, and holidays
• The salary range for this position is usually between $84,864 - $100,775 depending on skills and experience

Quesnel has a population of approximately 25,000 and features all major conveniences, including its own airport. Quesnel offers affordable housing, modern recreational and educational facilities, regular community events, as well as unlimited recreational activities for the outdoor enthusiast. It doesn’t take long to feel part of Quesnel’s welcoming community.

West Fraser believes inclusive, diverse teams build a more vibrant workforce, safer operations and a stronger company overall. We strive to create workplaces and leadership teams that are reflective of the diverse communities we are a part of. We will not discriminate against any applicant for employment on the basis of race, gender, national origin or any other protected legal characteristic.

If this position sounds like the career for you, apply today in confidence, by submitting your resume and cover letter at www.westfraser.com/jobs

We thank all candidates for their interest; however, only those selected for an interview will be contacted.