Oracle DBA L3This 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.
What you’ll do:
▪ Schema objects management
▪ Database objects re-organizations as required to manage the growth.
▪ Data movement such as import and export of data.
▪ Administration of user accounts & Administration of the concurrent managers.
▪ Routine system administration e.g., user access and security, profile options, menu management, data auditing, logs monitoring, password management. Patching, testing and cloning.
▪ Data growth Monitoring and action points including purging at regular interval.
▪ Database Server Resources Monitoring and action points.
▪ I/Os monitoring and management at file system level and disc level to optimize resources.
▪ Identifying the sudden spikes. Analysis of abnormal observation and action points to resolve them
▪ Monitoring inconsistence behaviour of database processes, scheduled jobs and take actions
▪ Table space management. Next Extent size management
▪ Incident’s logging and monitoring
▪ Management, application and verification of Oracle Patches.
▪ Conduct monthly and quarterly account reviews.
▪ Assistance with feasibility and proof of concept analysis and design for Customer planned IT projects that involve supported Oracle programs.
▪ Oracle program release planning
▪ Research information on problems/ questions posed by Customer production and development DBs.
▪ Evaluation of current backup, recovery and data replication procedures and work towards improvement of those procedures.
▪ Creation of new database instances and their support.
▪ Upgradation of database version from existing to latest recommended version in coordination with Customer domain owner.
▪ Database performance analysis and performance tuning.
▪ Logging, follow up, escalation of Oracle TARs and implementation of solution.
▪ Execution of queries/reports in the production database
▪ Schema Password Change Management
▪ Monitoring of applications, regular, scheduled and ad-hoc jobs as per requirement.
▪ Temporary database creation and management
▪ Problem Resolution and Root Cause Analysis
▪ Co-coordinating with other teams viz. Customer Application Team, Network Team, Storage Team, and Server Team, Helpdesk etc. to close the issue and provide countermeasures
▪ Preparing, presenting and executing action points at regular interval to control the data growth.
▪ Server Resources Monitoring and apprise the action points to Customer basis resource utilization trend DBA Team will be having the ownership of schema passwords of production databases.
▪ Change schema passwords as per password policy
▪ Keeping the service operating in the event of a fault.
▪ Running periodic diagnostics on the availability of systems and services.
▪ Monitoring, measuring and presenting IT service availability to Customer.
▪ Interaction with Application Team
▪ First Level Application Support for all applications deployed in Customer will be through applications team. DBA team will be reported any help required on database tuning or query optimization required.
▪ DBA Team will run the queries/ programs on the production databases as per the request of application team, monitor the same and provide the application team with the output.
▪ All the process documents created, and scripts deployed during the contract period will be property of Customer.
▪ Whenever any major or medium release is done, DBA team will monitor and track the effects of the release / deployment.
▪ Capturing the inefficiency of any database queries requested through the programs and coordinate with respective application team to resolve the issue.
▪ Knowledge of ASM, disk management, ASM rebalancing
▪ Oracle Data Guard, Oracle Active Data Guard
▪ SQL query tuning/profiling Oracle Apps (EBS) Administration (Preferred)
▪ Managing concurrent programs and reports
▪ Managing conflict domains
▪ Managing users
▪ Managing resource consumer groups and their hierarchies Configuration of multiple nodes Optimization of database performance and tuning.
▪ Monitoring of regular and scheduled jobs on ERP.
▪ Monitoring of regular and scheduled jobs on ERP and ensure improvement in coordination with Customer domain owner and respective application team
▪ Apps cloning and patching, troubleshooting
▪ Knowledge of ERP forms and RDF release in production environment
What you need to bring:
B.E. / B. Tech/BCA (On-Site), Relevant Certification (Preference).
8+ Years relevant experience, ITIL Certified, OEM Certified on Minimum One Technology
Technology: Oracle, Data Guard, RAC, RMAN, OEM
Certification: OCP (Oracle Certified Professional)
Team Management – should be able to manage the team of 10-12 resources
✓ Customer SPOC for Oracle Database Domain
✓ Communication and Problem-Solving - Excellent communication skills and the ability to visualize algorithmic structures.
✓ Process Knowledge – Incident, Change & Problem Management skills (should be able to perform RCAs for the Severity1 & repetitive incidents)
✓ Should have Collaborative approach, Adaptability
Technical Skills:
✓ RDBMS: Oracle 19c, 12c, 11g.
✓ Oracle Applications: Oracle Apps (EBS), Oracle Forms
✓ Operating systems: Linux, RHEL, IBM-AIX, HP-UNIX
✓ Tools & Utilities: Oracle Enterprise Manager (OEM), ITSM Tools (ServiceNow, Symphony SUMMIT), JIRA
Additional Skills:
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:
Job Level:
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.
اطلب مساعدة الخبراء لكتابة سيرة ذاتية مميزة.