Company Description
SquareTrade is the fastest growing company of its kind. We’re revolutionizing a $30b industry with service innovation and attention to customer satisfaction. We partner with some of the largest, most sophisticated retailers and carriers in the world (Amazon, Walmart, The Home Depot to name a few), consistently win industry awards, have received tens of thousands of 5-star reviews… and we’re just getting started. A member of the Allstate family, SquareTrade has headquarters in San Francisco and London. We are currently expanding in Europe and Asia Pacific, including Japan and Australia.
Job Description
We are looking for a talented, energetic Database Administrator to join our DBA team. As part of a small, geographically dispersed DBA team, you'll be responsible for managing our database environment, as well as working closely with IT, Engineering, QA, Data, and Analytics teams to understand and improve processes.
Responsibilities
- Create and configure PostgreSQL database clusters
- Create and configure cloud global database cluster on Aurora PostgreSQL
- Monitor and maintain database health and security across various environments
- Manage role-based access control at various security levels and perform periodic audits
- Manage backup and recovery
- Maintain disaster recovery procedures and perform periodic testing
- Perform regular server maintenance, including upgrades with minimal downtime
- Configure, support, and monitor database replication
- Provide end-to-end technical support and problem resolution
- Assist developers with deployment process, schema design, and query optimization
- Uphold database best practices across organization
- Write, review and optimize SQL queries
- 24x7 on-call support (in rotation) QUALIF
Qualifications
- Bachelor's degree in Computer Science or related field is highly preferred; equivalent work-related experience is acceptable
- 6+ years of database administration experience in PostgreSQL is required
- 3+ years AWS Aurora experience required
- 3+ years Terraform experience
- 3+ years writing and optimizing SQL queries
- Moderate scripting skills in the following: SQL, PL/pgSQL, BASH, Shell, Python, Ruby, Perl, etc. (bonus points if you've got them all!)
- Assist Analysts with complex SQL query optimization
- Understanding of CTE’s, window functions and aggregate functions
- Knowledge of database best practices in minimal-downtime environment
- Knowledge of entity relationship model
- Effective technical and analytical skills
- Solid written and verbal communication skills
- Ability to work independently with minimal supervision and assistance
- Expert at managing logical and physical replication
- Experience with pgBackRest, pgBouncer, HypoPG or other PostgreSQL related technologies is a huge bonus.
- Understanding of both logical and physical backup techniques
- Experience using the command line to manage the DB cluster
- Skill in cluster optimization using postgresql.conf, pg_hba.conf and pg_ident.conf a must
- Zest for learning new technologies is a must!
Additional Information
At SquareTrade you'll have access to:
- Robust medical, dental and vision coverage with generous employer contributions tailored for our diverse workforce
- Inclusive fertility care plan
- 5% company match into 401(k)
- Open access to mental health benefits including 1:1 therapy, coaching sessions and digital resources
- $75 monthly allowance to support self-care and well-being
- Career experience programs, tuition reimbursement and unlimited access to online courses to support your professional growth
- Supportive leave policies including paid parental, grieving and loss, and domestic violence protected leaves
- Flexible paid time off plus a generous holiday schedule
- Paid volunteer time to give back to the community
- Hybrid work arrangements
- $80 monthly internet connectivity stipend
- Reimbursement for in-home office setup
- Various corporate perks and discounts
(Colorado Only) Pursuant to applicable law, SquareTrade estimates the possible compensation for this role, if hired in Colorado, to be within the following range: 120K - 150K
The Team: http://www.squaretrade.com/leadership
SquareTrade is proud to be an Equal Employment Opportunity employer. We are committed to creating an inclusive work environment for all employees. We celebrate diversity and encourage applications from all qualified individuals regardless of race, religion, color, national origin, sex, gender identity, gender expression, sexual orientation, age, marital status, veteran status, or ability status.
Thank you for your interest in a career at SquareTrade. Throughout your job search, please be mindful of recruitment fraud.
Top Skills
What We Do
Over the past decade, Allstate Protection Plans (previously branded and known outside the U.S. as SquareTrade) has revolutionized the product protection industry. We’ve done it through innovation, seamless customer experiences, and by following the golden rule: treat others as you want to be treated. That’s why over 70% of consumers say they prefer Allstate Protection Plans over our competitors, and why Allstate Protection Plans are trusted by over 140 million customers and many of the largest retailers and mobile carriers in North America to protect everything from smartphones to appliances, TVs to furniture, and more.
