As a PostgreSQL Database Administrator you will be part of a team of talented and passionate engineers that come from diverse backgrounds fostering a culture that embraces individual perspectives. We have a flat structure with minimal management layers fostering an open and collaborative environment that empowers our engineers with freedom to innovate and have end-to-end ownership. We encourage people to voice their ideas, introduce and learn new technologies, and take risks. We have a microservices architecture with plans to rapidly launch a wide range of products. By joining Upgrade at this early stage, you'll be creating the building blocks that will have a significant impact and make a meaningful difference in people's lives.
Responsibilities
- Lead the design, development, implementation, monitoring and maintenance of Upgrade's data management systems
- Lead the development of standards and procedures to maximize DBMS performance, scale-ability, resilience, security, and data integrity
You are
- Highly motivated and self driven
- Enjoy learning new technologies and applying that to solving problems
- Enjoy collaborating and working in small teams
- Technically strong and hands-on
- Good at multitasking and thrive in fast pace environments
- Methodical, thorough, and solution oriented
Requirements
- 7+ years of experience administering production, always-on, high throughput, OLTP RDBMS's with the last 3+ years administering Postgres
- Proficiency in administering PostgreSQL v9.5+ database servers running on AWS
- Proficiency in PostgresSQL backup & recovery, upgrade, patching, and performance tuning
- Advanced knowledge of SQL query execution, execution analysis & optimization, indexing strategies, partitioning etc.
- Advanced knowledge of SQL schema modeling and evolution
- Proficiency in various RDBMS replication strategies
- Experience with geo-redundant database deployments (active/active, active/standby, etc.) is a plus
- Solid Linux fundamentals including kernel and OS tuning, as they relate to DB performance and security
- Familiarity with Sarbanes Oxley, PCI DSS, and other security practices is a plus
- Excellent troubleshooting, documentation, and communication skills
- Experience with other database management systems is a plus
The Good Stuff
- Unlimited vacation policy
- Medical, dental, & vision coverage; fitness, travel, and dining perks
- Designer open office space with amazing bay views
- Well stocked kitchen with snacks and drinks; game rooms and yoga room
- Close to BART and public transportation
- Stock options, commuter benefits, learning and development stipend
- Regularly host hackathons and local tech meetups
- Weekly and monthly social gatherings like cook-offs and game nights
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
by via developer jobs - Stack Overflow
No comments:
Post a Comment