Database Consultant

Job Description

About the role

Deploy and operate Oracle IT systems within the Equant MHS Data centers. Perform regular day to day database operations including; Problem Resolution, Upgrades and Maintenance, Backups, Performance Monitoring and Tuning.

Incident Management:

– Diagnose and fix database errors ; ensure solution is permanent i.e. adjust scripts or report to application owner the root cause and how to permanently resolve it
– Maintain physical integrity (i.e. managed by the database engine) of databases ; this includes restoring database contents when necessary from either export files or physical backup files – please note that data integrity (referential or functional relationship between records) is NOT under DBA responsibility.
– Perform post mortems analysis (i.e. find and document root cause) for every outage that had an impact to QoS

Change Management:

– Run change requests on target databases ; this may include physical model changes (DDL – data definition language) and data modification (DML – data manipulation language) ; collect and return completion status to requester
– Migrate databases to upper releases including data transfer ; propose best method to transfer data
– Participate in system evolution and attend development meetings when requested.

Performance Management:
– Run, analyze and report on database performances for applications class A/B or defined as critical to Equant business

Other Tasks / Requirements:

– Design and run export procedures for refreshing QA environments
– Design, document and maintain databases operation procedures
– Be involved in the "Equant Problem Management" process for database issues
– Specify needs on core services and tools (Monitoring, Statistics, Reporting,…)Proactively check available vendor patches and inform Equant of potential risks or security holes
– Function as a member of a dynamic team supporting a complex and diverse enterprise Oracle/Sybase/MS Sql Production environment
– Be able to work efficiently with minimal supervision, manage a diverse workload, work release schedules (May be out of hours) where required, and participate in Production system on-call rotation
– Provide IT customers with a seamless and efficient Global Surveillance & Restoration service as outlined within Service Level Agreements (SLAs)
– Provide accurate and timely KPI reporting