Job Purpose:

The IT Cloud Specialist is an information technology (IT) professional that leads the design, analysis, implementation, maintenance and ongoing support for company software and ERP (Enterprise Resource Planning) Systems databases hosted on premises and on oracle cloud. The position will be responsible for the installation, configuration, maintenance, upgrade and performance tuning of Oracle and MS SQL Server and other databases within Oracle Cloud Infrastructure (OCI) and On-premises. You will be responsible for managing the oracle cloud infrastructure and all applications and databases on OCI and on-premises. You will work closely with development teams to support multiple environments and ensure database availability, security, and performance. It will also include managing ongoing business Change Requests to application functionalities. This includes defining users and enabling data distribution to the right user on database levels while developing and maintaining database architectures, security, implementations, backups, high availability, reliability and efficiency. The IT Cloud Specialist will also be instrumental in the design and implementation of cross systems integrations.

Job Description:

• Experience in Oracle and Microsoft SQL server Database Installation, upgrade, Configuration, Maintenance, Cloning, Patching and Database troubleshooting and Oracle EBS 12.2 Application maintenance, cloning, upgrade and patching etc.
• Managed and optimized OCI resources, architecture and workloads to ensure cost-efficiency & performance.
• Implemented security best practices to ensure the confidentiality and integrity of data on OCI.
• Conduct performance tuning and capacity planning to optimize OCI resources.
• Participated in disaster recovery planning and testing for OCI environments.
• Provide users database integration support on ERP systems and databases.
• Create and maintain reliable application hosting environments (on-premises and on OCI in close coordination with System Administrators.
• Ensure IT Service Desk tickets assigned to yourself are closed within SLA’s avoiding escalations
• Perform out-of-hours visits (possibly on weekends) to sites or data centers to perform any maintenance activities or troubleshooting as required by the IT department.
• Ensure a successful Change Management process is in place and followed.
• Ensure IT processes are followed and request forms for services are properly filled, processed, and filed.
• Ensure Customer Satisfaction is of a high standard, and any escalations are resolved in a professional manner that is satisfactory to the business/users as appropriate.
• Assist and participate in innovation and standardization initiatives and documentations required.

Skills

• Bachelor’s Degree in Information Technology
• Certification & Experience in Oracle EBS Apps DBA, MS SQL Server DBA & Oracle Cloud architecture experience 
• Oracle DBA certified professional and Oracle cloud architect (Preferred)
• 5 Years experience as an Oracle Apps DBA, Microsoft SQL server DBA with proven hands-on experience in database administration and testing methodologies, Integrations and Data Mapping activities.
• Oracle cloud infrastructure architect with sound experience of managing independently. Minimum 2 Project Implementations of database upgrade. 
• Must have experience in PL/SQL Queries, shell scripts, procedures/packages, API etc. 
• Hands on experience working with database integrations with other databases. 
• Solid capabilities of managing application and database security and licensing requirements. 
• An advantage would be previous exposure to Airline ERP Systems.
• Graduate, Oracle EBS Apps DBA, MS SQL Server DBA & Oracle Cloud architecture experience 
• Oracle DBA certified professional and Oracle cloud architect (Preferred)