Oracle DBA

Based - Central London Tower Bridge

Oracle DBA:

• Oracle RDBMS 10g/11g/12c (3 years + recent installation, administration & troubleshooting)
• Backups, Recovery and DR - RMAN, Dataguard and logshipping.
• Oracle RAC - Real Application Clusters
• 12c GRID Control using diagnostics and tuning packs
• Upgrades/Migrations/Patching
• Understanding of SQL and PL/SQL.
• Linux/Unix Power User (Shell Scripting)

Desirable:

• IBM Tivoli Storage Manager for Databases
• Database San Storage Migrations/Replication/Snapshots
• SQL Databases running on Virtual Hosts.
• ITIL Background
• Microsoft or Oracle Certified in RBDMS technologies.

Behavioural Competencies:

• Eager to learn internal procedures and make improvements.
• Able to pro-actively provide creative solutions and service improvements.
• Able to work independently.
• Able to Juggle several task simultaneously.

Responsibilities

High Level Functional Activities:

• Use database management tools to investigate, diagnose and resolve database problems within service level agreement tolerances, referring to database users, other staff and suppliers as necessary.
• Use database management systems software and appropriate analysis tools to collect routine database performance statistics and create reports, including proposals for improvement.
• Carrying out routine configuration/installation and reconfiguration of Oracle/SQL Server database and related products.
• Enrols users, maintains system security, controls and monitors user access to databases.
• Backs up and restores databases, maintaining archived backup data on tape or other medium, Performs data maintenance and borrowing activities.
• Assists users or acts on their behalf to create complex query definitions (SQL, PL/SQL, TSQL) in order to extract and manipulate data.
• Assists in documenting procedures and scripts for all aspects of database installation, configuration and administration.
• Works with application developers, support staff and external software vendors to troubleshoot site-specific performance issues, escalating to developers for software fixes or implementing database improvements.

Work Experience Essential:

• Installation / configuration of databases.
• SQL Clustering management.
• Oracle RAC Support.
• Good working knowledge of LINUX.
• Creation of tables and indexes.
• Creation / upkeep of maintenance scripts.
• Implementation of security.
• Architecture design.
• Troubleshooting of database application / backup errors.
• Restore of databases.
• Execution of stored procedures.
• Configuration and support of SQL replication.
• Log Shipping Patch / service pack updates.