Overview

T&T Supermarket Database Administrator Full Time in Richmond, BC

T&T Supermarket

Branch Richmond BC CA

Position:
Database Administrator
Location:
Richmond, BC

SQL Server or DBA:. Minimum 2 years’ experience as a production SQL Server DBA, supporting mission critical databases and applications….

Job Summary

Reporting to IT Manager – Business Solution, DBA is a motivated, talented SQL Server Database Administrator with strong hands-on experience in SQL Server Administration, troubleshooting, disaster recovery, configurations, and support servers/databases in multiple environments, write and optimize SQL Queries, create logical and physical database schemas and work with development teams to build efficient SQL queries, stored procedures and implement new database schemas and enhancements.

Responsibilities and Duties

Given moderate to minimal direction, candidate should be able to perform the following tasks and duties:

  • Install, configure, and administer database software within the Microsoft SQL server stack including SSRS, SSAS, and SSIS.
  • Responsible for database recovery methodologies and the ability to perform them.
  • Establish and administer database security and environments.
  • Monitor and optimize database performance.
  • Create and/or tune complex SQL queries.
  • Work closely with development teams to prepare logical and physical database designs.
  • Review and assess the impact of database design changes prior to their implementation.
  • Provide technical expertise in the design and development of complex SQL queries and optimization.
  • Plan and implement database disaster recovery.
  • Identify project activities related to databases for a given project, as well as the amount of time involved to complete the tasks.
  • Participate in the on-call support of SQL Database Platforms. Maintain proper communication with team leads and management when issues occur or escalation is needed.
  • Continuously grow skills toward industry expert status in relational Database Administration.
  • Contribute to and adhere to company and industry standards.

Qualifications and Skills

  • BS in Computer Science, Computer Engineering, Information Science (or related field) or equivalent job experience.
  • Minimum 2 years’ experience as a production SQL Server DBA, supporting mission critical databases and applications.
  • Minimum 2 years reviewing/advising development team on best practices with SQL queries, and building/supporting development and test databases.
  • Minimum 2 years writing critic al ad-hoc updates to large production databases on a daily or weekly basis.
  • Experience with SQL 2014 or higher and Windows Operating Systems.
  • Able to write SSRS report against SQL Server database.
  • Can independently or with minimal assistance, translate business requirements directly into SQL.
  • Working knowledge of database recovery, database administration (including security), database optimization, and performance tuning.
  • Experience with Windows Server Failover Clusters, Partitioning, and Encryption preferred.
  • Demonstrate flexibility and the ability to work as a member of development team.

Job Type: Full-time

Required education:

  • Bachelor’s

Required experience:

  • SQL Server or DBA: 2 years
  • SQL 2014 or higher and Window Operation Systems: 2 years

or proceed with Standard Application Form.

Employment Type: Full Time
Location: Richmond, BC, CA
Posted on: 2018-01-11
Posted by: