Database Administrator

**About the role**:
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.

**Key Responsibilities**:

- Manage, monitor, and scale our cloud-based database fleet, with an emphasis on **AWS RDS and Aurora for PostgreSQL**.
- Tune SQL queries to increase performance and decrease overall system impact across PostgreSQL and SQL Server environments.
- Monitor database instances for performance problems and alleviate bottlenecks.
- Build automation and tooling to reduce operational toil and eliminate repetitive tasks.
- Design and refactor data structures to meet performance and scalability goals.
- Review schema change proposals from development teams, providing expert guidance on best practices for our target database platforms.
- Administer database roles and users.
- Manage and maintain robust backup and recovery strategies, leveraging both native AWS tools and custom solutions.
- Conduct capacity planning and make data-driven recommendations for scaling our database infrastructure.
- Coach, educate, and lead other engineers across the technology organization on how to best interact with data through code reviews, pairing and design reviews.

**Qualifications**:

- **5+ years of experience** managing and administering production **PostgreSQL**:

- **3+ years of experience** managing and administering production **SQL Server**:

- Expertise with **AWS-managed database services**, including **RDS and Aurora for PostgreSQL**.
- Working knowledge of core AWS services (e.g., EC2, S3, IAM, CloudWatch).
- Strong **PostgreSQL** performance tuning abilities. You must understand the query planner and be able to improve query performance without relying solely on automated advisors.
- Ability to read and interpret PostgreSQL EXPLAIN ANALYZE plans to identify performance bottlenecks.
- Proven Expertise in **SQL,**specifically **PostgreSQL and T-SQL**:

- Strong proficiency in scripting languages such as **PowerShell,** **Python**or **Bash** for automation.
- Experience with PostgreSQL high-availability (HA) and disaster recovery (DR) strategies, such as streaming replication.
- 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 principles.
- Working knowledge of database design fundamentals and best practices.
- Proficiency with database systems other than PostgreSQL and SQL Server is a major plus.
- Fundamental understanding of Git for version control is a plus.

**About GLG / Gerson Lehrman Group**

GLG is the world’s insight network. Our clients rely on GLG’s global team to connect with powerful insight across fields from our network of approximately 1 million experts (and the hundreds of new experts we recruit every day).

GLG’s industry-leading compliance framework allows clients to learn in a structured, auditable, and transparent way, consistent with their own internal compliance obligations and the highest professional ethical standards. Our compliance standards are a major competitive differentiator and key component of the company’s culture.

Gerson Lehrman Group, Inc. (“GLG”) is an equal opportunity employer and will not discriminate against any employee or applicant on the basis of age, race, religion, color, marital status, disability, gender, national origin, sexual orientation, veteran status, or any classification protected by federal, state, or local law.