Oracle DBA

Ref No. BHN535694
Salary £45,000 - £51,300/annum
Location Worthing, England
Job type Permanent
Job Status Open

Introduction

The Oracle DBA specifies, places and modifies data to support the development of database, warehouse and application solutions, and is responsible for the data used, updated and produced by the application.

Important

Oracle DBA

The Job

Scope of role:

  • Installing and testing new versions of the databases and warehouse solutions.
  • start-up, shutdown, and recovery tasks
  • user administration and database security parameters
  • database networking configuration and administration
  • database capacity planning and storage administration.
  • Provide troubleshooting and issue resolution for all database components.
  • Install, administer and support all database application server environments.
  • Perform database and application software/patches in all database environments as needed
  • Provide advanced scripting techniques to automate processes, provide integration and/or to troubleshoot developers code to provide for database queries.
  • Determine and enforce recommended (database) deployment, configuration, and setup methodologies for all database instances
  • Carry out analysis to determine user requirements and develop specifications.
  • Undertake the migration of data from old to new database applications and tasks such as:
  1. Mapping of data from old to new applications
  2. Clean-up of existing and new data, assistance with deletions and structural changes to existing data so as to facilitate the migration of data to a new system
  3. Accurate migration of data to a new application
  4. Set-up and configuration of a new application
  • Assistance with acceptance testing and error reporting on the new application.
  • Work closely with any external vendors or internal department contacts to ensure the efficient running of applications once deployed to the production environment.
  • Perform database performance analysis, reporting, and configuration and performance tune and optimize database components (database and application servers if applicable). Work to ensure maximum availability (99.9%) of all databases.
  • Set-up and maintenance of on-going statistics and management reporting functionality in database applications to allow for users to generate reports on-demand.
  • Provide troubleshooting and issue resolution for all database components.
  • Set-up and maintenance of import and export routines to and from internal and external databases and catalogues.
  • Create and maintain technical documentation about all applications and processes.
  • Establishing the needs of users and monitoring user access and security;
  • Monitoring performance and managing parameters to provide fast responses to front-end users;
  • Mapping out the conceptual design for a planned database;
  • Considering both back-end organisation of data and front-end accessibility for end-users;
  • Refining the logical design so that it can be translated into a specific data model;
  • Further refining the physical design to meet system storage requirements;
  • Maintaining data standards, including adherence to the Data Protection Act;
  • Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
  • Controlling access permissions and privileges;
  • Developing, managing and testing back-up and recovery plans;
  • Ensuring that storage and archiving procedures are functioning correctly;
  • Capacity planning;
  • Working closely with IT project managers, database programmers and multimedia programmers;
  • Communicating regularly with technical, applications and operational staff to ensure database integrity and security Major accountabilities of role (6-10 short statements)

Approx % of time spent in the role:

  1. Database Administration including installation, test, start-up, shutdown, administration, housekeeping / recovery tasks 12.5%
  2. Troubleshooting and issue resolution for all database components 12.5%
  3. Perform database and application software/patches in all database environments 12.5%
  4. Provide advanced scripting techniques to automate processes, provide integration and/or to troubleshoot developers code to provide for database queries 12.5%
  5. Undertake the migration of data from old to new database applications and tasks 12.5%
  6. Establishing the needs of users and monitoring user access and security 12.5%
  7. Undertake data modelling, logical and physical database design 12.5%
  8. Writing database documentation, including data standards, procedures and definitions for the data dictionary 12.5%

Knowledge/experience:

  • Strong proven experience as a database administrator, with expert experience in current RDBMS technologies e.g. Oracle, SQL Server, DB2
  • Proven ability to work with data warehouse along with the ETL scripting.
  • Proven experience of SQL/PLSQL, PHP, scripting and stored procedure and trigger development
  • Proficient in a Windows and VMware environments
  • Previous experience of large, complex data migrations, database housekeeping, performance tuning, trouble-shooting
  • Proven experience in complex data modelling, logical and physical database / warehouse design and management
  • Experience with Oracle DBA functions e.g. performance tuning, DB backup and recovery (RMAN), capacity planning, replication Capability:
  • Self-starter, flexible, motivated and enthusiastic
  • Good communication and inter-personal skills to allow for engagement with colleagues at all levels
  • Works collegiately / well in a team environment
  • Must be decisive, able to focus on priorities and able to contribute to operational debates, helping to identify and address future opportunities and challenges

Expert problem-solving and analytical skills, able to determine the impact of an issue quickly to prioritize further work.

 

Related jobs

 

Related articles

Back to top