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, as well as gain an in-depth knowledge of the business data to propose and implement effective solutions
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, ensuring that they have sufficient resources allocated to support high resilience and speed.
Perform and assist developers in performance tuning
Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades
Create and maintain technical documentation using defined technical documentation templates, as well as gaining an in-depth knowledge of the business data to propose and implement effective solutions
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
Ideally, you will also have:
- 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

Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (Health, Dependent Care, and Commuter)
Paid Time Off and Observance of State/Federal Holidays

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 environmentsOra2PgAgile development

Soft Skills

collaborationtechnical documentationproblem-solvingcommunicationproactive monitoringorganizational skillsattention to detailadaptabilityanalytical thinkingstakeholder engagement

Certifications

Bachelor's degreePostgreSQL certificationAWS certificationOracle certification