Hochgeladen von Nutzer10365

Postgre DBA Job Description

Job Title: Sr. Postgres DBA
Address the work will be performed: Remote
Target start date: 6/14
Length of contract assignment: 6-months. Good chance of extension
Work schedule/typical work week/daily start and end time:
8-5pm EST
Client description:
End client: Financial Services Technology firm
Project description:
End client is rolling out a new offering to its customers. This person will help full-time staff migrate some
of the databases.
Technology environment the consultant will be working in:
PostgreSQL, MySQL
Candidates day to day responsibilities:
This person will be tasked with joining the full-time staff of DBA’s and Architects to help upgrade and
migrate databases by:
Plan, install, and configure PostgreSQL database systems (i.e. PostgreSQL v9.x to v13.x and
EDB Postgres Advanced Server v9.x to v13.x) that meet business objectives and the needs of
Develop, implement, and test database backup and recovery plans
Troubleshoot and debug problems in existing database systems, and find new ways to
improve their speed, functionality, and scalability
Manage database and data security by controlling access to data through authentication,
authorization, and auditing
Perform tests to ensure database performance and security, as well as data integrity
Document and administer database policies, procedures, and standards
Participating in 24x7 on-call rotation and being available to perform weekend OS/DBA
maintenance activities on database servers
Required skills:
Experience as a Postgres DBA, with advanced hands-on knowledge of:
o Performance tuning, porting, and partitioning
o SQL Query Optimization
o Security
REPMGR v4.x or v5.x/EFM v3.x or v4.x
BARMAN v2.x/PgBackRest v2.x/BART v2.x
Pglogical v2.x/EDB XDB Replication v6.x
BDR Replication