Oracle DBA - Performance Subject Matter Expert

Oracle DBA - Performance Subject Matter ExpertThis role has been designed as ‘Hybrid’ with an expectation that you will work on average 2-3 days per week from an HPE office.

Who We Are:

Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We help companies connect, protect, analyze, and act on their data and applications wherever they live, from edge to cloud, so they can turn insights into outcomes at the speed required to thrive in today’s complex world. Our culture thrives on finding new and better ways to accelerate what’s next. We know diverse backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good. If you are looking to stretch and grow your career our culture will embrace you. Open up opportunities with HPE.

Job Description:

HPE Operations is our innovative IT services organization. It provides the expertise to advise, integrate, and accelerate our customers’ outcomes from their digital transformation. Our teams collaborate to transform insight into innovation. In today’s fast paced, hybrid IT world, being at business speed means overcoming IT complexity to match the speed of actions to the speed of opportunities. Deploy the right technology to respond quickly to market possibilities. Join us and redefine what’s next for you.
Position Overview: We are seeking a highly skilled and experienced Oracle Database Administrator (DBA) Performance Subject Matter Expert (SME) to join our team. As an Oracle DBA Performance SME, you will play a crucial role in optimizing the performance, reliability, and security of our Oracle database systems. Your expertise will be essential in maintaining and enhancing the overall efficiency and effectiveness of our database environment.

What you'll do:

• Work with a team that supports large number of Oracle databases.
• Participate in management, prioritization, minor enhancements / fix activities, problem management, stability analysis, etc.
• To be proactive in nature thus identifying problems in advance and looking for continuous service improvements.
• Min 10+ years of experience in Oracle database administration in production environments on Unix, Windows and Linux OS.
• Capable of performing Database Administration tasks independently in Oracle 10g, 11g, 12c and 19c.
• Analysis of technical issues and permanent fix/solution.
• Implementation of RAC, ASM, Data Guard for database failover between Data center and DR site, perform switchover /failover activities.
• Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• All above applicable to infrastructure which has standalone and RAC databases using file-system based or ASM based storage.
• Provide capacity planning and performance monitoring of our database environments.
• Support, administer and maintain production and non-production database environments.
• Implement and maintain proactive database monitoring.
• Work with engineering and application support teams to identify, triage and resolve performance issues. This requires the ability to analyze, optimize and tune complex SQL queries.
• Deploy and maintain high availability and failover technologies such as Active Data Guard, RAC.
• Create, clone and upgrade database environments to support implementation activities.
• Define, implement and support database backup and recovery policies using RMAN and/or storage replication technologies.
• Working knowledge of ITIL processes.
• Perform database restoration and recovery in the event of a failure.
• Ensure sensitive data is appropriately protected via industry standard encryption solutions.
• Contribute to, and update, systems documentation as required.
• Participate in providing 24x7 support on rotational basis to ensure operations of these critical systems for different customers.

What you need to bring:

Experience Required:
• 10 years in Database Management
• Minimum 5 to 8 Implementation cycle (individual contributor)
• Adoptive for 24x7 Shift Support
• Excellent spoken and written English Communication.
• Good attitude towards corporate environment.
• Hands on experience in Operations and Support of Oracle RDBMS 11g,12c and 19C.
• Team player & Mentor to the team.
• Energetic, self-motivated and self-sufficient in accomplishing tasks.
• Good analytical and problem solving skills.
Must Have:
• Must have implemented and supported mission critical systems providing 24X7 support.
• Must have excellent shell scripting skills.
• Must have proven experience in tuning databases and queries.
• Can drive projects to get the projects accomplished with superior results.
• Must deliver winning results and take accountability for your actions.
• Must be an expert in diagnosing and solving complex problems.
•Must have very good oral and written communication skills and have the ability to influence others.
• Must have 10+ years of Oracle database related work experience.
• Must have a BS or MS in Business, Computer Sciences, Engineering or related field (an equivalent combination of related education, training and experience may be considered).
• Deep understanding of Oracle DBMS 11.2,12c and 19C.
• Must have a deep understanding of Oracle Grid/RAC, Oracle Partitioning, Oracle CIS Security Standards, Oracle Enterprise Manager
• Must understand Oracle performance tuning techniques.
• Deep understanding of database replication using the following technologies: Oracle Active Data Guard, Oracle Golden Gate related data replication products. 
• Significant experience with HP-UX, Linux (RHEL).
 

Preferable:
• Knowledge in MSSQL/MySQL/PostgreSQL RDMS
• Solutioning towards Database requirement not limited to Oracle.
• Should have Hands on Experience in monitoring and management tools.
• Strong in preparing Knowledge Base Documents & SOP
• Good in ITIL/ITSM Process – Incident, Service Requests, Change Management & Problem Management
• Strong in adopting the SLA Governance.
• OCA/OCP Certified.
 

Technical Skills:
• S/he will demonstrate an in depth understanding of several products in more than one functional area involving usage, configuration, and interaction with other products.
• S/he must possess a balance of very well-developed troubleshooting, technical communication and written skills along with extensive product knowledge and skills. 
• Candidate should have excellent technical communication skills both verbal and written.

Interpersonal Skills: 
• Be professional in all modes of interaction with our internal & external customers.
• Be capable of making well founded decisions in high pressure situations & exercising diplomacy when operating in politically charged environments.
• Actively listen and confirm problem details showing empathy for urgent situations 
• Utilize effective negotiation skills which will lead to satisfactory issue resolutions.

Additional Skills:

Accountability, Accountability, Action Planning, Active Learning (Inactive), Active Listening, Bias, Business Growth, Business Planning, Coaching, Commercial Acumen, Creativity, Critical Thinking, Cross-Functional Teamwork, Customer Experience Strategy, Customer Solutions, Data Analysis Management, Data Collection Management (Inactive), Data Controls, Design Thinking, Empathy, Follow-Through, Growth Mindset, Intellectual Curiosity (Inactive), Long Term Planning, Managing Ambiguity {+ 5 more}

What We Can Offer You:

Health & Wellbeing

We strive to provide our team members and their loved ones with a comprehensive suite of benefits that supports their physical, financial and emotional wellbeing.

Personal & Professional Development

We also invest in your career because the better you are, the better we all are. We have specific programs catered to helping you reach any career goals you have — whether you want to become a knowledge expert in your field or apply your skills to another division.

Diversity, Inclusion & Belonging

We are unconditionally inclusive in the way we work and celebrate individual uniqueness. We know diverse backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good.

Let's Stay Connected:

Follow @HPECareers on Instagram to see the latest on people, culture and tech at HPE.

Job:

Services

Job Level:

Expert

HPE is an Equal Employment Opportunity/ Veterans/Disabled/LGBT and Affirmative Action employer. We are committed to diversity and building a team that represents a variety of backgrounds, perspectives, and skills. We do not discriminate and all decisions we make are made on the basis of qualifications, merit, and business need. Our goal is to be one global diverse team that is representative of our customers, in an inclusive environment where we can continue to innovate and grow together. Please click here: Equal Employment Opportunity.

Hewlett Packard Enterprise is EEO F/M/Protected Veteran/ Individual with Disabilities.

HPE will comply with all applicable laws related to employer use of arrest and conviction records, including laws requiring employers to consider for employment qualified applicants with criminal histories.