Oracle Support Administrator

Summary

Join Pythian as a Managed Operation Database Consultant and be part of a team providing comprehensive support for managed database and application infrastructure operations to diverse clients. You will coordinate, analyze, design, implement, and administer database solutions, recommend operational process improvements, and maintain servers. Troubleshooting operational problems, administering daily checks, responding to alerts, and communicating with customers and team members are key responsibilities. The role involves participation in shift patterns and on-call coverage. Opportunities exist to learn various database technologies and provide support. This position requires 3-7 years of DBA experience managing Oracle databases, including Oracle RAC, and a strong understanding of Oracle database technologies.

Requirements

• 3-7 years of DBA experience managing Oracle databases (including Oracle RAC) with good foundational understanding of Oracle database technologies
• Curiosity and tenacity to fully diagnose why something went wrong
• Troubleshooting and Performance Improvement Skills including index creation, query optimization, schema changes etc
• Understanding of database security management
• Experience managing logical & physical replication
• Knowledge of Oracle Data Guard and Golden Gate replication
• A basic understanding of Oracle Enterprise Manager or PostgreSQL pgAdmin console together with some Linux knowledge

Responsibilities

• Coordinate, analyze, design, implement and administer solutions as per need
• Recommend best practices for improvements to current operational processes
• Configure and maintain servers at database and Infrastructure level
• Troubleshoot operational problems
• Administer proactive database and infrastructure daily checks
• Respond to monitoring alerts
• Communicate status and planning activities to customers and other team members
• Participate in the team’s rotational shift pattern and on-call coverage rotation plan
• Opportunity to learn different database technologies and provide support

Preferred Qualifications

• SQL Server knowledge is advantageous being an additional skill set
• Knowledge of DevOps and Cloud AWS/AZURE/GCP

Benefits

• Competitive total rewards package with excellent take home salaries, shifted work time bonus (if applicable) and an annual bonus plan!
• Annual training allowance
• 2 paid professional development days
• 3 weeks of paid time off and flexible working hours
• Laptop with your choice of OS, and budget to personalize your work environment!