Citizen
Full Time
Direct Hire
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 8th Jul 2022
About the Role: The Senior Oracle Apps DBA will assist in providing Database administartion support for Morningstar Oracle Applications and Oracle E-Business Suite.
This individual will help installing/deploying new databases as well servers as per the Morningstar product team requirement. This individual will help in standardize Database Administration including the operating model, practices, procedures, and technologies. This position is based in our Mumbai location.
Qualifications Mandatory technical skills - A minimum of 5 years work experience in Oracle R12 with at least 1 year of work experience in Oracle R12 12.2.x version (12.2.8, 12.2.9 or 12.2.10 etc.) on the Linux platform.
Must be very hands-on in Oracle EBS 12.2.x rapidclone (EBS cloning) procedures for refreshing test instances.
Must be very hands-on in using the dual file system concept of Oracle EBS 12.2.x
Must be very hands-on in using Oracle R12 tools such as adop (online patching tool), adadmin (AD administration tool) etc.
A minimum of 7 years work experience in Oracle database administration (11g R2/12c R1/19c).
Must be very hands-on in Oracle database backup and recovery, database restores and duplication using RMAN tool.
Ability to perform Oracle database tuning (both SQL tuning and overall database tuning). - Intermediate level experience in Oracle PL/SQL database programming.
Intermediate level experience in Linux shell scripting. - Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. - Act as a subject matter expert (SME) for Oracle Applications DBA work.
Ability to work with cross-functional team members belonging to IT Infrastructure, Information Security, Network, Storage etc. in articulating and convincing Oracle requirements. Soft skills and educational qualifications
A Bachelors degree or above in Computer Science. - Easy to understand and detail oriented technical documentation skills. - Detail oriented, well organized and self-motivated.
A polite and respectful attitude towards team members.
A strong sense of urgency and adherence to project/task timelines.
Should be willing to work on some weekends (or) late night hours to support production maintenance tasks (or) urgent timelines.
Should follow Oracle DBA best practices set by Morningstar Oracle DBA tech lead (or) DBA manager.
Fast learner and should be able to take ownership at work. Execute a task/project from start to end independently.
Nice to have - Amazon Web Services (AWS) - Vertex O-Series web administration. - Vertex Indirect Tax Returns. - Oracle Automatic Storage Management (Oracle ASM) and Oracle Data Guard. - Backup and Recovery with CommVault.
Job Responsibilities
The Applications Database Administrator will clone, patch, and support Oracle applications in a Linux environment.
Excel at working under demanding project timelines, while producing high quality work.
Perform backup and recovery of Oracle 19c and 12c databases using both RMAN and user managed methods.
Perform performance tuning of Oracle database and E-Business suite applications.
Perform installations and upgrades of Oracle database software.
Perform Oracle R12 test instance refreshes (Oracle Apps cloning procedures) from production backups.
Work with Oracle Support for system issues that require product support. Log service cases and follow up for resolution as required.
Work with the onshore DBA to manage and maintain the application suite.
Work with business resources to assist with system issues or walk them through product issues.