Intermediate MS-SQL DBA/Developer (IT, Computers & GIS)

Full Time

  Zealots Consulting Inc. Executive Search (http://www.zealotsconsulting.com/)

  Vancouver, British Columbia, Canada

Zealots Consulting Inc. Executive Search was founded in 1997 and the company specializes in finding highly skilled Information Technology (IT) technical resources by shortening the time to fill ratio by utilizing its practicing consultants unique blend of information technology and intuitive human resources skills to complete assignments often deemed very difficult to place and retain. Since 1997, Zealots Consulting Inc. Executive Search's candidate send out to placement ratio is 3:1 and the company has filled 576 IT positions including: senior executive, contract, and technical roles.

Concurrently, Zealots Consulting Inc. provides companies with project management, IT change management, and organizational development services to help clients deliver their projects on time and under budget. In addition, the firm helps to develop future information technology talent by providing one on one career coaching and leadership development mentoring. 

Position Title: Intermediate MS-SQL DBA/Developer

Reports To: Manager, Development & Integration

Location: Vancouver, 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 Vancouver, 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: 

Required Education, Experience and Skills:

  • 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.