
POSTGRES DBA San Mateo, CA
Job description
Vindicia is a SaaS financial-based company and a leader in our market space. Offering enterprise-class subscription and recurring billing solutions, we are a billing engine behind household name companies. Vindicia combines cutting-edge customer acquisition methods with advanced customer retention technologies, while maintaining unmatched scalability.
We are a part of Amdocs, a multinational company. Amdocs is a leading software and services provider. Amdocs and its 25,000 employees serve customers in over 85 countries.
About you:
You are an experienced PostgreSQL DBA. You have deep knowledge in building, configuring, tuning and maintaining PostgreSQL databases that are running on Linux. You have a security mindset, continually maintaining databases to address new vulnerabilities and to keep them current. You have a curiosity to understand the applications that interact with your databases. You have a mindset and desire to work with others to deploy applications against your databases, improve performance, find issues and troubleshoot problems that may arise.
Requirements:
- Experience in designing, building, configuring and maintaining PostgreSQL databases on Linux
- Experience in creating, configuring and maintaining clustering with PostgreSQL databases
- Experience with databases supporting high volume, scalable, data-intensive systems
- Expert experience in performance tuning, query optimization, authentication, and partitioning
- Expert SQL scripting
- Experience with database security concepts, including access, auditing, and encryption
- Experience authoring scripts in Bash
- Experience with business continuity and recovery architecture processes
- Ability to learn how applications work by analyzing schema, querying data, and reviewing SQL
- Understanding of server hardware, including RAM, CPU, permanent storage, I/O, and other capacity related resources
- Experience in database capacity planning and forecasting
- Excellent visual, written, and verbal communications with the ability to intuitively put ideas into tangible form
- Must be able to participate in on-call rotation
Preferred skills:
- Experience with a high performance, low latency, 24x7x365 always-up, always available production PostgreSQL database environment
- Clustering PostgreSQL using Pacemaker and Corosync
- Experience with deploying, configuring and maintaining Postgres in AWS
- Experience in data sharding
- Linux administration experience
- Experience with Perl or Python
- Experience in one, or more, of PL/pgSQL , PL/Perl , PL/Python
We offer competitive salaries, a great working environment, and numerous other benefits. To apply send a cover letter and resume/CV in PDF format.
Job Type: Full-time
Experience:
- High Performance, low latency 24x7x365 alway up: 3 years (Preferred)
- Perl or Python: 3 years (Preferred)
- Forecasting: 3 years (Preferred)
- Shell Scripting: 3 years (Preferred)
- Business Continuity Planning: 3 years (Preferred)
- PostgreSQL: 3 years (Preferred)
- PL/pgSQL, PL/Perl, PL/Python: 3 years (Preferred)
- running on Linux: 3 years (Preferred)
Work authorization:
- United States (Preferred)
Additional Compensation:
- Commission
