Squaretrade - Denver, CO
posted about 2 months ago
SquareTrade is seeking a talented and energetic Database Administrator to join our DBA team. As part of a small, geographically dispersed DBA team, you will be responsible for managing our database environment and collaborating closely with IT, Engineering, QA, Data, and Analytics teams to understand and enhance processes. Your role will involve creating and configuring PostgreSQL database clusters, as well as setting up cloud global database clusters on Aurora PostgreSQL. You will monitor and maintain database health and security across various environments, manage role-based access control at different security levels, and perform periodic audits to ensure compliance and security standards are met. In addition to these responsibilities, you will manage backup and recovery processes, maintain disaster recovery procedures, and conduct regular server maintenance, including upgrades with minimal downtime. You will also configure, support, and monitor database replication, providing end-to-end technical support and problem resolution. Assisting developers with deployment processes, schema design, and query optimization will be a key part of your role, as well as upholding database best practices across the organization. Writing, reviewing, and optimizing SQL queries will be essential, and you will be part of a 24x7 on-call support rotation. This position requires a Bachelor's degree in Computer Science or a related field, or equivalent work-related experience. You should have at least 6 years of database administration experience in PostgreSQL, along with 3 years of experience with AWS Aurora and Terraform. Strong skills in writing and optimizing SQL queries, moderate scripting skills in languages such as SQL, PL/pgSQL, BASH, Shell, Python, Ruby, and Perl are also required. A zest for learning new technologies and effective technical and analytical skills will be crucial for success in this role.