Endeavour Recruitment has an excellent new opportunity for Senior Oracle Database Administrator to work for a large client in Brussels, Belgium. The duration of this role is 6 months and the daily all-inclusive rate is €533 euros.
Role and Responsibilities:
- PL/SQL programming
- ERD realisation and validation (3NF modelling)
- Query tuning (xplain, trace)
- DB tuning (ASH, AWR, Advisor, DB parameters)
- Writing complex queries (also recursive queries and hierarchical queries)
- Architectural solution
- Security model (also GDPR)
- Data workflow analysis
- Provide high value technical solutions in Oracle for specific problems
- Test and Validation through proof of concept
- Assure daily DBA operational activities covering:
- Daily Monitoring
- Day to day DBA tasks (import/export, space management –TBS - ASM, problem solving, ACL, Schema management, security, session, promotion management, application migration to another database)
- Maintenance of monitoring tools
- DB installation and configuration
- Technical lead on DB upgrades and migration
- Be the first technical support in the scope of the projects and in operations
Required Skills and Knowledge:
- You have a master’s degree in computer science and at least 10 years of relevant experience as DBA and/or DB developer
- Administration of Oracle 11R2, 12R1 and 12R2.
- APEX 5 (Oracle express)
- SQL (Oracle style and sql ansi standard)
- PL/SQL
- Sqlloader
- EXPDP/IMPDP
- RMAN
- Basic Linux knowledge + scripting
- Dynamic queries
- Links (db_link, Sqlloader, impdp, Sftp)
- Transaction validation (A.C.I.D.)
- Java in DB
- XML
- Scheduler Job
- Triggers (tables, system)
- Compression
- Data security
- Data loading
- ETL
- Partitioning
Please get in touch for further details on this excellent, not to be missed contract opportunity!