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.
Requirements
- 8+ years experience managing and administrating production Microsoft SQL Server infrastructures.
- An affinity for tracking down and optimizing performance issues in Microsoft SQL Server.
- Experience with SQL Server Availability Groups.
- Expertise in T-SQL.
- Strong proficiency in a scripting language; Ideally Powershell.
- 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.
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.
Other
- 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.
- Desire to learn and grow your technical skillset.
- 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.
