Description
Role: Oracle Database Architect
Duration: 3 months Initially
Location: Dublin, Ireland
Skills & Description:
- Minimum experience of 8 years in IT industry is needed
- Expertise Oracle RDBMS.
- Working knowledge of Data Modeling (Logical and Physical database design).
- Knowledge of OLTP and DSS database design is preferred.
- Good Knowledge of PL/SQL coding, usage of different database objects like Views, Materialized Views, Functions, Procedures, Packages, Global Temporary tables.
- Knowledge of Scripting languages like UNIX Shell script for server application development.
- Knowledge of SQL Tuning using execution plan, Database Performance Tuning using Oracle AWR reports, is must.
- Should know SQL profiling
- Should know how to read Oracle trace files.
- Knowledge of database Clustering and Data Replication technologies
- Knowledge of database backup and recovery methods.
- Knowledge of SQL Loader, EXPTDP and IMPDP utilities
- Should able to raise SR request on oracle support site and should able to interact with oracle DBAs confidentl
- Knowledge of UML Design, different architecture Design Patterns