SquareTrade
Database Administrator
SquareTrade, Denver, Colorado, United States, 80285
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.
ResponsibilitiesCreate and configure PostgreSQL database clustersCreate and configure cloud global database cluster on Aurora PostgreSQLMonitor and maintain database health and security across various environmentsManage role-based access control at various security levels and perform periodic auditsManage backup and recoveryMaintain disaster recovery procedures and perform periodic testingPerform regular server maintenance, including upgrades with minimal downtimeConfigure, support, and monitor database replicationProvide end-to-end technical support and problem resolutionAssist developers with deployment process, schema design, and query optimizationUphold database best practices across organizationWrite, review and optimize SQL queries24x7 on-call support (in rotation) QUALIFQualifications
Bachelor's degree in Computer Science or related field is highly preferred; equivalent work-related experience is acceptable6+ years of database administration experience in PostgreSQL is required3+ years AWS Aurora experience required3+ years Terraform experience3+ years writing and optimizing SQL queriesModerate 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 optimizationUnderstanding of CTE's, window functions and aggregate functionsKnowledge of database best practices in minimal-downtime environmentKnowledge of entity relationship modelEffective technical and analytical skillsSolid written and verbal communication skillsAbility to work independently with minimal supervision and assistanceExpert at managing logical and physical replicationExperience with pgBackRest, pgBouncer, HypoPG or other PostgreSQL related technologies is a huge bonus.Understanding of both logical and physical backup techniquesExperience using the command line to manage the DB clusterSkill in cluster optimization using postgresql.conf, pg_hba.conf and pg_ident.conf a mustZest 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 workforceInclusive fertility care plan5% 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-beingCareer experience programs, tuition reimbursement and unlimited access to online courses to support your professional growthSupportive leave policies including paid parental, grieving and loss, and domestic violence protected leavesFlexible paid time off plus a generous holiday schedulePaid volunteer time to give back to the communityHybrid work arrangements$80 monthly internet connectivity stipendReimbursement for in-home office setupVarious 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.
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.
ResponsibilitiesCreate and configure PostgreSQL database clustersCreate and configure cloud global database cluster on Aurora PostgreSQLMonitor and maintain database health and security across various environmentsManage role-based access control at various security levels and perform periodic auditsManage backup and recoveryMaintain disaster recovery procedures and perform periodic testingPerform regular server maintenance, including upgrades with minimal downtimeConfigure, support, and monitor database replicationProvide end-to-end technical support and problem resolutionAssist developers with deployment process, schema design, and query optimizationUphold database best practices across organizationWrite, review and optimize SQL queries24x7 on-call support (in rotation) QUALIFQualifications
Bachelor's degree in Computer Science or related field is highly preferred; equivalent work-related experience is acceptable6+ years of database administration experience in PostgreSQL is required3+ years AWS Aurora experience required3+ years Terraform experience3+ years writing and optimizing SQL queriesModerate 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 optimizationUnderstanding of CTE's, window functions and aggregate functionsKnowledge of database best practices in minimal-downtime environmentKnowledge of entity relationship modelEffective technical and analytical skillsSolid written and verbal communication skillsAbility to work independently with minimal supervision and assistanceExpert at managing logical and physical replicationExperience with pgBackRest, pgBouncer, HypoPG or other PostgreSQL related technologies is a huge bonus.Understanding of both logical and physical backup techniquesExperience using the command line to manage the DB clusterSkill in cluster optimization using postgresql.conf, pg_hba.conf and pg_ident.conf a mustZest 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 workforceInclusive fertility care plan5% 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-beingCareer experience programs, tuition reimbursement and unlimited access to online courses to support your professional growthSupportive leave policies including paid parental, grieving and loss, and domestic violence protected leavesFlexible paid time off plus a generous holiday schedulePaid volunteer time to give back to the communityHybrid work arrangements$80 monthly internet connectivity stipendReimbursement for in-home office setupVarious 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.