Database Reliability Engineer

About the Team:

The Technology Team at GLG builds the platform that matches companies around the world with the experts who can help them make the right call on their most important decisions. GLG is building a next generation platform to transform our industry, and we re looking for people to help define and build our data infrastructure. Joining GLG s Database Reliability Engineering (DRE) team, you ll collaborate with other database administrators, database engineers, systems architects, software engineers, product managers, and users to set and achieve goals that help GLG continue to define the future of expertise.

Database Reliability Engineering at GLG is a union of traditional database administration, database engineering, system operations, and software engineering. We focus on the interactions between applications and data stores. We build a deep understanding of applications, data pipelines, data stores, and develop code and configuration to optimize the interactions between those components for scalability, performance, and resilience. We work closely with application teams on the construction of data-heavy systems, provide expert guidance on the design, security, and implementation of data storage and the software systems that use them. We are polyglot database engineers that thrive in and understand multiple scripting languages and data platforms.

Key Responsibilities:

• Tune SQL queries to increase performance and decrease overall system impact.
• Monitor servers for performance problems and alleviate bottlenecks.
• Build systems and programs that automate away repetitive tasks.
• Design and refactor data structures to meet performance goals.
• Review schema change proposals from development teams and suggest best practices.
• Administer database roles and users.
• Monitor and maintain database backups and restores.
• Ensure optimal database indexing.
• Conduct capacity planning and make and implement recommendations.
• Coach, educate, and lead other engineers across the technology organization on how to best interact with data through pairing, design reviews, blogging, and teaching sessions.

Required Skills:

• 5+ years experience managing and administrating production Microsoft SQL Server infrastructures.
• 5+ years experience working with Microsoft SQL Server 2017 or higher.
• An affinity for tracking down and optimizing performance issues in Microsoft SQL Server.
• Strong communication skills and the ability to educate other team members on performance-minded schema and query design.
• Strong understanding and awareness of data security and secure data handling.
• Experience with SQL Server Availability Groups.
• Expertise in T-SQL.
• Strong proficiency in scripting language; Ideally PowerShell.
• Desire to learn and grow your technical skillset.
• Strong SQL Server performance tuning abilities. You must understand the SQL optimizer and be able to improve query performance without the aid of tools such as the index tuning adviser.
• Ability to read and understand SQL Server explain plans.
• Working knowledge of database design fundamentals. You will learn the existing database schema and relationships and be capable of suggesting best practices when reviewing schema modifications from development teams.
• Fundamental understanding of git is a plus.
• Proficiency with database systems other than SQL Server is a major plus.
• Proficiency in JavaScript, bash, and/or python are a plus.