Support a migration from the current Oracle database to a Postgres database and manage the database environments proactively
Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database
Create and maintain technical documentation, using defined technical documentation templates
Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements
Ensure the availability and performance of the databases that support our systems
Perform and assist developers in performance tuning
Proactively monitor the database systems to ensure secure services with minimum downtime
Improve maintenance of the databases to include rollouts, patching, and upgrades
Work within a structured and Agile development approach

Requirements

Bachelor's degree
Must be US Citizenship
7 years of experience with administrating PostgreSQL Databases in Linux environments
Experience with setting up, monitoring, and maintaining PostgreSQL instances
Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes
Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool
Experience implementing and maintaining data warehouses
Experience with AWS RDS for PostgreSQL
Experience with Oracle databases
Experience leveraging the Ora2Pg tool
Experience with working in cloud environments such as Azure and/or AWS
Prior federal consulting experience

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PostgreSQLOracle databaseLinuxdatabase administrationperformance tuningbackup and disaster recoverydata warehousingcloud environmentsmigrationOra2Pg

Soft Skills

collaborationtechnical documentationproblem-solvingproactive monitoringcommunication

Certifications

Bachelor's degreeUS Citizenship