Description

Manage, configure, and maintain PostgreSQL open-source databases while deploying applications to meet client requirements. Coordinate with developers, managers, and leadership to build effective database structures. Collaborate with product managers to ensure database code aligns with demand and define APIs alongside front-end developers. Monitor data structures and quality, integrating and maintaining database code through procedures, scripts, queries, and views.

Responsibilities

• Manage and maintain PostgreSQL and Oracle RAC databases.
• Coordinate with development teams to define APIs and ensure code quality.
• Monitor data structures, permissions, recovery, and security.
• Integrate database code using procedures, scripts, and views.
• Perform Oracle to PostgreSQL migrations using ORA2PG.

Required Skills

• 5+ years of database administration experience.
• In-depth knowledge of Oracle Database and PostgreSQL.
• Hands-on experience with Oracle RAC, Data Guard (DG), and GoldenGate.
• Proficiency with ORA2PG for Oracle to PostgreSQL conversions.
• Strong understanding of ETL concepts.
• Familiarity with PostgreSQL JSON support.
• Fluent English communication skills.

Preferred Skills

• Experience with DBMS management and optimization.

Key Skills

Education

ANY GRADUATE