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.