Senior PostgreSQL Database Engineer
PerconaSalary not specified
Full Time
Senior (5 to 8 years)
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Financial ServicesIndustries
Requirements
- 5+ years working as a PostgreSQL DBA
- Hands-on and daily work experience with Linux operating systems
- Expert knowledge of PostgreSQL management: high availability (esp. Patroni), CDC (Change Data Tracking), security, replication, maintenance (backups, restores, vacuum, re-indexing), version upgrades, disaster recovery, legacy migrations, configuration, monitoring, alerting, etc
- Strong experience in PostgreSQL Performance Tuning and Query optimization
- PostgreSQL user best practices and the ability to evangelize/train
- Excellent communication and collaboration skills, the ability to work with developers as well as other infrastructure team members
- Skill with containerization technologies (Docker, Kubernetes) and storage management
- Proficiency in shell script, Python, and PowerShell
- An engineering mindset – robustness, debugging, troubleshooting, root-cause analysis
- Experience with other RDBMS/NoSQL technologies (SQL Server, MySQL, MongoDB, ClickHouse, Kafka)
- Must be authorized to work full time in the U.S. (no sponsorship for work visas)
Responsibilities
- Own/maintain various PostgreSQL clusters and instances across different environments (prod/dev/UAT) on Linux
- Design and implement PostgreSQL database systems to meet business requirements (performance, HADR, etc.). Design/deploy/support appropriate data models and patterns
- Optimize database performance: hardware, configuration, indexing, partitioning, etc
- Write and optimize complex SQL queries for high-volume environments
- Develop/deploy/support backup and disaster recovery procedures
- Set up monitoring, alerting, and proactive measures to maintain database health and performance
- Diagnose and resolve database-related issues and provide timely solutions. Be able to reach below the database tier and troubleshoot OS, hardware, and network issues as well
- Work closely with development and infrastructure teams to support database usage
Skills
Key technologies and capabilities for this role
Questions & Answers
Common questions about this position
What experience level is required for this Senior PostgreSQL Database Engineer role?
Candidates need 5+ years working as a PostgreSQL DBA, along with hands-on daily experience with Linux OS.
What key PostgreSQL skills are required for this position?
Expert knowledge of PostgreSQL management including high availability (esp. Patroni), CDC, security, replication, maintenance, version upgrades, disaster recovery, performance tuning, and query optimization is required.
Is this a remote position, or is there a specific location requirement?
This information is not specified in the job description.
What is the salary or compensation for this role?
This information is not specified in the job description.
What soft skills or qualities make a strong candidate for this role?
Excellent communication and collaboration skills to work with developers and infrastructure teams, an engineering mindset for troubleshooting and root-cause analysis, and the ability to evangelize PostgreSQL best practices are key.
BTIG
Institutional sales, trading, and investment banking services
About BTIG
BTIG provides institutional sales and trading services, offering equity sales and trading, electronic trading, outsource trading, and corporate access. The firm's core capabilities include investment banking, global sales, electronic and outsource trading, prime brokerage, and research and strategy.
San Francisco, CaliforniaHeadquarters
2002Year Founded
VENTURE_UNKNOWNCompany Stage
Fintech, Financial ServicesIndustries
501-1,000Employees