Job Description

:
Intermediate Applications Database Administrator: Seeking a Intermediate DBA for primary support of Oracle E-Business Suite environments and secondary support of OCI, AWS, SQL and third-party products. Candidate should exhibit technical proficiency at proactively supporting recoverable applications and databases in a 24/7 hosting environment. Individual must possess excellent verbal and written communication skills. Oracle E-Business Suite R12.2 Application Administration:
• Refresh Non-Production instances from Production. • Perform application patch analysis, install and resolve patch install issues. • Monitors environment to assure performance, stability & availability.
• Investigates and resolves problems. • Coordinate with deployment teams to promote code based on formal Change Management process to user test and production environments with minimal disruption to user productivity. • System Administration such as Oracle Workflow support, add new accounts or roles, set profiles and grant user privileges at appropriate levels of access. • Assist in installing new Products/Modules as per business requirement. Oracle Database Administration 12c: • Provide Production and Non-Production database access. • Backup, restore Oracle databases and resolve backup issues. • Coordinate with Security, Unix, Storage and Network teams in planning/executing DBA tasks. • Excellent experience in Oracle developer software tools like TOAD. • Patch analysis, planning and executing database patches after due testing and approvals. • Provide sizing/capacity planning recommendations.

• Perform database patch analysis, install and resolve patch install issues.
• Experience with Oracle DB Enterprise features like Oracle Grid/ASM, DataGuard (Physical/Logical Standby),

Multi-tenant DB (CDB/PDB)
Performance Tuning: • Identifying poorly performing Concurrent Programs/SQL queries and work with technical teams to tune SQL queries/procedures. • Diagnose and present effective solutions for application and database performance issues supported by empirical evidence. • Optimize the Database and Application Components and parameters for sustained performance and avoiding performance bottlenecks. • Review and generate database statistics.
Service Desk Support: • Triage, escalate and troubleshoot user issues and resolve service incidents. • Assist IT business analyst and development teams. • Create and manage Oracle Support service requests for database and application issues. • Assist in supporting third-party products and external interfaces.
Minimum Qualifications
Minimum Qualifications:
• Bachelor’s degree or equivalent (CS, CE, CIS, IS, MIS or engineering discipline). • 2.6 plus years of experience in Oracle EBS (11i & R12) Applications DBA support. • Strong experience in Oracle EBS as Oracle Apps DBA. Experience in upgrades, cloud migration and fusion applications is added advantage.
• Hands on working knowledge of database SQL commands and scripting. • Working experience in global rolled out environment will be an added advantage. • Basic knowledge of MS SQL Server database is desirable. • Experience in integrating/supporting 3rd party external applications • Available off hours for occasional critical support and maintenance
Assignment Category
Fulltime-Regular
Amount of Travel Required
0%
Background Check and Drug Testing Information
CDM Smith reserves the right to require background checks including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, CDM Smith may conduct drug testing for designated positions. Background checks are conducted after an offer of employment has been made in the United States. The timing of when background checks will be conducted on candidates for positions outside the United States will vary based on country statutory law but in no case, will the background check precede an interview. CDM Smith will conduct interviews of qualified individuals prior to requesting a criminal background check, and no job application submitted prior to such interview shall inquire into an applicant's criminal history. If this position is subject to a background check for any convictions related to its responsibilities and requirements, employment will be contingent upon successful completion of a background investigation including criminal history. Criminal history will not automatically disqualify a candidate. In addition, during employment individuals may be required by CDM Smith or a CDM Smith client to successfully complete additional background checks, including motor vehicle record as well as drug testing.
Agency Disclaimer
All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Recruitment Center Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith and any resume submitted to any employee outside of CDM Smith Recruiting Center Team (RCT) will be considered property of CDM Smith. CDM Smith will not be held liable to pay a placement fee.
Business Unit
COR
Group
COR
Employment Type
Regular