Responsibilities:
• Tune complicated Oracle DB queries
• Learn the DB design and recommend re-design if needed for better performance
• Excellent understanding of Oracle Optimizer, has a good knowledge and experience with most of the optimizer parameters and their effect
• Work with Development team to identify and resolve issues. Work with third parties as appropriate including opening service requests with Oracle
• Assist in developing our database monitoring strategy for proactive performance, tuning and high availability in a 24×7 production environment
• Lead and manage Development, Test, QA and Production databases and implementing future Oracle enhancements to meet the business needs of the end users
• Resolve locking conflicts/blocking and resource utilization
Requirements
• 5+ years of experience in Oracle SQL Tuning
• Proficient with recent Oracle database versions (19) and features
• Experience working with Oracle RDBMS 19c or above, Oracle RAC, Oracle TDE, Oracle Dataguard, Oracle CloudControl
• Experience with partitioning, replication, multi-level security, clustering, distributed transactions, OLTP & OLAP
• Database and application performance tuning
Advantage:
• Knowledge of AWS and other cloud solutions including Aurora, PostgreSQL and MongoDB
• Experience with AWS RDS solutions
Personal skills
• Team Player
• Flexible, open-minded, team player, with a friendly and pleasant personality
• Ability to manage, prioritize and solve problems quickly and completely
• Willing to work occasionally in nonstandard working hours (nights or weekends)
• Excellent written and verbal English
• Good communication skills
• Problem solving skills are a must