Your

Role:

The Senior SQL Server DBA is responsible for managing Global Relay's production Microsoft SQL database systems. This includes the development, review, and maintenance of database scripts, custom reports, data extracts, and ongoing optimization of databases and applications to ensure the highest level of database and application performance.

As part of the Development organization, the Senior DBA will work closely with business users and developers to assist in managing updates to staging and production environments. This will include reviewing proposed database changes as well as recommending and implementing changes to optimize performance and ensure high availability.

Your Job:
• Monitor and maintain all internal Microsoft SQL databases
• Perform routine archiving, security, and auditing related tasks, according to applicable policies and procedures
• Support client database functions, including data extraction, transformation, and loading (ETL) services
• Provide... management reports, customer reports, and data extracts
• Conduct research, analysis, and profiling to develop methods to improve database performance, functionality, and availability
• Plan, communicate, execute, and document database related maintenance and upgrades
• Assist with space management initiatives and database migration projects
• Support audit and security processes including access control and user management
• Make recommendations on existing and future storage and system infrastructure
• Ensure that all issues in staging and production environments are addressed quickly

About You:
• Minimum of 5 years of experience in database administration, development, and support
• Experience in Windows
• Experience in Microsoft SQL 2012/ 2016 /2019
• Experience in database architecture modeling, design, and implementation
• Expert knowledge in database performance tuning and query optimization
• Ability to work with agile teams to support dynamic and high-availability environments
• Strong knowledge of database backups/restores, clustering, mirroring, and replication
• Experience in documentation and presentation of technical tasks and implementation plans
• Thorough knowledge of database design and optimization
• Excellent technical troubleshooting and issue documentation skills
• Excellent written and oral communication, problem solving, and organization skills
• Strong initiative and ability to work under minimal supervision
• Excellent ability to work in a collaborative team environment
• Able to meet project schedules and quality standards
• Able to balance priorities and work under pressure
• Ability to work in a fast-paced, entrepreneurial, high-tech environment
• Database certification an asset
Vancouver BC

Salary Criteria