Intermediate MS-SQL DBA/Developer

Zealots Consulting Inc.

March 27, 2015

Original postings on the Viatec site are removed after the position is closed, but the posting will be archived here. The original posting was at
http://www.viatec.ca/job-board/13618

Job Category: 
Technical
Job Specialization: 
Software Development
Job
Company Overview: 

Zealots Consulting Inc. Executive Search is recruiting for our top tiered Industry retained client, Western Forest Products Inc., offering top market salaries, 100% employer paid benefits, training and leadership opportunities, and a company pension plan.

Western's key strength is its dynamic people. With more than 2,000 talented and motivated employees, the company has industry-leading knowledge of the fibre base, skills in product manufacturing and dedication to customer service as well as a commitment to safety, community and environmental values.

Job Summary: 

Position Title: Intermediate MS-SQL DBA/Developer

Reports To: Manager, Development & Integration

Location: Nanaimo, British Columbia

Reference # T-201549

Client Background and Primary Accountabilities:

Zealots Consulting Inc. Executive Search is recruiting for our top tiered Industry retained client, Western Forest Products Inc., offering top market salaries, 100% employer paid benefits, training and leadership opportunities, and a company pension plan.

Western's key strength is its dynamic people. With more than 2,000 talented and motivated employees, the company has industry-leading knowledge of the fibre base, skills in product manufacturing and dedication to customer service as well as a commitment to safety, community and environmental values.

Our retained client, Western Forest Products Inc. is currently seeking an experienced Intermediate MS-SQL DBA/Developer to join the Company's Management Information Services Team and Business Services Group.

This position will work out of the Company's Head Office, in beautiful Nanaimo, British Columbia (BC), and some light travel to the company operations located in Nanaimo, BC on Vancouver Island may be required on occasion.

Reporting to the Manager of Development & Integration, the Intermediate MS SQL DBA/ Developer is responsible for primarily designing and administering databases across the enterprise to ensure that these perform in an optimum and secure manner. In addition, the role will be expected to work with the development team and assist with writing and optimizing MS-SQL, T-SQL, PL/SQL functions and SSIS packages in support of system and report development projects.

Education & Required Experience:

• Degree or Diploma in Computer Science, Engineering, or related field.
• 3+ years of DBA experience in MS-SQL Server or as an Oracle production DBA.
• 3+ years of development experience in MS-SQL, T-SQL, or PL/SQL.
• Data structure design and architecture familiarity.
• Data defect debugging & fixing, and root cause analysis experience.
• Experience implementing clustered SQL server database solutions.
• Well versed in the software development lifecycle.
• Unit testing & manual quality assurance (QA) testing experience.
• Tools knowledge specifically in: SQL Manager, Visual Studio, TFS, and Azure.
• The ability to work in a team oriented environment with a strong customer service orientation is a mandatory requirement for this position.

Skills, Knowledge & Abilities:

The Intermediate MS-SQL DBA/ Developer works closely with the rest of the support team including: database administrators, software development team members, network support, system administrators, and business intelligence specialists.

SPECIFIC ACCOUNTABILITIES

MS-SQL Database Administrator -- 60% of the Role

• Maintain design structure by implementing database standards and guidelines.

• Maintain database performance by developing proper database tuning methodologies.

• Implement platform upgrades and migrations by coordinating with the affected parties, and to monitor the resultant performance changes.

• Provide information by collecting, analyzing, and summarizing database performance and trends.

• Confirm database requirements by conferring with all of the affected stakeholders by studying operations and objectives procedures and integrating enterprise requirements, and by applying database concepts and functional capabilities to the role.

• Document database architecture and operational procedures.

• Maintain data integrity by establishing 'best of breed' industry standards, and monitoring performance.

• Support and troubleshoot and optimize performance issues, resolve production problems, and provide timely follow-up to clients and to provide problem issues/reports on a monthly basis.

• Work with the development and product teams to create, recommend, and maintain security by adhering to: data access, data privacy, and data transformation standards.

MS-SQL Development (Database) -- 40% of the Role

• Transform business requirement into logical and physical data models.

• Conduct data model reviews with developers, software analyst and subject matter experts to collaborate and gain consensus.

• Work with the development team to enforce company standards, and to produce a high quality work.

• Diagnose and resolve complex MS-SQL performance problems.

• Build complex MS-SQL reports.

• Develop SSIS packages as required.

Nice to Have Technical Skills:

• Software development in SSIS and/or SSRS is highly desired.

Required Soft Skills:

• Excellent communication skills (both oral and written) and very strong customer service skills orientation is required.

• Strong problem solving capabilities.

• A high degree of detail orientation is absolutely required for this role.

Nice to Have Industry Exposure:

• Exposure to Forestry, Lumber or Industry Related experience is highly desirable.

Contact:

In confidence, please call or email your resume and cover letter quoting, Intermediate MS-SQL DBA/ Developer by sending your resume to:

recruiter@zealotsconsulting.com

Cliff Tang, Principal
Zealots Consulting Inc. Executive Search
IT Recruitment Consulting & Leadership Development
"Part of Your Team"
Lynn Valley Town Centre
1199 Lynn Valley Road, Box 16133, North Vancouver, BC
V7J 3S9 Canada
604-727-3141 (phone)
604-988-3152 (fax)

recruiter@zealotsconsulting.com
web: www.zealotsconsulting.com

How To Apply: 

In confidence, please call or email your resume and cover letter quoting, Intermediate MS-SQL DBA/ Developer to:

recruiter@zealotsconsulting.com

Cliff Tang, Principal
Zealots Consulting Inc. Executive Search

IT Recruitment Consulting & Leadership Development

"Part of Your Team"

Lynn Valley Town Centre

1199 Lynn Valley Road, Box 16133,  North Vancouver, BC

V7J 3S9 Canada

604-727-3141 (phone)

604-988-3152  (fax)

e-mail: recruiter@zealotsconsulting.com

web: www.zealotsconsulting.com