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