Postgres Architect Opening

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



** Open to remote workers. **

What is the specific title of the position? 

Senior PostgreSQL Database Administrator Consultant 


What Project/Projects will the candidate be working on while on assignment? 

The candidate will be working on the EDSS to Documentum migration project that involves postgreSQL as the backend database. 


Is this person a sole contributor or part of a team? 

The person is a part of the team but will be mostly be a solely contributor to analyzing, designing and standing up over 20 plus Production postgreSQL database for one of the largest ever document storage repositories in the world that involves billions of documents. 
The team is the regular development EDMS team that will be working in Documentum, but this person will be the sole contributor for postgreSQL 

 

We are looking for a postgres architect that would not only be able to migrate an Oracle database to Postgres, but build the engine from the ground up. This person will be the most senior DBA that has answers to all questions.


What are the top 5-10 responsibilities for this position?

1. postgreSQL Bi Directional Replication 
2. postgreSQL Database Analysis and Design 
3. postgreSQL Installation 
4. postgreSQL Performance Tuning for very high workloads (30k transactions per second) 
5. postgreSQL Database Partitioning 
6. postgreSQL Geo separated High Availability 



What software tools/skills are needed to perform these daily responsibilities?

1. postgreSQL 
2. Toad OR DB Visualizer or any similar tools 
3. Linux 
4. Docker Containers 


What skills/attributes are a must have?

1. postgreSQL with Certification is a must 
2. postgreSQL Development experience 
3. High availability hardcore experience 
4. Shell Scripting 
5. ODBC 


What skills/attributes are nice to have? 

1. May have written books or white papers on postgreSQL 
2. Java Skills 
3. Automation skills 


Where is the work to be performed? 

The entire engagement demands a very hands on Consultant who will be the sole contributor to postgreSQL. But the role can work remotely.  

Some of the functions the contractor will perform hands on are: 

- Standing up from scratch, managing and putting into production over 20 plus PostgreSQL Databases as Docker Containers 
- postgreSQL Bi Directional Replication 
- postgreSQL Database Analysis and Design 
- postgreSQL Installation 
- postgreSQL Performance Tuning for very high workloads (30k transactions per second) 
- postgreSQL Database Partitioning 
- postgreSQL Geo separated High Availability 

 

Best Regards,

 

Dillon Tang | Technical Recruiter | Apex Systems

4100 Newport Place Drive, Suite 410, Newport Beach, CA 92660

Office: 949.623.0003 | Fax: 949-623-0004

dtang@xxxxxxxxxxxxxxxxxx | www.apexsystems.com

 

This e-mail communication (including any attachments) may contain confidential information intended solely for the use of the intended recipient. If you are not the intended recipient, you should immediately stop reading this message and delete it from your system. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql Admin]     [PHP Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux