CGS Federal (Contact Government Services)
PostgreSQL Database Developer
CGS Federal (Contact Government Services), San Francisco, California, United States, 94199
Overview
CGS Federal (Contact Government Services) is seeking a PostgreSQL Database Developer to join our team supporting 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.
Responsibilities
Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database
Create and maintain technical documentation, using defined templates, and 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 sufficient resources for 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
Work within a structured and Agile development approach
Qualifications
Bachelor's degree
Must be US Citizenship
7 years of experience with administering 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 and Commitment CGS is committed to solving challenging and dynamic problems. We value honesty, professionalism, and quality work, and offer a comprehensive benefits package.
Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (Health, Dependent Care, and Commuter)
Paid Time Off and Observance of State/Federal Holidays
Equal Opportunity Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
How to apply Join our team and become part of government innovation!
Explore additional job opportunities with CGS on our Job Board:
https://cgsfederal.com/join-our-team/
For more information about CGS please visit: https://www.cgsfederal.com or contact:
Email: info@cgsfederal.com
#J-18808-Ljbffr
Responsibilities
Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database
Create and maintain technical documentation, using defined templates, and 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 sufficient resources for 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
Work within a structured and Agile development approach
Qualifications
Bachelor's degree
Must be US Citizenship
7 years of experience with administering 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 and Commitment CGS is committed to solving challenging and dynamic problems. We value honesty, professionalism, and quality work, and offer a comprehensive benefits package.
Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (Health, Dependent Care, and Commuter)
Paid Time Off and Observance of State/Federal Holidays
Equal Opportunity Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
How to apply Join our team and become part of government innovation!
Explore additional job opportunities with CGS on our Job Board:
https://cgsfederal.com/join-our-team/
For more information about CGS please visit: https://www.cgsfederal.com or contact:
Email: info@cgsfederal.com
#J-18808-Ljbffr