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 end-users 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 o o o o 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
