Senior Oracle APPS DBA
NTT Corporation
- Hyderabad, Telangana
- Permanent
- Full-time
Oracle Database 11g,12c & 19c
Performance Tuning and Troubleshooting skillsWorking at NTTKey Roles and Responsibilities:
- Ensures that assigned Packaged Application technologies such as ERP, Middleware and other business critical software in the clients environment site is configured, installed, tested, and operational
- Performs necessary checks, apply monitoring tools and respond to alerts
- Identifies problems and errors prior to or when it occurs and log all such incidents in a timely manner with the required level of detail
- Assists in analyzing, assigning, and escalating support calls
- Investigates third line support calls assigned and identify the root cause of incidents and problems
- Reports and escalates issues to 3rd party vendors if necessary
- Provides onsite technical support to clients and provide field engineering services to clients
- Conducts a monthly random review of incidents and service requests, analyze and recommend improvement in quality
- Provides continuous feedback to clients and affected parties and update all systems and/or portals as prescribed by NTT
- Proactively identifies opportunities for work optimization including opportunities for automation of work
- May manage and implement projects within technology domain, delivering effectively and promptly per client agreed upon requirements and timelines
- May work on implementing and delivering Disaster Recovery functions and tests.
- 9+ Years of Experience in 11i , R12.1.3 and R12.2.x Administration
- Oracle EBS DBA - Strong Oracle Applications DBA with RAC, Performance Tuning, High availability architecture and OEM 13C required.
- Install, patch, configure, tune and maintain the Oracle E-business Suite 12 and 11g/12c/19c Oracle databases.
- Should have sound knowledge in Upgrades, Migrations, 19c Multi-tenant Databases and also E-business suite.
- Concurrent Manager/Requests management/troubleshooting
- PCP (Parallel Concurrent Processing)
- Maintain emphasis on current databases by integrating them into daily business activities. Collaborate with the app development team to devise and execute a strategy for enhancing performance, offering guidance throughout the process. Additionally, provide comprehensive support for EBS database administration tasks.
- Automation of some of the DBA tasks like Database health check reports/Possible monitoring Shell scripts if anything missing in the environment
- OEM 13c Enhancements and configure the EBS environments in OEM 13c, also performance improvements in OEM 13c
- Enhance the existing automation scripts like house cleaning /Audit purge scripts etc. and steam line the EBS Multi-Node end to end cloning.
- EBS Performance issues related to workflow and prepare a plan and implement the purge process if required
- Database performance tuning and SQL Query Tuning using SQL Tuning advisor, Auto trace, TKPROF, STATSPACK, AWR, ADDM, explain plan, OEM Cloud Control (12c and 13c)
- Physical (Hot/Cold) Backups using RMAN and Logical (Data Pump Export and Import, Regular Import & Export) backups
- Oracle 19c RAC database
- Installation, configuration, and administration of Oracle 11g (11.2.0.1 to 11.2.0.4) and 12c (12.1.0.2 and 12.2.0.1) and 19c Standalone and RAC Database servers
- Working knowledge on 3rd party integrations,Oracle SSO,SOA and Public Cloud will have added advantage.
- Excellent Communication Skills
- Ability to communicate and work across different cultures and social groups
- Ability to plan activities and projects well in advance, and takes into account possible changing circumstances
- Ability to maintain a positive outlook at work
- Ability to work well in a pressurized environment
- Ability to work hard and put in longer hours when it is necessary
- Ability to apply active listening techniques such as paraphrasing the message to confirm understanding, probing for further relevant information, and refraining from interrupting
- Ability to adapt to changing circumstances
- Ability to place clients at the forefront of all interactions, understanding their requirements, and creating a positive client experience throughout the total client journey
- Bachelor's degree or equivalent qualification in Information Technology/Computing (or demonstrated equivalent work experience)
- Certifications relevant to the services provided (certifications carry additional weightage on a candidate’s qualification for the role)
- Relevant certifications such as:
- Oracle Database 19c certified professional.
- Oracle Cloud Infrastructure Architect Professional
- 9 years of work experience
- Seasoned experience required in Engineering function within a medium to large ICT organisation
- Seasoned experience of Managed Services
- Excellent working knowledge of ITIL processes
- Excellent experience working with vendors and/or 3rd parties
- Seasoned experience managing Packaged Application technologies such as ERP, Middleware and other business critical software