Postgres DBA Job Description

Postgres DBA Job Description Template

Our company is looking for a Postgres DBA to join our team.

Responsibilities:

  • Develop simple and complex stored procedures, functions and views to meet enhancement requirements;
  • Provide best practice guidance to the development team with regard to database design and usage;
  • Develop automation technologies to expedite the process of loading data into the end target;
  • Develop ETL strategies for integrating data from multiple sources in data warehouses;
  • Design and develop relational databases;
  • Develop appropriate corrective actions to resolve production data issues;
  • Design database schema to meet new enhancement requirements;
  • Optimize database performance;
  • Develop ETL strategies for integrating or migrating data from multiple sources.

Requirements:

  • Demonstrated experience writing complex stored procedures and queries;
  • Proven experience troubleshooting and solving complex databases schemas/warehouses;
  • Understanding and experience of Software Development LIfe Cycle;
  • Strong analytical and communication skills;
  • Bachelor’s degree preferred;
  • Experience in database development, administration and management;
  • Proven experience using ETL for data integration;
  • Proven experience with integration from oracle to postgres;
  • Proven experience with intregration from oracle to postgres.