Senior SQL Database Developer

Get AI-powered advice on this job and more exclusive features.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.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 databasesPerform routine archiving, security, and auditing related tasks, according to applicable policies and proceduresSupport client database functions, including data extraction, transformation, and loading (ETL) servicesWork as part of an agile development team to Architect, deploy and maintain SQL services for enterprise servicesCollaborate with QA in development of test cases for SQL ServicesProvide management reports, customer reports, and data extractsConduct research, analysis, and profiling to develop methods to improve database performance, functionality, and availabilityPlan, communicate, execute, and document database related maintenance and upgradesAssist with space management initiatives and database migration projectsSupport audit and security processes including access control and user managementEnsure staging and production environments are running smoothlyAbout you:Minimum of 7 years of experience in database administration, development, and supportExperience in WindowsExperience in Microsoft SQL 2012/ 2016 /2019Proven ability to solve technically complex, multi-faceted problems; strong analytical skillsExperience in high-level systems analysis, measurement, queuing theory and capacity analysisSelf-motivated and curious – an ability to understand how complex systems work.Experience in database architecture modeling, design, and implementationExpert knowledge in database performance tuning and query optimizationAbility to work with agile teams to support dynamic and high-availability environmentsStrong knowledge of database backups/restores, clustering, mirroring, and replicationExperience in documentation and presentation of technical tasks and implementation plansThorough knowledge of database design and optimizationExcellent technical troubleshooting and issue documentation skillsExcellent written and oral communication, problem solving, and organization skillsStrong initiative and ability to work under minimal supervisionExcellent ability to work in a collaborative team environmentAble to meet project schedules and quality standardsAble to balance priorities and work under pressureAbility to work in a fast-paced, entrepreneurial, high-tech environmentCompensation: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 teamBritish Columbia - Base Salary Range:$65,000—$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 www.globalrelay.com.Seniority levelSeniority levelMid-Senior levelEmployment typeEmployment typeFull-timeJob functionJob functionInformation TechnologyIndustriesSoftware DevelopmentReferrals increase your chances of interviewing at Global Relay by 2xGet notified about new Senior Database Developer jobs in Vancouver, British Columbia, Canada.Senior Data Scientist - Microsoft OneDriveApplied Sr Data Scientist - Fintech FoundationBurnaby, British Columbia, Canada 1 month agoSoftware Engineer (Senior API Developer))Richmond, British Columbia, Canada 1 month agoBurnaby, British Columbia, Canada 1 week agoSenior Software Engineer, Treasury ServicesWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr