Oracle Database Administrator - Madrid, España - IFS

    IFS
    IFS Madrid, España

    hace 1 mes

    Default job background
    De jornada completa
    Descripción

    Job Description

    The Database Administrator role in the Database Services Team is responsible for the overall delivery of the Oracle Database-related pieces for all the applications within the IFS Cloud Suite. Additionally, the role is expected to cover a 24/7 shift pattern as well as support customers in different continents, including EURA compliance.

    The responsibilities include:

  • Daily DB Operations Follow common and documented processes in day to day duties supporting and maintaining our Database services. Act as a DBA resource to help perform some of those daily duties when the need arises to address issues with client systems Act as a final point of escalation for challenging issues with our database services Work as needed to support internal and external teams during investigations and corrective actions during problem management investigations. Work with R&D alongside the CSA to provide guidance and feedback to improve the IFS product set in future releases.
  • Backup Solutions Implement agreed backup solutions for the IFS Application suite to satisfy our own and our customers' needs
  • Performance Tuning Follow best practices and approaches to manage performance issues in our Cloud database environments Work with the CSA and R&D teams to address performance issues through both short term and long-term methods
  • Disaster Recovery Implement and test regularly, in conjunction with the CSA and RnD teams, any agreed disaster recovery solutions and ensure the solution suits the needs of IFS and our customers
  • Monitoring Implement appropriate tooling to monitor and manage the database availability within our cloud database services. Follow processes in place to manage availability issues in production environments.
  • Automation and Tooling Work with the CSC, CSA and Automation teams to automate and reduce time and overhead for common tasks wherever possible.
  • Training and skills transfer Deliver DBA knowledge transfer/training sessions to selected internal teams if required.

    • Qualifications

    Experience

  • MandatoryAt least 2-3 years' experience performing Oracle Database administration functions in cloud computing or enterprise IT service deliveryDemonstrated knowledge of cloud computing services or IT service management methodologies and best practicesExperience in a modern ticket/service desk tooling such as ServiceNow, Jira Service Desk or a similar tool
  • Value AddExperience in ITIL, ISO 20000 or a similar service delivery frameworkExperience in provision of cloud computing services or IT service delivery

    • Certifications

  • A formal qualification (degree, HND, etc.) in Computer Science/Information Technology is useful but not mandatory.
  • ITIL qualifications would be useful but are not mandatory.
  • Vendor provided technical certification (CCNA, OCP, MCSA, etc.) would be useful though not mandatory.

    • Personal Abilities

  • Citizens of the European Union or a corresponding work permit in Poland
  • Excellent communication and interpersonal skills including a business fluent English
  • Ability to work to deadlines, targets and needs of the role
  • Ability to manage own time, efficiently and effectively

    • Technical Skills

  • Experience of implementing and managing critical production systems, especially in the cloud, including a strong awareness of customer-driven priorities and commercial pressures is essential.
  • Experience of supporting multi-tenant Oracle databases (CDB/PDB)
  • Experience administering Oracle databases (minimum 12c) on Linux and Windows operating systems
  • Some technical experience with performance tuning - AWR/ASH/ADDM/TKPROF/tracing sessions, etc – in a multi-tier architecture
  • Good technical experience using OEM for various database administration purposes.
  • Good technical experience with backup/restore – RMAN, data pump export/import.
  • Knowledge of disaster recovery; dataguard – setup and troubleshooting.
  • Experience with database cloning – RMAN active duplicate
  • Some technical experience linux shell scripts: bash (knowledge of powershell scripting and windows command also nice to have)
  • Experience with database upgrades (12c to 19c and above) and patching
  • Experience working within a strict ticketing system, such as Service Now, JIRA, etc
  • Basic understanding of Cloud Technologies – Azure, AWS or GCP

    • The following skills and exposure are not essential but are very useful:

  • Knowledge of other database systems – Azure SQL, MS SQL Server, PostgreSQL, MySQL, etc.
  • Microsoft Azure PaaS ( App Services, SQL Database, Storage, Redis Cache, PostgreSQL), Event Hub, Automation, monitoring, Security Centre.
  • Network architectures, especially related to Microsoft Azure ( vNets, NSGs, VPN, ExpressRoute, SSL/TLS certificates, DNS).
  • Native Azure monitoring
  • DevOps Practices (Terraform, Chef and related tools), and how these are leveraged in design and operations to be able to deliver and support hundreds of instances seamlessly.
  • Familiarity with other SaaS Cloud solutions ( Salesforce, Office 365)
  • Security principles – encryption, authentication, authorisation, integrity, auditing, pen testing etc – and how these are applied in a cloud environment.

    • The successful candidate will have a proven track record working with a wide range of teams including operations, R&D, consulting and support services. They will work effectively in an internationally distributed, multi-discipline team and must be highly self-motivated and proactive, with excellent problem solving and communication skills.