Senior SQL Database Developer

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,…