Database Administrator - SQL Server
Services généraux
Date de publication : 11 mai 2023
Lieu d’emploi : Quesnel
Type d’emploi : Alternance travail-études
Début : Immédiatement
Entreprise : West Fraser Timber Co. Ltd.
Site Web : www.westfraser.com
Adresse : 1250 Brownmiller Road, Quesnel, Colombie-Britannique, Canada V2J 6P5
Descriptions d’emploi
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 or Vancouver,
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. We offer an excellent
compensation package including a competitive salary, excellent
benefits, and an outstanding pension plan. Safety is one of West
Fraser’s core values and our employees can expect a challenging,
stable work environment with career development opportunities.
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.
Conditions d’emploi
- Expérience minimum : 0 à 1 an
- Niveau d'éducation minimum : 12e année ou l’équivalent
- Langue : Anglais