Job Description

Who we are:For over 20 years, Global Relay has set the standard in enterprise information archiving with industry-leading cloud archiving, surveillance, eDiscovery, and analytics solutions. We securely capture and preserve the communications data of the world's most highly regulated firms, giving them greater visibility and control over their information and ensuring compliance with stringent regulations.Though we offer competitive compensation and benefits and all the other perks one would expect from an established company, we are not your typical technology company. Global Relay is a career-building company. A place for big ideas. New challenges. Groundbreaking innovation. It's a place where you can genuinely make an impact - and be recognized for it.We believe great businesses thrive on diversity, inclusion, and the contributions of all employees. To that end, we recruit candidates from different backgrounds and foster a work environment that encourages employees to collaborate and learn from each other, completely free of barriers.We encourage you to apply if your qualifications and experience are a good fit for any of our openings.Your role:The Senior SQL Database Developer 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 Database Developer is responsible for the ongoing programming in connection with our various DB's, services, and applications; and assisting with the development and testing of new systems, features, and services. This will include complying with the standards that are set by the team and company in terms of development styles, methodologies and processes.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
• Work as part of an agile development team to Architect, deploy and maintain SQL services for enterprise services
• Collaborate with QA in development of test cases for SQL 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
• Ensure staging and production environments are running smoothly

About you:

• Minimum of 7 years of experience in database administration, development, and support
• Experience in Windows
• Experience in Microsoft SQL 2012/ 2016 /2019
• Proven ability to solve technically complex, multi-faceted problems; strong analytical skills
• Experience in high-level systems analysis, measurement, queuing theory and capacity analysis
• Self-motivated and curious - an ability to understand how complex systems work.
• 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

Compensation:Global Relay advertises the pay range for this role in compliance with British Columbia's pay transparency laws. Individual pay rates are determined by evaluating factors such as expertise, skills, education, and professional background.The range below reflects the expected annual base salary, which is only one element of our comprehensive total rewards package designed to reflect our company pay philosophy, culture and values. We aim to foster an inspiring work environment and support employees' work-life rhythms. We provide a comprehensive extended health benefits program, including virtual healthcare and a wellness allowance. Employees also receive annual allotted vacation days, which increase based on tenure. Other benefits include: Paid sick days, maternity/parental enhancement program, corporate bonuses, and an RRSP contribution matching program.For Vancouver-based employees, we provide a subsidized meal program, courtesy of our talented in-house culinary team!British Columbia - Base Salary Range:$65,000xe2x80x94$130,000 CADWhat you can expect:At Global Relay, there's no ceiling to what you can achieve. It's the land of opportunity for the energetic, the intelligent, the driven. You'll receive the mentoring, coaching, and support you need to reach your career goals. You'll be part of a culture that breeds creativity and rewards perseverance and hard work. And you'll be working alongside smart, talented individuals from diverse backgrounds, with complementary knowledge and skills.Global Relay is an equal-opportunity employer committed to diversity, equity, and inclusion.We seek to ensure reasonable adjustments, accommodations, and personal time are tailored to meet the unique needs of every individual.We understand flexible work arrangements are important, and we encourage that in our work culture. Whether it's flexibility around work hours, workstyle, or lifestyle, we want to ensure our employees have a healthy work/life balance. We support and value a hybrid work model that blends collaboration with the team in the office and focus time from the comfort of your home.To learn more about our business, culture, and community involvement, visit .

Global Relay