SquareTrade
Database Administrator
SquareTrade, Denver, Colorado, United States, 80285
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: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
(California Only) Pursuant to applicable law, SquareTrade estimates the possible compensation for this role, if hired in California, to be within the following range: 123K - 160K
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.
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: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
(California Only) Pursuant to applicable law, SquareTrade estimates the possible compensation for this role, if hired in California, to be within the following range: 123K - 160K
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.