Description

Manage and optimize PostgreSQL and Oracle database environments, ensuring high availability and performance.

Responsibilities

• Manage database backup and restore operations using pg_dump, rman, and physical backup tools.
• Perform database performance tuning and SQL query optimization.
• Configure and maintain replication via Goldengate and manage failover processes.
• Collaborate with data architects to design conceptual data models, data flows, and physical data models.
• Implement data strategies, security protocols, authentication models, and data encryption.

Required Skills

• 8+ years of relevant experience in database administration.
• Expertise in Oracle and PostgreSQL administration.
• Strong proficiency in SQL and query development.
• Experience with replication (Goldengate) and failover implementation.
• Proficiency in scripting and task automation using Bash, Python, and SQL.
• Experience using Git for version control.
• Solid understanding of application design and development patterns for database access.

Preferred Skills

• Experience with other RDBMS such as SQL Server or DB2.
• Experience with NoSQL databases like Couchbase or MongoDB.

Key Skills

Education

Any Graduate