Description

Manage and optimize PostgreSQL and Oracle database environments in Phoenix, AZ.

Manage database backup and restore operations using pg_dump, RMAN, and physical backup tools. Perform database performance tuning and SQL query optimization. Manage replication via GoldenGate and handle failover processes. Collaborate with data architects to design conceptual, data flow, and physical data models. Implement data strategies and ensure database security through authentication models and data encryption.

Responsibilities

• Execute database backup and restore operations using pg_dump, RMAN, and physical backup tools.
• Perform database performance tuning and SQL query optimization.
• Manage replication via GoldenGate and handle failover processes.
• Collaborate with data architects to design conceptual, data flow, and physical data models.
• Implement data strategies and ensure database security through authentication models and data encryption.

Required Skills

• 5+ years of relevant experience in PostgreSQL and Oracle DBA roles.
• Deep expertise in Database Administration and SQL.
• Proficiency in scripting and task automation using SQL, Bash, Python, and Git.
• Practical experience with database design and application development workflows.
• Strong understanding of database security and encryption protocols.
• Ability to communicate and collaborate with application development teams.

Preferred Skills

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

Key Skills

Education

Any Graduate