What are the responsibilities and job description for the Senior Database Administrator( Oracle EBS) position at NextGen | GTA: A Kelly Telecom Company?
Description
- Install, configure, clone, and maintain Oracle E-Business Suite multi-node R12.2 environments (Production, Test, Development, DR)
- Perform EBS patching including AD, TXK, and Oracle PSU/CPU patches in Production and Non-Production environments.
- Migrate and administer EBS databases and application stacks to Microsoft Azure cloud.
- Administer Oracle Databases (19c) supporting EBS.
- Perform database upgrades, patching, backup, and recovery using RMAN and CommVault technologies.
- Provide support and troubleshoot issues related to Oracle Workflow, Application Desktop Integrator, Forms, OAF & Weblogic.
- Monitor concurrent manager jobs and assess performance related issues.
- Implement security best practices and maintain confidentiality on managed systems.
- Monitor, manage and resolve incoming Service Desk tickets.
- Ensure that availability service level agreement targets are met for production applications.
- Manage tablespaces, users, roles, and security.
- Responsible for setting up and maintaining Disaster Recovery environments of Oracle EBS databases and conduct DR drills.
- Monitor and tune database performance using AWR, ASH, and SQL tuning.
- Analyze and correct issues in real time, owning problem resolution from beginning to end.
- Perform scheduled maintenance and support release deployment activities after hours.
- Develop shell or Perl scripts for automation, monitoring, and reporting.
- Provide trend and growth analyses to aid in capacity planning and resource management.
- Participate in software deployment process; partner with development and support teams throughout the SDLC process.
- Act as team lead on projects, assisting with development of project plans and task lists.
- Share domain and technical expertise with others
- Evaluate and recommend emerging database technologies and methodologies.
- Other duties as assigned.
Supervisory Responsibilities: None
Education
- 4 Year / Bachelors Degree
- Bachelor's degree in computer science, Business, Engineering or equivalent work experience required
Experience
- Between 8 and 10 years of Database Administration and Oracle EBS Administration experience on Unix/Linux platforms.
- Strong knowledge of Oracle EBS R12.2 multi-node architecture.
- Experience with EBS migration and administration on Azure or cloud platforms.
- Experience with upgrading EBS application and database tiers.
- Strong Unix/Linux administration skills.
- Experience with monitoring tools including Oracle Enterprise Manager(OEM).
- Excellent troubleshooting and communication skills.