CGS Federal (Contact Government Services) ยท 4 months ago
PostgreSQL Database Developer
Rockville, MD
Full-time
Hybrid
Senior Level
$107K/yr - $145K/yr
7+ years expCGS Federal is seeking a PostgreSQL Database Developer to support their Data Analytics and Business Intelligence platform for federal customers. The role involves migrating from Oracle to Postgres databases and ensuring the performance and availability of database systems.
ConsultingInformation TechnologyLegalProfessional ServicesProject ManagementSoftware
No H1B
U.S. Citizen Only
Responsibilities
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
Qualification
Required
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
Preferred
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
Company
CGS Federal (Contact Government Services)
Contact Government Services strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Anthony Miller
Partner, President of Operations
Brian York
Partner, President of Strategy
Company data provided by crunchbase