Chief Technologies, LLC Hiring for Senior Architect/Solution Architect Job at Remote Full Time

Chief Tech is seeking a passionate PostgreSQL Database Developer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions that empower our federal customers. You will support a migration from the current Oracle database to a Postgres database and manage the database environments proactively. As we continue our growth, you will play a key role in ensuring scalability of our data systems.

Primary Duties

• 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

Required Skills

• 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

Desired Skills

• 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

Job Types: Full-time, Contract

Pay: $70.00 – $80.00 per hour

Experience level:

• 6 years

Schedule:

• 8 hour shift
• Monday to Friday

Experience:

• PostgreSQL: 6 years (Preferred)

Work Location: Remote