Oracle DBA

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.