Database Analyst (PostgreSQL)

Website ERT, Inc.

Position Description

Will guide an analysis to determine the level of effort and cost required to migrate applications and infrastructure from Oracle (Enterprise) RDBMS to equivalent capability hosted in PostgreSQL RDBMS;  Assess the complexity and dependencies for multiple database applications and determine the optimal migration path for each application; Identify an appropriate PostgreSQL database (server/cluster) architecture which will accommodate the application requirements in terms of performance; throughput and other scaling characteristics;  Identify which capabilities and functionality are not able to be replicated in PostgreSQL and the impact on re-factoring applications.


Required Skills

8-10 years of experience in Data Analysis.  All candidates must have knowledge of relational database technology; Oracle 11, 12; PostGreSQL 9.x; data modelling; query performance and tuning; PL/SQL (triggers, functions, stored procedures, packages etc.); partitioning and parallel query; materialized views and spatial data objects


Desired Skills

Knowledge of APEX development environment and methods desirable.


Must be a US Citizen or Permanent Resident and be able to pass a background investigation to obtain a security badge to enter the applicable government facility.



BS in Computer Science or related discipline, or equivalent.


Submit resume to ERT’s Career Opportunities Web Page at:


Earth Resources Technology, Inc. (ERT)

ERT is a VEVRAA Federal Contractor and Equal Opportunity/Affirmative Action employer – All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status.

To apply for this job please visit the following URL: →