[Hiring] Oracle Database Consultant @Pythian

Role Description

As a Database Consultant you will work as part of Pythian's Oracle team and supply complete support for all aspects of database and application infrastructure to a variety of our customers. Our collaborative environment means everyone works together to solve complex puzzles and develop innovative solutions for our customers.

What you will be doing:

• Database Management & Technical Expertise:
• Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance.
• Infrastructure Analysis & Improvement:
• Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures.
• Ensure maximum uptime and recoverability for all databases.
• Backup & Disaster Recovery:
• Administer backup procedures and disaster recovery plans.
• Proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems.
• Data Integrity & Recovery:
• Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases.
• Action Plan Development:
• Develop and review action plans for maintenance, deployment, and upgrades.
• Ensure all relevant client documentation is completed.
• Maintain a thorough understanding of client information, including warnings, handoffs, and briefing notes.
• Data Architecture:
• Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation).
• Perform data transformation and migration using scripts or stored procedures.
• Problem Management:
• Lead problem management efforts by assessing incidents for recurring patterns.
• Design technical procedures for regular requests and changes.
• Develop/review action plans and associated documentation.
• Oncall:
• Participate equally in the team’s on call rotation, typically one weekend per month.
• Client Engagement & Communication:
• Client Commitments: Make, manage, and meet client commitments in collaboration with team members.
• Reporting & Communication: Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries.
• Client Alignment: Maintain alignment with client operating procedures, including change control, and manage client allotments.
• Technical Client Affinity: Take on technical client affinity as assigned by the Team Manager.
• Process Improvement:
• Participate in and, at times, lead efforts to suggest, recommend, and potentially design/implement new monitoring checks and enhancements to DBC toolkits.
• Focus on initiatives that increase the value Pythian provides to clients.

Qualifications

• Knowledge and experience in installing, configuring and upgrading Oracle databases & tools relevant in Oracle Administration.
• Experience with automation technologies such as Ansible, Terraform, Puppet, Chef, SALT.
• Debugging skills and the ability to troubleshoot methodically.
• Very good documentation skills.
• Understanding of current IT service standards such as ITIL is a plus.
• Experience with cloud-native and managed database monitoring tools, including AWS CloudWatch, Google Cloud Operations (Stackdriver), and Azure Monitor.
• Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL.
• Experience migrating between on-premises and cloud-based databases.
• Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration.
• Experience in monitoring PostgreSQL databases using industry-standard tools such as Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Nagios and Datadog is an asset.
• Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP or Azure is considered an asset.
• Experience with scripting (bash/python) and software development (C++, Java, Go) is considered an asset.

Benefits

• Competitive total rewards package.
• Flexibly work remotely from your home, with no daily travel requirement to an office.
• Collaborate with some of the best and brightest in the industry.
• Substantial training allowance for skill development.
• All necessary equipment to work from home, including a laptop with your choice of OS.
• Annual wellness budget for health and well-being.
• Generous amount of paid vacation and sick days.
• Day off to volunteer for your favorite charity.