Red Zone Requirement Form
Job Title: Oracle / SQL DBA
Job Description
Our Client is currently splitting their Infrastructure team into 2 divisions, Build and
Support. Due to permanent personnel leaving and not being replaced and an increase in
activity there is a huge demand on the support team to continue and keep live systems
running. To cope with the demand, they are moving a DBA from the build team into
What is the business Support to aid with the extra work.
challenge that the client is
tasked with? A Oracle DBA resource is therefore required to be backfill the Oracle DBA moving
across and continue with the project work, which is mainly configuring and helping with
the infrastructure builds behind the SAP programme. There is also the chance to get
involved in the planning to phase of moving from Oracle 10g to 11i.
Purpose of the requirement: A database administrator (DBA) is responsible for the environmental aspects
(E.g. What will be the goals of the enterprise databases that support our customer
and objectives of the applications. In general this covers
person?)
Recoverability - Creating and testing backups
Integrity - Verifying or helping to verify data integrity
Security - Defining and/or implementing access conttrols to the data
Availability - Ensuring maximum uptime
Performance - Ensuring maximum performance given budgetary constraints
Development and testing support - Helping programmers and engineers to
efficiently utilise the database
Accountable for ensuring the database components of our client supported
systems provide the performance and availability required by the customer
businesses.
Define and agree backup and recovery requirements for all database services
Provide specialist Database Administration services to support the production
environment
Maintain the integrity of the production environment by controlling and managing
all database infrastructure changes.
Work with IT managers and architects to implement and maintain pertinent
standards and develop systems accordingly.
Identify potential service improvements from the capabilities and advances
provided by our client’s standard database technologies.
Technical support of problems associated with database services
Red Zone Requirement Form
Production support for the implementation of database services
Proven Physical Database design and implementation skills·
Involved in Technical Implementation and support for Oracle & SQL Server databases in
Windows, Linux and UNIX.(minimum 5 years experience)
Knowledge of UNIX Korn, Bourne and Bash shell scripting, PL/SQL and SQL.
Track record of good problem solving skills·
Applied Change Management processes to databases, and migrated changes across
quality environments for development, test and production. ·
Good communications skills·
Knowledge of SQL Server 7 to 2005, and Oracle 7 to 10i or above database
management systems ·
ITIL Foundation Certification
What are the day to day Job Desirable:
Duties of the individual:
Awareness or knowledge of Netbackup and RMAN an advantage.·
Awareness or knowledge of large multi Terbyte Unix based Oracle systems an
advantage.·
Awareness or knowledge of large SAP systems an advantage.·
Data modelling or Case tool knowledge an advantage.
OCP Certification
Other relevant information
May require on-call 24*7 cover and out-of-hours work.
Key focus on audit point implementation, hardening user-ids, protecting listeners
and improving software currency for the Oracle Db’s in the UK.
Level of Level of
Essential Desirable
Experience Experience
Technical skills &
competence required: Oracle 9i, 10G DBA 5 Years + SAP Knowledge 1 project
Please prioritise in order of SQL 2005 / 2008 DBA 3 Years Oracle 11i knowledge
importance.
Any additional screening n/a.
Red Zone Requirement Form
required for clearances.
(PES, SC, DV Etc)
Is it essential the candidate has previous
experience working in any particular
industries? Would it be beneficial for the It’s a nice to have to worked in a Retail environment before
candidate to have worked for any specific
company?
Type of Inter-personal skills required?
Someone whom can hit the ground running as projects are
Please describe the work environment and
already underway
company culture?
Well know retail client
Key selling points of the role: Chance of Extension – Our contractor has been there 15 months after
coming in on a 3 month contract.
