Beschreibung
We urgently require a Database Specialist who can be available immediately for this 12 week contract with the NCIA. The majority of systems developed by NCIA rely to some degree on the presence of a database system. Frequently, NCIA requires additional workforce to help with the development, testing and administration of databases.
There is also an occasional requirement for a database expert to review database designs of capabilities being developed by contractors on behalf of NCIA.
Activities to be performed:
- Develops and maintains specialist knowledge of database concepts, object and Datamodelling techniques and design principles and a detailed knowledge of database architectures, software and facilities
- Analyses data requirements to establish, modify or maintain object/data models
- Evaluates potential solutions, demonstrating, installing and commissioning products
- Uses database management system software and tools to investigate problems and collect performance statistics and create reports
- Carries out routine configuration/installation and reconfiguration of database and related products.
- Design and implement RDBM and OODBM systems
- Define data structures, logical and physical databases using Case Tools
- Revise database design; implement stored procedures, triggers; apply normalization and other harmonization activities
- Define advanced queries
- Use built-in Data Access classes in Application Frameworks to create Database Interfaces and classes in applications to be able to accessand manage databases
- Evaluate and select commercial or academic databases for use
- Prepare Data Dictionaries and other related database documentation
Requested Skills & Competencies
- Oracle Database and Oracle Application Server Administration skills are essential qualifications
- Microsoft Certified Solutions Associate SQL Server 2012
- Microsoft Technology Associate IT Infrastructure
- Oracle Database 11g Administrator Certified Professional
- Oracle Enterprise Manager 11g Certified Implementation Specialist
- Knowledgeable of both relational and non-relational (NOSQL) database principles, design, implementation and/or administration
- Knowledgeable of Object Oriented Database principles design, implementation and/or administration
- Experience with writing queries and query optimization
- High-level knowledge of other computing disciplines including software development, system integration and IT service provision
- Understanding of polyglot consistence and map reduce technologies