Description

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

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