Contact Review prides itself on finding high-quality, high-accountability, barred attorneys specifically tailored to the needs of our project. Assists with document review, privilege review, expert testimony, legal research, and foreign language translation Fosters a culture where every team member sees themselves as an extension of the project's team Looks for ways to improve efficiency and streamline workflows
PostgreSQL Database Developer
Location
United States
Posted
9 days ago
Salary
Not specified
Job Description
Role Description
CGS 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.
- 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
Qualifications
- 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
Requirements
- 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
Job 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
- Health, Dental, and Vision
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- Paid Time Off and Observance of State/Federal Holidays
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Database Administrator DB2 (zOS) - Virtual
Alight SolutionsAlight Inc. (NYSE: ALIT) is a leading cloud-based human capital technology and services provider
The role is responsible for the installation and management of the z/OS DB2 system, application objects, and program products, including disaster recovery planning for these components. Duties also involve providing DB2 Database design, implementation, configuration, planning, SQL coding/tuning, and offering Level 2/3 support for all DB2 for zOS issues.
SQL Server Database Administrator
RESPECAchieving the impossible. Transforming our clients' visions into reality.
SQL Server DBA maintaining a performance-driven application at RESPEC
Senior Database Administrator (Top Secret cleared)
IIIIIIUSICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals.
The role involves participating in all phases of the Software Development Lifecycle (SDLC) to design, develop, and maintain secure, mission-critical applications using Java, Kotlin, and TypeScript. Responsibilities also include developing and optimizing Oracle and SQL Server database solutions within AWS GovCloud environments.
The Senior Applications Database Administrator will manage the full database lifecycle, including installation, configuration, deployment, operations, upgrades, and management of database technologies across public cloud and traditional data centers. This role involves providing high-end technical DBA support, proposing performance enhancements, and managing Oracle EBS environments including patching and workflow administration.
