Squaretrade - Denver, CO
posted 3 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 improve processes. This role is crucial in ensuring the health and security of our database systems, which are integral to our operations and service delivery. You will be tasked with creating and configuring PostgreSQL database clusters, as well as managing cloud global database clusters on Aurora PostgreSQL. Your responsibilities will also include monitoring and maintaining database health, managing role-based access control, and performing periodic audits to ensure compliance with security protocols. In addition to these core responsibilities, you will manage backup and recovery processes, maintain disaster recovery procedures, and perform regular server maintenance with minimal downtime. You will also be responsible for configuring, supporting, and monitoring database replication, providing end-to-end technical support, and assisting developers with deployment processes, schema design, and query optimization. Upholding database best practices across the organization is essential, as is writing, reviewing, and optimizing SQL queries. The role requires 24x7 on-call support in rotation, ensuring that our database systems are always available and performing optimally.