**38975BR** **Requisition ID:** 38975BR **Business Unit:** COR **Job Description:** Job Description: Seeking an Senior 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. Additional Knowledge on SQL DBA preferred • Application development (PowerShell, VBScript, SQL). • Experience managing large scale SQL Server 2014 and higher environments in a virtual/cloud environment. • Expert knowledge of Microsoft SQL Server Database Administration for SQL Server versions 2014 up to the latest version. Includes but not limited to installs, upgrades, server and database migrations and troubleshooting. Knowledge of Windows Failover Clustering for SQL Server AlwaysOn High Availability groups and Mirroring is preferred • Expert knowledge in Microsoft SQL Server Database related products such as Integration Services (SSIS) and Reporting Services (SSRS) Minimum Qualifications: • Bachelor’s degree or equivalent (CS, CE, CIS, IS, MIS or engineering discipline). • 5 - 8 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. **Job Title:** Senior Database Administrator **Group:** COR **Employment Type:** Regular **Minimum Qualifications:** Bachelor's degree. 5 years of related experience. Domestic and/or international travel may be required. The frequency of travel is contingent on specific duties, responsibilities, and the essential functions of the position, which may vary depending on workload and project demands. Equivalent additional directly related experience will be considered in lieu of a degree. **Why CDM Smith?:** Check out this video and find out why our team loves to work here! (https://www.cdmsmith.com/en/Video/Meet-CDM-Smith) **Join Us! CDM Smith – where amazing career journeys unfold.** Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co-workers are invested in you and your success. Where you are encouraged and supported to do your very best and given the tools and resources to do so. Where it’s a priority that the company takes good care of you and your family. Our employees are the heart of our company. As an employer of choice, our goal is to provide a challenging, progressive and inclusive work environment which fosters personal leadership, career growth and development for every employee. We value passionate individuals who challenge the norm, deliver world-class solutions and bring diverse perspectives. Join our team, and together we will make a difference and change the world. **Job Site Location:** India - Bangalore / Chennai **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. **Amount of Travel Required:** 0% **Assignment Category:** Fulltime-Regular **Background Check and Drug Testing Information:** CDM Smith Inc. and its divisions and subsidiaries (hereafter collectively referred to as “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.